zl程序教程

您现在的位置是:首页 >  数据库

当前栏目

ubuntu18.04安装配置mysql

mysql安装配置 ubuntu18.04
2023-06-13 09:15:36 时间

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