之前在Mac下安装Mysql8.0的时候和Mysql5.7有一些不一样的地方,这里把我自己的安装过程简单记录一下。
安装brew
ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" |
安装Mysql8.0
brew install mysql mysql.server start mysql_secure_installation mysql -uroot -p mysql> select host,user,plugin from mysql.user; flush privileges; |
启动、停止、重启
mysql.server start mysql.server stop mysql.server restart |
修改密码
use mysql; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码'; FLUSH PRIVILEGES; |
删除MySql
brew uninstall mysql brew cleanup sudo rm /usr/local/mysql sudo rm -rf /usr/local/mysql* sudo rm -rf /Library/StartupItems/MySQLCOM sudo rm -rf /Library/PreferencePanes/My* sudo vim /etc/hostconfig (ps:需要删除其中的MYSQLCOM=-YES-) sudo rm -rf ~/Library/PreferencePanes/My* sudo rm -rf /Library/Receipts/mysql* sudo rm -rf /Library/Receipts/MySQL* sudo rm -rf /var/db/receipts/com.mysql.* |
添加账号
CREATE USER 'sampadm'@'localhost' IDENTIFIED BY 'secret'; |
赋权
GRANT ALL ON sampdb.* TO 'sampadm'@'localhost'; |
本文内容不用于商业目的,如涉及知识产权问题,请权利人联系51Testing小编(021-64471599-8017),我们将立即处理