Archive | Databases RSS feed for this section
How to Reset the MySQL Root Password

How to Reset the MySQL Root Password

by on 14. Oct, 2008 in Databases, Linux, MySQL

Follow the steps below if you have forgotten your mysql root password and wish to reset it. 1.  Create a text file with the following information in it. UPDATE mysql.user SET Password=PASSWORD(‘NEW_PASSWORD’) WHERE User=’root’; FLUSH PRIVILEGES; Replace “NEW_PASSWORD” with your desired mysql password.  Save the file to /etc/mysql-pass-reset 2.  Stop MySQL /etc/init.d/mysqld stop 3.  Start [...]

Read full story • Comments { 0 }
How to Change Autoincriment Value in MySQL

How to Change Autoincriment Value in MySQL

by on 03. Oct, 2008 in Databases, MySQL

If you have a attribute in your table that automatically increments itself for every new row, you can change what the next value is very easily. You can do so by either of the two following ways. 1. Change the autoincrement value with a simple sql query. ALTER TABLE {table name} AUTO_INCREMENT = {some number}; [...]

Read full story • Comments { 0 }