Activating remote access on MySQL database

Asked Jan 03 '20 at 08:52

Active Jan 03 '20 at 10:46

Viewed 57 times

I am trying to access my MySQL server remotely, I have an old pc as dedicated server running on a different address and I want to try to connect to it remotely from my laptop, how would I do this.

I've tried a lot of options, the the one most commonly found is
GRANT ALL ON *.* TO 'user'@'%' IDENTIFIED BY 'password';

I just get a syntax error, near the IDENTIFIED BY

but this didn't work, and I can't find any other solutions

edited Jan 03 '20 at 09:27

Jonathan Willcock

5,012
3
20
31

asked Jan 03 '20 at 08:52

Gido Selten

Can you please update your question with the exact syntax error you are getting? – Jonathan Willcock Jan 03 '20 at 09:36
https://stackoverflow.com/questions/8348506/grant-remote-access-of-mysql-database-from-any-ip-address – jarlh Jan 03 '20 at 10:29
@JonathanWillcock it doesn't specify – Gido Selten Jan 03 '20 at 10:40

Activating remote access on MySQL database

0 Answers0