mysql across domains

[jmsconsult02]

I need to be able to access a mysql database that is located on another domain . I've set mysql so that its not restriced to localhost.
So for example, i have a myql db that is set up on domain1.com whose owner:group is domain1:domain1.

In another owner:group lets say domain2:domain2 there is a domain called domain2.com - when i try to access the database that was set up in the domain1 account from domain2 account it does not work.

However I can access it from another server by using the ip address.

This is silly

 

[jmsconsult02]

Direct Admin/mysql

I'm running centos 4, mysql 4.x and direct admin. This type of configuration works fine in plesk.

I updated the mysql user accounts from webmin..

Thanks again

 

[walleed222]

you must go to phpmyadmin and choose your db and go to privileges and from there add privilege for localhost for the user used from site 2 on the same server

 

[jmsconsult02]

Thank you for your reply however I still am unable to connect.

I am sure that I have localhost set up so that it will allow connections from any domain. The situation is this:

DB: grnbuilder_prod user grnbuilderl_prod

Website is www.grnshare.com and the user is grnshare. I am trying to connect from grnshare to the grnglobal_prod db, and i get this error...

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'grnbuilder_prod'@'localhost' (using password: YES) in /home/grnshare/domains/grnshare.com/public_html/system/connection.php on line 13
no connection to the db server

grnshare.com does not have any databases associated with it, i just want to connect to the one on grnbuilder.

Also i am able to get to the grnbuilder database from an external server running plesk without a problem..


* note: domain names to protect the innocent...lol