To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h password 'new-password' Alternatively you can run: /usr/bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default.This is strongly recommended for production servers. Please report any problems with the /usr/bin/mysqlbug script!Description: Failed to install an the client server RPM.The server will not start: magare:~$ sudo rpm -i My SQL-client-5.1.25-0.glibc23.x86_64My SQL-server-5.1.25-0.glibc23.x86_64PLEASE REMEMBER TO SET A PASSWORD FOR THE My SQL root USER !
The following is from localhost./usr/local/mysql5/libexec/mysqld: Table 'plugin' is read only [ERROR]: Can't open the mysql.plugin table. After some Googling, I found out that this problem was due to the Inno DB logs.I deleted ib_logfile0 and ib_logfile1 and I was able to start mysql server without any problems.The latest information about My SQL is available at Support My SQL by buying support/licenses from Starting My SQL..Manager of pid-file quit without updating file.[Falure] Note that after this service mysql restart fails as well: magare:~$ sudo service mysql restart My SQL manager or server PID file could not be found! Manager of pid-file quit without updating f[Fail] How to repeat: Make sure you have nothing in /var/lib/mysql and /var/lock/subsys/mysql.