MySQL root access from all hosts

by

Update:

As mentioned in the comments, since MySql 8 you need to first explicitly create the user, so the command will look like:

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

Original answer:

There’s two steps in that process:

a) Grant privileges. As root user execute with this substituting 'password' with your current root password :

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

b) bind to all addresses:

The easiest way is to comment out the line in your my.cnf file:

#bind-address = 127.0.0.1

and restart mysql

service mysql restart

By default it binds only to localhost, but if you comment the line it binds to all interfaces it finds. Commenting out the line is equivalent to bind-address=*.

To check where mysql service has binded execute as root:

netstat -tupan | grep mysql

Update For Ubuntu 16:

Config file is (now)

/etc/mysql/mysql.conf.d/mysqld.cnf

(at least on standard Ubuntu 16)

More Related Contents:

  1. Node.js can’t authenticate to MySQL 8.0
  2. How to connect to MySQL from the command line
  3. 1052: Column ‘id’ in field list is ambiguous
  4. Codeigniter – multiple database connections
  5. Column count doesn’t match value count at row 1
  6. How to add levenshtein function in mysql?
  7. How to search JSON data in MySQL?
  8. MySQL error 1449: The user specified as a definer does not exist
  9. MySQL – UPDATE query with LIMIT
  10. phpMyAdmin on MySQL 8.0 [duplicate]
  11. Change decimal separator in MySQL
  12. Fetching linked list in MySQL database
  13. How to skip certain database tables with mysqldump?
  14. How can I correct MySQL Load Error
  15. Count number of unique values
  16. ‘Access denied for user ‘root’@’localhost’ (using password: NO)’
  17. MySQL treats ÅÄÖ as AAO?
  18. Count with IF condition in MySQL query
  19. mysql_fetch_row() vs mysql_fetch_assoc() vs mysql_fetch_array() [duplicate]
  20. Authentication with old password no longer supported, use 4.1 style passwords
  21. Mysql select where not in table
  22. How to format number with “.” as thousands separator and “,” as decimal separator?
  23. Using DISTINCT and COUNT together in a MySQL Query
  24. Which DATATYPE is better to use TEXT or VARCHAR?
  25. Error installing mysqlclient for python on Ubuntu 18.04
  26. WooCommerce: Finding the products in database
  27. How can I “select *” from a table in MySQL but omit certain columns?
  28. For homebrew mysql installs, where’s my.cnf?
  29. MySQL Select Multiple VALUES
  30. Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?

Leave a Comment