Experiences of mysql Remote Data Connection

Mysql Remote Data Connection Experience summary [SQL] <span style = "font-family: Helvetica, Tahoma, Arial, sans-serif;"> 1. new User </span> [SQL] mysql> insert into mysql. user (Host, User, Password) values ("localhost", "lionbule", password ("hello1234"); mysql> flush privileges; 2. modify the User Password www.2cto.com [SQL] mysql> update mysql. user set password = password ('new password') where User = "lionbule" and Host = "localhost"; mysql> flush privileges; 3. DELETE user [SQL] mysql> DELETE FROM User WHERE user = "lionbule" and Host = "localhost"; mysql> flush privileges; 4. permission allocation 4.1. grant usage grant permission on database. * to username @ 'login host' identified by 'Password' [SQL] permission: Common summary, ALL/ALTER/CREATE/DROP/SELECT/UPDATE/DELETE database :*. * Indicates all tables in all databases. * Indicates all tables in the test database. test_table indicates the test_table table username of the test Database: mysql account name login HOST: www.2cto.com allow login to mysql server Client ip '%' indicates all ip addresses 'localhost' indicates the local machine '123. 168.10.2 'specific IP password: the logon password of the account is as follows: [SQL] mysql> grant all on test. * to lionbule @ '%' identified by 'hello1234'; mysql> flush privileges;