mac安装mysql
安装
brew install mysql
启动
brew services start mysql
安装后提示信息
To have launchd start mysql now and restart at login:
brew services start mysql
Or, if you don't want/need a background service you can just run:
mysql.server start
==> Summary
/usr/local/Cellar/mysql/8.0.25_1: 300 files, 289.3MB
==> Caveats
==> mysql
We've installed your MySQL database without a root password. To secure it run:
mysql_secure_installation
MySQL is configured to only allow connections from localhost by default
To connect run:
mysql -uroot
To have launchd start mysql now and restart at login:
brew services start mysql
Or, if you don't want/need a background service you can just run:
mysql.server start
安装后提示信息
select host,user,authentication_string from mysql.user;
host: 允许用户登录的ip‘位置'%表示可以远程;
user:当前数据库的用户名;
authentication_string: 用户密码(后面有提到此字段)
如果authentication_string下面有值则清空
use mysql;
update user set authentication_string='' where user='root'
设置root密码
ALTER user 'root'@'localhost' IDENTIFIED BY 'root'
连接mysql
mysql -uroot -p