Mysql adds, deletes, and adds Permissions

Mysql adds, deletes, and adds Permissions
Create mysql> insert into mysql. user (Host, User, Password) values ("localhost", "test", password ("1234"); adds a user name named test and Password of 1234, however, this user can only log on locally. If you want to log on remotely, you can change localhost to % to indicate that any computer can log on, or change to a specific ip address to indicate that you can only log on to a specific ip address. Add permissions for mysql> grant all privileges on testDB. * to test @ localhost identified by '20140901'; indicates that you have added any operations on all tables in the testDB database during local login to test. If you want to specify permissions, you can change all privileges to select, update, or delete or a combination of the three. If you want to specify table permissions, you can set testDB. * Changing to testDB.info indicates that operations can be performed on the info table in the testDb database. to specify the access address, you can change @ % to localhost, indicating that user test can only perform database operations locally. Refresh the system permission table mysql> flush privileges; Delete the user mysql> Delete FROM User Where user = 'test' and Host = 'localhost '; delete account and permission mysql> drop user username @ '%'; Change user Password mysql> update mysql. user set password = password ('new password') where User = "test" and Host = "localhost ";