{"id":57,"date":"2018-04-24T05:42:35","date_gmt":"2018-04-24T05:42:35","guid":{"rendered":"http:\/\/td_uid_8_5adec3cbeaab1"},"modified":"2018-06-01T10:11:58","modified_gmt":"2018-06-01T10:11:58","slug":"how-to-install-mysql-on-centos-7","status":"publish","type":"post","link":"https:\/\/forumweb.hosting\/blog\/how-to-install-mysql-on-centos-7\/","title":{"rendered":"How to Install MySQL on CentOS 7"},"content":{"rendered":"

MySQL is a free and open source software used to manage databases on a computer. MySQL can be installed on many different operating system platforms such as Windows, Linux and Mac OS X. In this article, we will guide you to install MySQL in CentOS 7 using command line on server.<\/p>\n

What you need to prepare before installing:
\n– Root access to your server.
\n– CentOS 7 was installed on your server.<\/p>\n

Step 1 – Download and prepare the MySQL repository<\/strong><\/p>\n

To start, you should connect to your server via SSH and prepare the commands below for use in the command line.<\/p>\n

First, you need to check if the system is up-to-date and up-to-date if needed. Type the following command:<\/p>\n

sudo yum update<\/p><\/blockquote>\n

Waiting for system updates. Then install MySQL repositories. You can find the latest version here: https:\/\/dev.mysql.com\/downloads\/repo\/yum\/). Type the following command:<\/p>\n

wget http:\/\/mysql.com\/get_mysql57-community-release-el7-9.noarch.rpm<\/p><\/blockquote>\n

Once loaded, you will see that the .rpm file has been saved.<\/p>\n

\"\"<\/a><\/p>\n

Now you can prepare the repository and install MySQL packages from it. Type the command:<\/p>\n

sudo rpm -Uvh mysql57-community-release-el7-9.noarch.rpm<\/p><\/blockquote>\n

You will likely see the same result:<\/p>\n

\"\"<\/a><\/p>\n

When you see that it reaches 100%, you will be able to start installing MySQL CentOS 7. Detailed instructions will be in the next step.<\/p>\n

Step 2 – Install MySQL on the server<\/strong><\/p>\n

Now you can install MySQL right from this command line:<\/p>\n

sudo yum install mysql-server<\/p><\/blockquote>\n

A list of files will be given and you will receive a confirmation message to download them. Type y, and then press ENTER to continue.<\/p>\n

# yum install mysql-server
\nLoaded plugins: fastestmirror, security
\nSetting up Install Process
\nDetermining fastest mirrors
\nepel\/metalink | 3.7 kB 00:00
\n* epel: fedora.mirror.serversaustralia.com.au
\nbase | 3.7 kB 00:00
\nepel | 4.7 kB 00:00
\nepel\/primary_db | 6.0 MB 00:00
\nextras | 3.4 kB 00:00
\nupdates | 3.4 kB 00:00
\nupdates\/primary_db | 8.1 MB 00:03 …
\nResolving Dependencies
\n–> Running transaction check
\n—> Package mysql-server.x86_64 0:5.1.73-8.el6_8 will be installed
\n–> Processing Dependency: mysql = 5.1.73-8.el6_8 for package: mysql-server-5.1. 73-8.el6_8.x86_64
\n–> Processing Dependency: perl-DBI for package: mysql-server-5.1.73-8.el6_8.x86 _64
\n–> Processing Dependency: perl-DBD-MySQL for package: mysql-server-5.1.73-8.el6 _8.x86_64
\n–> Processing Dependency: perl(DBI) for package: mysql-server-5.1.73-8.el6_8.x8 6_64
\n–> Running transaction check
\n—> Package mysql.x86_64 0:5.1.73-8.el6_8 will be installed
\n—> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
\n—> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed
\n–> Finished Dependency Resolution<\/p>\n

Dependencies Resolved<\/p>\n

================================================================================
\nPackage Arch Version Repository Size
\n================================================================================
\nInstalling:
\nmysql-server x86_64 5.1.73-8.el6_8 base 8.6 M
\nInstalling for dependencies:
\nmysql x86_64 5.1.73-8.el6_8 base 895 k
\nperl-DBD-MySQL x86_64 4.013-3.el6 base 134 k
\nperl-DBI x86_64 1.609-4.el6 base 705 k<\/p>\n

Transaction Summary
\n================================================================================
\nInstall 4 Package(s)<\/p>\n

Total download size: 10 M
\nInstalled size: 29 M
\nIs this ok [y\/N]: y<\/p><\/blockquote>\n

You will see the download process as follows:<\/p>\n

Downloading Packages:
\n(1\/4): mysql-5.1.73-8.el6_8.x86_64.rpm | 895 kB 00:00 …
\n(2\/4): mysql-server-5.1.73-8.el6_8.x86_64.rpm | 8.6 MB 00:01 …
\n(3\/4): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm | 134 kB 00:00 …
\n(4\/4): perl-DBI-1.609-4.el6.x86_64.rpm | 705 kB 00:00 …
\n——————————————————————————–
\nTotal 3.8 MB\/s | 10 MB 00:02
\nRunning rpm_check_debug
\nRunning Transaction Test
\nTransaction Test Succeeded
\nRunning Transaction
\nInstalling : perl-DBI-1.609-4.el6.x86_64 1\/4
\nInstalling : perl-DBD-MySQL-4.013-3.el6.x86_64 2\/4
\nInstalling : mysql-5.1.73-8.el6_8.x86_64 3\/4
\nInstalling : mysql-server-5.1.73-8.el6_8.x86_64 4\/4
\nVerifying : perl-DBD-MySQL-4.013-3.el6.x86_64 1\/4
\nVerifying : mysql-server-5.1.73-8.el6_8.x86_64 2\/4
\nVerifying : mysql-5.1.73-8.el6_8.x86_64 3\/4
\nVerifying : perl-DBI-1.609-4.el6.x86_64 4\/4<\/p><\/blockquote>\n

Wait for the installation to complete. Result:<\/p>\n

Installed:
\nmysql-server.x86_64 0:5.1.73-8.el6_8<\/p>\n

Dependency Installed:
\nmysql.x86_64 0:5.1.73-8.el6_8 perl-DBD-MySQL.x86_64 0:4.013-3.el6
\nperl-DBI.x86_64 0:1.609-4.el6<\/p>\n

Complete!<\/p><\/blockquote>\n

If you see the word “Complete!” At the bottom of the page, means that MySQL has been successfully installed on the server.<\/p>\n

Step 3 – Run MySQL and see if it works<\/strong><\/p>\n

MySQL is not booted after installation, so you need to boot with the following command:<\/p>\n

sudo systemctl start mysqld<\/p><\/blockquote>\n

Wait a few seconds. You will not receive a response to MySQL startup, so check the following:<\/p>\n

sudo systemctl status mysqld<\/p><\/blockquote>\n

The result of the MySQL status will be as follows:<\/p>\n

If you see MySQL active and running as shown above, you have successfully installed MySQL and have started MySQL on the server.<\/p>\n

Summary<\/strong>
\nYou have completely installed MySQL on CentOS 7 server. From now on you can store databases on it to manage them or using them to build websites or web applications.<\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL is a free and open source software used to manage databases on a computer. MySQL can be installed on many different operating system platforms such as Windows, Linux and Mac OS X. In this article, we will guide you to install MySQL in CentOS 7 using command line on server. What you need to […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[69,65],"_links":{"self":[{"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/posts\/57"}],"collection":[{"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/comments?post=57"}],"version-history":[{"count":10,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/posts\/57\/revisions"}],"predecessor-version":[{"id":550,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/posts\/57\/revisions\/550"}],"wp:attachment":[{"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/media?parent=57"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/categories?post=57"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/tags?post=57"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}