Zen Cart Logo
Forums / Bug Reports / Cannot Connect to Database on Fresh 1.5.4 Install

Cannot Connect to Database on Fresh 1.5.4 Install

Views: 990

Results 1 to 2 of 2
26 Jan 2015, 5:07 AM
#1
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,567
Plugin Contributions:
58

Cannot Connect to Database on Fresh 1.5.4 Install

After debugging, it was found that the newly created database needed to have the collation set to utf8 in order for the database username and password to be accepted. This isn't mentioned in the documentation and doesn't appear to be identified by the installer.

26 Jan 2015, 4:22 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Cannot Connect to Database on Fresh 1.5.4 Install

I can't replicate this problem.

This is what I tried:

  1. Create a new database with default character set of latin1, and collation latin1_general_ci
  2. Run zc_install and choose Install, provide database name, username, password
  3. Install ran fine.

Tested against MySQL 5.5.27, PHP 5.6, 5.5, 5.4.

What did you do differently? What exact steps must I take to recreate your symptoms?

numinix:

This isn't mentioned in the documentation and doesn't appear to be identified by the installer.
That isn't formally a requirement. There's nothing technically in the code that requires UTF-8, although it's highly recommended.