#### 登录
* * * * *
> [root@iZ23y6t26auZ ~]$ mysql -u root -p
> Enter password:
#### 命令
* * * * *
> grant all privileges on . to ‘root’@’%’ identified by ‘123456’ with grant option;
> flush privileges;
#### 示例
* * * * *
> GRANT ALL PRIVILEGES ON youliao.* TO ‘root’@‘180.173.85.193’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION;
#### 释义
* * * * *
> <div class="aaa">将 youliao 数据库的所有权限授权给 root 这个用户,允许 root 用户在 180.173.85.193 这个IP进行远程登录,并设置 root 用户的密码为 123456</div>