By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,602 Members | 1,473 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,602 IT Pros & Developers. It's quick & easy.

auto script returns error accessing database

P: n/a
I have a shopping cart with an automatic installation script. Add a new
database without tables, configure the script with the table's
user/password, and it's supposed to set up all the tables in the database.

Yet each time I call the setup program, I get this error:

DataBase Error, mySQL Error Reason :
Access denied for user: 'u*******@domain.com' (Using password: YES) at
/home/webadmin/[omitted]/cgi-bin/[omitted].pm line 109

The password appearing in the script is definitely not "YES" and I have
checked to ensure that the script contains the correct user and password
for the database.'

Any ideas

--
Best wishes

Richard Galli
Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Richard Galli wrote:
Access denied for user: 'u*******@domain.com' (Using password: YES) at
/home/webadmin/[omitted]/cgi-bin/[omitted].pm line 109

The password appearing in the script is definitely not "YES"


This is an understandable mistake, given the phrasing of the error
message! :-)

But the phrase doesn't mean that it's using the word "YES" as a
password, it means that it *is* using a password, as opposed to
connecting to a database using a login without specifying a password.

In my experience, one common reason for the error you describe is that
the database exists, but no one granted access to that database for
'u*******@domain.com' with the password you know is correct.

Log in as the superuser and issue a command such as:

GRANT ALL ON mydatabase.* TO 'user'@'domain.com' IDENTIFIED BY
'thecorrectpassword';

Of course, substitute the names of things as appropriate.

Note that the user and the domain are quoted individually, with a @
between them. If you say 'u***@domain.com', it interprets that whole
string as a user's name on the local host.

See http://dev.mysql.com/doc/mysql/en/adding-users.html and other pages
in the same section of the doc for more information.

Regards,
Bill K.
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.