乌班图源码安装mysql5.6_Ubuntu下安装MySQL5.6.23_MySQL

Ubuntu下安装MySQL 5.6.23

1.下载对应Linux-generic的源码包，解压，将解压后的文件夹重命名为mysql，移动到/usr/local目录下；

tar –xzf mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz

mv mysql-5.6.23-linux-glibc2.5-x86_64 mysql

sudo mv mysql /usr/local

2.创建用户mysql和组mysql

vonzhou@de16-C6100: sudo groupadd mysql

vonzhou@de16-C6100: sudo useradd -r -g mysql mysql

3、进入mysql目录

vonzhou@de16-C6100: sudo cd /usr/local/mysql

4、将mysql文件夹own及grp变更为mysql

vonzhou@de16-C6100:/usr/local/mysql$ sudo chown -R mysql .

vonzhou@de16-C6100:/usr/local/mysql$ sudo chgrp -R mysql .

5、执行mysql安装脚本，设置用户

vonzhou@de16-C6100:/usr/local/mysql$ sudo ./scripts/mysql_install_db --user=mysql

Installing MySQL system tables..../bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

vonzhou@de16-C6100:/usr/local/mysql$ sudo apt-get install libaio-dev

(..........)

vonzhou@de16-C6100:/usr/local/mysql$ sudo ./scripts/mysql_install_db --user=mysql

Installing MySQL system tables...2015-03-18 21:22:46 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2015-03-18 21:22:46 5284 [Note] InnoDB: Using atomics to ref count buffer pool pages

2015-03-18 21:22:46 5284 [Note] InnoDB: The InnoDB memory heap is disabled

2015-03-18 21:22:46 5284 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2015-03-18 21:22:46 5284 [Note] InnoDB: Memory barrier is not used

2015-03-18 21:22:46 5284 [Note] InnoDB: Compressed tables use zlib 1.2.3

2015-03-18 21:22:46 5284 [Note] InnoDB: Using Linux native AIO

2015-03-18 21:22:46 5284 [Note] InnoDB: Using CPU crc32 instructions

2015-03-18 21:22:46 5284 [Note] InnoDB: Initializing buffer pool, size = 1