Win7 32-bit system that operates MySQL through the dbforge Studio MySQL toolmysql Add user, new database, user authorization, delete user, change password (note that each line followed by A; indicates that a command statement ends):
1. Create a connection
1.1 Login MySQL: Log in with Root
Test the state.
1.2 Create User:
GRANT USAGE on *. * to ' User01 ' @ ' localhost ' identified by ' 123456 ' with GRANT OPTION;
The red part above is a non-existent user, execute the above statement, create a user is: username, password: password user.
1.3 Then log in:
Test it.
2. Authorizing the user
Log in with the root user, after the login interface
With the root login mode, the authorization format: Grant permissions on the database. * To username @ Login host identified by "password";
2.1 If you want to specify Partial permissions to a user, you can write:
Grant Select,update on testdb.* to [e-mail protected] identified by ' 123456 ';
Flush privileges; Refresh System Permissions Table
2.2 Authorize this database to telnet to the User01 user Permissions:
For example, if you want to myuser use MyPassword to connect to a MySQL server from any host.
GRAN T all privileges on * * to ' myuser ' @ '% ' identified by ' MyPassword ' with GRANT OPTION;
FLUSH privileges;
If you want to allow users to connect to a MySQL server from a host myuser IP 192.168.1.9 and use MyPassword as the password
GRANT all privileges on *. * to ' myuser ' @ ' 192.168.1.3 ' identified by ' MYP Assword ' with GRANT OPTION;
FLUSH privileges;
If you want to allow users to connect to the MySQL server's DK database myuser from the IP-192.168.1.9 host, and use MyPassword as the password
GRANT all privileges the dk.* to ' myuser ' @ ' 192.168.1.3 ' identified by ' MyPassword ' with GRANT OPTION;
FLUSH privileges;
2.3 Authorized User01 users have some permissions for all databases:
Mysql>grant Select,delete,update,create,drop on * * to User01@ "%" identified by "123456";
User01 users have Select,delete,update,create,drop permissions on all databases.
@ "%" indicates authorization for all non-local hosts, excluding localhost. (The localhost address is set to 127.0.0.1, if set to the real local address, do not know whether it can, no authentication.) )
Authorization to localhost: plus a grant all privileges on testdb.* to [email protected] identified by ' 1234 ';
MySQL add user with authorization (dbforge studio MySQL) text detailed, remote access