常用Mysql命令

赋予某Ip远程操作权限

1)  select user,host,password from mysql.user;

2)  grant all privileges on *.* to 'root'@'192.168.0.1' identified by 'flashbox_test' with grant option;

3)  flush privileges;

修改密码：

  UPDATE user SET Password=PASSWORD('admin') where USER='root';

Linux 文件权限赋予：

  chown -R admin:admin  /home