Sensible Open Source

Blog Status

  • 4 yrs 48 wks 4 days old
  • Updated: 11 Mar 2010
  • 455 entries
  • 174 comments
Total: 1,212,908
since: 5 Apr 2005

LinkBlogS

Creating Vidcasts

18 June 2007, Monday 7:05 P GMT-06
Tags:      

Man, Can't Microsoft Catch A Break?

16 March 2007, Friday 12:26 P GMT-06

Viacom, Google andYou Tube, Oh My!

16 March 2007, Friday 12:25 P GMT-06

Switch to digital TV to start in October

16 March 2007, Friday 7:46 A GMT-06

Is the Ice Ready? No, Its Still To Hot To Use...

16 March 2007, Friday 7:43 A GMT-06

MIT Entire Curriculum At disposal of e-learners

6 March 2007, Tuesday 11:52 A GMT-06

A cure for e-mail attention disorder?

2 March 2007, Friday 12:51 A GMT-06
Tags:  

Windows-on-Mac software gets virtualization update

1 March 2007, Thursday 5:08 A GMT-06

EnterpriseDB is/n't Open Source

1 March 2007, Thursday 3:37 A GMT-06

BitTorrent download portal debuts

27 February 2007, Tuesday 9:05 A GMT-06

$45b TXU buyout

27 February 2007, Tuesday 9:02 A GMT-06

iPhone Competitors Got The Touch

26 February 2007, Monday 3:43 A GMT-06
Tags:        

HTC - Smart Mobility

25 February 2007, Sunday 4:22 A GMT-06

Hard to find 1-800 numbers

23 February 2007, Friday 8:35 A GMT-06

Cuba Embraces Open-Source Software

21 February 2007, Wednesday 3:10 A GMT-06

Vista at the tipping point, Err Dipping Point?

11 February 2007, Sunday 11:11 A GMT-06
Tags:  

PostgreSQL Open Source And Persistence

3 February 2007, Saturday 10:32 P GMT-06

Blackboard Pledges No Patent Blocks

3 February 2007, Saturday 10:28 P GMT-06

UVU

5 January 2007, Friday 11:58 P GMT-06

Open-source IP PBX software appliance"

4 January 2007, Thursday 3:44 A GMT-06

Asterisk an under-appreciated Open Source Success Story

4 January 2007, Thursday 3:43 A GMT-06

Open Source AJAX Tooling

4 January 2007, Thursday 3:41 A GMT-06

Google MAIL API Secuirty Alert

1 January 2007, Monday 7:37 P GMT-06
Tags:    

United States Patent Application: 0060288329

26 December 2006, Tuesday 4:00 A GMT-06

LinkBlog Popular Tags

                                       







««Mar 2010»»
SMTWTFS
  12
3
456
789
10
111213
14151617181920
21222324252627
28293031

 

August 16, 2012

Time Left

2 years 5 months 5 days

                   

RSS Add-Me








Google Related Links

MYSQL - Lost Password - No Sweat

posted 16 August 2007, Thursday
YOU RECEIVE:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
First kill the instance :  
ISSUE THE COMMAND:  kill `cat /var/run/mysqld/mysqld.pid`
 
Next start the mysql server instance or daemon with the --skip-grant-tables option as seen below:
/usr/bin/mysqld_safe --user=mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid 
--skip-grant-tables
--datadir=/var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid &
 
 Next get into the MYSQL shell and issue the next three commands:
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('your_new_password') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
AGAIN, ISSUE THE COMMAND:  kill `cat /var/run/mysqld/mysqld.pid`
 
Restart the instance/daemon  /etc/rc.d/init.d/mysqld start
Connect with your new password.

# mysql -u root -p
Enter password: your_new_password


tags:        

links: digg this    del.icio.us    technorati    reddit




1. Michael Davis left...
17 August 2007, Friday 12:47 pm :: http://www.bigablog.com

You get it? MySQL password.