I am trying to run the installation wizard and keep getting "MySQL Error Occured" when I hit continue to step 4. I have looked in the forum and most of the similar error messages have additional info. at the bottom.
This is a new installation ...
Has anyone come across this? or how can I fix this. Thanks

The information is a little vague, however, in my experience, the most common cause of this error has been a spelling mistake or missing capital letter.

Recheck your sql connection settings, and follow them to the letter (Case sensitive).

Also, a common mistake is for people to type in localhost when their SQL hosting server is called something else. I would suggest if you do not know your SQL host, to contact your hosting provider for more help.

Finally, some hosts do not allow remote access for security purposes. In this case, using an off-site host will produce the same error. Make sure the SQL server is directly related to your web-hosting account.

Thank you for your response. I agree the error is pretty vague. It doesnt say much. I just get MySQL Error Occured after I continue to step 4. Here is how my settings look like as provided by the hosting service.


(If you are unsure these should be available from your web hosting provider.)
Database Hostname: mysql.netfirms.com
Database Name: d60330151
Database Username:admin
Database Password: ********
Database Prefix:
(Optional - Used for multiple installations on one database) e.g. store1_
Drop tables if they exist: With this checked any previous install with same tables prefix on this database will be lost. (Default is checked)
Locale Settings
Store Country: United States of America
Administrator Configuration Settings
(These details are used to access the admin control panel of your store)
Username:xtragadget.com
Password:********
Confirm Password:********
Email Address: myemail@domain.com
Full Name: xtra gadget

(This can be changed at anytime)


Legend (Fixed Width)


Advanced Settings
(Leave these if you are unsure)
Store URL: e.g. http://www.domain.com/store
Server Root Directory: e.g. /path/to/your/store
Site Root Relative Path: e.g. /store/ (Including End Slash)
GD Version:
View phpinfo()
(Opens in new window) 2 1 None Click the phpinfo() link to check your server config.

your help will be appreciated.

[quote name='boyohboy' date='Jan 20 2007, 07:47 PM' post='118391']
[quote name='Brivtech' post='118363' date='Jan 20 2007, 07:34 AM']
Advanced Settings
(Leave these if you are unsure)
Store URL: e.g. http://www.domain.com/store
Server Root Directory: e.g. /path/to/your/store
Site Root Relative Path: e.g. /store/ (Including End Slash)
GD Version:
View phpinfo()
(Opens in new window) 2 1 None Click the phpinfo() link to check your server config.

your help will be appreciated.
[/quote]

Im having a similiar issue but i think you will find your problem is that under advanced the system has not picked up or autodetected the correct details.

my settings are similiar to yours only for very first item i put in localhost as the database is local. and all setting are correct becuase i created the database. however i keep getting stuck at step 4, more info would be appreciated. the error i have is:

The config file could not be written.
Step 4 out of 5 1 2 3 4 5

Step 4 - Set Back File Permissions
Please make sure the following file permissions are set back correctly:
File / Folder Current Permission Required Permission
includes/global.inc.php 0644 0644 Help
Please ensure the file permission are set correctly to continue.

if you have msn please pm or email me and maybe someone could quickly talk me through.

[/quote]

Step 4 - Set Back File Permissions
Please make sure the following file permissions are set back correctly:
File / Folder Current Permission Required Permission
includes/global.inc.php 0644 0644 Help
Please ensure the file permission are set correctly to continue.

if you have msn please pm or email me and maybe someone could quickly talk me through.
[/quote]


I think all you need to do is set the correct permissions in includes/global.inc.php back to 644

[quote name='boyohboy' date='Jan 20 2007, 11:04 PM' post='118424']
[/quote]

Step 4 - Set Back File Permissions
Please make sure the following file permissions are set back correctly:
File / Folder Current Permission Required Permission
includes/global.inc.php 0644 0644 Help
Please ensure the file permission are set correctly to continue.

if you have msn please pm or email me and maybe someone could quickly talk me through.
[/quote]


I think all you need to do is set the correct permissions in includes/global.inc.php back to 644
[/quote]


Hey...I got this working. The database username provided by hosting was wrong. Had to delete and recreate , worked fine............off to configuring my shop:-)