database

MySQL Update – MySQL Upgrade

MySQL Update – MySQL Upgrade

MySQL update process some times create issues like, MySQL server doesn't start. when you perform MySQL update using yum update or yum update mysql or yum update mysql-server before restarting or stopping server  , you need to run command mysql_upgrade or mysql_upgrade -uroot -p MySQL Update Errors some time mysql server stop and doesn't start and you are unable to perform mysql_upgrade command, you get error like this in mysql logs  /var/log/mysqld.log [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' [ERROR] Fatal error: mysql.user table is damaged.…
Read More