ubuntu20.04下mysql安装

源安装
sudo apt-get update
sudo apt-get install -y mysql-server

查看service状态
sudo systemctl status mysql

加固mysql
sudo mysql_secure_installation
(你将会被要求配置VALIDATE PASSWORD PLUGIN，它被用来测试 MySQL 用户密码的强度，并且提高安全性，按提示操作即可)

创建用户并设置权限
sudo mysql
(登陆mysql后，依次执行以下命令，创建数据库开发者账户)
use mysql;
select * from user;
CREATE USER '用户名'@'%' IDENTIFIED BY '密码';
ALTER USER '用户名'@'%' IDENTIFIED BY '密码' PASSWORD EXPIRE NEVER;
ALTER USER '用户名'@'%' IDENTIFIED WITH mysql_native_password BY '密码';
FLUSH PRIVILEGES;
show grants for '用户名'@'%';
update user set Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_priv='Y',Drop_priv='Y',Reload_priv='Y',Shutdown_priv='Y',Process_priv='Y',File_priv='Y',Grant_priv='Y',References_priv='Y',Index_priv='Y',Alter_priv='Y',Show_db_priv='Y',Super_priv='Y',Create_tmp_table_priv='Y',Lock_tables_priv='Y',Execute_priv='Y',Repl_slave_priv='Y',Repl_client_priv='Y',Create_view_priv='Y',Show_view_priv='Y',Create_routine_priv='Y',Alter_routine_priv='Y',Create_user_priv='Y',Event_priv='Y',Trigger_priv='Y',Create_tablespace_priv='Y',Create_role_priv='Y',Drop_role_priv='Y' where User='用户名';
grant all privileges on *.* to '用户名'@'%';
FLUSH PRIVILEGES;

安装MySQL Workbench
https://dev.mysql.com/downloads/workbench/
(在官网下载页，选择社区版本对应ubuntu系统的安装包，下载安装即可)

也可以在IDEA中使用数据库插件管理mysql数据库（需要mysql驱动）