MySQL is a opensource, Relational Database Management System. MySQL is a most popular database server for Linux but it supports large number of platforms. In MySQL we can easily create stored procedure and execute sql queries.
This how to guide will help you to install MySQL on CentOS, RHEL 7/6/5 and Fedora 20/19/18 using yum package manager.
Step 1. Add MySQL Yum Repository
First we need to add MySQL yum repository in our system provided by MySQL. Execute one of below command as per your operating system version.
For CentOS/RHEL 7# rpm -Uvh http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm For CentOS/RHEL 6# rpm -Uvh http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm For CentOS/RHEL 5# rpm -Uvh http://repo.mysql.com/mysql-community-release-el5-5.noarch.rpm For Fedora 20# rpm -Uvh http://repo.mysql.com/mysql-community-release-fc20-5.noarch.rpm For Fedora 19# rpm -Uvh http://repo.mysql.com/mysql-community-release-fc19-5.noarch.rpm For Fedora 18# rpm -Uvh http://repo.mysql.com/mysql-community-release-fc18-5.noarch.rpm
Step 2. Install MySQL
As we have successfully added MySQL yum repository in our system. Lets move for MySQL installation. Execute below command to install mysql server on your system. This will also install some other dependencies in system.
# yum install mysql-community-server
Step 3. Start MySQL
Start the MySQL server with the following commands from Linux terminal
For CentOS/RHEL 6/5# service mysqld start For CentOS/RHEL 7# systemctl start mysqld
You can check the status of the MySQL server or stop MySQL server using following commands as per your operating system version.
For CentOS/RHEL 6/5# service mysqld status # service mysqld stop For CentOS/RHEL 7# systemctl status mysqld # systemctl stop mysqld
Step 4. MySQL Post Install Setup
After installing MySQL first time, execute mysql_secure_installation command to secure MySQL server. It will prompt for few question’s, we recommended to say yes ( y ) for each.
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MySQL to secure it, we'll need the current password for the root user. If you've just installed MySQL, and you haven't set the root password yet, the password will be blank, so you should just press enter here. Enter current password for root (enter for none): OK, successfully used password, moving on... Setting the root password ensures that nobody can log into the MySQL root user without the proper authorisation. You already have a root password set, so you can safely answer 'n'. Change the root password? [Y/n]
yNew password: Re-enter new password: Password updated successfully! Reloading privilege tables.. ... Success! By default, a MySQL installation has an anonymous user, allowing anyone to log into MySQL without having to have a user account created for them. This is intended only for testing, and to make the installation go a bit smoother. You should remove them before moving into a production environment. Remove anonymous users? [Y/n] y... Success! Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the network. Disallow root login remotely? [Y/n] y... Success! By default, MySQL comes with a database named 'test' that anyone can access. This is also intended only for testing, and should be removed before moving into a production environment. Remove test database and access to it? [Y/n] y- Dropping test database... ... Success! - Removing privileges on test database... ... Success! Reloading the privilege tables will ensure that all changes made so far will take effect immediately. Reload privilege tables now? [Y/n] y... Success! Cleaning up... All done! If you've completed all of the above steps, your MySQL installation should now be secure. Thanks for using MySQL!
Step 5. Start and Connect MySQL
After doing all initial settings restart MySQL using following command.
For CentOS/RHEL 6/5# service mysqld restart For CentOS/RHEL 7# systemctl restart mysqld
Also enable service to auto start on system reboot using following command.
# chkconfig mysqld on
Now connect mysql database server Linux shell using below command. It will prompt for password for authentication. On successful login you will get mysql command prompt, where we can execute SQL queries.
mysql -u root -p
Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 51 Server version: 5.5.34 MySQL Community Server (GPL) by Remi Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement. mysql>