MySQL: How to allow remote connection to mysql

by

That is allowed by default on MySQL.

What is disabled by default is remote root access. If you want to enable that, run this SQL command locally:

 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
 FLUSH PRIVILEGES;

And then find the following line and comment it out in your my.cnf file, which usually lives on /etc/mysql/my.cnf on Unix/OSX systems. In some cases the location for the file is /etc/mysql/mysql.conf.d/mysqld.cnf).

If it’s a Windows system, you can find it in the MySQL installation directory, usually something like C:\Program Files\MySQL\MySQL Server 5.5\ and the filename will be my.ini.

Change line

 bind-address = 127.0.0.1

to

 #bind-address = 127.0.0.1

And restart the MySQL server (Unix/OSX, and Windows) for the changes to take effect.

More Related Contents:

  1. Calculate date range between two rows
  2. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  3. Error Code: 2013. Lost connection to MySQL server during query
  4. String concatenation in MySQL
  5. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  6. MySQL Foreign Key Error 1005 errno 150 primary key as foreign key
  7. MySQL error code: 1175 during UPDATE in MySQL Workbench
  8. Cannot connect to Database server (mysql workbench)
  9. How to connect mysql workbench to running mysql inside docker?
  10. MySQL Workbench: How to keep the connection alive
  11. How do I retrieve my MySQL username and password?
  12. MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be found
  13. MySQL error 1022 when creating table
  14. Is there a naming convention for MySQL?
  15. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  16. MySQL Errno 150
  17. MySQL Workbench: Error in query (1064): Syntax error near ‘VISIBLE’ at line 1
  18. error code 1292 incorrect date value mysql
  19. Order by FIELD in MYSQL
  20. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  21. Accessing a mysql database from external host/ip? (ie: mysql workbench)
  22. Error Code: 1062. Duplicate entry ‘1’ for key ‘PRIMARY’
  23. mySQL query to search all tables within a database for a string?
  24. Create a new database with MySQL Workbench
  25. Errno 121, duplicate key on write or update?
  26. Finding duplicate values in MySQL
  27. Error installing mysql2: Failed to build gem native extension
  28. using (-) dash in mysql table name
  29. How can I enable MySQL’s slow query log without restarting MySQL?
  30. MySQL cartesian product between two SELECT statements

Leave a Comment