Liunx下MySQL常用命令

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