MySQL Database Server on Debian

This tutorial is how to install MySQL Database Server on Debian Linux.

MySQL is a relational database management system, which means it stores data in separate tables rather than putting all the data in one big area. This adds flexibility, as well as speed. The SQL part of MySQL stands for “Structured Query Language,” which is the most common language used to access databases. The MySQL database server is the most popular open source database in the world. It is extremely fast and easy to customize, due to its architecture. Extensive reuse of code within the software, along with a minimalist approach to producing features with lots of functionality, gives MySQL unmatched speed, compactness, stability, and ease of deployment. Their unique separation of the core server from the storage engine makes it possible to run with very strict control, or with ultra fast disk access, whichever is more appropriate for the situation. (http://www.redfernservices.com/glossary_of_terms.asp)

Let’s start it:
Install MySQL Server

aptitude install mysql-server

Configure MySQL Server
MySQL initially only allows connections from the localhost (127.0.0.1). We’ll need to remove that restriction if you wish to make it accessible to everyone on the internet. Open the file /etc/mysql/my.cnf.

vi /etc/mysql/my.cnf

Find the line bind-address = 127.0.0.1 and comment it out

...
#bind-address = 127.0.0.1
...

Check it out!

mysql

It should like this:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server
version: 4.0.24_Debian-10sarge1-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

MySQL comes with no root password as default. This is a huge security risk. You’ll need to set one. So that the local computer gets root access as well, you’ll need to set a password for that too. The local-machine-name is the name of the computer you’re working on.

mysqladmin -u root password yournewpassword
mysqladmin -h root@localhost -u root password yournewpassword
/etc/init.d/mysql restart