Ubuntu20.04安装 mysql8.0.32

检查删除原有的mysql(可以不做自己记录)1、 下载MySQL :: Download MySQL Community Server (Archived Versions)wget https://cdn.mysql.com/archives/mysql-8.0/mysql-server_8.0.32-1ubuntu20.04_amd64.deb-bundle.tar2、解压到指定目录下tar xvf mysql-server_8.0.32-1ubuntu20.04_amd64.deb-bundle.tar -C /opt/mysql-8.0.32/3、安装依赖sudo apt install -y libaio1 libmecab2 man-db libc-bin4、安装mysqldpkg -i mysql-community-client-plugins_8.0.32-1ubuntu20.04_amd64.deb dpkg -i mysql-community-client-core_8.0.32-1ubuntu20.04_amd64.deb dpkg -i mysql-common_8.0.32-1ubuntu20.04_amd64.deb dpkg -i mysql-community-client_8.0.32-1ubuntu20.04_amd64.deb dpkg -i mysql-client_8.0.32-1ubuntu20.04_amd64.deb dpkg -i mysql-community-server-core_8.0.32-1ubuntu20.04_amd64.deb dpkg -i mysql-community-server_8.0.32-1ubuntu20.04_amd64.deb确认完密码后有个选项我选的第一个第二个好像是mysql5啥的。完了后就可以登录了。按 Tab 键就会切换。5、远程连接首次登录 sudo mysql使用远程连接工具报错ALTER USER root% IDENTIFIED WITH mysql_native_password BY 你的密码; systemctl restart mysql # 重启mysql远程连接正常如果报错 ERROR 1396 (HY000): Operation ALTER USER failed for root%确认 root 用户的实际 host再需要远程访问创建 root% 用户SELECT user, host FROM mysql.user WHERE user root; CREATE USER root% IDENTIFIED WITH mysql_native_password BY 你的密码; # 创建 root% 用户 GRANT ALL PRIVILEGES ON *.* TO root% WITH GRANT OPTION; #赋予全部权限 FLUSH PRIVILEGES;6、开机自启动参考博客Ubuntu/Linux安装JDK、Mysql、Redis、Rabbitmq、Nginx 并设置开机自启动_ubuntu service mysql start 自动启动-CSDN博客在centos中开机自启动命令 systemctl enable mysqld 在buntu中是 systemctl enable mysql systemctl restart mysql # 重启 systemctl status mysql # 查看状态7、ubuntu22.04直接安装mysql上面方式没安装成功先删除dpkg -l | grep -i mysql sudo dpkg --purge mysql-common #彻底删除冲突包mysql-commonsudo apt update sudo apt install mysql-server systemctl status mysql # 可以看到mysql已经启动成功 # 执行安全初始化脚本以增强安全性例如禁用匿名用户、删除测试数据库等 sudo mysql_secure_installation Disallow root login remotely? (Press y|Y for Yes, any other key for No) : nosudo mysql # 直接登录mysql update user set host % where user root; ALTER USER root% IDENTIFIED WITH mysql_native_password BY xxxxxx; FLUSH PRIVILEGES; systemctl restart mysql # 重启mysqltlenet ip 3306 不通vim /etc/mysql/mysql.conf.d/mysqld.cnf bind-address 127.0.0.1前加入#注释掉 systemctl restart mysql # 重启mysql使用第三方工具可以连接数据库