Access denied for user 'user'@'ip-address'

Question

Trying to access MYSQLfrom remote server. i have 3 db(db1,db2,db3).

db2 & db3 are in same server, db1 is in my old server.

Trying to connect db1 from new server using mysql_connect('ip','user','pwd'), But it shows Access denied for user 'user'@'ip-address' message.

Both db1,db2 are connecting the same way.

What is the solution for this? I tried some privilege allocation, but doesn't work.

in db1, you have to allow your new server ip to connect with this user, your db1 may be configured to only allow "use@localhost"... — Random, Nov 05 '15 at 09:07
Stop using mysql_* functions. They are deprecated. The error message tells you the database server credentials are not setup correctly. — tlenss, Nov 05 '15 at 09:08
Possible duplicate of [grant remote access of MySQL database from any IP address](http://stackoverflow.com/questions/8348506/grant-remote-access-of-mysql-database-from-any-ip-address) — Musa Haidari, Nov 05 '15 at 09:09
Problem solved, i forgot to add password in GRANT PRIVILEGES command. Thank you all — Shijo Rose, Nov 05 '15 at 11:12

score 0 · Answer 1 · answered Nov 05 '15 at 09:11

First give rights on db1 to your user, you can use below command-

grant select, insert, update, delete on db1.* to myuser@'my_server_ip' identified by 'my_pass';

Note: You can add/delete privileges as per your requirement here my_server_ip means from where you are trying to connect db.

Second thing, as you are trying to connect db1 remotely so also include host ip in your connection string.

score 0 · Answer 2 · answered Nov 05 '15 at 09:12

You have to enable the "Remote Access".

To do it, follow the following steps:

locate your my.cnf file and open it:

vi /etc/my.cnf

after [mysqld] just remove or comment skip-networking command.
add the following command:

bind-address=YOUR-SERVER-IP

score 0 · Answer 3 · answered Nov 05 '15 at 11:15

This problem is solved by giving privileges to user@host.

GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP-ADDRESS' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

NOTE:Do not avoid "PASSWORD", if your user has set password

Access denied for user 'user'@'ip-address'

3 Answers3