ubuntu22 mysql 8.0.33

一、安装

下载安装
sudo apt install mysql-server -y

查看版本
mysql --version

mysql Ver 8.0.33-0ubuntu0.22.04.2 for Linux on x86_64 ((Ubuntu))

查看是否运行
sudo systemctl status mysql

Active: active (running) since Thu 2023-05-18 19:53:54 CST; 2h 41min ago

修改密码
进入mysql（默认无密码）
sudo 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

查看
select host,user from user;

返回结果：

±----------±-----------------+
| host | user |
±----------±-----------------+
| localhost | debian-sys-maint |
| localhost | mysql.infoschema |
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
±----------±-----------------+
5 rows in set (0.26 sec)

改为可从任何主机访问数据库
update user set host='%' where user='root';

返回结果：

Query OK, 1 row affected (0.22 sec)
Rows matched: 1 Changed: 1 Warnings: 0

查看
select host,user from user;

返回结果：

±----------±-----------------+
| host | user |
±----------±-----------------+
| % | root |
| localhost | debian-sys-maint |
| localhost | mysql.infoschema |
| localhost | mysql.session |
| localhost | mysql.sys |
±----------±-----------------+
5 rows in set (0.00 sec)

改密码

show databases;

show tables;

select host,user from user;

alter user 'root'@'%' identified with mysql_native_password by 'master$12342023';

flush privileges;

退出
exit

测试登录
mysql -u root -p 123456

退出
exit

开启远程访问
改
vim /etc/mysql/mysql.conf.d/mysqld.cnf

将以下地址均改为 0.0.0.0

bind-address = 127.0.0.1
mysqlx-bind-address = 127.0.0.1

重启mysql
sudo systemctl restart mysql

测试：使用navicat连接
二、卸载
使用 apt-get 命令卸载 MySQL：
sudo apt-get remove --purge mysql-server mysql-client mysql-common

删除 MySQL 的配置文件和数据：
sudo rm -rf /etc/mysql/ /var/lib/mysql/

清除 MySQL 相关的依赖：
sudo apt-get autoremove

清除残留文件和目录：
sudo find / -iname 'mysql*' -exec rm -rf {} ;

参考: unbuntu如何彻底删除mysql？
————————————————