Ubuntu安装mysql及相关配置

提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档

---

前言

提示：这里可以添加本文要记录的大概内容：
例如：随着人工智能的不断发展，机器学习这门技术也越来越重要，很多人都开启了学习机器学习，本文就介绍了机器学习的基础内容。

---

提示：以下是本篇文章正文内容，下面案例可供参考

一.安装Mysql

#更新
sudo apt-get update
#安装
sudo apt-get install mysql-server

二.初始配置

#1
VALIDATE PASSWORD PLUGIN can be used to test passwords...
Press y|Y for Yes, any other key for No: N (我的选项)

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

#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 (我的选项)

#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) : Y (我的选项)

#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 (我的选项)

#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 (我的选项)

# 检查运行状态，active为启动
systemctl status mysql.service

三.Mysql root用户登不上

1.进入该文件查看用户，密码

 vim /etc/mysql/debian.cnf

2.根据文件中的用户名，密码，登录MySQL

3.查看root用户加密方式并修改

 use mysql;
select user,plugin from user where user='root';
 alter user 'root'@'localhost' identified with mysql_native_password by '你的密码';

4.设置root新密码

alter user 'root'@'localhost' identified by '123456';

5.使配置生效

FLUSH PRIVILEGES;

四.Mysql允许远程连接

1.修改配置文件

vim /etc/mysql/mysql.conf.d/mysqld.cnf  
[mysqld]
port=3306
bind-address=0.0.0.0
然后重新启动mysql服务，执行service mysql restart

2.修改对应数据库，表权限

use mysql;
update user set host='%' where user ='root';  # 更新域属性，'%'表示允许外部访问
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;  # 再执行授权语句