ERROR 1130 (HY000): Host ” is not allowed to connect to this MySQL server [duplicate]

by

Your root account, and this statement applies to any account, may only have been added with localhost access (which is recommended).

You can check this with:

SELECT host FROM mysql.user WHERE User="root";

If you only see results with localhost and 127.0.0.1, you cannot connect from an external source. If you see other IP addresses, but not the one you’re connecting from – that’s also an indication.

You will need to add the IP address of each system that you want to grant access to, and then grant privileges:

CREATE USER 'root'@'ip_address' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip_address';

If you see %, well then, there’s another problem altogether as that is “any remote source”. If however you do want any/all systems to connect via root, use the % wildcard to grant access:

CREATE USER 'root'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

Finally, reload the permissions, and you should be able to have remote access:

FLUSH PRIVILEGES;

More Related Contents:

  1. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  2. MySQL: How to reset or change the MySQL root password?
  3. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  4. Remote Connections Mysql Ubuntu
  5. Install MySQL on Ubuntu without a password prompt
  6. How to insert BLOB and CLOB files in MySQL?
  7. Removing MySQL 5.7 Completely [closed]
  8. MySQL fails on: mysql “ERROR 1524 (HY000): Plugin ‘auth_socket’ is not loaded”
  9. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysql.sock’ (2)
  10. MYSql config bind-address set to 0.0.0.0 but netstat shows different on Ubuntu
  11. Remove duplicate rows in MySQL
  12. Split value from one field to two
  13. Error Code: 2013. Lost connection to MySQL server during query
  14. MySQL DISTINCT on a GROUP_CONCAT()
  15. SQL Performance UNION vs OR
  16. MySQL ON DUPLICATE KEY – last insert id?
  17. MySQL user DB does not have password columns – Installing MySQL on OSX
  18. MySQL – can I limit the maximum time allowed for a query to run?
  19. MySQL ‘user_id’ in where clause is ambiguous problem
  20. What does it mean when MySQL is in the state “Sending data”?
  21. How to insert data to MySQL with auto-incremented column(field)?
  22. SQL Server equivalent of substring_index function in MySQL
  23. Remote connect to clearDB heroku database
  24. Use MySQL to determine whether today is a user’s birthday
  25. How can you determine how much disk space a particular MySQL table is taking up?
  26. Can’t connect to RDS instance from EC2 instance
  27. Access mysql running on localhost from minikube
  28. MySQL fulltext search – Only results that contain all words
  29. How to use `bcrypt` algorithm within `encrypt` function in MySQL for verifying password?
  30. How do I add more members to my ENUM-type column in MySQL?

Leave a Comment