Installation Steps For MySql Server (version 5.7.23) For Centos

By -

MySQL is an open source free relational database management system (RDBMS) released under GNU (General Public License). It is used to run multiple databases on any single server by providing multi-user access to each created database.
Below Steps are provided for  installing MySQL 5.7.23 version on RHEL/CentOS 7/6/5 and Fedora 23/22/21 using MySQL Yum repository via YUM utility.

Step 1: Adding the MySQL Yum Repository 

  • We will use official MySQL Yum software repository, which will provides RPM packages for installing the latest version of MySQL  server, client, MySQL Utilities, MySQL Workbench, Connector/ODBC, and Connector/Python for the RHEL/CentOS 7/6/5 and Fedora 23-21.
  • Now download and add the following MySQL Yum repository to your respective Linux distribution system’s repository list to install the latest version of MySQL.

            ----------------------------------On RHEL/CentOS 7 ----------------------------------------------------------------
             #  wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
            ----------------------------------On RHEL/CentOS 6 ----------------------------------------------------------------
            # wget http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm
            ----------------------------------On RHEL/CentOS 5 ----------------------------------------------------------------
           # wget http://dev.mysql.com/get/mysql57-community-release-el5-7.noarch.rpm
  • After downloading the package for your Linux platform, now install the downloaded package with the following command.

               --------------------------------On RHEL/CentOS 7 ----------------------------------------
               # yum localinstall mysql57-community-release-el7-7.noarch.rpm
              -------------------------------- On RHEL/CentOS 6 ----------------------------------------
               # yum localinstall mysql57-community-release-el6-7.noarch.rpm
              ---------------------------------On RHEL/CentOS 5 ----------------------------------------
               # yum localinstall mysql57-community-release-el5-7.noarch.rpm

  • The above installation command adds the MySQL Yum repository to system’s repository list and downloads the GnuPG key to verify the integrity of the packages.
  • You can verify that the MySQL Yum repository has been added successfully by using following command.           
         # yum repolist enabled | grep "mysql.*-community.*"

Step 2: Installing Latest MySQL Version
  • Install  version of MySQL (currently 5.7) using the following command.
         # yum install mysql-community-server
  • The above command installs all the needed packages for MySQL server mysql-community-server, mysql-community-client, mysql-community-common and mysql-community-libs.

Step 3: Installing MySQL Release Series

  • You can also install different MySQL version using different sub-repositories of MySQL Community Server. The sub-repository for the recent MySQL series (currently MySQL 5.7) is activated by default, and the sub-repositories for all other versions (for example, the MySQL 5.6 or 5.5 series) are deactivated by default.
  • To install specific version from specific sub-repository, you can use --enableor --disableoptions using yum-config-manager or dnf config-manager as shown:
        # yum-config-manager --disable mysql57-community
        # yum-config-manager --enable mysql56-community

Step 4: Starting the MySQL Server

  • After successful installation of MySQL, it’s time to start the MySQL server with the following command:             
       # service mysqld start
  • You can verify the status of the MySQL server with the help of following command.     
       # service mysqld status

Output Sample of running MySQL :

  • Now finally verify the installed MySQL version using following command.           
       # mysql –version

Output Sample:
mysql  Ver 14.14 Distrib 5.7.23, for Linux (x86_64) using  EditLine wrapper

 Step 5: Securing the MySQL Installation
The command mysql_secure_installation allows you to secure your MySQL installation by performing important settings like setting the root password, removing anonymous users, removing root login, and so on.

Note: MySQL version 5.7 or higher generates a temporary random password in /var/log/mysqld.logafter installation.

Use below command to see the password before running mysql secure command.
            # grep 'temporary password' /var/log/mysqld.log
Once you know the password you can now run following command to secure your MySQL installation.
            # mysql_secure_installation

Note: Enter new Root password means your temporary password from file /var/log/mysqld.log.
Now follow the onscreen instructions carefully, for reference see the output of the above command below.

Output Sample:
Enter password for user root:
Enter New Root Password
VALIDATE PASSWORD PLUGIN can be used to test passwords and improve security. It checks the strength of password and allows the users to set only those passwords which are secure enough. Would you like to setup VALIDATE PASSWORD plugin? Press y|Y for Yes, any other key for No: y

There are three levels of password validation policy: LOW Length >= 8MEDIUM Length >= 8, numeric, mixed case, and special characters STRONG Length >= 8, numeric, mixed case, special characters and dictionary  file Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 2
Using existing password for root.
Estimated strength of the password: 50
Change the password for root ? ((Press y|Y for Yes, any other key for No) : y
New password: Set New MySQL Password
Re-enter new password: Re-enter New MySQL Password
Estimated strength of the password: 100
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y

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? (Press y|Y for Yes, any other key for No) : 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? (Press y|Y for Yes, any other key for No) : 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? (Press y|Y for Yes, any other key for No) : 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? (Press y|Y for Yes, any other key for No) : y
Success.

All done!

Step 6: Connecting to MySQL Server
Connecting to newly installed MySQL server by providing username and password.
 # mysql -u root -p 

Sample Output:

Step 7: Updating MySQL with Yum

Besides fresh installation, you can also do updates for MySQL products and components with the help of following command.
           # yum update mysql-server
That’s it, you’ve successfully installed MySQL 5.7.23 on your system.
--------------------------------------------------------------------------------------------------------------------------
Note: 
Install only when you are in need of mysql – connector-java
- yum install mysql-connector-java

To Uninstall MYSQL:
yum remove mysql
yum remove mysql-server
yum clean all
yum remove mysql55-libs


Thanks,
Have Fun!!!!

Please Leave your Comment Below If you Have Any Clarifications Regarding Installations or Any Suggestions.

Comments

Post a Comment

Popular posts from this blog

Quick Setup Steps For Installing & Integrating Spark,Hive,Hadoop Processess Together !!!

By -
Image
If you wish For Indepth Understanding go to my Previous Blog and Install All  Separately. You can Install all the Packages Separately or Install together using the following Commands. SSH :                                                                            #For Interacting With All   - ssh-keygen -t rsa -P ""  - cat $HOME/.ssh/id_rsa.pub >> $HOME/.ssh/authorized_keys  - # ssh-add -l # Not Working the run the command  - ssh localhost Install and Configuration for Spark, Hive and Hadoop: Make a separate Directory for Installing All the Packages you can use 'mkdir' command to create a directory   - mkdir /home/user/Dilli/Installed/All_Setup  - cd /home/user/Dilli/Installed/All_Setup  - java -version  - readlink -f /usr/bin/java | sed "s:bin/java::"  - wget https://archive.apache.org/dist/hadoop/core/hadoop-2.9.0/hadoop-2.9.0.tar.gz  - tar -xzvf hadoop-2.9.0.tar.gz  - mv hadoop-2.9.0 hadoop  - wget http://www-eu
Read more

Twitter Analysis Using R

By -
Image
PREREQUISITES: You have already installed  R  and are using  RStudio . In order to extract tweets, you will need a Twitter application and hence a Twitter account. If you don’t have a Twitter account, please  sign up . Use your Twitter login ID and password to sign in at  Twitter Developers . 1.  STEPS TO CREATE A TWITTER APPLICATION a.  Navigate to My Applications in the upper right hand corner. b.  Navigate to My Applications in the upper right hand corner. c.  Create a new application. d.  Fill out the new app form. Names should be unique, i.e., no one else should have used this name for their Twitter app. Give   a brief description of the app. You can change this later on if needed. Enter   your website or blog address.   Callback URL can be left blank. Once you’ve done this, make sure you’ve read the “Developer Rules Of The Road” blurb, check the “Yes, I agree” box, fill in the CAPTCHA and click the “Create Your Twitter Application” button. e.  
Read more

Best Practices for Apache Hive Performance Tuning

By -
If you’re wondering how to scale Apache Hive, here are the best ways to make the most of Hive performance. 1. Partitioning Tables :                                      Hive partitioning is an effective method to improve the query performance on larger tables. 2 . Compress map/reduce output : By enabling compression at various Levels we can achieve the performance improvement in Hive Queries.                                                     Inside Hive-site.xml Add these Properties               <property>                   <name> mapred.compress.map.output </name>                   < value> true </value>               </property>               <property>                   <name> mapred.output.compress </name>                   <value> true </value>             </property> 3 . Map join  :             We can improve the performance of joins by enabling Auto Convert Ma
Read more

Performance Improvement in Hive (Properties in HIVE -SITE.XML)

By -
There are list of Properties Available to increase the Performance in hive. Use the Properties Appropriate to your Need. <?xml version="1.0" encoding="UTF-8" standalone="no"?> <?xml-stylesheet type="text/xsl" href="configuration.xsl"?> <configuration> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://localhost:3306/metastore_db_3?createDatabaseIfNotExist=true&amp;useSSL=false</value> <description>JDBC connect string for a JDBC metastore</description> </property> <property> <name>javax.jdo.option.ConnectionDriverName</name> <value>com.mysql.jdbc.Driver</value> <description>Driver class name for a JDBC metastore</description> </property> <property> <name>javax.jdo.option.ConnectionUserName</name> <value>hiveuser</value>
Read more

Installation Steps for Hive

By -
Hive is a SQL Database which uses various servers like thrift, Derby, MySQL to maintain the metastore. Here in this setup MySQL server is configured as a base to maintain the metastore of Hive. SSH : -------  - ssh-keygen -t rsa -P ""  - cat $HOME/.ssh/id_rsa.pub >> $HOME/.ssh/authorized_keys  - # ssh-add -l # Not Working the run the command  - ssh localhost   Needed Software’s - Java ,Hadoop,MySql Server Before Installing Hive you make sure all the dependent Software's are correctly Installed .If it is not Installed then you can Refer my Previous Blog to Install them. After Successfully Installing the Softwares correctly!!!! Download Hive from below Repository: https://archive.apache.org/dist/hive The following steps are required for installing Hive on your PC. Let us assume the Hive archive is downloaded onto the /Downloads directory . Here, we download Hive archive named “ ap ache-hive-2.3.0-bin.tar.gz ". The fol
Read more

Facebook Data Analysis Using R

By -
Image
Hey Folks, Today We gonna Learn to Analyse Facebook Data using R . Before Going to concept, makesure you Have R Installed in your System, If Not Proceed the Following Steps to Install. Step 1 – Install R  1. Download the R installer from: https://cran.r-project.org/ 2. Run the installer. Default settings are fine. If you do not have admin rights on your laptop, then ask your local IT support. In that case, it is important that you also ask them to give you full permissions to the R directories. Without this, you will not be able to install additional packages later. Step 2 – Install RStudio 1. Download RStudio: https://www.rstudio.com/products/rstudio/download/ 2. Once the installation of R has completed successfully (and not before), run the RStudio installer. 3. If you do not have administrative rights on your laptop, step 2 may fail. Ask your IT Support or download a pre-built zip archive of RStudio which doesn’t need installing.    a. Download the appropriate a
Read more

Installation Steps For Spark

By -
Image
Downloading  and Installation Steps for Spark: Step 1 : Make sure whether  Java is installed Correctly:               Open Terminal and type.                                                  java -version If Java is already installed correctly on your system, you will  see the following output on your screen:                            Java version "1.8.0_71"              Java(TM) SE Runtime Environment (build 1.8.0_71-b13)              Java HotSpot(TM) Client VM (build 25.0-b02, mixed mode). If java is not installed on your system, then install it.           Ubuntu 14.04 : - sudo add-apt-repository ppa:openjdk-r/ppa - sudo apt-get update - sudo apt-get install openjdk-8-jdk - sudo apt-get install openjdk-8-jre Ubuntu 16.04 : - sudo ap
Read more