These two days, I encountered some problems, I am afraid to forget, put it up, keep the spare this method is to search on Google, but he is from 9cbs, ^ _ ^ 1, enter mysql, create a new user Xuys: Format: GRANT Permissions ON Database Name. Table Name User @ Login Host Identified by "User Password"; Grant SELECT, UPDATE, INSERT, DELETE ON *. * To Xuys@192.168.88.234 Identified by "Xuys1234"; View Results, Execution: Use mysql; select host, user, password from user; you can see Xuys users who have just created in the User table. The Host field represents the host of the login. It is also possible to use the host name to use the host name. If the value of the Host field is changed to the% to the Mysql server on any client machine, it is recommended to set to% in the development time. . Update user set host = '%' where user = 'xuys'; 2, ./mysqladmin-uroot -p21century reload ./mysqladmin-URoot -p21century shutdown3,. / mysqld_safe --user-root & remember: on the authorization form Any modification requires re-relevo, which will be implemented in step 3.
If the above three steps or cannot be connected to the client, do the following, insert a record in the DB table of the MySQL database: use mysql; Insert Into DB VALUES ('192.168.88.234,'% ',' Xuys' , 'Y', 'y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'); Update DB set host = '%' where user = 'xuys'; Repeat the second, 3 above.
