Ubuntu 18.04 安装mysql5.7

数据运维 2023-04-28 法医手机阅读

Ubuntu18.04安装mysql5.7，供大家参考，具体内容如下 1.1安装首先执行下面三条命令： # 安装mysql服务sudo apt-get install mysql-server# 安装客户端sudo apt install mysql-client# 安装依赖sudo apt install li

Ubuntu18.04安装mysql5.7，供大家参考，具体内容如下

1.1安装

首先执行下面三条命令：

安装mysql服务 sudo apt-get install mysql-server
安装客户端 sudo apt install mysql-client
安装依赖 sudo apt install libmysqlclient-dev
检查状态 sudo netstat -tap | grep mysql

1.2设置root密码

mysql5.7安装完成后普通用户不能进mysql，原因：root的plugin被修改成了auth_socket，用密码登陆的plugin应该是mysql_native_password，直接用root权限登录就不用密码,修改root密码和登录验证方式：

$ sudo su

mysql mysql> mysql> select user, plugin from mysql.user; +------------------+-----------------------+ | user | plugin | +------------------+-----------------------+ | root | auth_socket | | mysql.session | mysql_native_password | | mysql.sys | mysql_native_password | | debian-sys-maint | mysql_native_password | +------------------+-----------------------+ 4 rows in set (0.00 sec) mysql> update mysql.user set authentication_string=PASSWORD('123456'), plugin='mysql_native_password' where user='root'; mysql> flush privileges; mysql> exit Bye
exit $ sudo /etc/init.d/mysql restart $ mysql -uroot -p

Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.22-0ubuntu18.04.1 (Ubuntu)

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

1.3配置mysql远程登录