Joomla Install: MySQL Password Issue

[RegLinUsr]

I am beginning with a clean UniServer Nano5.7.4 and default Joomla 1.5.22 install.

 

I changed all of the UniServer security name/password [user01/open4me] combinations and

set the mySQL password as above. I created my database, joom1, via phpMyAdmin. I then go

to setup Joomla and get as far as the database configuration screen.

 

- Database Type: mySQL

- Host Name: localhost [and tried 127.0.0.1]

- Username: user01

- Password: open4me

- Database Name: joom1

 

At that point, I get the following error upon attempting to submit my configuration choices.

 

Error: Could not connect to the database.

• Connector returned number: Unable to connect to the database:Could not connect to MySQL
  

Any ideas as to what the issue may be? Did I miss anything?

 

Thanks!

 

================== UNIFORM SERVER STATUS ==================

Your Internet IP Address = ###.###.###.###
Accessible from Internet = NO
Cron run status		  = Not running
PHP INI: php.ini file	= Production

APACHE SERVER:

  Apache port			= 80
  Apache SSL port		= 443
  Apache executable name = Apache.exe
  Apache service name	= ApacheS1
  Apache SSL server	  = Enabled
  Apache run status	  = Running
  Apache install status  = Installed as a standard program

MySQL SERVER:

  MySQL port			 = 3306
  MySQL executable name  = mysqld-opt.exe
  MySQL service name	 = MySQLS1
  MySQL run status	   = Running
  MySQL install status   = Installed as a standard program

PORT STATUS:

  Apache port	 = 80 In use by this server
  Apache SSL port = 443 In use by this server
  MySQL port	  = 3306 In use by this server


Press any key to continue . . .

[Shyokou Ouyou]

As if another instance of the IP stack priority in Windoze se7en, where IPv6 is preferred over IPv4 ...

 

Please refer to either this or that as well as further references, if you like ...

 

I am beginning with a clean UniServer Nano5.7.4 and default Joomla 1.5.22 install.

 

I changed all of the UniServer security name/password [user01/open4me] combinations and

set the mySQL password as above. I created my database, joom1, via phpMyAdmin. I then go

to setup Joomla and get as far as the database configuration screen.

 

- Database Type: mySQL

- Host Name: localhost [and tried 127.0.0.1]

- Username: user01

- Password: open4me

- Database Name: joom1

 

At that point, I get the following error upon attempting to submit my configuration choices.

 

Error: Could not connect to the database.

• Connector returned number: Unable to connect to the database:Could not connect to MySQL
  

Any ideas as to what the issue may be? Did I miss anything?

 

Thanks!

 

================== UNIFORM SERVER STATUS ==================

Your Internet IP Address = ###.###.###.###
Accessible from Internet = NO
Cron run status		  = Not running
PHP INI: php.ini file	= Production

APACHE SERVER:

  Apache port			= 80
  Apache SSL port		= 443
  Apache executable name = Apache.exe
  Apache service name	= ApacheS1
  Apache SSL server	  = Enabled
  Apache run status	  = Running
  Apache install status  = Installed as a standard program

MySQL SERVER:

  MySQL port			 = 3306
  MySQL executable name  = mysqld-opt.exe
  MySQL service name	 = MySQLS1
  MySQL run status	   = Running
  MySQL install status   = Installed as a standard program

PORT STATUS:

  Apache port	 = 80 In use by this server
  Apache SSL port = 443 In use by this server
  MySQL port	  = 3306 In use by this server
Press any key to continue . . .

[RegLinUsr]

As if another instance of the IP stack priority in Windoze se7en, where IPv6 is preferred over IPv4 ...

 

Please refer to either this or that as well as further references, if you like ...

 

None of that has anything to do with my problem. I am able to access both the UniServer and the Joomla installation via browsing to either http://localhost/ and http://localhost/joomla/

or http://127.0.0.1/ and http://127.0.0.1/joomla/ in Firefox.

 

As well, my C:\WINDOWS\system32\drivers\etc\hosts is already set to "127.0.0.1 localhost" with both of these lines commented out by default; "#127.0.0.1 localhost" & "#::1 localhost"

 

I have since deleted the entire UniServer and then completed a clean install using Nano 5.7.4. In this install, I created my new MySQL database but used a new MySQL user instead of

ROOT but did not grant global access, only granting full database privileges.

 

Upon getting to the Joomla Database Configuration screen, I used the following settings.

- Database Type: mySQL

- Host Name: 127.0.0.1

- Username: user01

- Password: open4me

- Database Name: user01

 

Now I get a completely different error upon configuration submission.

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to
use near 'TYPE=MyISAM CHARACTER SET `utf8`' at line 29 SQL=CREATE TABLE `jos_banner` ( `bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(30) NOT NULL default 'banner',
`name` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`imptotal` int(11) NOT NULL default '0',
`impmade` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(100) NOT NULL default '',
`clickurl` varchar(200) NOT NULL default '',
`date` datetime default NULL,
`showBanner` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL, `custombannercode` text,
`catid` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`description` TEXT NOT NULL DEFAULT '',
`sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
`ordering` INTEGER NOT NULL DEFAULT 0,
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`tags` TEXT NOT NULL DEFAULT '',
`params` TEXT NOT NULL DEFAULT '',
PRIMARY KEY (`bid`), 
KEY `viewbanner` (`showBanner`), 
INDEX `idx_banner_catid`(`catid`) ) TYPE=MyISAM CHARACTER SET `utf8`

I searched some more and found information about V55_Joomla_1_5_15a.exe buried in an older announcements post. I then tried the Uniform Server Joomla plugin as listed on the

Uniform Server 5.5-Nano, Released Announcements page. Upon using this plugin, I'm able to have a working Joomla.

 

So, what gives?! Why is it that it seems that Joomla can be setup to run on the UniServer but we can't actually do so ourselves?