Upgarde mysql server

Process To Upgrade MySQL

  1. Before any upgrade, back up your databases, including the mysql database that contains the grant tables.
  2. Shut Down all your database
  3. After you upgrade to a new version of MySQL, you should run mysql_upgrade This program will check your tables, and repair them if necessary. It will also update your grant tables to make sure that they have the current structure so that you can take advantage of any new capabilities. (Some releases of MySQL introduce changes to the structure of the grant tables to add new privileges or features.)
  4. mysql_upgrade will not work with myisam table so you need to run the following command ALTER TABLE tbl ENGINE=INNODB;