Scott Haneda wrote:
on 9/2/05 9:08 AM, Michael Stassen at [EMAIL PROTECTED] wrote:
Modify them how?
show grants for 'root'@'localhost';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN,
PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, LOCK TABLES,
EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'root'@'localhost'
IDENTIFIED BY PASSWORD 'xxxxxxxxxxxx' WITH GRANT OPTION
This looks pretty much full access to me?
I didn't look closely to see if anything's missing in that list, but full
access usually looks like this:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD
'xxxxxxxxxxxx' WITH GRANT OPTION
And that is the odd thing, running that gives me:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
So [EMAIL PROTECTED] is missing something (you can't GRANT a privilege you
don't have). In that case, I think you need to do as Gleb suggested. Shut
down mysqld, then start it with --skip-grant-tables and reissue
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
then stop and start the server again.
Alternatively, you could try to do this witout stopping mysqld. UPDATE
[EMAIL PROTECTED]'s row in the mysql.user table to have the correct values,
then FLUSH PRIVILEGES (but I'm suspicious something like that is how this
started).
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
