audibleCode

I am browsing blog and i just found this thing that i didn’t know

Reseting mysql password

1.  
   1.  
      1. Stop the server
         
      2. #/etc/init.d/mysql stop
         
      3. Login as root
         
      4. #mysqld_safe –skip-grant-tables –user=root
         
      5. #mysql -u root
         
      6. Enter this command
         
      7. mysql>update mysql.user set password=password(’newpassword’) where user=’root’;
         
      8. start the service again
         
      9. #etc/init.d/mysql start
         
      10. login again
          
      11. #mysql -u root -p

Hi all,

Today i just want to start by sharing an experience that i had with MySQL Database. I was a project for a friend. The project was a CMS for a movie site and all of a sudden an error message started appearing, that the

table “employee” has crashed.

This made the admin page inaccessible. The true is if you have been working with MySQL for sometime you might have seen this error. I want to share with you i i fixed this error. 

Before that i want to ask “Does anyone what causes MySQL table to crash” if you do please leave a comment as to how.

Read the rest of this entry »