Hello,
Today suddenly I found that MySQL is down on one of my servers. Trying to restart MySQL failed with below message ! without any other error message.
TIME mysqld ended
Looking at cron log I found below update log for mysql. Anyway I managed to restart it after several tries.
1- My question is that do I need to reset MySQL root password or anything else? Do I need to do anything?
2- Is there any chance of more MySQL crashes?
Regards,
Mac
MySQL is not up to date (Wed Oct 16 16:53:03 2002)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL/MySQL-3.23.54a-1.i386.rpm
Preparing... ##################################################
Giving mysqld a couple of seconds to exit nicely
MySQL ##################################################
Installing all prepared tables
021216 6:38:23 /usr/sbin/mysqld: Shutdown Complete
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h server.domain.com password 'new-password'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL &= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
Starting mysqld daemon with databases from /var/lib/mysql
021216 06:38:23 mysqld ended
MySQL-client is not up to date (Wed Oct 16 16:53:03 2002)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL-client/MySQL-client-3.23.54a-1.i386.rpm
Preparing... ##################################################
MySQL-client ##################################################
MySQL-devel is not up to date (Wed Oct 16 16:53:03 2002)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL-devel/MySQL-devel-3.23.54a-1.i386.rpm
Preparing... ##################################################
MySQL-devel ##################################################
MySQL-bench is not up to date (Wed Oct 16 16:53:03 2002)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL-bench/MySQL-bench-3.23.54a-1.i386.rpm
Preparing... ##################################################
MySQL-bench ##################################################
MySQL-shared is not up to date (Wed Oct 16 16:53:03 2002)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL-shared/MySQL-shared-3.23.54a-1.i386.rpm
Preparing... ##################################################
MySQL-shared ##################################################
Today suddenly I found that MySQL is down on one of my servers. Trying to restart MySQL failed with below message ! without any other error message.
TIME mysqld ended
Looking at cron log I found below update log for mysql. Anyway I managed to restart it after several tries.
1- My question is that do I need to reset MySQL root password or anything else? Do I need to do anything?
2- Is there any chance of more MySQL crashes?
Regards,
Mac
MySQL is not up to date (Wed Oct 16 16:53:03 2002)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL/MySQL-3.23.54a-1.i386.rpm
Preparing... ##################################################
Giving mysqld a couple of seconds to exit nicely
MySQL ##################################################
Installing all prepared tables
021216 6:38:23 /usr/sbin/mysqld: Shutdown Complete
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h server.domain.com password 'new-password'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL &= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
Starting mysqld daemon with databases from /var/lib/mysql
021216 06:38:23 mysqld ended
MySQL-client is not up to date (Wed Oct 16 16:53:03 2002)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL-client/MySQL-client-3.23.54a-1.i386.rpm
Preparing... ##################################################
MySQL-client ##################################################
MySQL-devel is not up to date (Wed Oct 16 16:53:03 2002)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL-devel/MySQL-devel-3.23.54a-1.i386.rpm
Preparing... ##################################################
MySQL-devel ##################################################
MySQL-bench is not up to date (Wed Oct 16 16:53:03 2002)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL-bench/MySQL-bench-3.23.54a-1.i386.rpm
Preparing... ##################################################
MySQL-bench ##################################################
MySQL-shared is not up to date (Wed Oct 16 16:53:03 2002)
Retrieving http://updates.cpanel.net/pub/sysup//7.3/MySQL-shared/MySQL-shared-3.23.54a-1.i386.rpm
Preparing... ##################################################
MySQL-shared ##################################################