Howto reset mysql password on ubuntu server 9.10

New IBM server has arrived, its IBM X3100-42X.

Standard install required; DNS, LAMP and OpenSSH server on  Ubuntu Server 9.10.

Problem came when I forgot password for MySQL. I think the solution isn’t far from what I done in FreeBSD.

First attempt login to MySQL server :

# mysql -uroot -p

Enter password:
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)

Look MySQL process :

Continue reading

FreeBSD 8.0 RELEASE has been released, get your iso or update your source now!

While waiting for official announcement I see that FreeBSD 8.0 iso file just replace 8.0RC3.

Quick download iso file for FreeBSD 8.0 Release :

Update via source using csup or cvsup

set to :

RELENG_8_0 for release

or

RELENG_8 for stable

Update via freebsd-update :

freebsd-update upgrade -r 8.0-RELEASE

Open network access for mysql on ubuntu server

Error message came out when I try to access new vps server :

$ mysql -ubox-p -h box.rasyid.net

Enter password:
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘box.rasyid.net’ (61)

Edit my.cf file :

# nano /etc/mysql/my.cnf

find this line :

bind-address           = 127.0.0.1

add # in the front into

#bind-address           = 127.0.0.1

save and restart mysql.

Re try again :

$ mysql -ubox -p -h box.rasyid.net

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 50
Server version: 5.0.75-0ubuntu10.2 (Ubuntu)

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>