Mysql: Unable to log in Mysql Server remotely
Pick one
Try to log in to MySQL Server with MySQL Admin Strator, Server Reply Error message: Host '60 -248-32-13.hinet-ip.hinet.net' Is Not Allowed to Connect To thismysql Server
This is because of the privilege, how is the following: shell> mysql --user = root -p Enter password mysql> use mysqlmysql> grant select, insert, update, delete on [db_name]. * To [username] @ [ipadd] Identified by '[Password]';
[username]: Remote login user code [DB_NAME]: Indicates Database Model [Password] to be open to the user: Remote login user password [ipadd]: IP address or IP Reflection DNS Name, this example The content needs to be filled in '60 -248-32-13.hinet-ip.hinet.net ', the card letter is induced (')
(It is actually executed on the remote server, the address fills in the IP address of the local host.)
If you want to open all permissions, please: mysql> update user set select_priv = 'y', INSERT_PRIV = 'Y', delete_priv = 'y', create_priv = 'y', Drop_Priv = 'Y', Reload_priv = 'Y', shutdown_priv = 'Y', Process_priv = 'Y', File_priv = 'Y', Grant_priv = 'Y', references_priv = 'Y', Index_priv = 'Y', Alter_priv = 'Y', Show_db_priv = 'Y', Super_priv = 'Y', Create_tmp_table_priv = 'Y', Lock_tables_priv = 'Y', Execute_priv = 'Y', Repl_slave_priv = 'Y', Repl_client_priv = 'Y' where user = '[username]';
Pick
How to solve the client and server connection (mysql): xxx.xxx.xxx.xxx is not allowed to connect to this MySQL Serv
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. . 3,. / Mysqld_safe --user-root & Remember: Any modification of the authorization table needs to re-reload, which is executed 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.
three,
Additional FBYSSS Solve the method of pHPMYADMIN connection remote users:
1. Log in to the remote mysql server with the root account,
Grant SELECT, UPDATE, INSERT, DELETE ON *. * to sss@192.168.0.114 Identified by "SSS"
Update user set host = '%' where user = 'sss';
Exit MySQL, execute it under the shell #MYSQLADMIN -U ROOT -P [Password] Reload
#mysqladmin -u root -p [password] Shutdown
# / etc / rc.d / init.d / mysqld start
2.
Modify the config.inc.php file under the phpMyAdmin directory, find
$ CFG ['Servers'] [$ I] ['Host'] Modified to Remote Server Address $ CFG ['Servers'] [$ I] ['User'] Modified to SSS
$ CFG ['Servers'] [$ I] ['Password'] Modified to SSS password
It should be noted that: Grant All Privilege does not assign "Grant" permissions to the user. If you want to add, you can use Use mysql directly in MySQL; Update User Set Grant_Priv = 'Y' to achieve the requirements.
