MySQL new user and database access authorization

# MySQL-U root-p# allows local IP access to localhost,127.0.0.1# Insert  intoMysql.User(Host,User, Password)Values('localhost','Zhouz', Password ('1234') ; # allow extranet IP Access #Insert  intoMysql.User(Host,User, Password)Values('%','Zhouz', Password ('1234') ; # Refresh Authorization # flushPrivileges; # Create a database #Create DatabaseZhouzdbDEFAULTCHARSET UTF8 COLLATE utf8_general_ci;# grant the user full access to the database through the extranet IP #Grant  All Privileges  on' Zhouzdb '.*  to 'Zhouz'@'%'Identified by '1234'# Grant the user full permissions on the database on the local server #Grant  All Privileges  on' Zhouzdb '.*  to 'Zhouz'@'localhost'Identified by '1234'; # Refresh permissions # flushPrivileges# quit root Login # \q# has a new account Zhouz login, due to the use of%Any IP connection, so you need to specify external access ip# MySQL-U Zhouz-H192.168.1.168 -p#1234

MySQL new user and database access authorization