Ubuntu20.4安装及配置mysql详细教程

一、通过apt 安装MySQL服务（推荐，会安装最新版）#命令1 更新源sudo apt-get update#命令2 安装mysql服务sudo apt-get install mysql-server

二、初始化配置sudo mysql_secure_installation

配置项较多，如下所示：

#1VALIDATE PASSWORD PLUGIN can be used to test passwords…Press y|Y for Yes, any other key for No: N (选择N ,不会进行密码的强校验)

#2Please set the password for root here…New password: (输入密码)Re-enter new password: (重复输入)

#3By default, a MySQL installation has an anonymous user,allowing anyone to log into MySQL without having to havea user account created for them…Remove anonymous users? (Press y|Y for Yes, any other key for No) : N (选择N，不删除匿名用户)

#4Normally, root should only be allowed to connect from’localhost’. This ensures that someone cannot guess atthe root password from the network…Disallow root login remotely? (Press y|Y for Yes, any other key for No) : N (选择N，允许root远程连接)

#5By default, MySQL comes with a database named ‘test’ thatanyone can access…Remove test database and access to it? (Press y|Y for Yes, any other key for No) : N (选择N，不删除test数据库)

#6Reloading the privilege tables will ensure that all changesmade so far will take effect immediately.Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y (选择Y，修改权限立即生效)三、检查mysql服务状态systemctl status mysql.service

四、配置远程访问

在Ubuntu下MySQL缺省是只允许本地访问的，使用workbench连接工具是连不上的； 如果你要其他机器也能够访问的话，需要进行配置； 找到 bind-address 修改值为 0.0.0.0(如果需要远程访问)

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

登录数据库

sudo mysql -uroot -p

如果为了安全性，设置了用户验证，必须使用sudo，才能登录，出现如下情况：（尽量不要设置ubuntu用户在验证，否则会很麻烦）

mysql -uroot -p

解决方法：sudo vim /etc/mysql/my.cnf

添加以下字段

[mysqld]skip-grant-tables

保存后重启mysql，可以正常登陆了

systemctl restart mysql

这样操作后，是相当于跳过了mysql的密码认证。很不安全，直接就可以登录进去。