MySql 实践完整详细总结

按照下面的步骤依次安装

--------------------------------
下面是安装 mysql 8.0 server 步骤
--------------------------------
su
apt update
apt upgrade -y
apt install mysql-server
systemctl start mysql
systemctl enable mysql
systemctl status mysql
mysql_secure_installation 依次选择 Y
mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password'; # your_password 替换为你希望设置的密码
FLUSH PRIVILEGES; # 刷新权限
CREATE DATABASE TEST_DB; # 创建数据库

CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypassword'; # 8.0以上版本用法
GRANT ALL PRIVILEGES ON mydatabase.* TO 'myuser'@'localhost'; # myuser - 用户名 
FLUSH PRIVILEGES;
EXIT;

nano /etc/mysql/mysql.conf.d/mysqld.cnf # 设置用户远程访问权限
bind-address = 0.0.0.0
systemctl restart mysql
GRANT ALL PRIVILEGES ON mydatabase.* TO 'myuser'@'%'; # 授权用户远程登陆
FLUSH PRIVILEGES;

mysql -u AARON -p -h localhost # 验证新用户AARON是否创建和授权成功

如果此前安装过MYSQL，安装先卸载步骤

su
systemctl stop mysql
apt purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-*
rm -rf /etc/mysql /var/lib/mysql /var/log/mysql
deluser mysql # 删除专用用户
delgroup mysql # 删除专用组
apt autoremove
apt autoclean
dpkg -l | grep mysql # 验证卸载
systemctl status mysql