MySQL：Ubuntu18.04 如何安装和卸载mysql8.0.16

迷南。 2022-01-05 04:39 238阅读 0赞

1、下载[mysql-apt-config\_0.8.13-1\_all.deb][mysql-apt-config_0.8.13-1_all.deb]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25ldHllYXhp_size_16_color_FFFFFF_t_70][]

2、 运行命令

> sudo dpkg -i mysql-apt-config\_0.8.13-1\_all.deb  
> sudo apt update

3、安装MySQL

> sudo apt install mysql-server

4、查看mysql

> mysql -u root -p

若执行报如下错误：

> ERROR 1698 (28000): Access denied for user 'root'@'localhost'

则可以通过如下方式

> sudo vi /etc/mysql/conf.d/mysql.cnf

添加如下内容

> \[mysqld\]  
> skip-grant-tables

重启MySQL

> service mysql restart

再进行

> mysql -u root -p

由于MySQL版本大于MySQL 8.0.11，不能使用如下方式修改密码了

> use mysql;  
> update user set authentication\_string=password('你的密码') where User='root';  
> flush privileges;

要使用如下方法：

> use mysql;  
> update user set plugin = 'mysql\_native\_password', authentication\_string=null where User='root';  
> flush privileges;

将前面配置的skip-grant-tables去掉

> sudo vi /etc/mysql/conf.d/mysql.cnf

重启MySQL，再登录

> service mysql restart  
> mysql -u root

再使用

> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql\_native\_password BY '你的密码';

退出后，就可以用新密码登录了。

5、卸载mysql

> sudo apt-get auto-remove  mysql-server

另外，还要把/var/lib/mysql和/etc/mysql目录删除

参考文档

[Ubuntu18.04 安装mysql8.0.11][Ubuntu18.04 _mysql8.0.11]  
[mysql出现ERROR1698(28000):Access denied for user root@localhost错误解决方法][mysql_ERROR1698_28000_Access denied for user root_localhost]  
[How to reset the root password in MySQL 8.0.11?][How to reset the root password in MySQL 8.0.11]  
[Can't start MySQL5.5 on Ubuntu 12.04 - “dpkg: dependency problems”][Can_t start MySQL5.5 on Ubuntu 12.04 - _dpkg_ dependency problems]

[mysql-apt-config_0.8.13-1_all.deb]: https://dev.mysql.com/downloads/repo/apt/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25ldHllYXhp_size_16_color_FFFFFF_t_70]: /images/20211230/5d9c0f12d2bf4ac79670e674de0ca1c6.png
[Ubuntu18.04 _mysql8.0.11]: https://www.cnblogs.com/luoli-/p/9249769.html
[mysql_ERROR1698_28000_Access denied for user root_localhost]: https://www.cnblogs.com/cpl9412290130/p/9583868.html
[How to reset the root password in MySQL 8.0.11]: https://stackoverflow.com/questions/50691977/how-to-reset-the-root-password-in-mysql-8-0-11
[Can_t start MySQL5.5 on Ubuntu 12.04 - _dpkg_ dependency problems]: https://stackoverflow.com/questions/13276088/cant-start-mysql5-5-on-ubuntu-12-04-dpkg-dependency-problems