centos 6.5 install mysql 5.6

1w160c2cd1

　　To install the MySQL server 5.6,follow the given below steps.

Step 1: Login into the Server and download the yum repo rpm package.
(URL: http://dev.mysql.com/downloads/repo/)

yum install wget
wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

　　Step 2: Now install the downloaded rpm package.

rpm -ivh mysql-community-release-el6-5.noarch.rpm

　　Step 3: Now install the mysql server by using yum command.
Note: The yum command by-default also install the dependencies

yum install mysql-server

　　Step 4: After installation start the mysql server

/etc/init.d/mysqld start

　　Other options:

Usage: /etc/init.d/mysqld {start|stop|status|restart|condrestart|try-restart|reload|force-reload}

　　Step 5: Because the MySQL server is just installed it has blank mysql root password. To reset the mysql root password.
　　You can use the given below command, and follow the instruction

mysql_secure_installation

　　You can also use the given below alternate method
　　Login into mysql server. Because it is freshly installed hence root password is blank

mysql -u root

　　After login you will get mysql propmt. Run the given commands (remove mysql> if you are doing copy paste these commands)

mysql> use mysql;
mysql> update user set password=PASSWORD("GIVE-NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit

 
　　
　　From souce code
　　# Preconfiguration setup
  shell> groupadd mysql
  shell> useradd -r -g mysql mysql
  # Beginning of source-build specific instructions
  shell> tar zxvf mysql-VERSION.tar.gz
  shell> cd mysql-VERSION
  shell> cmake .
  shell> make
  shell> make install
  # End of source-build specific instructions
  # Postinstallation setup
  shell> cd /usr/local/mysql
  shell> chown -R mysql .
  shell> chgrp -R mysql .
  shell> scripts/mysql_install_db --user=mysql
  shell> chown -R root .
  shell> chown -R mysql data
  shell> bin/mysqld_safe --user=mysql &
  # Next command is optional
  shell> cp support-files/mysql.server /etc/init.d/mysql
　　
　　./bin/mysqladmin -u root password


　　vi /etc/my.cnf
　　[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
basedir = /usr/local/mysql
datadir = /var/lib/mysql
port = 3306
# server_id = .....
#socket = /var/lib/mysql/mysql.sock
user=mysql
　　
　　
　　
　　
　　http://sharadchhetri.com/2013/12/26/install-mysql-server-5-6-in-centos-6-x-and-red-hat-6-x-linux/