grant remote access of MySQL database from any IP address

by 
TO 'user'@'%'

% is a wildcard – you can also do '%.domain.com' or '%.123.123.123' and things like that if you need.

More Related Contents:

  1. How to grant remote access permissions to mysql server for user?
  2. MySQL grant all privileges to database except one table
  3. How to grant remote access to MySQL for a whole subnet?
  4. GRANT with database name wildcard in MySQL?
  5. SQL split values to multiple rows
  6. How do I escape reserved words used as column names? MySQL/Create Table
  7. How to store multiple options in a single table?
  8. How to populate a table with a range of dates?
  9. Throw an error preventing a table update in a MySQL trigger
  10. MySQL and GROUP_CONCAT() maximum length
  11. What data type to use for hashed password field and what length?
  12. MySQL pagination without double-querying?
  13. MySQL convert date string to Unix timestamp
  14. How to speed up SELECT .. LIKE queries in MySQL on multiple columns?
  15. MySql Table Insert if not exist otherwise update
  16. How do I select an entire row which has the largest ID in the table?
  17. MySQL error 1064 syntax but everything seems fine
  18. MySQL/MariaDB – order by inside subquery
  19. How to run SQL script in MySQL?
  20. My MySQL trigger doesn’t work, simple syntax, not complicated
  21. Removing MySQL 5.7 Completely [closed]
  22. How to optimize COUNT(*) performance on InnoDB by using index
  23. script to convert mysql dump sql file into format that can be imported into sqlite3 db
  24. Sum results of a few queries and then find top 5 in SQL
  25. ERROR 1148: The used command is not allowed with this MySQL version
  26. ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
  27. Too many auto increments with ON DUPLICATE KEY UPDATE
  28. Unserialize through query at database level itself
  29. Detecting utf8 broken characters in MySQL
  30. django cannot connect mysql in docker-compose

Leave a Comment