Portal Home > Knowledgebase > Articles Database > Problem with Fantastico and SQL Database

Problem with Fantastico and SQL Database

Posted by zerodamage, 12-04-2005, 09:43 PM
I installed SMF using Fantastico and what it does is create the database and user automatically. I however do not know the password for this user for the database. Anyone tell me how to get the password or is there a default that Fantastico uses in this process? Thanks

Posted by IHSL, 12-04-2005, 10:18 PM
In your file manager, or via FTP, locate this file: Settings.php If your forum is at yourdomain.com/forum, you will find Settings.php in "public_html/forum" Simon

Posted by ayksolutions, 12-04-2005, 10:30 PM
Or you can just view it via phpMyAdmin.

Posted by IHSL, 12-04-2005, 10:39 PM
He can't view his password via phpMyAdmin. Simon

Posted by heymrdj, 12-04-2005, 10:41 PM
View Settings.php But if I may ask did you just forget it or something? The username and password have to be typed in during installation.

Posted by IHSL, 12-04-2005, 10:47 PM
The topic starter said he used fantastico to install SMF. Fantastico auto-creates the mysql database and user. It does not prompt the user for such information (nor does it display it after the install). It does ask for an admin user/pass combination, but that is only for the forum management, not the database. Simon

Posted by heymrdj, 12-04-2005, 11:00 PM
Sry I got confused in that. The admin user pass should be available if you select mysql databases in cpanel.

Posted by ayksolutions, 12-04-2005, 11:24 PM
He should have the info in mysql/phpmyadmin as that is where it is stored. He could use a converter to convert from hex to regular letters, there's one here: http://www.javascriptkit.com/script/...mconvert.shtml I use that for phpbb and it works just fine. You can modify your password in the admin table in phpbb, not sure what its called in SMF as I have never used that forum before.

Posted by ayksolutions, 12-04-2005, 11:26 PM
Sorry, my mistake. I finally read his whole problem and I was referring to the admin or just plain user setup. You do have to look in the php file to find the db login info.

Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read
System setup (Views: 360)
Dualrack down (Views: 466)