Setting the root password on MySQL

I just installed MySQL version 4.1.20 on my CentOS 4.4 server. The default install of MySQL server uses a blank password for root so I had to have it changed. I also set the MySQL service to start up every time my machine boots up.

This is how I did it;

Method 1

1. # yum -y install mysql-server (This will install the mysql binaries)
2. # chkconfig mysqld on (Adds mysqld to the startup services)
3. # service mysqld start (Starts the MySQL server)
4. # mysql -u root@localhost (Brings up the MySQL console)
5. #mysql> set password for root=password(‘password’); (Sets the root password to “password”)
6. #mysql> reload privileges; (Reloads the grant tables)

Method 2

1. # mysql -u root (Brings up the MySQL console)
2. #mysql> use mysql (Use the mysql database)
3. #mysql> update user
-> set password=password(“password”) (Sets the root password to “password”)
-> where user=”root”;
4. # reload privileges; (Reloads the grant tables)
That’s it, the next time you want to get the MySQL console up you’ll have to run #mysql -u root -p to get the password prompt.

Post-Installation Setup and Testing at MySQL

Update:

This will work too.

/usr/bin/mysqladmin -u root password ‘new-password’
/usr/bin/mysqladmin -u root -h pandora.crib password ‘new-password’

TMNET Restoration date pushed to 29th Jan

Update from TMNET.

ANNOUNCEMENT

Services Restoration Update

Telekom Malaysia Berhad (TM) would like to update its customers on the on-going restoration works undertaken by the consortium for its Internet services, which were affected by the earthquake off Taiwan on December 26th, 2006. To date, we have already recovered more than 80 per cent bandwidth capacity for the Internet traffic.

The consortium, which TM is a member of, is still fervently working towards the full restoration of the submarine cables affected by the incident. The consortium has duly informed us that the current bad weather conditions in the affected area are delaying the restoration works in progress. The extensive works undertaken by the consortium include laying new cables as many are experiencing high tension on them; and additional repair works are needed to be performed on several cables damaged by fishing hooks.

In view of these unforeseen circumstances, the consortium has confirmed that the full restoration will be completed by January 29th, 2007. Your patience is much appreciated during this restoration process.

Customers can call our Customer Interaction Center at 1-300-88-9515 (24 hours) or 1-300-88-1515 from 8.00 a.m. till midnight, or e-mail custcare@tm.net.my for any enquiries.

Alan Bernard’s awesome Ts

This is the work of my best pal from KL,Alan Bernard. I would say he’s more of a brother to me then a pal.

479335825l.jpgThe guy has a brilliant creative mind when it comes to original designs. Look at the design above. It’s for T-shirts that he now designs and sells them. Check them out for yourself.

SUSE Enterprise Desktop 10 website

“SUSE Linux Enterprise Desktop 10 is the compelling alternative to Windows Vista” . That’s the quote on Novell’s new page for SLED 10. The site talks about the advantages of SLED over Microsoft’s Vista. Cost,Security,….etc. Make sure to check out the demos too.

TMNET Restoration date pushed to 23rd Jan

tmnet-logo.pngNot the 20th but the 23rd now. Tmnet made an announcement stating that due to bad wheather the restoration work is taking longer to cmplete. The new date for full restoration is now said to be the 23rd of Jan which is tomorrow. Let’s wait and see….

“Telekom Malaysia Berhad (TM) would like to announce that its Internet services, which are experiencing some degradation in performance due to the international link outage caused by the earthquake off Taiwan on December 26th, 2006, has already recovered more than 80 per cent bandwidth capacity for its Internet traffic to-date.

The consortium is still fervently working towards the full restoration of the submarine cables affected by the incident. However, due to the bad weather conditions in that area hampering restoration works, we expect the full recovery of our bandwidth capacity for Internet traffic by January 23rd, 2007.

We wish to assure you that TM is doing all that is possible to fully restore our services as soon as possible. Your patience is much appreciated during this restoration process.”

Original Article

© 2008-2012 The Danesh Project
Powered by Wordpress and made by Guerrilla. Hosted at ServerFreak