CODEWITHSUNDEEP
mysqlexternalconnection
Sebastian
Sebastian

Reputation: 82

MySQL doesn't allow external connections

I have a problem with my MYSQL that doesn't allow external connections . I try to connect an website to an mysql that is on another server .

What I did was to comment in my.cnf skip-external-locking and bind-adress and it still doesn't work .

I also put the host % and also doesn't work .

When I try to connect from puty with mysql -h ip -u user -p I get this output: ERROR 1045 (28000): Access denied for user 'fulgeratii'@'myip' (using password: YES)

Upvotes: 0

Views: 682

Answers (1)

Spholt
Spholt

Reputation: 4012

It may be worth checking that the user you are trying to use has the correct grants on the mysql server.

To be sure i would try temporarily using the root user or granting all to your user like so:

GRANT ALL ON *.* TO 'fulgeratii'@'localhost';

At the very least it will eliminate the possibility of a MySQL permission problem

Upvotes: 1

Related Questions