执行如下代码:
登录mysql:
mysql -uroot -ppassword
使用mysql数据库:
mysql> use mysql;
查看当前mysql中的配置信息:
mysql> select user,host,password from user;
赋权:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.1' IDENTIFIED BY 'password' WITH GRANT OPTION;
即时生效:
mysql> flush privileges;