[thelist] MySQL Permissions Going In Circles
Jay Greenspan
jay at trans-city.com
Wed Mar 27 10:11:01 CST 2002
Jay,
Why are you doing INSERTs into the GRANT tables? Bad plan. Use the GRANT
statement instead. Much, much easier to work with.
Next: the fact that you're logged in as the Linux root user has no
effect on the MySQL user accessing the database. Log out of MySQL and
try logging in as the MySQL root user:
shell> /path/to/mysql/install/bin/mysql -u root -pMypassword
Then familiarize yourself with the GRANT statement and use it.
http://www.mysql.com/doc/G/R/GRANT.html
-j
On Wednesday, March 27, 2002, at 11:00 AM, Jay Blanchard wrote:
> 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.
More information about the thelist
mailing list