[BALU] MySQL administrator SUMMARY

Daniel Hallmark daniel.hallmark at gmail.com
Wed Apr 18 11:43:19 CDT 2007

On 4/18/07, Stuart Carter <stuart.carter at spamcop.net> wrote:
>> This reinforces the fact that the ouruser account doesn't exist as far
>> as mysql is concerned.
> But the list of users shoots "above the screen" and I don't know how to
> see the stuff "above" the final screen it displays?

At the mysql commandline prompt type:
\P more

This sets the "pager" to more (or you could use less, etc.)
Then run your sql query "select User from mysql.user;"
The results should be piped through more just like you were paging
through any other program output.  We're looking for the "ouruser"
account and also to see how many copies of the "ouruser" account exist
(to follow up on Ed's thoughts that perhaps there are different
instances of the account defined for specific hosts that have
different permissions).

> [root at server~]# mysql -u ouruser -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 85 to server version: 5.0.27

> >> > What happens if you try logging into the local mysql commandline
> >> > client using a non-existent account and password (i.e. make something
> >> > up known not to be legitimate)?
> [root at server ~]# mysql -u fred -p
> Enter password:
> ERROR 1045 (28000): Access denied for user 'fred'@'localhost' (using
> password: YES)

Based on this authentication is turned on, and the fact that you are
able to log into mysql as "ouruser" would seem to indicate that the
account exists and has a password set.  So I'm at a complete loss as
to why "ouruser" doesn't show up when you select from the "user"

I'd agree with Jim that the problem appears to be one of permissions,
and I think Ed had a good point that we need to see if those
permissions are assigned to different copies on a per-host basis.  But
so far we have yet to actually "see" the ouruser account when we look
at the user accounts on the table.  Hopefully running through the
pager will help you locate them.


More information about the Members mailing list