Re: MySQL command line access

Very good question Todd. Here's the thing. As you know, MySQL has its
own users and passwords separate from your IBM i profiles. What you may
not realize is that MySQL can have the same user name for more than one
profile. What makes a profile unique is the user name and the host. So
'root' @ 'localhost' (your command line access) and 'root' @
'www.myurl.com' (your site) can have completely different passwords and
authorities.

Go into your GUI tool. (I assume it is PHPMyAdmin) Look in the database
named "mysql". Find the table "user". If you browse the records, I bet
you will find more than one record for user "root" with different
passwords. Of course the passwords are encrypted, so you won't be able to
read them, but you will be able to tell if they are different. If they
are, and you don't know what the password is for 'root' @ 'localhost', you
can clear out the password field in the record and then it should let you
in without a password. BE SURE TO PUT A PASSWORD BACK ON THE PROFILE WHEN
DONE!!!

Hope that helps,

Brian May
Project Lead
Management Information Systems
Garan, Incorporated
Starkville, Mississippi



TAllen@xxxxxxxxxxxx
Sent by: web400-bounces@xxxxxxxxxxxx
08/09/2010 05:16 PM
Please respond to
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>


To
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
cc

Subject
[WEB400] MySQL command line access






W have MySQL installed and running a few databases. I can connect using
the MySQL admin GUI tool just fine. However, I am denied access using
root
and the same password when connecting on the green screen with QP2TERM.

ERROR 1045 (28000): Access denied for user 'root'@'localhost'

Any ides what I could be doing wrong?

Thanks,
Todd Allen
EDPS
Electronic Data Processing Services
tallen@xxxxxxxxxxxx



This communication and any transmitted documents are intended to be
confidential. If there is a problem with this transmission, please contact
the sender. If the reader of this message is not the intended recipient,
or the employee or agent responsible to deliver it to the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.