Mysql学习笔记

101 阅读1分钟

ubuntu20安装mysql

# 更新 安装
sudo apt update
sudo apt install mysql-server

# 查看状态
sudo systemctl status mysql

# root用户设置
sudo mysql_secure_installation

# 登录mysql
sudo mysql

# 创建用户 授予权限
use mysql;
CREATE USER 'ubmechdb'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'ubmechdb'@'%';
FLUSH PRIVILEGES;