Accessing a mysql database from external host/ip? (ie: mysql workbench)

by

You need to do 

GRANT ALL PRIVILEGES ON *.* TO mysql@'bla.bla.bla' ...

The part after the @ is the host from which the connection is coming, so you have allowed only connections coming from localhost. You need to allow access from each remote host necessary (or all hosts – ... mysql@'%' ... – if applicable).

More Related Contents:

  1. Calculate date range between two rows
  2. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  3. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  4. Can’t connect to MySQL server error 111 [closed]
  5. Error Code: 2013. Lost connection to MySQL server during query
  6. How do I find the MySQL my.cnf location
  7. MySQL: How to allow remote connection to mysql
  8. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  9. Stored procedure that Automatically delete rows older than 7 days in MYSQL
  10. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  11. MySQL Foreign Key Error 1005 errno 150 primary key as foreign key
  12. MySQL error code: 1175 during UPDATE in MySQL Workbench
  13. MySQL – ERROR 1045 – Access denied
  14. Cannot connect to Database server (mysql workbench)
  15. How to connect mysql workbench to running mysql inside docker?
  16. MySQL Workbench: How to keep the connection alive
  17. Bash script to insert values in MySQL
  18. How to change MySQL table names in Linux server to be case insensitive?
  19. Commit data in a mysql container
  20. Is there a naming convention for MySQL?
  21. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  22. libmysqlclient15-dev on macs?
  23. MySQL Errno 150
  24. MySQL fails on: mysql “ERROR 1524 (HY000): Plugin ‘auth_socket’ is not loaded”
  25. error code 1292 incorrect date value mysql
  26. Order by FIELD in MYSQL
  27. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  28. mySQL query to search all tables within a database for a string?
  29. Create a new database with MySQL Workbench
  30. Errno 121, duplicate key on write or update?

Leave a Comment