ubuntu_mysql_install

ubuntu系统mysql的安装与配置

安装

ubuntu默认自带mysql包，更新apt软件包并安装即可，在Ubuntu18.04上默认安装包版本为5.7.33。

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

注意区分mysql的client和server。

配置

初始化指令 sudo mysql_secure_installation 详细配置

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

#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

mysql运行检查

输入指令
systemctl status mysql.service
如下显示则安装成功

ERROR 1698 (28000)错误解决方案

普通用户权限下出现无法登陆mysql,而root权限下不需密码验证直接登陆的状况。
原因出自auth_socket插件，详见官方文档:插件式权限认证Pluggable Authentication
不需要使用该功能时的解决方案如下
1进入root权限
sudo -i
2插件式权限认证登陆
mysql
3进入mysql数据库，修改root认证字符串为密码并设置，插件值为mysql原生密码
mysql>use mysql;
mysql> update mysql.user set authentication_string=PASSWORD('newPwd'), plugin='mysql_native_password' where user='root';
4刷新权限表
mysql>flush priviledges;
5退出mysql
mysql>quit
6重启mysql服务
service mysql restart

brilliantrocks / ubuntu_mysql_install Goto Github PK