Watch slow queries on MySQL

First login as root on the command line to MySQL: mysql -u root -p mysql Enter your mysql root password. Set the log slow queries variables: SET GLOBAL slow_query_log = ‘ON’; Verify your variables are set properly: SHOW VARIABLES; You [...]

Reset root password for MySQL on Ubuntu

Stop the MySQL Server. sudo /etc/init.d/mysql stop Start the mysqld configuration. sudo mysqld –skip-grant-tables & Login to MySQL as root. mysql -u root mysql Replace YOURNEWPASSWORD with your new password! UPDATE user SET Password=PASSWORD(‘YOURNEWPASSWORD’) WHERE User=’root’; FLUSH PRIVILEGES; exit;