running mysql_fix_privilege_tables kills my root password

views:

answers:

running mysql_fix_privilege_tables kills my root password

I am learning mysql and ran into a problem with 'mysql.proc' missing when trying to create a stored procedure. mysql version 5.1.41.

I read that running the script 'mysql_fix_privilege_tables' is supposed to fix the previous error. I am getting a strange side effect... my root password is no longer good anymore when I run this script and can no longer log into mysql because of this. the only solution is to remove mysql and start over. I have done this twice now and have no clue as to why it is affecting my root password. any clues?

Updated 11/28: I found it is a bug in workbench with a particular model sync setting. It is removing the mysql database and for some reason when you do a repair, mysql erases all users. Kind of a perfect storm kind of thing I think.

Maybe this article (geared at Debian Linux running mysql) might help you and save you the pain in having to remove mysql and reinstall again. The principal should remain the same as I have noticed this is tagged with macosx.

Hope this helps, Best regards, Tom.

tommieb75 2009-11-27 01:02:20

This definitely helps... Thx. Why would I get the mysql.proc error to begin with? any idea?

sdmiller 2009-11-27 01:17:26

Better yet... why would the script change my root password? Thx for the help!

sdmiller 2009-11-27 01:18:34

@sdmiller: Can you show what you were doing exactly at the point prior to this problem? A side note, that script could have a bug in it. Report it to mysql team, as you are running macosx. It will be of help to them! I have never used this script tbh...http://linux.die.net/man/1/mysql_fix_privilege_tables this shows the man page for the said script..read what it says about it superseded by a newer script....then again, that script is something you run once against mysql..

tommieb75 2009-11-27 09:11:35

I loaded mysql workbench. I synced the databases once and then started getting 'missing mysql.proc' error any time I tried to sync or add a stored procedure. I read online that the mysql.proc error sometimes occurs due to databases not being up to date or something like that and to run the mysql_fix_privilege_tables' script and that should fix it. After I run the script, I can no longer log into mysql using root and password. I used link you supplied in order to reset the password and found that root can been removed completely... I have no users in mysql anymore. Thanks for you help

sdmiller 2009-11-28 01:59:30

@sdmiller: check this and verify you have the right version of mysql...http://forums.mysql.com/read.php?98,73660,74161#msg-74161. Also...there may be light at the end of the tunnel here: http://forums.mysql.com/read.php?98,73660,73660, Look at the last 4 replies in that thread and see if that sheds any light...Hope this helps you. Take care. ;)

tommieb75 2009-11-28 02:24:44

Thanks, I am definitely running mysql 5.1.41, The stored procedures work until I run the sync in mysql workbench. Then I get the mysql.proc error and can't create stored procedures anymore. It is weird. THanks for you help!

sdmiller 2009-11-28 02:38:19

ansaurus

tags:

views:

answers:

running mysql_fix_privilege_tables kills my root password

related questions