Posts Tagged ‘mysql’

How to reset MySQL passwords.

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 --user=root (Windows-Users skip --user=root). Connect to the mysqld-server using: shell> mysql -u Continue reading →

MySQL: How te get last autoincrenment id.

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 {   // // Create a Statement instance that we can use for // Continue reading →

Return top
 

Warning: array_filter() [function.array-filter]: The first argument should be an array in /var/www/web41/html/hp_fstyle/wordpress/wp-content/plugins/wordpress-tweaks/tweaks.php on line 650