Sorry to have bothered you. I believe I found the problem. I had a "1" (One)
in the password instead of a l (L). it was working from the command prompt,
because I was typing it in the same way, but from the application, it was
stored. So, basically, I had the password wrong.
Thanks,
Jesse
----- Original Message -----
From: Jim Lyons
To: Jesse
Cc: MySQL List
Sent: Friday, October 10, 2008 8:28 AM
Subject: Re: "access denied" error
What is the PHP connect string? Are you connecting to the database you have
access to? are you connecting as the same user (myuser)? Do other php
applications work, so you know it's not a php-mysql issue?
On Fri, Oct 10, 2008 at 6:59 AM, Jesse <[EMAIL PROTECTED]> wrote:
I have a PHP application that I inherited. I have it running on a Ubuntu
8.04 virtual machine. I have set up a user to access the MySQL database, and
from the command prompt, I can access it just fine. For instance, from the
Ubuntu prompt, if I type MySQL -umyuser -p, it asks me for the password and
after typing it in, I'm in. I can also see the only database I've given that
user access to, and I tried a simple SELECT and it worked fine. However, when I
access the database through the PHP application, I get the error, "Access
denied for user 'trucksma_db'@'localhost' (using password: YES)"
Can anyone tell me what the issue could be here? Why would I have "access
denied" through the PHP application, but not through the MySQL client?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
