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 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. Install MySQL
zypper in mariadb mariadb-tools |
You will be asked a Y/N, answer Y.
At the end press q to exit pager.
Step 2. Starting MySQL
Now you’ll have to start MySQL.
systemctl start mysql |
MySQL has now started on your server.
Step 3. Enabling MySQL to start at Boot Time
systemctl enable mysql |
Step 4. Harden MySQL
Basically, this means to secure our MySQL server, for more knowledge on hardening MySQL, I recommend checking out this article.
mysql_secure_installation |
You will again be asked a series of questions like to change root password, remove anonymous user accounts, disable root logins outside of localhost, and remove test databases. I would recommend answering them yes.
Great you are done with installing MySQL on openSuSe 13.1.
Well Done!
0 Comments