How To Reset The MySQL 5.5 Server root Password

Author: , March 16th, 2022

Had an old server, needed to get root.

For MySQL 5.7: https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html For some other v5.7 nodes, I had admin access via a different user’s login, so all I needed was this:

How To Upgrade MySQL to 5.7 on CentOS/AWS Linux

Author: , December 7th, 2017

START: Server version: 5.5.54-log MySQL Community Server (GPL) FINISH: Server version: 5.7.20-log MySQL Community Server (GPL)

If you do not restart MySQL server at the end, you will get this error:

Check and veify your my.cnf ssl entries if you see the following error in the /var/log/mysqld.log file at startup:

How To Install MySQL 5.5 On CentOS Using RPM And Yum

Author: , July 29th, 2011

If you get this error: “Table ‘mysql.servers’ doesn’t exist”, do this: