in Software by (10.1k points)
0 like 0 dislike

How I can to enable remote access in MySQL DBMS?

I try to connect to mysql server from remote machine, and run into error like: "ERROR 1130 (HY000): Host ‘’ is not allowed to connect to this MySQL server".

mysql remote access

1 Answer

0 like 0 dislike
by (10.1k points)

You need turn off (commented) bind-address directive in configuration file (usually named mysqld.cnf) of your MySQL server like this:

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
# bind-address        =

Your answer

Try to answer the question as detailed as possible.
Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.