Install Mysql Database Centos 7

Install Mysql Database on Centos 7

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack (and other 'AMP' stacks). LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python." Free-software-open source projects that require a full-featured database management system often use MySQL.

Not yet in the repos list, so I had to download the lastest MySQL yum repo for mysql from http://dev.mysql.com/downloads/repo/yum/

At the time of this article it was mysql-community-release-el7-5.noarch.rpm

Install MySQL repo

You can download that from our server

wget http://briansnelson.com/stuff/mysql-community-release-el7-5.noarch.rpm
yum localinstall mysql-community-release-el7-5.noarch.rpm

Install MySQL via Yum

yum install mysql-server mysql

Enable MySQL to start on boot

systemctl enable mysqld.service

You should see something like the following:

ln -s '/usr/lib/systemd/system/mysqld.service' '/etc/systemd/system/mysql.service'
ln -s '/usr/lib/systemd/system/mysqld.service' '/etc/systemd/system/multi-user.target.wants/mysqld.service'

Disable MySqL from start on boot

systemctl disable mysqld.service

You should see something like the following:

rm '/etc/systemd/system/multi-user.target.wants/mysqld.service'
rm '/etc/systemd/system/mysql.service'

Start/Stop/Restart MySQL

Start

systemctl start mysqld.service

Stop

systemctl stop mysqld.service

Restart

systemctl restart mysqld.service

Check if MySQL is running

systemctl is-active mysqld.service
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Expand your bash history to 2500

Expand your .bash_history to 2500 I do alot of testing and alot of work on Centos servers. I...

CentOS One Liner Commands

Centos Oneliners kill all pts for x in $(ps aux | grep pts| awk '{print $2}'); do kill...

Setup logrotate to rotate your logs

Use logrotate to Manage Log Fiiles logrotate is a tool for managing log files created by...

How To Add Date and Time To Bash History

As Linux users and engineers, we often have to look back in our bash history to figure out...

Install Apache Web Server Centos 7

Install Apache Web Server on Centos 7 The Apache HTTP Server Project is an effort to...