#### 登录 * * * * * > [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>