# Mysql Skills
# 一、修改密码
alias mysql='/usr/local/mysql-8.0.19-macos10.15-x86_64/bin/mysql' // alias
mysql -u root -p // enter password
SET PASSWORD FOR root@localhost = '123456';
Query OK, 0 rows affected (0.04 sec)
exit // 退出
1
2
3
4
5
6
7
8
2
3
4
5
6
7
8
# 二、忘记密码，重制密码
# 1.首先确定mysql的版本信息
在系统设置中找到mysql
# 2.关闭mysql服务
sudo /usr/local/mysql/support-files/mysql.server stop
sudo mysql.server stop
1
2
3
2
3
# 3.安全模式启动mysql
sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables
sudo mysqld_safe --skip-grant-tables
1
2
3
2
3
# 4.回到终端
mysql -u root
1
# 5.更改 root 密码
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';
1
2
2
# 6.退出重启mysql
exit // 退出
sudo /usr/local/mysql/support-files/mysql.server start
sudo mysql.server start
1
2
3
4
5
2
3
4
5
# 三、安装和卸载
brew install mysql
brew install --cask mysqlworkbench
brew services start mysql
open -a MySQLWorkbench
mysqlworkbench
1
2
3
4
5
2
3
4
5
brew services stop mysql
brew uninstall mysql
rm -rf /usr/local/var/mysql
rm /usr/local/etc/my.cnf
sudo dscl . -delete /Users/_mysql
sudo dscl . -delete /Groups/_mysql
1
2
3
4
5
6
7
8
9
2
3
4
5
6
7
8
9