Zen Cart Logo
Forums / Installing on a Linux/Unix Server / Error 1044 message - Yahoo hosting vs MySql

Error 1044 message - Yahoo hosting vs MySql

Locked

Views: 2,448

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
7 Jun 2007, 12:10 AM
#1
strations avatar

strations

New Zenner

Join Date:
Jun 2007
Posts:
3
Plugin Contributions:
0

Error 1044 message - Yahoo hosting vs MySql

Howdy y'all,

I just installed zen cart and received this error message:

1044 Access denied for user 'fotostrations'@'localhost' to database 'mysql'
in:
[DROP TABLE IF EXISTS upgrade_exceptions;]

What can I do to resolve this issue?

thank you,

R.

7 Jun 2007, 1:46 AM
#2
econcepts avatar

econcepts

Totally Zenned

Join Date:
Dec 2005
Posts:
1,505
Plugin Contributions:
2

Re: Error 1044 message - Yahoo hosting vs MySql

strations:

Howdy y'all,

I just installed zen cart and received this error message:

1044 Access denied for user 'fotostrations'@'localhost' to database 'mysql'
in:
[DROP TABLE IF EXISTS upgrade_exceptions;]

What can I do to resolve this issue?

thank you,

R.

Sounds like you do not have the proper permissions to perform that command (DROP). "Access Denied" messages stem from incorrect permission setting (in this case it looks like at the MySQL level).

Make sure the username you are utilizing to connect to the DB has permission to perform these types of commands. If you are unsure, check with your host.

7 Jun 2007, 2:14 AM
#3
strations avatar

strations

New Zenner

Join Date:
Jun 2007
Posts:
3
Plugin Contributions:
0

Re: Error 1044 message - Yahoo hosting vs MySql

Thanks for the insight econcepts... I'll see if I can run with it from here!

R.

7 Jun 2007, 4:02 AM
#4
strations avatar

strations

New Zenner

Join Date:
Jun 2007
Posts:
3
Plugin Contributions:
0

Re: Error 1044 message - Yahoo hosting vs MySql

Sorry, it still gives me the same error message. I have change the permissions to the directory and the subdirectories to 777 and I still receive the error message;

1044 Access denied for user 'fotostrations'@'localhost' to database 'mysql'
in:
[DROP TABLE IF EXISTS zen_upgrade_exceptions;]

I do gain access to MySql db when I go through my web hosting and use phpMyAdmin and enter the username/password

I host with yahoo (no help there) and I uploaded zen cart with a ftp on a Power Mac OS 10.4.9

Anyone else with any helpful hints?

thanx,
R.

7 Jun 2007, 4:59 AM
#5
drbyte avatar

drbyte

Sensei

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

Re: Error 1044 message - Yahoo hosting vs MySql

strations:

Sorry, it still gives me the same error message. I have change the permissions to the directory and the subdirectories to 777It's not a file permissions problem. It's a mysql database permissions problem.

strations:

1044 Access denied for user 'fotostrations'@'localhost' to database 'mysql'That means you've told Zen Cart that:
your database username is 'fotostrations'
and that your database name is 'mysql'
and your database server is 'localhost'

For Yahoo hosting, that's incorrect.
With Yahoo, you need to set your Database Server to 'mysql'
and then supply your correct database name. You can find your database name from the pulldown menu in your phpMyAdmin area.