mac开启mysql，重置mysql密码，允许远程连接

一.mac系统开启关闭mysql

sudo /usr/local/mysql/support-files/mysql.server start

 sudo /usr/local/mysql/support-files/mysql.server stop

 sudo /usr/local/mysql/support-files/mysql.server restart

二.mac系统忘了mysql密码怎么重置

1.关闭mysql服务

sudo /usr/local/mysql/support-files/mysql.server stop

2.安全模式启动mysql

sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables

3.Command + N重新打开一个终端，输入

Mysql -u root 

4.重置密码

SET PASSWORD FOR zhanghai@'%' = 'zhanghai';

或者

FLUSH PRIVILEGES;SET PASSWORD FOR root@'localhost' = PASSWORD('重新设置的密码');

5.重新启动一下mysql就可以正常访问了

sudo /usr/local/mysql/support-files/mysql.server restart

三.mysql 8 设置允许远程连接

1.连接数据库

mysql -u root -p

2.进入mysql数据库

use mysql;

3.查看用户相关信息

select host, user, authentication_string, plugin from user; 

注：如果没有上述%号显示，则执行以下语句

update user set host = '%' where user = 'root';

4.设置允许远程用户访问

GRANT ALL ON *.* TO 'root'@'%'；

5.刷新权限

flush privileges;    

四.新建账号

1.新建账号

create user '用户名'@'%' identified by '密码';

2.给账号授权数据库

grant all privileges on 数据库.* to '用户名'@'%' ;

五.解决1227错误

对用户授权即可

GRANT PROCESS ON *.* TO 'root'@'%'；

六.解决1129错误

mysqladmin flush-host -h 127.0.0.1 -u root -p123456