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.注释绑定本地服务器
代码语言：javascript复制vim vim /etc/mysql/mysql.conf.d/
#bind-address = 127.0.0.1
