{"id":1327,"date":"2016-12-28T12:27:52","date_gmt":"2016-12-28T12:27:52","guid":{"rendered":"http:\/\/www.fastwebhost.in\/blog\/?p=1327"},"modified":"2019-01-22T12:00:04","modified_gmt":"2019-01-22T12:00:04","slug":"mysql-installation-on-centos-server","status":"publish","type":"post","link":"https:\/\/www.fastwebhost.in\/blog\/mysql-installation-on-centos-server\/","title":{"rendered":"Installing MySQL on CentOS Server"},"content":{"rendered":"
INTRODUCTION<\/h5>\n

MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP\/Python\/Perl) stack. It uses a relational database and SQL (Structured Query Language) to manage its data. Let’s see Installing MySQL on CentOS server.<\/p>\n

Installing MySQL 5.6<\/h6>\n

To install MySQL 5.6 this way, update the package index on your server with below command<\/p>\n

yum update<\/p>\n

Now download the Yum Repo package of MySQL Server 5.6<\/p>\n

wget http<\/span>:<\/span>\/\/repo<\/span>.<\/span>mysql<\/span>.<\/span>com<\/span>\/<\/span>mysql<\/span>–<\/span>community<\/span>–<\/span>release<\/span>–<\/span>el6<\/span>–<\/span>5<\/span>.<\/span>noarch<\/span>.<\/span>rpm<\/span><\/a><\/span><\/p>\n

Below rpm command helps you install the rpm package which was already downloaded in the above step.<\/p>\n

rpm <\/span>–<\/span>ivh mysql<\/span>–<\/span>community<\/span>–<\/span>release<\/span>–<\/span>el6<\/span>–<\/span>5.noarch<\/span>.<\/span>rpm<\/span>\"\"<\/span><\/p>\n

After this installation completes, we can see two new yum repo’s  related to MySQL.<\/p>\n

 [<\/span>root@localhost <\/span>~]#<\/span> ls <\/span>–<\/span>1<\/span> \/<\/span>etc<\/span>\/<\/span>yum<\/span>.<\/span>repos<\/span>.<\/span>d<\/span>\/<\/span>mysql<\/span>–<\/span>community<\/span>*<\/span>\/etc\/<\/span>yum<\/span>.<\/span>repos<\/span>.<\/span>d<\/span>\/<\/span>mysql<\/span>–<\/span>community<\/span>.<\/span>repo<\/span>\/<\/span>etc<\/span>\/<\/span>yum<\/span>.<\/span>repos<\/span>.<\/span>d<\/span>\/<\/span>mysql<\/span>–<\/span>community<\/span>–<\/span>source<\/span>.<\/span>repo<\/span><\/p><\/blockquote>\n

Using the below yum command, now we can install MySQL Server 5.6 . All dependencies will be installed itself.<\/p>\n

yum install mysql<\/span>–<\/span>server<\/span>\"mysql-install\"<\/span><\/p>\n

Installing MySQL 5.7<\/h6>\n

To install MYSQL 5.7, need to download  yum repo package of MySQL Server 5.7. Using the URL you can download using “wget”<\/span> command.<\/p>\n

wget https<\/span>:\/\/<\/span>dev<\/span>.<\/span>mysql<\/span>.<\/span>com<\/span>\/<\/span>get<\/span>\/<\/span>mysql57<\/span>–<\/span>community<\/span>–<\/span>release<\/span>–<\/span>el7<\/span><\/a> 7.noarch.rpm<\/span>yum localinstall mysql57-community-release-el7-7.noarch.rpm<\/span><\/p>\n

Now install MYSQL with the below command.<\/p>\n

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

Configuring MySQL<\/h5>\n

This version of Oracle MySQL sets a root password by default. We need to retrieve it from the mysql logs.<\/p>\n

cat \/var\/log\/mysqld.log<\/p>\n

For MYSQL 5.7 default password is generated while downloading and installing MYSQL 5.7 repo.<\/p>\n

When it comes to MYSQL 5.6 we need to follow the below process using “mysql_secure_installation”<\/span>.<\/p>\n

A temporary password is generated for root@localhost: *password*<\/p>\n

mysql_secure_installation<\/p>\n

You\u2019ll be prompt to enter your current password. Enter the root MySQL password set during installation.<\/p>\n

Enter current password for root (enter for none):<\/p><\/blockquote>\n

Then, assuming you set a strong root password, go ahead and enter nat the following prompt:<\/p>\n

Change the root password? [Y\/n] n<\/p><\/blockquote>\n

Remove anonymous users, Y:<\/p><\/blockquote>\n

Remove anonymous users? [Y\/n] Y<\/p><\/blockquote>\n

Disallow root logins remotely, Y:<\/p><\/blockquote>\n

Disallow root login remotely? [Y\/n] Y<\/p><\/blockquote>\n

Remove test database and access to it, Y:<\/p><\/blockquote>\n

Remove test database and access to it? [Y\/n] Y<\/p><\/blockquote>\n

And reload privilege tables, Y:<\/p><\/blockquote>\n

Reload privilege tables now? [Y\/n] Y<\/p><\/blockquote>\n

In another method, you can log into MySQL server database and reset the password in secure way.<\/p>\n

mysql -u root<\/p>\n

You will see mysql prompt like this mysql><\/strong> . Use the below given commands to reset root\u2019s password.<\/p>\n

mysql> use mysql;mysql> update user set password=PASSWORD(“GIVE-NEW-ROOT-PASSWORD”) where User=’root’;mysql> flush privileges;mysql> quit\"mysql-commadline\"<\/span><\/p>\n

Below are some MYSQL commands<\/p>\n

To stop MySQL<\/h6>\n

service mysql stop<\/p>\n

To start MySQL<\/h6>\n

service mysql start<\/p>\n

To check the status of MySQL<\/h6>\n

service mysql status<\/p>\n

To restart MySQL<\/h6>\n

Service mysqld restart<\/p>\n

Sources to install MySQL<\/h6>\n

The below URL allows you to find MySQL repo to install it on your CentOs server.<\/p>\n

http:\/\/dev.mysql.com\/doc\/mysql-apt-repo-quick-guide\/en\/<\/a><\/p>\n

Hope this article helps you. You can comment below if you have any queries.<\/p>\n

\"\"Authorshiva<\/a>Posted onDecember 28, 2016<\/a>Edit<\/a>“How to install MYSQL on CENTOS”<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

INTRODUCTION MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP\/Python\/Perl) stack. It uses a relational database and SQL (Structured Query Language) to manage its data. Let’s see Installing MySQL on CentOS server. Installing MySQL 5.6 To install MySQL 5.6 this way, update the package index […]<\/p>\n","protected":false},"author":8,"featured_media":1330,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[22],"tags":[59,36,60,61],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/posts\/1327"}],"collection":[{"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/comments?post=1327"}],"version-history":[{"count":3,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/posts\/1327\/revisions"}],"predecessor-version":[{"id":4713,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/posts\/1327\/revisions\/4713"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/media\/1330"}],"wp:attachment":[{"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/media?parent=1327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/categories?post=1327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fastwebhost.in\/blog\/wp-json\/wp\/v2\/tags?post=1327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}