MySQL dump restore issue

After restoring mysql dump from pc 55 to sciforum found the user of sciforum vanished, all table database privileges of local system gone.

The lesson learned is never restore everything , the the needed tables and restore these. OR atleast exclude mysql user tables and recreate user, tables, db privileges.

Created user wp again and then found issues on update command of mysql, getting error “can not load from mysql.proc”

run command 
mysql_upgrade -u root -p 
and the problem is fixed

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.