Ubuntu 上安装 MySQL

本文讲述怎么在 Ubuntu 上安装 MySQL(8)

查看最新版本 https://dev.mysql.com/downloads/repo/apt
可以看到 (mysql-apt-config_0.8.15-1_all.deb)

点 Download 跳到一个新的页面，
将鼠标移到 No thanks, just start my download. 上，
可以看到链接 https://dev.mysql.com/get/mysql-apt-config_0.8.15-1_all.deb
复制链接地址，然后下载：

1	wget https://dev.mysql.com/get/mysql-apt-config_0.8.15-1_all.deb

1	sudo dpkg -i mysql-apt-config_0.8.15-1_all.deb

选择 OK

执行更新命令：sudo apt update

安装 MySQL：

1	sudo apt install mysql-server

进入 MySQL 交换模式：

1
2
3

mysql -u root -p

Enter password: 输入你安装时设置的密码

切换数据库

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 host, user, authentication_string, plugin from user; 

+-----------+------------------+----------------------------+-----------------------+
| host      | user             | authentication_string      | plugin                |
+-----------+------------------+----------------------------+-----------------------+
| localhost | mysql.infoschema | $A$005$THISISACOMBINATI... | caching_sha2_password |
| localhost | mysql.session    | $A$005$THISISACOMBINATI... | caching_sha2_password |
| localhost | mysql.sys        | $A$005$THISISACOMBINATI... | caching_sha2_password |
| localhost | root             | $A$005$;z8JpNgh&u*U^VA<... | caching_sha2_password |
+-----------+------------------+----------------------------+-----------------------+
4 rows in set (0.00 sec)

可以看到 root 这个用户的 host 只允许 localhost 本地访问，
所以将 host 对应的值修改成 % 来允许任意 IP 访问~

1	mysql> update user set host='%' where user='root' and host='localhost';

刷新权限

1	mysql> flush privileges;