ubuntu18.04安装配置mysql

1.apt-get 安装mysql-server

• apt-get install mysql-server

2.初始化配置mysql

• mysql_secure_installation

1.密码强度检查（n:可以设置较弱的密码 y:要设置比较复杂的密码）
Press y|Y for Yes, any other key for No: N (我的选项)

2.为root用户设置密码
New password: (输入密码)
Re-enter new password: (重复输入)

3.mysql安装有一个默认的匿名用户（n: 删除匿名用户）
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.设置root用户只允许本地连接
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.mysql有一个任何人都可以访问的测试数据库（y: 删除 n：保留）
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 (我的选项)

3. 查看mysql服务器的状态

• systemctl status mysql.service   /  service mysql status
• service mysql restart  : 重启mysql数据库

4.允许所有机器都可以访问数据库

• "%" : 所有机器
• "localhost": 本地机器
• grant all privileges on *.* to 'root'@'%' identified by '123' with grant option;
• flush privileges;

5.注释绑定本地服务器
 

vim vim  /etc/mysql/mysql.conf.d/
#bind-address           = 127.0.0.1