Difference between revisions of "Mysql 5.6"

From VoIPmonitor.org
Jump to navigation Jump to search
Line 27: Line 27:
 
  yum remove mysql-server
 
  yum remove mysql-server
 
   
 
   
  wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-5.6.14-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
+
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-compat-5.6.17-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
  wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-client-5.6.14-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
+
  wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-5.6.17-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
  wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-server-5.6.14-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
+
  wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-client-5.6.17-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
 +
  wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-server-5.6.17-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
 
   
 
   
  rpm -ihv MySQL-shared-5.6.14-1.el6.x86_64.rpm
+
  rpm -ihv MySQL-shared-compat-5.6.17-1.el6.x86_64.rpm
 
+
rpm -ihv MySQL-shared-5.6.17-1.el6.x86_64.rpm
 
  rpm -ihv --force MySQL-server-5.6.14-1.el6.x86_64.rpm  
 
  rpm -ihv --force MySQL-server-5.6.14-1.el6.x86_64.rpm  
 
  rpm -ihv --force MySQL-client-5.6.14-1.el6.x86_64.rpm
 
  rpm -ihv --force MySQL-client-5.6.14-1.el6.x86_64.rpm

Revision as of 09:43, 13 May 2014

Debian

cd /usr/src
wget http://www.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.17-debian6.0-x86_64.deb/from/http://cdn.mysql.com/ -O mysql-5.6.17-debian6.0-x86_64.deb
dpkg -i mysql-5.6.14-debian6.0-x86_64.deb
rm mysql-5.6.14-debian6.0-x86_64.deb
mv /etc/mysql/my.cnf /etc/my.cnf
cp /opt/mysql/server-5.6/support-files/mysql.server /etc/init.d/mysql.server && update-rc.d mysql.server defaults
apt-get install libaio1
chown -R mysql /opt/mysql/server-5.6/
chgrp -R mysql /opt/mysql/server-5.6/

upgrade mysql

/opt/mysql/server-5.6/scripts/mysql_install_db --user=mysql --datadir=/var/lib/mysql
rm /opt/mysql/server-5.6/my.cnf 
vi /etc/my.cnf
basedir = /opt/mysql/server-5.6
lc-messages-dir = /opt/mysql/server-5.6/share
remove language = …

Centos 6.4

yum install libaio perl
yum remove mysql-server

wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-compat-5.6.17-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-shared-5.6.17-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-client-5.6.17-1.el6.x86_64.rpm/from/http://cdn.mysql.com/
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-server-5.6.17-1.el6.x86_64.rpm/from/http://cdn.mysql.com/

rpm -ihv MySQL-shared-compat-5.6.17-1.el6.x86_64.rpm
rpm -ihv MySQL-shared-5.6.17-1.el6.x86_64.rpm
rpm -ihv --force MySQL-server-5.6.14-1.el6.x86_64.rpm 
rpm -ihv --force MySQL-client-5.6.14-1.el6.x86_64.rpm


/etc/init.d/mysql restart
mysql_upgrade