1. mysql的启动、停止、重启命令
在MySQL安装目录下:
启动命令:./support-files/mysql.server start
重启命令:./support-files/mysql.server restart
停止命令:./support-files/mysql.server stop
2. 查看是否启动
ps -ef|grep mysql # 查看mysql 进程
netstat -ano |grep "3306" # 查看3306端口
3. 配置mysql允许远程访问:
1、创建远程登录对象:
CREATE USER 'root'@'%' IDENTIFIED BY '123456';
2、授权远程登录:
grant all privileges on *.* to 'root'@'%' with grant option;
3、强制刷新:
flush privileges;
use mysql;
#mysql8==>不允许<==授权并创建用户了,要分开使用
grant all privileges on *.* to '新用户名'@'%' identified by '密码' with grant option;
grant all privileges on *.* to '新用户名'@'指定ip' identified by '密码' with grant option;
例如:以前使用
grant all privileges on *.* to 'root'@'%' identified by "123456" with grant option;
mysql8分开操作为:
CREATE ROLE 'root'@'%'; #创建角色CREATE USER 'root'@'%' IDENTIFIED BY '123456';
ALTER USER 'root'@'%' IDENTIFIED with mysql_native_password by '123456'; #修改密码
grant all privileges on *.* to "root"@"%"; #给角色授权
flush privileges; #刷新权限
#另外修改主机
update mysql.user set host='具体要指定的主机ip' where user='root';
RENAME USER 'jeffrey'@'localhost' TO 'jeff'@'127.0.0.1'; #重命名
flush privileges; #刷新权限
select user,host,authentication_string from user;
注:远程连接需要开放端口防火墙,阿里云用户还需要在安全组中开放端口
引用原文:
https://blog.csdn.net/u010565545/article/details/104961184
https://blog.csdn.net/u010476739/article/details/100083959