CODEWITHSUNDEEP
mysql
Alex.Barylski
Alex.Barylski

Reputation: 2933

mysql fails to allow remote connection

I have followed the steps here:

ERROR 1130 (HY000): Host '' is not allowed to connect to this MySQL server

Carried out this activity dozens of times and it worked -- now for some reason it is not

I have done:

  1. Comment out bind-address in my.cnf and restart service
  2. GRANT ALL PRIVILEGES ON . TO 'root'@'%';
  3. FLUSH PRIVILEGES;

The only difference here is that MySQL is running in a VM under VirtualBox and I am connecting to the VM mysql instance via WIndows 7.

SSH and other services work fine...

The passwords are fine as they work when I connect via SSH...

My new modem/router possibly at fault, blocking outgoing or ingoing connections on port 3306???

I assume that traffic from a host to guest still goes through the router...but the thing is...my requests are certainly making to the MySQL server as the log file shows fail requests...

WTF amm I missing???

The error I receive: Error No. 1045 Access denied for user 'root'@'my-desktop' (Using Passowrd: YES)

Upvotes: 0

Views: 193

Answers (2)

vch
vch

Reputation: 211

You also have to edit my.cnf. Change:

bind-address           = 127.0.0.1

to

#bind-address           = 127.0.0.1

then restart mysql. Also, if you are going to allow outside access, create a user other than root. That's always a bad idea.

Upvotes: 1

meda
meda

Reputation: 45490

By default connection from outside are not allowed for security reasons.

Because exposing your database to the public internet is never a good idea, you will need to whitelist the IP address manually to allow connection.

Upvotes: 0

Related Questions