MySQL: Difference between revisions
From Leo's Notes
This page was last edited on 26 June 2013, at 20:31.
No edit summary |
|||
| Line 18: | Line 18: | ||
see http://leo.steamr.com/2011/10/mysql-binary-logs/ | see http://leo.steamr.com/2011/10/mysql-binary-logs/ | ||
== InnoDB Sequential Autoincrement on Duplicate Key Insert == | |||
You may notice that the auto increment value increments even on a duplicate key insertion. To make InnoDB act similar to MyISAM, put the following line under the <code>[mysqld]</code> section in <code>/etc/my.cnf</code> | |||
innodb_autoinc_lock_mode = 0 | |||
Revision as of 20:31, 26 June 2013
Reset Mysql Root Password
see http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Basically, to reset the root password, restart mysql with the --skip-grant-tables option to start mysql without user accounts, then update the root password.
service mysql stop
mysqld_safe --skip-grant-tables
mysql
> update mysql.user set password=PASSWORD('newpassword') WHERE user='root';
> quit
service mysql restart
Binary Logs
see http://leo.steamr.com/2011/10/mysql-binary-logs/
InnoDB Sequential Autoincrement on Duplicate Key Insert
You may notice that the auto increment value increments even on a duplicate key insertion. To make InnoDB act similar to MyISAM, put the following line under the [mysqld] section in /etc/my.cnf
innodb_autoinc_lock_mode = 0