Ubuntu安装mysql

1、安装mysql

sudo apt-get update
sudo apt-get install mysql-server 
apt-get isntall mysql-client
sudo apt-get install libmysqlclient-dev

 

2、安装完成后，直接使用以下命令登录

sudo mysql -u root

 

3、为root用户设置密码

auth_socket 使用 Unix socket 文件来验证本地的用户身份

mysql_native_password，这个才是 mysql 正常的用户名密码登录方式。

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select user,host,plugin from user;
+------------------+-----------+-----------------------+
| user             | host      | plugin                |
+------------------+-----------+-----------------------+
| root             | localhost | auth_socket           |
| mysql.session    | localhost | mysql_native_password |
| mysql.sys        | localhost | mysql_native_password |
| debian-sys-maint | localhost | mysql_native_password |
+------------------+-----------+-----------------------+
4 rows in set (0.00 sec)

mysql> update user set plugin="mysql_native_password" where user='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update mysql.user set authentication_string=password('Test@1234') where user='root';
Query OK, 0 rows affected, 1 warning (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 1


mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)