mysql – Making Life Simple

Recover MySQL root password

Posted on December 26, 2008 by lalit — No Comments ↓

You can recover MySQL database server password with following five easy steps. Step # 1: Stop the MySQL server process. Step # 2: Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for Continue reading Recover MySQL root password→

mysql_insert_id() returns NULL or 0

Posted on February 29, 2008 by lalit — No Comments ↓

If you have multiple mysql connections (i.e. mysql_connect() or mysqli_connect()) on the page you will need to specify the the connection you are using when calling this function. example: mysql_insert_id($MY_CONN);