My sql 5.6 installation and upgradation steps in centos

50 %
50 %
Information about My sql 5.6 installation and upgradation steps in centos
Education

Published on February 4, 2014

Author: pawanitrooman

Source: slideshare.net

Description

MySQL 5.6 installation and upgradation. Step by step
configuration instructions.

MySQL 5.6 installation and upgradation. Step by step configuration instructions. ****************************************************************** A MySQL server package (mysql­server­5.0.77­4.el5_5.4) is installed. The current MySQL server package is provided by a different vendor (CentOS) than MySQL AB, Sun Microsystems, Inc., or Oracle and/or its affiliates. Some files may be installed to different locations, including log files and the service startup script in /etc/init.d/. Upgrading directly from MySQL 5.0 to MySQL 5.6 may not be safe in all cases. A manual dump and restore using mysqldump is recommended. It is important to review the MySQL manual's Upgrading section for version­specific incompatibilities. A manual upgrade is required. ­ Ensure that you have a complete, working backup of your data and my.cnf files. ­ Shut down the MySQL server cleanly ­ Remove the existing MySQL packages. Usually this command will  list the packages you should remove:  rpm ­qa | grep ­i '^mysql­'  You may choose to use 'rpm ­­nodeps ­ev <package­name>' to remove  the package which contains the mysqlclient shared library. The  library will be reinstalled by the MySQL­shared­compat package. ­ Install the new MySQL packages supplied by Oracle and/or its affiliates ­ Ensure that the MySQL server is started ­ Run the 'mysql_upgrade' program This is a brief description of the upgrade process. Important details can be found in the MySQL manual, in the Upgrading section. ******************************************************************  Mysql 5.6 RPM Installation steps   [root@test45 /]#rpm ­ivh MySQL­server­5.6.13­1.linux_glibc2.5.x86_64.rpm    [root@test45 /]#rpm ­ivh MySQL­client­5.6.13­1.linux_glibc2.5.x86_64.rpm    [root@test45 /]# rpm ­ivh MySQL­devel­5.6.13­1.linux_glibc2.5.x86_64.rpm       [root@test45 /]#service mysql restart

Note :­ if you get below error then Starting MySQL ERROR! Couldn't find MySQL server (/var/lib/bin/mysqld_safe) Starting MySQL ERROR! Couldn't find MySQL server (/var/lib/bin/mysqld_safe) [root@test45 mysql]# service mysql restart Shutting down MySQL.. SUCCESS! Starting MySQL ERROR! Couldn't find MySQL server (/var/lib/bin/mysqld_safe) [root@test45 mysql]# mkdir /var/lib/bin [root@test45 mysql]# service mysql restart ERROR! MySQL server PID file could not be found! Starting MySQL ERROR! Couldn't find MySQL server (/var/lib/bin/mysqld_safe) [root@test45 /]# find -name mysqlmanager [root@test45 /]# find -name mysqld_safe ./usr/bin/mysqld_safe [root@test45 /]# cp ./usr/bin/mysqld_safe /var/lib/bin/. [root@test45 mysql]# service mysql restart ERROR! MySQL server PID file could not be found! Starting MySQL.. SUCCESS! [root@test45 /]# service mysql status SUCCESS! MySQL running (5697) [root@test45 /]# rm -rf /usr/local/mysql/var/[MyNAS].pid [root@test45 /]# !se service mysql status SUCCESS! MySQL running (5697) Note:­ In Mysql5.6 A random root password has been set. You will find it in  '/root/.mysql_secret'. #vim /root/.mysql_secret                                                Reset root password #mysqladmin ­u root ­p'MUZOV9do' password ******* P@w@n Kumar

Add a comment

Related presentations

Related pages

MySQL :: MySQL 5.6 Reference Manual :: 2 Installing and ...

2.5.6 Installing MySQL on ... 2.9.1 MySQL Layout for Source Installation 2.9.2 Installing MySQL ... Installation of MySQL generally follows the steps ...
Read more

CentOS 에 MySQL 5.6 설치 - Software

CentOS 에 MySQL 5.6 설치하기 ... My sql 5.6 installation and upgradation steps in centos MySQL 5.6 installation and upgradation. Step by step ...
Read more

2.5 Installing MySQL on Linux - MySQL :: MySQL 5.6 ...

SQL Statement Syntax. ... 2.5.6 Installing MySQL on Linux Using Debian Packages from Oracle ... for which several methods for installation are available:
Read more

linux - Best way to install MySQL 5.6 on Centos 6.4 ...

... came with the Centos distribution. To my ... refman/5.6/en/linux-installation ... it failed to install MySQL-server.x86_64 0:5.6.16 ...
Read more

Install MySQL Server 5.6 in CentOS 6.x and Red Hat 6.x Linux

Install MySQL Server 5.6 in CentOS 6.x and Red ... To install the MySQL server 5.6,follow the given below steps. ... Step 4: After installation start the ...
Read more

Installing MySQL Server on CentOS | Knowledge Center ...

SQL refers to the language used by ... This article describes a basic installation of a MySQL database server on CentOS ... MySQL installation.
Read more

database - Update MySQL version from 5.1 to 5.5 in CentOS ...

I tried to update MySQL from 5.1 to 5.5 in CentOS 6 ... I am going to try these steps ... com/doc/refman/5.6/en/linux-installation-yum-repo.html). My OS ...
Read more

install MySQL Server 5.6 on CentOS 7 / RHEL 7

In this tutorial we will learn, how to install MySQL Server 5.6 on CentOS 7 / RHEL 7 . In our previous post, we have installed MySQL Server 5.6 on CentOS 6 ...
Read more