Mysql adding user for remote access

by

In order to connect remotely, you have to have MySQL bind port 3306 to your machine’s IP address in my.cnf. Then you have to have created the user in both localhost and ‘%’ wildcard and grant permissions on all DB’s as such . See below:

my.cnf (my.ini on windows)

#Replace xxx with your IP Address 
bind-address        = xxx.xxx.xxx.xxx

Then:

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';

Then:

GRANT ALL ON *.* TO 'myuser'@'localhost';
GRANT ALL ON *.* TO 'myuser'@'%';
FLUSH PRIVILEGES;

Depending on your OS, you may have to open port 3306 to allow remote connections.

More Related Contents:

  1. MySQL remote connection fails with “unknown authentication method”
  2. Out of memory Microsoft VBScript runtime error 800a0007
  3. MySQL how to fill missing dates in range?
  4. Left Outer Join doesn’t return all rows from my left table?
  5. How can i optimize MySQL’s ORDER BY RAND() function?
  6. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  7. How to split the name string in mysql?
  8. Normalization in MYSQL
  9. Is there a REAL performance difference between INT and VARCHAR primary keys?
  10. How do I do a fuzzy match of company names in MYSQL with PHP for auto-complete?
  11. how to compute similarity between two strings in MYSQL
  12. Timestamp with a millisecond precision: How to save them in MySQL
  13. Combine Multiple child rows into one row MYSQL
  14. sql join two table
  15. How to schedule a MySQL query?
  16. Is there a Profiler equivalent for MySql? [closed]
  17. Cast int to varchar
  18. LOAD DATA LOCAL INFILE gives the error The used command is not allowed with this MySQL version
  19. Import SQL file into mysql
  20. MySQL SELECT last few days?
  21. How do you debug MySQL stored procedures?
  22. Schrödingers MySQL table: exists, yet it does not
  23. MySQL Calculate Percentage
  24. ld: library not found for -lzstd while bundle install for mysql2 gem Ruby on macOS Big Sur 11.4 Apple M1
  25. How to migrate SQL Server database to MySQL? [closed]
  26. How to insert selected columns from a CSV file to a MySQL database using LOAD DATA INFILE
  27. how to cast the hexadecimal to varchar(datetime)?
  28. Postgres LEFT JOIN with WHERE condition
  29. MySQL – Using COUNT(*) in the WHERE clause
  30. Rank() over Partition by in mysql

Leave a Comment