Step by step Install Ubuntu Server 9.10

Step by step guide install Ubuntu Server 9.10 :

1. Download latest iso file or request free ubuntu CD from shipit.

2. Insert CD on CDROM/DVDROM.

3. Make sure to boot from CD/DVDROM

Choose “install ubuntu server”

install_ubuntu_server_910_1

4. Choose Language

Language chosen in this step will be work in the future use.

Continue reading

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

in Work | 485 Words

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>