MySQL - Reset root password and extract table from dump

Just a couple MySQL notes. Debian 6 Squeeze - Reset MySQL root user password You’ll need to stop MySQL server for resetting it this way. Start MySQL with –skip-grant-tables and send to background. Press enter to get back to command line. Connect to to MySQL. Use mysql database and run the command to update the root user password and flush privileges. ...

March 23, 2013 · 1 min · Shane Cunningham

Install MySQL 5.6 on CentOS 6.3

No guarantee this works or that it won’t completely blow up your system. libaio is required so install that bad boy. To make this work you need to remove mysql-libs-5.1.61-4.el6.x86_64 which also removes a few other things, please make sure you are ok with these things being removed. The programs removed are cronie, cronie-anacron, crontabs and postfix. ...

February 14, 2013 · 1 min · Shane Cunningham