[HowTo] 1.7 | Install MySQL

As usual:

#apt-get install mysql-server

Set the root password:

#mysqladmin -u root password MyPassWord

(replacing MyPassWord by the password you want)

I'm sorry but I won't explain how to install phpMyAdmin, because I don't use it anymore. Instead I'm using the mysql admin GUI. As it's an external connection, we'll have to comment a line in the /etc/mysql/my.cnf (comment the line bind-address = 127.0.0.1 ) Then you'll be able to connect to your database from anywhere. Then restart the mysql server:

#/etc/init.d/mysqld restart

Quickly, you must add an user who can connect from the exterior. I've done that in command line:

#mysql -u root -p

(type your password)

#> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'MyPassWord' WITH GRANT OPTION;

Done! We have a mysql database with remote access.

Conclusion

That's all folks. Your web server is installed and should work properly. Keep thinking of upgrading/updating your system often using the following commands:

#apt-get update
#apt-get upgrade

I hope you'll succeed in your server installation thanks to my HowTo. Don't hesitate to comment for any sugestion.