Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server

Possibly a security precaution. You could try adding a new administrator account:

mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    ->     WITH GRANT OPTION;
mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
    ->     WITH GRANT OPTION;

Although as Pascal and others have noted it’s not a great idea to have a user with this kind of access open to any IP. If you need an administrative user, use root, and leave it on localhost. For any other action specify exactly the privileges you need and limit the accessibility of the user as Pascal has suggest below.

Edit:

From the MySQL FAQ:

If you cannot figure out why you get Access denied, remove from the user table all entries that have Host values containing wildcards (entries that contain ‘%’ or ‘_’ characters). A very common error is to insert a new entry with Host=’%’ and User=’some_user’, thinking that this allows you to specify localhost to connect from the same machine. The reason that this does not work is that the default privileges include an entry with Host=’localhost’ and User=”. Because that entry has a Host value ‘localhost’ that is more specific than ‘%’, it is used in preference to the new entry when connecting from localhost! The correct procedure is to insert a second entry with Host=’localhost’ and User=’some_user’, or to delete the entry with Host=’localhost’ and User=”. After deleting the entry, remember to issue a FLUSH PRIVILEGES statement to reload the grant tables. See also Section 5.4.4, “Access Control, Stage 1: Connection Verification”.

Related Posts:

  1. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  2. Cannot add or update a child row: a foreign key constraint fails
  3. Cannot add or update a child row: a foreign key constraint fails
  4. How to make MySQL table primary key auto increment with some prefix
  5. Cannot delete or update a parent row: a foreign key constraint fails
  6. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  7. Rename a column in MySQL
  8. Syntax error due to using a reserved word as a table or column name in MySQL
  9. MySQL root password change
  10. Installation of MySQL for Visual Studio 1.2.8 failed
  11. Not unique table/alias
  12. How do I import an SQL file using the command line in MySQL?
  13. Install mysql-python (Windows)
  14. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  15. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  16. SQL Query Where Field DOES NOT Contain $x
  17. Disable ONLY_FULL_GROUP_BY
  18. MySQL WHERE IN ()
  19. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  20. mysqladmin: connect to server at ‘localhost’ failed
  21. mysql update multiple columns with same now()
  22. Mysql command not found in OS X 10.7
  23. Usage of MySQL’s “IF EXISTS”
  24. MySQL – UPDATE query based on SELECT Query
  25. grabbing first row in a mysql query only
  26. mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
  27. Order a MySQL table by two columns
  28. MySQL AS keyword
  29. Should I use the datetime or timestamp data type in MySQL?
  30. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  31. How do I change the data type for a column in MySQL?
  32. Unknown Column In Where Clause
  33. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  34. Cannot connect to Database server (mysql workbench)
  35. mysqld: Can’t change dir to data. Server doesn’t start
  36. How to solve “Error: MySQL shutdown unexpectedly”?
  37. Can you do a For Each Row loop using MySQL?
  38. Drop all databases in MySQL
  39. How to properly create composite primary keys – MYSQL
  40. MySQL – count total number of rows in php
  41. How to get the count of each distinct value in a column?
  42. Data is not constantly loading from custom wordpress table
  43. How do you properly prepare a %LIKE% SQL statement?
  44. How to run WordPress across 2 VMs for high availability
  45. Mysqldump add drop table?
  46. How to disable `SQL_CALC_FOUND_ROWS` [duplicate]
  47. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  48. #1115 – Unknown character set: ‘utf8mb4’
  49. How to copy post titles to post slug in phpmyadmin
  50. WordPress Deadlock Error
  51. How to do a MySQL dump from production site without using a search and replace script for local development?
  52. How to bulk edit canonical url’s in SQL?
  53. Concurrent / simultaneous MySQL connections
  54. How to check for empty and not a failure
  55. What is the most secure way to set up the MySQL user in WPMU?
  56. How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
  57. Keeping database within limits, please help!
  58. Best settings for MySQL to speed up site? [closed]
  59. HTML Entities in Post Title
  60. Can’t find my wordpress DB in phpmyadmin
  61. Deprecated: mysql_connect():
  62. How are multiple WordPress WPDB queries handled?
  63. $wpdb select all meta for each post
  64. Calculate average crossing post categories
  65. Replacing link URL ending strings via MySQL
  66. Many slow queries post_type = ‘attachment’;
  67. SQL command to convert all tags in lowercase?
  68. Problem with admin login after deployment
  69. Find out how many times the user has logged in
  70. WordPress plugins for database queries
  71. Is it possible to create a WordPress table using array and loop?
  72. Can’t run database query
  73. How to stop $wpdb from prepending database name
  74. Match tag names with form titles
  75. Error missing MySQL extension
  76. Getting Error Trying to Create Table
  77. Best approach for a custom database filling in WP custom post types
  78. Why doesn’t custom mysql query return results? Is syntax correct?
  79. Insert two row in wordpress database
  80. SQL statement using placeholder is not returning results
  81. How to Bulk find and replace MySQL for post image url
  82. Wpdb query with dynamic table name
  83. How to search usermeta table
  84. Regular XML-RPC timeouts
  85. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  86. update multiple rows in mysqli table base on two values
  87. How can I verify WordPress nonce from the following code?
  88. How to write in MySQL more characters in user_nicename
  89. $wpdb->get_var not returning count
  90. Custom user query – orderby meta_key (that may not exist)
  91. How to get Attachments(image) with specific width\height ratio
  92. What is the cron doing?
  93. Apache Redirect based on WordPress permissions
  94. SQL error on restoring database
  95. MySQL database gives blank page (white screen of death)
  96. Datatabase error: Commands out of sync
  97. why is $wpdb->update() causing a DB error from within wp_set_password()
  98. Global MySQL replacing of text patterns/matches
  99. InnoDB: Error: log file ./ib_logfile0 is of different size
  100. Postgres equivalent to MySQL’s \G?

Leave a Comment