MySQL new user and database access authorization

# mysql-u root-p# allows local IP access to localhost, 127.0.0.1# insert into Mysql.user (Host,user,password) VALUES (' localhost ', ' Zhouz ' , password (' 1234 ')); # Allow extranet IP access # INSERT INTO Mysql.user (Host,user,password) VALUES ('% ', ' Zhouz ', password (' 1234 ')); Refresh Authorization # flush privileges;# Creating database # Create databases zhouzdb DEFAULT CHARSET UTF8 COLLATE utf8_general_ci;# Grant users all of the database through the extranet IP Permissions # Grant all Privileges "zhouzdb". * to ' Zhouz ' @ '% ' identified by ' 1234 '; # grant the user full permissions on the database on the local server # grant all privileges O N ' zhouzdb '. * to ' Zhouz ' @ ' localhost ' identified by ' 1234 '; # flush privileges;# exit root re-login # \q# New account Zhouz login, due to the use of is% any IP connection, so you need to specify external access ip# mysql-u zhouz-h 192.168.1.168-p# 1234

Usually rarely use the MySQL command line mode operation, today get the new user authorization, encountered some problems here simple collation

Note: If you only open extranet access, you will not be able to access it locally, and you will need to add local access if you want to access MySQL on your local server.

MySQL new user and database access authorization