linux mysql命令

连接mysql
mysql -uroot -p
回车后：输入密码

查看所有数据库
show databases;

选中数据库
use 数据库名
举例：use mysql;

查看用户
select user,host from user;

创建用户
create user ‘用户名’@‘主机名’ identified by ‘密码’;
举例：create user ‘root’@‘101.132.185.87’ identified by ‘’;

退出mysql
快捷键ctrl+c

改服务器上mysql的权限，%：表示可以任何主机都能连接到mysql服务器
GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’ IDENTIFIED BY ‘自己数据库的密码’ WITH GRANT OPTION;
如：GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’ IDENTIFIED BY ‘’ WITH GRANT OPTION;

或者 % 换成自己本地的IP地址
GRANT ALL PRIVILEGES ON . TO ‘root’@‘192.168.x.x’ IDENTIFIED BY ‘这里写自己数据库的密码’ WITH GRANT OPTION;

刷新权限使其生效
FLUSH PRIVILEGES;

关闭服务
service mysql stop;
开启服务
service mysql start;
进行登录
mysql -u root -p
该账号下的mysql数据库
show databases;

修改user表的root用户
update user set host = ‘%’ where user = ‘root’

查看mysql安装位置
在mysql命令行中执行
show variables like ‘%basedir%’;