Top Nav

Archive | MySQL

Mysql Password Recovery

Here’s a link to the instruction on how to reset a lost root password for mysql:

http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html

0

Setting auto_increment counter

Here’s a sql query to set the auto_increment counter:

0

Slow Query Log

http://dev.mysql.com/doc/mysql/en/Slow_query_log.html

Add the following options to mysqld command line:

0