【ubuntu20.04安装MySQL以及MySQL-workbench可视化工具】

最新推荐文章于 2025-04-11 15:12:10 发布

delilahy123

最新推荐文章于 2025-04-11 15:12:10 发布

阅读量9.2k

点赞数 12

文章标签： mysql 数据库 database

本文链接：https://blog.csdn.net/delilahy123/article/details/124834998

版权

文章目录

前言
安装步骤
总结

前言

本文基于Ubuntu20.04 LST 以及MySQL 8.0.29，可视化工具使用mysql-workbench-community_8.0.29-1ubuntu20.04_amd64.deb

安装步骤

1.安装MySQL

sudo apt-get update  #获取最新的软件源
sudo apt-get install mysql-server #安装mysql

启动与关闭MySQL

service mysql start  #启动MySQL
service mysql stop  #关闭MySQL

2.配置MySQL

开始配置：

sudo mysql_secure_installation

...
# 1.询问是否安装密码插件，我选择 No
VALIDATE PASSWORD COMPONENT can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD component?
Press y|Y for Yes, any other key for No: n

# 2.为root用户设置密码
Please set the password for root here.

New password: 

Re-enter new password: 
#2.1 解决方法详见下一小节，解决bug
 ... Failed