Aji’s Journal

April 1, 2009

Mysql Commands

Filed under: Network and Server — admin @ 2:20 pm

Reset root password
1. Stop mysql server
/etc/init.d/mysql stop
2. Start mysql server with safe mode and skip grant tables
#mysqld_safe –skip-grant-table

3. Update the new password

mysql
mysql> use mysql;
mysql> UPDATE user SET password=password('passwordhere') WHERE user='root';

4. Stop mysqld_safe by pressing Ctrl+C
5. Start mysql server
/etc/init.d/mysql start

1 Comment »


  1. Pillspot.org. Canadian Health&Care.No prescription online pharmacy.Special Internet Prices.Best quality drugs. Online Pharmacy. Buy pills online…

    Buy:Female Cialis.Advair.Aricept.Cozaar.Acomplia.Seroquel.Wellbutrin SR.Zocor.Benicar.Buspar.Ventolin.Zetia.Female Pink Viagra.Prozac.Lasix.SleepWell.Lipitor.Lipothin.Amoxicillin.Nymphomax….

    Trackback by DOUG — June 30, 2010 @ 6:02 pm

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress