一.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