Friday 12 November 2010

Reset MySql Password

I was having trouble following instruct on some website with using mysqladmin, 
some how it didn't work, luckily I remember the method below.

Reseting your mysql password

1 .You need to run mysql in safe-mode
safe_mysqld --user=mysql --skip-grant-tables --skip-networking &

2. Access mysql:
mysql

3. Get a list of user from the database
use mysql;
select * from user;

4. Pick a user to change their password.
In my case it was a fresh install so I change all the user password
update user set password=password('newPassword');

5. Flush the privileges
FLUSH PRIVILEGES

6. Restart mysql
killall mysqld
service mysql start

Thursday 11 November 2010

UGotFile Undermaintance

It pretty heart breaking to see "Under Network Maintenance. Please come back later" covering up two years of your hard works at ugotfile.com. This is a really big issue, there were never any problem that can't be solve with the server still running. All other server is redundancy for the main server so, it's impossible to failed.
I'm totally surprise, to redeem this horrible incident I'm going to host another copy of ugotfile.com at citium.net. It's unfortunate but there aren't going to be any files at citium.net. The process is going to take some time, the database is 5GB, going to takes ages to upload.

Here is some picture of me being happy at the data center.

Cheers