MySQL修改用户密码与权限设置

    grant 权限 on 库名.表名 to '用户名'@'IP' identified by '密码';
    mysql> grant all privileges on *.* to 'root'@'localhost' identified by '000000';
    Query OK, 0 rows affected (0.03 sec)
    
    mysql> grant all privileges on *.* to 'root'@'%' identified by '000000';
    Query OK, 0 rows affected (0.00 sec)
    
    
      
      
      
      
      
      
    

    Syntax:
    SET PASSWORD [FOR user] = password_option
    
    password_option: {
    PASSWORD('auth_string')
      | OLD_PASSWORD('auth_string')