Ubuntu Server 18.04安装MySql

Ubuntu Server 18.04安装MySql

环境信息:
OS:Ubuntu Server 18.04
MySql:5.7.23

  1. 安装MySQl

sudo apt update
sudo apt install mysql-server

2.配置MySql
2.1 安装配置

sudo mysql_secure_installation

配置如下:

#1是否安装密码校验插件
VALIDATE PASSWORD PLUGIN can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD plugin?
Press y|Y for Yes, any other key for No:

#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. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production
environment.
Remove anonymous users? (Press y|Y for Yes, any other key for No) :

#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) :

#5是否删除“测试”库
By default, MySQL comes with a database named ‘test’ that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.
Remove test database and access to it? (Press y|Y for Yes, any other key for No) :

#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) :

2.2 检查Mysql服务状态:

systemctl status mysql.service

显示如下表示正常:

● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: active (running) since Sun 2018-10-14 11:21:31 UTC; 31min ago
Main PID: 9327 (mysqld)
Tasks: 29 (limit: 2292)
CGroup: /system.slice/mysql.service
└─9327 /usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid

Oct 14 11:21:30 ntech systemd[1]: Starting MySQL Community Server…
Oct 14 11:21:31 ntech systemd[1]: Started MySQL Community Server.

2.3 远程连接

1.登录MySql
sudo mysql -uroot -p
use mysql
update user set host=’%’ where user=‘root’;
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘’ WITH GRANT OPTION;
flush privileges;
exit;
2.修改mysql.conf文件
位置:/etc/mysql/mysql.conf.d/mysql.conf
将“bind-address = 127.0.0.1”注释
3.重启Mysql
sudo /etc/init.d/mysql restart

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值