安装 MySQL8.0（Ubuntu）

最新推荐文章于 2024-12-18 18:38:27 发布

Agatha方艺璇

最新推荐文章于 2024-12-18 18:38:27 发布

阅读量321

点赞数 1

分类专栏： Spark MySQL 大数据文章标签： mysql ubuntu

本文为作者原创文章转载请与作者联系并注明出处

本文链接：https://blog.csdn.net/agatha_aggie/article/details/109148201

版权

大数据同时被 3 个专栏收录

63 篇文章 2 订阅

订阅专栏

MySQL

11 篇文章 0 订阅

订阅专栏

Spark

9 篇文章 0 订阅

订阅专栏

Ubuntu安装MySQL8.0

一、下载安装

1、更新源

sudo apt-get update

2、安装mysql服务

sudo apt-get install mysql-server

二、初始化配置

1、mysql配置

sudo mysql_secure_installation

#1
VALIDATE PASSWORD PLUGIN can be used to test passwords…
Press y|Y for Yes, any other key for No: N (选择N ,不会进行密码的强校验)
#2
Please set the password for root here…
New password: (输入密码123456)
Re-enter new password: (重复输入123456)
#3
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them…
Remove anonymous users? (Press y|Y for Yes, any other key for No) : N (选择N，不删除匿名用户)
#4
Normally, root should only be allowed to connect from
‘localhost’. This ensures that someone cannot guess at
the root password from the network…
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : N (选择N，允许root远程连接)
#5
By default, MySQL comes with a database named ‘test’ that
anyone can access…
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : N (选择N，不删除test数据库)
#6
Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y (选择Y，修改权限立即生效)

2、检查mysql状态

systemctl status mysql.service

在这里插入图片描述

三、配置远程访问

在Ubuntu下MySQL缺省是只允许本地访问的，使用workbench连接工具是连不上的，如果你要其他机器也能够访问的话，需要进行远程配置

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
#找到 bind-address 修改值为 0.0.0.0(如果需要远程访问)

sudo /etc/init.d/mysql restart #重启mysql