How To Install Mysql 5.6 In Centos 7
Hello Friends, In this article I am going to explicate how we can install MySQL 5.6 server in CentOS and Redhat 6/seven/8 using yum command.
Organisation requirements :
- Server : CentOS release half dozen.seven (Final)
- Architecture : i686 i386 GNU/Linux
You may also similar this articles:
- How to install MySQL eight.0 server on CentOS and Redhat?
- How to setup MySQL Master and Slave replication using rsync?
Follow the beneath steps to install MySQL 5.6 server using yum command.
Install MySQL 5.half-dozen server on CentOS and Redhat
Login into server using ssh protocol. Download and install mysql-customs repo using below control.
# ssh [e-mail protected]_ip_and _hostname # mkdir /root/dowload/ # cd /root/download/
Install wget
first of all install wget command on your automobile if it is not installed by default. follow this below control to install wget.
# yum install wget
You will get back some output like below if you take already installed wget packet.
Loaded plugins: fastestmirror Setting up Install Process \Loading mirror speeds from buried hostfile * base: mirror.nbrc.ac.in * epel: ftp.riken.jp * extras: mirror.nbrc.ac.in * updates: mirror.nbrc.air conditioning.in Package wget-1.12-eight.el6.i686 already installed and latest version Nothing to do
Download and Install mysql-customs repo
Now download and install mysql-community repo
# wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm --2016-11-25 06:30:03-- http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm Resolving repo.mysql.com... 104.108.196.141 Connecting to repo.mysql.com|104.108.196.141|:fourscore... continued.
Install mysql 5.6 server using yum control
Permit's install MysQL five.6 server following beneath command:
#yum install mysql-server Loaded plugins: fastestmirror Setting up Install Process Loading mirror speeds from cached hostfile * base: mirror.nbrc.air-conditioning.in * epel: epel.mirror.net.in * extras: mirror.nbrc.ac.in * remi: mirrors.thzhost.com * remi-php56: mirrors.thzhost.com * remi-safe: mirrors.thzhost.com * updates: mirror.nbrc.air conditioning.in ajenti | two.5 kB 00:00 vz-base | 951 B 00:00 vz-updates | 951 B 00:00 Package mysql-server is obsoleted by mysql-community-server, trying to install mysql-community-server-5.6.34-2.el6.i686 instead Resolving Dependencies --> Running transaction check ---> Package mysql-community-server.i686 0:v.6.34-ii.el6 will be installed ................................ .................... Install 5 Package(south) Total size: 73 M Installed size: 299 K Is this ok [y/Northward]: y Downloading Packages: Running rpm_check_debug Running Transaction Examination Transaction Test Succeeded Running Transaction Alert: RPMDB altered outside of yum. Installing : mysql-customs-common-five.half dozen.34-2.el6.i686 i/5 Installing : mysql-customs-libs-5.six.34-2.el6.i686 2/5 Installing : mysql-community-client-5.six.34-2.el6.i686 3/5 Installing : numactl-2.0.9-two.el6.i686 4/5 Installing : mysql-customs-server-5.half dozen.34-2.el6.i686 5/5 Verifying : mysql-community-common-five.6.34-2.el6.i686 1/v Verifying : mysql-community-client-5.6.34-2.el6.i686 2/5 Verifying : numactl-2.0.9-ii.el6.i686 3/v Verifying : mysql-community-libs-5.6.34-2.el6.i686 4/5 Verifying : mysql-community-server-5.6.34-two.el6.i686 5/5 Installed: mysql-community-server.i686 0:five.6.34-2.el6 Dependency Installed: mysql-community-client.i686 0:5.6.34-2.el6 mysql-community-common.i686 0:5.half dozen.34-2.el6 mysql-community-libs.i686 0:5.vi.34-ii.el6 numactl.i686 0:2.0.9-2.el6 Complete!
After installation completed restart mysql service using below command.
#service mysqld start
Or
#/etc/init.d/ mysqld kickoff
Note : Nosotros have installed MySQL server with blank root countersign. We will need to reset root countersign using "mysql_secure_installation" follow beneath instructions to reset password.
mysql_secure_installation
Follow this below control to install mysql secure installation.
# mysql_secure_installation Annotation: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN Product USE! PLEASE READ EACH Step CAREFULLY! In guild to log into MySQL to secure it, we'll need the electric current password for the root user. If you've just installed MySQL, and you haven't prepare the root password however, the password volition be blank, so you should only printing enter hither. Enter current password for root (enter for none): <ENTER> OK, successfully used password, moving on... Setting the root password ensures that nobody can log into the MySQL root user without the proper potency. Ready root password? [Y/due north] <Type hither "Y"> New password:***** Re-enter new countersign:***** Password updated successfully! Reloading privilege tables.. ... Success! Past default, a MySQL installation has an anonymous user, assuasive anyone to log into MySQL without having to accept a user account created for them. This is intended simply for testing, and to make the installation go a bit smoother. Y'all should remove them before moving into a production environment. Remove anonymous users? [Y/n] <Type here "Y"> ... Success! Normally, root should only exist allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the network. Disallow root login remotely? [Y/n] < Type " Y " if you lot want to disable root remote loging for security purpose> ... Success! Past default, MySQL comes with a database named 'test' that anyone tin admission. This is besides intended only for testing, and should be removed earlier moving into a production surround. Remove test database and access to it? [Y/n] < Type "Y" > ... Success! Reloading the privilege tables volition ensure that all changes made and then far will take effect immediately. Reload privilege tables now? [Y/n] ... skipping. All done! If you've completed all of the above steps, your MySQL installation should at present be secure. Cheers for using MySQL! Cleaning upwards...
At present login with you root password
#mysql -uroot -p Enter countersign:***** Welcome to the MySQL monitor. Commands cease with ; or \one thousand. Your MySQL connection id is fourteen Server version: 5.6.34 MySQL Community Server (GPL) Copyright (c) 2000, 2022, 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 corresponding owners. Type 'assistance;' or '\h' for help. Type '\c' to clear the electric current input statement. mysql>
I hope this article will exist helpful you to install MySQL 5.six server on Centos and Redhat. If yous accept any queries and problem please comment in annotate section.
Thank you! for visiting LookLinux.
If you find this tutorial helpful please share with your friends to continue it live. For more helpful topic browse my website www.looklinux.com . To become an author at LookLinux Submit Article . Stay connected to Facebook .
About the author
Howdy! I'm Santosh and I'm here to post some cool article for you. If y'all have whatsoever query and suggestion please annotate in comment section.
Source: https://www.looklinux.com/step-step-mysql-5-6-server-installation-centos-6-x-redhat-6-x/
Posted by: millerbeemed94.blogspot.com
0 Response to "How To Install Mysql 5.6 In Centos 7"
Post a Comment