Unable to access mysql database remotely

Question

I ran this command-

[root@dev-img mysql]# mysql -u root -h 192.168.1.181 -e "use mysql;"

and this is the output I got-

ERROR 1045 (28000): Access denied for user 'root'@'192.168.1.65' (using password: NO)

Is there anything wrong with my command? I've searched everywhere and the syntax seems to be as above.

Answer 1

Two possible problems

1. You didn't specify the -p option. Without -p the client will not prompt for a password and will attempt to connect without one
2. The database may not be configured to allow remote login for root. You may have to login on the server and enable remote access (i.e. GRANT ALL ON *.* TO root@'%' IDENTIFIED BY '...';)

Answer 2

I will add though that allowing root from remote clients (especially allowing root from '%' ) is VERY BAD security wise

Answer 3

Extract:

How Do I Grant Access To An Existing Database?

Let us assume that you are always making connection from remote IP called 202.54.10.20 for database called webdb for user webadmin, To grant access to this IP address type the following command At mysql> prompt for existing database, enter:

mysql> update db set Host='202.54.10.20' where Db='webdb';
mysql> update user set Host='202.54.10.20' where user='webadmin';

Review complete info:

http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

Aditional Info:

http://www.rackspace.com/knowledge_center/article/mysql-connect-to-your-database-remotely

Regards.

Answer 4

You need to make sure there exists a user root@192.168.1.65 with privileges to the database mysql.

If you have access to the mysql instance another way, do the following to see what privileges this user has:

show grants for root@'192.168.1.65';

The results should look something like the following:

grant all privileges on mysql.* to 'root'@'192.168.1.65' identified by password 'XXXX';

If you don't see results for that "show" statement above, then use the "grant" statement above to give the privileges.

If the IP address you are connecting from changes often, you can open it up to the wildcard host %, like:

grant all privileges on mysql.* to 'root'@'%' identified by password 'XXXX';

but that's not terribly secure.

(If you don't have access, ask your DBA/webhost to do that.)

Then you can connect using that statement, but add the -p flag so you can enter your password:

mysql -u root -p -h 192.168.1.181 -e "use mysql;"