Sql / Phpmyadmin / Password Issues

[justbishop]

The only DB's I've ever messed with have been the ones auto created by the turnkey install od phpBB from CPanel, but now I have a links directory script that I'm trying to manually install. It required a DB, so I created a new one, and I added myself as a user (with all privledges,) from the dropdown box.

 

My problem is that when I run the config.php file for this script, it says it can't connect to the DB. I just wanted to find out if the default password for the DB is my pass that I use to log onto CPanel? If so, then something else in the config file isn't right, and I'm not quite sure what...

[TCH-Don]

No the password is the password for the user you added to the database.

[justbishop]

Ok, then that's what I'm confused about...I just added a user from a dropdown list, and I've never been asked to make up a password for any of the users because phpBB did all of that automatically I guess (and like i mentioned, up til now, that's the only context in which I messed with SQL or phpMyAdmin at all.)

 

I guess the next question is how do I add a user to that dropdown list that it gives me to choose a user from?

 

[EDIT] Ok, so I am a total moron. I found where to create a new user. Anyway, did that, updated the config file in question with the new info, yadda, yadda, yadda. Still getting this error message, though: "Cannot connect to the MySQL server. Please check your variables and re-upload the config.php file or try again later."

 

[ANOTHER EDIT] Arrrrg! On the FAQ for the directory script, I found this:

I've installed SimpleDir 2.2 and everything works. When I try to login (with the default password), the page is blank.

The white admin screen is a common occurence on servers running PHP 4.x. I'm sorry, but I do not know how to fix this problem at the moment.

And TCH runs PHP Version 4.3.8. So that means that this is hopeless, correct?

[TCH-Don]

goto cpanel > mysql

and look at the database

you should see just below it

users in database

then below that is a sample connection for php

 

PHP $dbh=mysql_connect ("localhost", "yourcpanelname_databaseusername", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());

mysql_select_db ("yourcpanelname_databasename");

 

this should help you see what goes into your config file

 

 

for example if my cpanel name is xyz and the database is forum

and the user name is bob

 

then you would have

database="xyz_forum";

user="xyz_bob";

password="bobspassword";

Edited November 8, 2004 by TCH-Don

[TCH-Dick]

You might want to upgrade to SimpleDir 3.2

[justbishop]

*is a dork*

 

I must have not read everything correctly...I wasn't aware that there was a newer one, lol! Either way, I did end up getting it installed and working, but the templating system was a bit confusing, so I found an even better (and more powerful,) script to use.