mysql issue on Fedora 7

jack wallen jlwallen at monkeypantz.net
Tue Dec 25 15:50:49 UTC 2007


Simon Andrews wrote:
> 
> This isn't by any chance a system you've updated to F7 from something 
> earlier?  You can get strange permission errors the first time you try 
> to change the grant tables after a version update.
> 
> To see if this is the problem try running the:
> 
> mysql_fix_priviledge_tables
> 
> program (probably as mysql_fix_priviledge_tables --user=root 
> --password=[your password here])
> 
> If that helps then you should probably run the full:
> 
> mysql_upgrade
> 
> command to sort out any other problems in the install.
> 
> Hope this helps
> 
> Simon.
> 

thank you simon. fortunately i wound up getting it up and running with 
the help of phpmyadmin. i started the db server with the:

mysqld_safe --skip-grant-tables --user=root &

and then went into the mysql database and changed the permissions within 
some of the tables to get the root user privileges again. just took me a 
long time to find the right the tables.


-- 
jack wallen, jr. www.monkeypantz.net
"To know recursion, you must first know recursion"




More information about the users mailing list