centos reset mysql root password

sudo /etc/init.d/mysqld stop
sudo mysqld_safe --skip-grant-tables &
mysql -u root
use mysql;
update user set password=PASSWORD("newrootpassword") where User='root';
flush privileges;
quit
sudo /etc/init.d/mysqld stop
sudo /etc/init.d/mysqld start

http://www.rackspace.com/knowledge_center/article/mysql-resetting-a-lost-mysql-root-password

• mysql максимальная длина строки
• update longtext MySQL server has gone away
• mysqldump: Got error 1016 Can’t open file when using LOCK TABLES
• Firebird SELECT MAX CAST AS INT
• SELinux enable mysql remote access — разрешить удаленный доступ к mysql