Mysql5.7.10新加使用者

zping發表於2016-01-22
INSERT INTO mysql.user(HOST,USER,authentication_string,ssl_cipher,x509_issuer,x509_subject,select_priv) 
VALUES('192.168.60.%','hzx',PASSWORD('123'),'','','','Y');

UPDATE USER SET authentication_string=PASSWORD("123") WHERE USER="hzx";

insert into `user` (`Host`, `User`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Create_user_priv`, `Event_priv`, `Trigger_priv`, `Create_tablespace_priv`, `ssl_type`, `ssl_cipher`, `x509_issuer`, `x509_subject`, `max_questions`, `max_updates`, `max_connections`, `max_user_connections`, `plugin`, `authentication_string`, `password_expired`, `password_last_changed`, `password_lifetime`, `account_locked`) values('%','root','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','','0','0','0','0','mysql_native_password','*8CA43C54A4C481D73918D03479A51528EE3C9050','N',NOW(),NULL,'N');


UPDATE user SET authentication_string=PASSWORD('123');


FLUSH PRIVILEGES;

 

 SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user

 如果出現:

You must reset your password using ALTER USER statement before executing this statement.

  使用下列命令更新密碼:

      mysql> SET PASSWORD = PASSWORD('123');  這句話重新設定一次密碼

 

相關文章