It happens, you set a super complicated password for your MySQL root account and 2 months down the road forget what it was.

Here’s how you’d fix that.

1. Stop your current MySQL database if it is running

root@abubu# service mysqld stop

2. Start MySQL in safe mode and bypass reading the privilege table.

root@abubu# mysqld_safe --skip-grant-tables

3. Reset your root password MySQL console. If it goes well you will not need to key in a password.

root@abubu# mysql -u root mysql

mysql> update user set Password=PASSWORD('new-password');
mysql> flush privileges;
mysql exit;

4. Kill the MySQL process and restart MySQL normally.

Raj Kissu Rajendran from APIT, who is also a Google Summer Of Code participant gets featured in the local papers.

Raj is working on the “BLOB Streaming Support for phpMyAdmin” project which enables the management of streaming content (audio, video) in and out of the MySQL database through phpMyAdmin. keep up with his progress

This is what he had to say about the local OSS scene,

I envision a more innovation-centric industry driven by research and collaboration, especially in open source. The nature of open source is in its shared environment where experts help newbies design and implement efficient code. I think the local ICT industry needs to be more adventurous in R&D (research and development).

OSS in Malaysia is still slow due to the lake of exposure but it’s people like this who help spread the word by contributing great work.

Good job dude!!

Source: NST

I was playing a round with new software today which needed MySQL 5. My server’s running CentOS 4.6 which ships by default with MySQL 4.

The to upgrade to MySQL 5 from MySQL 4 is easy. There are 2 options you could use.

The first option would require you to remove all MySQL 4 packages by running,

># yum remove mysql

The seconf option is way simpler.

># yum --enablerepo=centosplus update mysql

This will download MySQL 5 from the plus repository and replace the installed MySQL 4.

Remeber to backup your DBs before updating.

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’