Test DB Connectivity

[gbud]

I am testing the Forum News script on a hosted server running mysql 4 and php 4.

After configuration and creating a test page I am getting the following error:
"Error connecting to mysql database with username and password specified."

I know my hosting company uses a non standard mysql tcp port. The account I am using works with phpmyadmin. Is there a connection string I can run to test DB connectivity. Any trouble shooting tips would be appreciated

[Patrick]

To use a non-standard port just include it in on the host.

For example, localhost:3307 would attempt to connect to localhost on port 3307 (instead of default 3306).

Depending on your website host, you may also have mysql on another server, such as otherserver.com:3307 (again assuming non-standard port such as 3307 and otherserver.com instead of localhost).

[gbud]

Thanks for the quick response. I have to admit I just made a mistake. I had my mind on mssql thinking port 1433. The hosting company is using 3306. If you have some trouble shooting techniques to pass on, I will appreciate that.

thanks again

[Patrick]

Thanks for the quick response. I have to admit I just made a mistake. I had my mind on mssql thinking port 1433. The hosting company is using 3306. If you have some trouble shooting techniques to pass on, I will appreciate that.

thanks again


Wait... so does it work now or not?

[gbud]

Thanks again for the response. No it is not currently working. I am going to try and add a new dba account for the phpbb db and see if that helps. the account I am using originally had rw access. Later I added the rest of the permissions. I am going to scrap the account for the new dba and see if that helps. I'll check to see if my hosting company will allow me to see the db logs to try to see what is going on.

Thanks for your work and willingness to support it

[gbud]

creating an account with what the hosting company calls "dba" access did the trick. On the old account I gave it all the permissions I could give it. So my next question is what access is required for a db account to work with the news-forum?

Its working for now, I hope to get an account with least privelege access.

thanks

[Patrick]

The script doesn't modify the database in any way. You just need to give it read access to the database (give it the ability to SELECT).