Cannot see a database

Neko_D

Whenever I try to connect to a remote MySQL server, I cannot see the database I need to use.I can see the database when I connect to the server using the server's myphpadmin program. However, when I run my script for my home machine I cannot see the database. This is the database I need to use for my project. Can anyone help me?

SpeedBird

Have you set up a user in MySQL with access to the schema of the database? And what does your connection string look like? If the server hosting MySQL is behind a firewall you need to make sure that a rule exists for port 3306 (or whatever port MySQL is listening on) to allow you to connect.

Neko_D

SpeedBird wrote:
Have you set up a user in MySQL with access to the schema of the database? And what does your connection string look like? If the server hosting MySQL is behind a firewall you need to make sure that a rule exists for port 3306 (or whatever port MySQL is listening on) to allow you to connect.

Well my connection string looks about like the following mysql_connect("mcis.western.edu", "myUsername", "myPassword");

So I need to add the port variable? Because it is firewalled. But I can still see the one other database I am allowed to see on that server.

SpeedBird

No, you don't need to specify a port if you are using 3306 (the default).

If you can see the other database it sounds like the username you are using to access MySQL doesn't have privileges to access the schema you want. If it was due to a firewall you wouldn't see any databases, in fact you wouldn't be able to connect to MySQL at all.

Do you get an error when trying to connect?

Neko_D

SpeedBird wrote:
No, you don't need to specify a port if you are using 3306 (the default).

If you can see the other database it sounds like the username you are using to access MySQL doesn't have privileges to access the schema you want. If it was due to a firewall you wouldn't see any databases, in fact you wouldn't be able to connect to MySQL at all.

Do you get an error when trying to connect?

I see, well when I hit the database I run a script that connects me and runs the querey "Show Databases;" and then I try and dispaly the results. When I display the results I only get the information_schema and a_different_db, but not the one I need.