asked in Software by (8.9k points)
0 like 0 dislike
32 views

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 ‘255.255.255.255’ is not allowed to connect to this MySQL server".

mysql remote access

1 Answer

0 like 0 dislike
answered by (8.9k 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        = 127.0.0.1

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.

Related questions

0 like 0 dislike
1 answer 42 views
0 like 0 dislike
1 answer 36 views
0 like 0 dislike
1 answer 32 views
0 like 0 dislike
1 answer 20 views
0 like 0 dislike
1 answer 44 views
0 like 0 dislike
1 answer 22 views
0 like 0 dislike
1 answer 19 views
0 like 0 dislike
1 answer 38 views
...