How to grant remote access permissions to mysql server for user?

by

This grants root access with the same password from any machine in *.example.com:

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

If name resolution is not going to work, you may also grant access by IP or subnet:

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

MySQL GRANT syntax docs.

More Related Contents:

  1. grant remote access of MySQL database from any IP address
  2. MySQL show status – active or total connections?
  3. MySQL grant all privileges to database except one table
  4. mySQL Error 1040: Too Many Connection
  5. How to grant remote access to MySQL for a whole subnet?
  6. How to kill MySQL connections
  7. GRANT with database name wildcard in MySQL?
  8. MySQL giving “read ECONNRESET” error after idle time on node.js server
  9. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  10. SELECTING with multiple WHERE conditions on same column
  11. Should MySQL have its timezone set to UTC?
  12. Using union and order by clause in mysql
  13. Exporting results of a Mysql query to excel?
  14. OUTPUT Clause in MySQL
  15. use mysql SUM() in a WHERE clause
  16. Sorting by date & time in descending order?
  17. passing LIMIT as parameters to MySQL sproc
  18. Case statement in MySQL
  19. MySQL: Inner join vs Where [duplicate]
  20. MySQL ‘UPDATE ON DUPLICATE KEY’ without a unique column?
  21. Import MySQL dump to PostgreSQL database
  22. How to select data where a field has a min value in MySQL?
  23. Database corruption with MariaDB : Table doesn’t exist in engine
  24. How to SELECT by MAX(date)?
  25. MYSQL declaring variables
  26. get a recursive parent list
  27. MYSQL – Split Data Into Multiple Rows
  28. Strip last two characters of a column in MySQL
  29. mysql double-quoted table names
  30. php connection pooling mysql [duplicate]

Leave a Comment