Just checking In!

Happy new years!!!

I'm just checking since i really haven't been posting like i should. I've been busy trying to build my business and just enjoy the holidays with family and friends. Since everyone already stated there new years revolution to the world I might as well follow suit:

1. Make it a point to be down right thankful for my family and what i have cause it could always be worst.

2. Spend less time chasing a buck and more time developing my skill set.

3. Teach my family what I now and Incorporate technology into family time.

4. Go to more IT events (SELF2012, OLF, DEATHCON etc....)

5. Become great with at least 2 programming languages

6. Stop letting MySql kick my behind.

7. Repeat numbers one-six

That's it for now, time to start on one of my many projects getting "Deb Squeeze" onto my Samsung galaxy s!

Be safe and stay free (as in beer)

-Loafy

posted from Bloggeroid

How to Reset "MySql" Root Password (CentOS 5)

Evening all,

Ran into a problem a few weeks ago that I finally set down and solved after visiting a couple of forums. These steps are pieced together from many places. Special thinks to all the forums that helped me reset my database password. *Note* Every thing in blue is what you type. *Where you see "whatever password you want" means just that but keep it inside the parentheses () and quotations.

Stop the MySQL daemon : service mysqld stop
Start MySQL in safe mode with the –skip-grant-tables and -u root options in background : mysqld_safe –skip-grant-tables -u root &
Start the command line client as root : mysql -u root
Issue the MySQL command to reset the root password : UPDATE mysql.user SET Password=PASSWORD(‘whatever password you want’) WHERE User=’root’;
Issue the flush privileges command : FLUSH PRIVILEGES;
Quit the command line tool : quit
Find MySQL Process ID: ps aux | grep mysqld
Stop the MySQL process : kill process id goes here `cat /var/run/mysqld/mysqld.pid`
Restart the MySQL daemon : service mysqld start
Log in as root to make sure the new password is active : mysql -u root -p
Type the new password at the prompt

YOUR IN, DON'T FORGET IT NEXT TIME!!!!!