Could not connect to MySQL

[rawdata]

Hi,

 

This is my first post, I need help desperately.

I'm on my 3rd install of Uniserver Mona 4.3 (in the last 5 months) with Joomla 1.5.19 always on a localhost and under Windows XP sp3. I always install Mona in my d drive root , I have that entire drive dedicated to just this project.

 

Over the last 2 days I gone through the install process maybe 5 times, deleting everything, starting over always with the same result:>>> Database Error: Unable to connect to the database:Could not connect to MySQL

 

In previous installs I never had this much difficulties.

I've read many post and tried everything under the sun but still keep getting this message.

 

I do the manual install and have gone through the steps in order.

The database is created, the joomla.sql info is imported, and the tables, mods, templates all seem to be there OK. Deleted the installation folder. But it stops working there.

 

I've checked the php.ini file (display errors off)

I have a copy of the install data, nothing out of the ordinary it seems

 

 

Can somebody please help, I'll be bald soon?

[BobS]

I'm on my 3rd install of Uniserver Mona 4.3 (in the last 5 months) with Joomla 1.5.19 always on a localhost and under Windows XP sp3. I always install Mona in my d drive root , I have that entire drive dedicated to just this project.

 

result:>>> Database Error: Unable to connect to the database:Could not connect to MySQL

Sorry you're having such problems. The key is to identify why you're getting the error.

To me, this sounds like a MySQL user account problem. When I set up Joomla (or any other app), I always set up a specific user for that DB, primarily for security. Example: DB is jdb15, user is jdbuser, passwd is Jdq156. Then I make sure that the privileges for that user are correct, which is a key part.

 

Using myPhpAdmin, I create the DB, then go back a level (the home point) and select privileges to Add a new User.

On this form, put in the name, select Host as local, and put in the password (2 fields); then hit GO.

 

On the next form, BELOW the Global privileges, is database-specific; Select the jdb15 database. This will show the next form, where you want to check select, insert, update, delete, create, alter, index and drop. I've never needed to use more. Then hit GO. Now you're ready to use the specific values for the Joomla connection.

 

The connection is specified in the configuration.php file and requires four parameters:

var $host = 'localhost'; // This is normally set to localhost

var $user = 'jdbuser'; // MySQL username

var $password = 'Jdq156'; // MySQL password

var $db = 'jdb15'; // MySQL database name

 

Hope that's clear enough (I made it detailed for other readers), and that it solves the problem.

Regards,

BobS

P.S. Tear paper, not your hair.

[rawdata]

BobS,

 

 

Thanks a lot for replying in such detail. Thanks for taking the time.

I already have a DB installed from myphpadmin and a user but I'm going to do as you say just the same.

 

Please understand that I'm new at this, know some html and css and english...

 

I guess you did not mention the following because it is self-evident nbut I need to check anyway: how about inserting this part between creating the db and the user ??? << INSERT INTO `jos_users` VALUES (62, 'Administrator', 'admin', 'your-email@email.com', '21232f297a57a5a743894a0e4a801fc3', 'Super Administrator', 0, 1, 25, '2005-09-28 00:00:00', '2005-09-28 00:00:00', '', ''); INSERT INTO `jos_core_acl_aro` VALUES (10,'users','62',0,'Administrator',0); INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25,'',10); >>

 

I got that from a Joomla installation manual.

It needs to be done right?

They say do it as an SQL Query, I did that as well on other occasions.

Or maybe what you do would make this redundant?

 

<quote> Then I make sure that the privileges for that user are correct, which is a key part. Using myPhpAdmin, I create the DB, then go back a level (the home point) and select privileges to Add a new User. On this form, put in the name, select Host as local, and put in the password (2 fields); then hit GO.</quote>

 

In any case, when I do it, I get this: <<Your SQL query has been executed successfully>>

Which I'm sure is a good thing

 

Also, while fooling around in php my admin I looked at another DB (than my Joomla one)

 

mysql (which has 16 items) I looked at servers and within that "ports" which is different in many ways from all other tables in that section. Its the only one that is not char(64) and not utf8_general_ci and has an attribute of none? Is this normal? This should be set at port 3306 correct?

 

<quote>The connection is specified in the configuration.php file and requires four parameters"</quote>

Can I just delete the other db and make changes to the existing configuration.php?

 

 

Once more, thank you very much, I'll be back with the results shortly.

 

RDT

 

P.S. Tear paper, not your hair.

 

PPS, The paper was the first to go!

[rawdata]

It works!

 

Thanks BobS!

Only wish I could have talked to you 2 days earlier.

 

The Joomla lit I've seen is mostly all about> do this and that happens but in real life we all know that s$#@ happens! This should be included in all Joomla books under "troubleshooting solutions"

 

TY very much

 

RD

[BobS]

It works!

 

Thanks BobS!

 

REMEMBER! The SIMPLE solutions are the BEST ones, since they usually require less undoing later.

 

Also, when you are implementing a fix, do ONE thing at a time. All that extra SQL for the Joomla Admin users should have waited for step two. Otherwise you can't be sure just what fixed the problem.

 

Anyway, glad I helped.

BobS