WAMP-MySQL-Joomla database connect problem
Posted: Fri Sep 26, 2008 12:29 am
Hi
This started with trying Joomla 1.5.7(a newbie). I followed a Lynda.com tutorial which used WampServer. Changed privileges in PhpMyAdmin and config.inc.php and off I went. I LOVE JOOMLA! Reminds me of the StoresOnline interface but vastly superior!!
After finishing the tutorial I deleted that installation and copied over a fresh Joomla install package to start my test site. Did everything the same but Joomla would not connect to the database.
So here is my pre-install setup:
Release version.............: 1.5.7
Localhost....................: WAMPSERVER 2c
System Information.......: PHP Version 5.2.6
.................................Apache/2.2.8 (Win32)
.................................MySQL 5.0.51a
My OS........................: Windows XP SP2 build 2600
PhpMyAdmin privileges...: localhost username = root
................................: localhost password = iforgot
config.inc.php..............: $cfg['Servers'][$i]['password'] = 'iforgot';
Reading the 1.5 Installation Manual for Joomla I see it says "Warning! By default the standard installation of MySQL does not use a password - it is blank. This will not be accepted by Joomla! and it is not a particularly wise security habit to get into in any case. You should ensure that you have set a password up within the my.ini file which is the configuration file of MySQL."
When I look at the my.ini file in the MySQL folder of WAMP there is no text whatsover as referring to a password?
So I opened 'my.ini' and inserted the line "password=iforgot" in the client section.
I can access the database, named 'joomla150' through the MySQL console. But when I reach the Joomla installation 'Database Configuration' screen and set:
Database Type
'mysql'
Host Name
'localhost'
Username
'root'
Password
'iforgot'
Database Name
'joomla150'
Pressing Next gets me:
An error has occurred.: Unable to connect to the database:Could not connect to MySQL.
I searched through the forum but couldn't find a solution that has resolved my problem.
Thanks, help would really be appreciated.
This started with trying Joomla 1.5.7(a newbie). I followed a Lynda.com tutorial which used WampServer. Changed privileges in PhpMyAdmin and config.inc.php and off I went. I LOVE JOOMLA! Reminds me of the StoresOnline interface but vastly superior!!
After finishing the tutorial I deleted that installation and copied over a fresh Joomla install package to start my test site. Did everything the same but Joomla would not connect to the database.
So here is my pre-install setup:
Release version.............: 1.5.7
Localhost....................: WAMPSERVER 2c
System Information.......: PHP Version 5.2.6
.................................Apache/2.2.8 (Win32)
.................................MySQL 5.0.51a
My OS........................: Windows XP SP2 build 2600
PhpMyAdmin privileges...: localhost username = root
................................: localhost password = iforgot
config.inc.php..............: $cfg['Servers'][$i]['password'] = 'iforgot';
Reading the 1.5 Installation Manual for Joomla I see it says "Warning! By default the standard installation of MySQL does not use a password - it is blank. This will not be accepted by Joomla! and it is not a particularly wise security habit to get into in any case. You should ensure that you have set a password up within the my.ini file which is the configuration file of MySQL."
When I look at the my.ini file in the MySQL folder of WAMP there is no text whatsover as referring to a password?
So I opened 'my.ini' and inserted the line "password=iforgot" in the client section.
I can access the database, named 'joomla150' through the MySQL console. But when I reach the Joomla installation 'Database Configuration' screen and set:
Database Type
'mysql'
Host Name
'localhost'
Username
'root'
Password
'iforgot'
Database Name
'joomla150'
Pressing Next gets me:
An error has occurred.: Unable to connect to the database:Could not connect to MySQL.
I searched through the forum but couldn't find a solution that has resolved my problem.
Thanks, help would really be appreciated.