How to grant remote access to MySQL for a whole subnet?

by

It looks like you can also use a netmask, e.g.

GRANT ... TO 'user'@'192.168.0.0/255.255.255.0' IDENTIFIED BY ...

More Related Contents:

  1. grant remote access of MySQL database from any IP address
  2. How to grant remote access permissions to mysql server for user?
  3. MySQL grant all privileges to database except one table
  4. GRANT with database name wildcard in MySQL?
  5. MySQL and GROUP_CONCAT() maximum length
  6. What data type to use for hashed password field and what length?
  7. Which is faster: multiple single INSERTs or one multiple-row INSERT?
  8. MySQL pagination without double-querying?
  9. MySQL convert date string to Unix timestamp
  10. How to speed up SELECT .. LIKE queries in MySQL on multiple columns?
  11. Using an Alias in SQL Calculations
  12. MySql Table Insert if not exist otherwise update
  13. How to get difference between two dates in months using MySQL query?
  14. MySQL – Control which row is returned by a group by
  15. Can MySQL replace multiple characters?
  16. My MySQL trigger doesn’t work, simple syntax, not complicated
  17. Using ORDER BY and GROUP BY together
  18. How can VBA connect to MySQL database in Excel?
  19. updating columns with a sequence number mysql
  20. Select a column with a keyword name
  21. Sum results of a few queries and then find top 5 in SQL
  22. Select all months within given date span, including the ones with 0 values
  23. 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
  24. Use Composite Primary Key as Foreign Key
  25. How to use a user variables in MySQL LIKE clause?
  26. Linux shell script for database backup
  27. How can a query multiply 2 cell for each row MySQL?
  28. Rails select random record
  29. MySQL query to select results with auto increment as a new column added in the result
  30. How to import a csv file into MySQL workbench?

Leave a Comment