[SOLVED] can't use database on Remote mysql server.
#1
I googled it and use some of the solutions , but no luck.

The last tried tut is-
http://www.cyberciti.biz/tips/how-do-i-e...erver.html

Please tell me how to remotely connect to mysql database from another IP.

Mysql server is in 10.2.1.121

the site is in 10.2.1.100

Thanks.

Well now I can connect from 10.2.1.100 but cannot use the mysql database.
Getting this error- 
PHP Code:
ERROR 1044 (42000): Access denied for user 'bar'@'10.2.1.111' to database 'bar' 
Yeah my bad i typo the ip address.
GRANT ALL ON 'database'.* TO root@'10.2.1.111' IDENTIFIED BY 'pass';




Users browsing this thread: 1 Guest(s)