ubuntu mysql5.6 deb_ubuntu mysql5.6安装

下载

监控旧版本

sudo netstat -tap | grep mysql

whereis mysql

mysql: /usr/bin/mysql /etc/mysql /usr/lib/mysql /usr/bin/X11/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz

ls /etc/mysql

conf.d debian.cnf debian-start my.cnf

ls /usr/lib/mysql

plugin

ls /usr/share/mysql

charsets debian-start.inc.sh fill_help_tables.sql japanese ndb-config-2-node.ini russian

config.huge.ini dutch french korean norwegian serbian

config.medium.ini echo_stderr german mysqld_multi.server norwegian-ny slovak

config.small.ini english greek mysql_system_tables_data.sql polish spanish

czech errmsg-utf8.txt hungarian mysql_system_tables.sql portuguese swedish

danish estonian italian mysql_test_data_timezone.sql romanian ukrainian

卸载旧版本

sudo apt-get remove --purge mysql-server mysql-client mysql-common

sudo apt-get autoremove

sudo apt-get autoclean

安装

sudo apt-get install libaio-dev

sudo dpkg -i mysql-5.6.15-debian6.0-x86_64.deb

配置

sudo groupadd mysql

sudo useradd -r -g mysql mysql

cd /opt/mysql/server-5.6/

sudo mkdir data

sudo chown mysql:mysql data

sudo mkdir log

sudo chown mysql:mysql log

sudo cp /opt/mysql/server-5.6/share/english/errmsg.sys /usr/share/mysql/errmsg.sys

sudo chown mysql:mysql /usr/share/mysql/errmsg.sys

sudo scripts/mysql_install_db --user=mysql --no-defaults

sudo cp support-files/my-default.cnf /etc/mysql/my.cnf

sudo cp support-files/mysql.server /etc/init.d/mysql.server

sudo cp support-files/mysql-log-rotate /etc/logrotate.d/mysql.server

sudo nano /etc/mysql/my.cnf

[client]

port = 3306

socket = /tmp/mysql56.sock

[mysqld_safe]

port = 3306

socket = /tmp/mysql56.sock

nice = 0

[mysqld]

user = mysql

pid-file = /tmp/mysql56.pid

port = 3306

socket = /tmp/mysql56.sock

basedir = /opt/mysql/server-5.6

datadir = /opt/mysql/server-5.6/data

tmpdir = /tmp

lc-messages-dir = /usr/share/mysql

#bind-address = 127.0.0.1

key_buffer = 16M

max_allowed_packet = 16M

thread_stack = 192K

thread_cache_size = 8

myisam-recover = BACKUP

query_cache_limit = 1M

query_cache_size = 16M

log_error= /opt/mysql/server-5.6/log/error.log

expire_logs_days = 10

max_binlog_size = 100M

[mysqldump]

quick

quote-names

max_allowed_packet = 16M

[mysql]

#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]

key_buffer = 16M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

启动

sudo service mysql.server start

mysqladmin -u root password 'root'