[thelist] MySQL Permissions Going In Circles

[Chris Blessing]

Jay,

Can you use mysqladmin to set the password for the root/new accounts?

mysqladmin -u <username> password <new password>

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

> Morning gurus,
>
> Seems I have hosed the MySQL login. I inserted a new user in the
> user table
> with no password (because that was going to be set later. I then
> reload the
> grant tables and suddenly I do not need a password to login. Nor can I
> access any of the tables (because apparently MySQL thinks I am
> the new user,
> even though I am logged into Linux as root). I am just short of
> re-installing MySQL...but of course want to turn to the gurus first.
>
> TIA!
>
> Jay