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