How to reset MySQL passwords.

Wednesday, October 22nd, 2008 Posted in Uncategorized | No Comments »

Obviously this only works if you have direct access to the MySQL-Servers startup routine. This link describes what you need to do: http://dev.mysql.com/doc/refman/5.1/de/resetting-permissions.html Essentially this is what you do. It is the unsafe yet fastest way. Kill mysqld start mysql by mysqld --skip-grant-tables ...

MySQL: How te get last autoincrenment id.

Saturday, July 12th, 2008 Posted in Computer, Programming | 2 Comments »

There are three ways using java: http://dev.mysql.com/doc/refman/6.0/en/connector-j-usagenotes-basic.html#connector-j-examples-autoincrement-getgeneratedkeys This is the one I prefere, because the value is scoped by the Statment instance, hence only overwritten when I reuse the specific Statement: Statement stmt = null; ResultSet rs = null; try { // ...