Introduction
MYSQL is a software, with MySQL server at its core, and a lot of utility programs, that helps is managing and administration of database.
For example, let’s say you want to create a new database, you send a message to the MySQL server that says, for instance, “Create a new database and call it newdb.” The MySQL server then creates a subdirectory in its data directory, names the new subdirectory newdb, and puts the necessary files with the required format into the newdb subdirectory. In the same manner, to add data to that database, you send a message to the MySQL server, giving it the data and telling it where you want the data to be added.
For more information on MySQL please check out this article.
Let Us Begin Our Installation of MySQL
You can either follow the video below or go along with the written steps right below it.
Step 1.Update your system:
sudo apt-get update
sudo apt-get upgrade
Step 2. Install MySQL
sudo apt-get install mysql-server |
You will be asked a series of questions during this process, you will have set up a password for the MySQL root user.
Step 3. Harden MySQL
Basically, this means to secure our MySQL server, for more knowledge on hardening MySQL, I recommend checking out this article.
sudo mysql_secure_installation |
You will again be asked a series of questions like changing the root password, removing anonymous user accounts, disabling root logins outside of localhost, and removing test databases. I would recommend answering them yes.
Step 4. Accessing MySQL
- To log in to MySQL as the root user:
mysql -u root -p
- When prompted, enter the root password. You’ll then be presented with a welcome header and the MySQL prompt as shown below:
mysql>
Great you are done with installing MySQL on Debian 7.
Well Done!!
0 Comments