how can i access to my DB from another VB installed

[Dode]

hi

i have 2 sites

http://www.site1.com
http://www.site2.com

i'm install VB in http://www.site1.com
and i want to access the DataBase from site2
i know the user name & password
but i can't determind the host name
in site1 i put ( localhost )
but when i want to access it from site2 , i must put the IP address but it's not working .

any idea ?

[TechTalk]

Im assuming you own 2 licenses or you wouldnt be able to do this legally :D

Have you tried using the hostname instead of the ip address?

ie: domain.com

That should work. (now keep in mind this is the hostname of the mysql server....so if the server doesnt exist on the same box as your site then this would be incorrect)

~Chris

[Dode]

i put Domain name & Ip address , it's give me :
Warning: Access denied for user: 'sam10@' (Using password: YES) in admin/db_mysql.php3 on line 31

any idea ?

[TechTalk]

Originally posted by Dode
i put Domain name & Ip address , it's give me :
Warning: Access denied for user: 'sam10@' (Using password: YES) in admin/db_mysql.php3 on line 31

any idea ?

Can you login locally on that machine, using localhost? If so then you should be able to use the ip / hostname. Sounds to me like invalid login info

~Chris

[Dode]

yes i can , when i put ( localhost ) it's work fine !
i guess maby need to set port address , example :

209.25.236.11:3306
?

[Freddie Bingham]

Your mysql user must have access to use the database from other sites than from localhost. You will need to ask your admin if your database in fact allows this.

i.e.

Database is on site1

Your database has permissions to allows sam10 to connect from localhost only. You need to ask to allow sam10 to connect from site2.

[Dode]

thank you
i will ask them .