Ubuntu下Mysql安装 - yingziaiai/SetupEnv GitHub Wiki

最后按如下成功： http://liyonghui160com.iteye.com/blog/2175936 http://blog.csdn.net/cougar0709/article/details/6362894 http://blog.csdn.net/u010257584/article/details/51320542

mysql版本基本有三种类型：deb, tar.gz. rpm

uname -a 如果有x86_64的是64位，没打印64的就是32位

http://blog.csdn.net/lzh4188521/article/details/12359995

sudo apt-get install (http://jingyan.baidu.com/article/425e69e6bbc6c7be14fc1640.html)

sudo rpm ***.rpm

下载ＲＰＭ地址： http://dev.mysql.com/downloads/mysql/5.6.html#downloads http://ftp.ntu.edu.tw/pub/MySQL/Downloads/MySQL-5.5/

安装方式有两种：

rpm安装方式： http://blog.csdn.net/u010257584/article/details/51320542

http://blog.csdn.net/superchanon/article/details/8546254/

step1:检查mysql是否安装

rpm -qa | grep -i mysql

若已安装，则删除

rpm -e mysql-libs-5.1.61-4.el6.x86_64 --nodeps

［可见已经安装了库文件，应该先卸载，不然会出现覆盖错误。注意卸载时使用了--nodeps选项，忽略了依赖关系］

step2:安装

rpm -ivh MySQL-server-5.6.26-1.linux_glibc2.5.x86_64.rpm

rpm -ivh MySQL-client-5.6.26-1.linux_glibc2.5.x86_64.rpm

设置Mysql: 1.设置用户名用分组与权限

用户名密码： 启动mysql服务器 service mysql start

设置初始密码 more /root/.mysql_secret

建立用户组及用户(http://blog.itpub.net/26148431/viewspace-1623902/)

groupadd mysql

useradd -g mysql mysql

允许远程登录设置

修改字符集和数据存储路径

设置开机自启动

允许远程登录

安装过程中出现的错误种类： 类型1:

http://blog.chinaunix.net/uid-28384295-id-3447441.html

sudo rpm -ivh MySQL-server-5.6.34-1.el6.x86_64.rpm [sudo] password for fuying: rpm：RPM should not be used directly install RPM packages, use Alien instead! rpm：However assuming you know what you are doing... 警告： MySQL-server-5.6.34-1.el6.x86_64.rpm: 头 V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY 错误： 依赖检测失败： /bin/sh 被 MySQL-server-5.6.34-1.el6.x86_64 需要。。。

类别2: sudo apt-get install mysql-server mysql-client

但其实安装的是5.5.3版本的，所以需要删除

http://www.jbxue.com/db/14719.html

1，删除mysql

sudo apt-get autoremove --purge mysql-server-5.5

sudo apt-get remove mysql-common

2，清理残留安装软件

dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P

3，清除数据库旧数据 清除旧数据

  1. 检查是否在运行

http://www.cnblogs.com/linjiqin/archive/2013/03/04/2942497.html

检查Mysql是否正在运行

sudo netstat -tap | grep mysql 当您运行该命令时，您可以看到类似下面的行：

root@ubuntu:~# sudo netstat -tap | grep mysql tcp 0 0 localhost.localdo:mysql : LISTEN
870/mysqld 如果服务器不能正常运行，您可以通过下列命令启动它：

sudo /etc/init.d/mysql restart

http://www.tuicool.com/articles/2EfM7f

fuying@ubuntu2:/opt/JAVA/MYSQL$ rpm -qa | grep -i mysql MySQL-server-5.6.34-1.linux_glibc2.5.x86_64 fuying@ubuntu2:/opt/JAVA/MYSQL$ service mysql start Starting MySQL .touch: 无法创建"/var/lib/mysql/ubuntu2.err": 权限不够 chmod: 无法访问"/var/lib/mysql/ubuntu2.err": 没有那个文件或目录 /usr/bin/mysqld_safe: 129: /usr/bin/mysqld_safe: cannot create /var/lib/mysql/ubuntu2.err: Permission denied /usr/bin/mysqld_safe: 1: eval: cannot create /var/lib/mysql/ubuntu2.err: Permission denied touch: 无法创建"/var/lib/mysql/ubuntu2.err": 权限不够 chown: 无法访问"/var/lib/mysql/ubuntu2.err": 没有那个文件或目录 chmod: 无法访问"/var/lib/mysql/ubuntu2.err": 没有那个文件或目录 /usr/bin/mysqld_safe: 129: /usr/bin/mysqld_safe: cannot create /var/lib/mysql/ubuntu2.err: Permission denied

  • The server quit without updating PID file (/var/lib/mysql/ubuntu2.pid).

fuying@ubuntu2:/usr/bin$ service mysql status

  • MySQL is not running fuying@ubuntu2:/usr/bin$ /etc/init.d/mysql start Starting MySQL .touch: 无法创建"/var/lib/mysql/ubuntu2.err": 权限不够 chmod: 无法访问"/var/lib/mysql/ubuntu2.err": 没有那个文件或目录 /usr/bin/mysqld_safe: 129: /usr/bin/mysqld_safe: cannot create /var/lib/mysql/ubuntu2.err: Permission denied /usr/bin/mysqld_safe: 1: eval: cannot create /var/lib/mysql/ubuntu2.err: Permission denied touch: 无法创建"/var/lib/mysql/ubuntu2.err": 权限不够 chown: 无法访问"/var/lib/mysql/ubuntu2.err": 没有那个文件或目录 chmod: 无法访问"/var/lib/mysql/ubuntu2.err": 没有那个文件或目录 /usr/bin/mysqld_safe: 129: /usr/bin/mysqld_safe: cannot create /var/lib/mysql/ubuntu2.err: Permission denied
  • The server quit without updating PID file (/var/lib/mysql/ubuntu2.pid). fuying@ubuntu2:/usr/bin$ sudo /etc/init.d/mysql start [sudo] password for fuying: Starting MySQL . * The server quit without updating PID file (/var/lib/mysql/ubuntu2.pid). fuying@ubuntu2:/usr/bin$ ps -ef|grep mysqld fuying 18826 9873 0 08:58 pts/8 00:00:00 grep --color=auto mysqld fuying@ubuntu2:/usr/bin$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) fuying@ubuntu2:/usr/bin$ mysql -uroot -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

fuying@ubuntu2:/opt/JAVA/MYSQL$ /usr/bin/mysql_install_db --user=root WARNING: Could not write to config file /usr/my.cnf: 权限不够

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

./usr/sbin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory fuying@ubuntu2:/opt/JAVA/MYSQL$ sudo /usr/bin/mysql_install_db --user=root Installing MySQL system tables.../usr/sbin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

最后，终于成功做以下步骤： fuying@ubuntu2:/opt/JAVA/MYSQL$ sudo /usr/bin/mysql_install_db --user=rootInstalling MySQL system tables...2016-10-19 09:06:14 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-10-19 09:06:14 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap. 2016-10-19 09:06:14 0 [Note] /usr/sbin/mysqld (mysqld 5.6.34) starting as process 22513 ... 2016-10-19 09:06:14 22513 [Note] InnoDB: Using atomics to ref count buffer pool pages 2016-10-19 09:06:14 22513 [Note] InnoDB: The InnoDB memory heap is disabled 2016-10-19 09:06:14 22513 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-10-19 09:06:14 22513 [Note] InnoDB: Memory barrier is not used 2016-10-19 09:06:14 22513 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-10-19 09:06:14 22513 [Note] InnoDB: Using Linux native AIO 2016-10-19 09:06:14 22513 [Note] InnoDB: Using CPU crc32 instructions 2016-10-19 09:06:14 22513 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2016-10-19 09:06:14 22513 [Note] InnoDB: Completed initialization of buffer pool 2016-10-19 09:06:14 22513 [Note] InnoDB: Highest supported file format is Barracuda. 2016-10-19 09:06:14 22513 [Warning] InnoDB: Resizing redo log from 2320 to 23072 pages, LSN=1595685 2016-10-19 09:06:14 22513 [Warning] InnoDB: Starting to delete and rewrite log files. 2016-10-19 09:06:14 22513 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2016-10-19 09:06:15 22513 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2016-10-19 09:06:15 22513 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2016-10-19 09:06:15 22513 [Warning] InnoDB: New log files created, LSN=1595685 2016-10-19 09:06:15 22513 [Note] InnoDB: 128 rollback segment(s) are active. 2016-10-19 09:06:15 22513 [Note] InnoDB: Creating tablespace and datafile system tables. 2016-10-19 09:06:15 22513 [Note] InnoDB: Tablespace and datafile system tables created. 2016-10-19 09:06:15 22513 [Note] InnoDB: Waiting for purge to start 2016-10-19 09:06:15 22513 [Note] InnoDB: 5.6.34 started; log sequence number 1595685 ERROR: 1136 Column count doesn't match value count at row 1 2016-10-19 09:06:15 22513 [ERROR] Aborting

2016-10-19 09:06:15 22513 [Note] Binlog end 2016-10-19 09:06:15 22513 [Note] InnoDB: FTS optimize thread exiting. 2016-10-19 09:06:15 22513 [Note] InnoDB: Starting shutdown... 2016-10-19 09:06:17 22513 [Note] InnoDB: Shutdown completed; log sequence number 1625695 2016-10-19 09:06:17 22513 [Note] /usr/sbin/mysqld: Shutdown complete

OK

Filling help tables...2016-10-19 09:06:17 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-10-19 09:06:17 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap. 2016-10-19 09:06:17 0 [Note] /usr/sbin/mysqld (mysqld 5.6.34) starting as process 22543 ... 2016-10-19 09:06:17 22543 [Note] InnoDB: Using atomics to ref count buffer pool pages 2016-10-19 09:06:17 22543 [Note] InnoDB: The InnoDB memory heap is disabled 2016-10-19 09:06:17 22543 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-10-19 09:06:17 22543 [Note] InnoDB: Memory barrier is not used 2016-10-19 09:06:17 22543 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-10-19 09:06:17 22543 [Note] InnoDB: Using Linux native AIO 2016-10-19 09:06:17 22543 [Note] InnoDB: Using CPU crc32 instructions 2016-10-19 09:06:17 22543 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2016-10-19 09:06:17 22543 [Note] InnoDB: Completed initialization of buffer pool 2016-10-19 09:06:17 22543 [Note] InnoDB: Highest supported file format is Barracuda. 2016-10-19 09:06:17 22543 [Note] InnoDB: 128 rollback segment(s) are active. 2016-10-19 09:06:17 22543 [Note] InnoDB: Waiting for purge to start 2016-10-19 09:06:17 22543 [Note] InnoDB: 5.6.34 started; log sequence number 1625695 2016-10-19 09:06:17 22543 [Note] Binlog end 2016-10-19 09:06:17 22543 [Note] InnoDB: FTS optimize thread exiting. 2016-10-19 09:06:17 22543 [Note] InnoDB: Starting shutdown... 2016-10-19 09:06:19 22543 [Note] InnoDB: Shutdown completed; log sequence number 1625705 OK

To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h ubuntu2 password 'new-password'

Alternatively you can run:

/usr/bin/mysql_secure_installation

which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

cd mysql-test ; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/

The latest information about MySQL is available on the web at

http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

WARNING: Found existing config file /usr/my.cnf on the system. Because this file might be in use, it was not replaced, but was used in bootstrap (unless you used --defaults-file) and when you later start the server. The new default config file was created as /usr/my-new.cnf, please compare it with your file and take the changes you need.

old version: mysql版本基本有三种类型：deb, tar.gz. rpm

uname -a 如果有x86_64的是64位，没打印64的就是32位

http://blog.csdn.net/lzh4188521/article/details/12359995

sudo apt-get install (http://jingyan.baidu.com/article/425e69e6bbc6c7be14fc1640.html)

sudo rpm ***.rpm

下载ＲＰＭ地址： http://dev.mysql.com/downloads/mysql/5.6.html#downloads http://ftp.ntu.edu.tw/pub/MySQL/Downloads/MySQL-5.5/

安装方式有两种：

rpm安装方式： http://blog.csdn.net/u010257584/article/details/51320542

http://blog.csdn.net/superchanon/article/details/8546254/

step1:检查mysql是否安装

rpm -qa | grep -i mysql 若已安装，则删除

rpm -e mysql-libs-5.1.61-4.el6.x86_64 --nodeps

［可见已经安装了库文件，应该先卸载，不然会出现覆盖错误。注意卸载时使用了--nodeps选项，忽略了依赖关系］

step2:安装

rpm -ivh MySQL-server-5.6.26-1.linux_glibc2.5.x86_64.rpm

rpm -ivh MySQL-client-5.6.26-1.linux_glibc2.5.x86_64.rpm

设置Mysql: 1.设置用户名用分组与权限

用户名密码： 启动mysql服务器 service mysql start

设置初始密码 more /root/.mysql_secret

建立用户组及用户(http://blog.itpub.net/26148431/viewspace-1623902/)

groupadd mysql

useradd -g mysql mysql

允许远程登录设置

修改字符集和数据存储路径

设置开机自启动

允许远程登录

安装过程中出现的错误种类： 类型1:

http://blog.chinaunix.net/uid-28384295-id-3447441.html

sudo rpm -ivh MySQL-server-5.6.34-1.el6.x86_64.rpm [sudo] password for fuying: rpm：RPM should not be used directly install RPM packages, use Alien instead! rpm：However assuming you know what you are doing... 警告： MySQL-server-5.6.34-1.el6.x86_64.rpm: 头 V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY 错误： 依赖检测失败： /bin/sh 被 MySQL-server-5.6.34-1.el6.x86_64 需要。。。

类别2: sudo apt-get install mysql-server mysql-client

但其实安装的是5.5.3版本的，所以需要删除

http://www.jbxue.com/db/14719.html

1，删除mysql

sudo apt-get autoremove --purge mysql-server-5.5

sudo apt-get remove mysql-common

2，清理残留安装软件

dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P

3，清除数据库旧数据 清除旧数据

检查是否在运行 http://www.cnblogs.com/linjiqin/archive/2013/03/04/2942497.html

检查Mysql是否正在运行

sudo netstat -tap | grep mysql 当您运行该命令时，您可以看到类似下面的行：

root@ubuntu:~# sudo netstat -tap | grep mysql tcp 0 0 localhost.localdo:mysql : LISTEN 870/mysqld 如果服务器不能正常运行，您可以通过下列命令启动它：

sudo /etc/init.d/mysql restart

http://www.tuicool.com/articles/2EfM7f

fuying@ubuntu2:/opt/JAVA/MYSQL$ rpm -qa | grep -i mysql MySQL-server-5.6.34-1.linux_glibc2.5.x86_64 fuying@ubuntu2:/opt/JAVA/MYSQL$ service mysql start Starting MySQL .touch: 无法创建"/var/lib/mysql/ubuntu2.err": 权限不够 chmod: 无法访问"/var/lib/mysql/ubuntu2.err": 没有那个文件或目录 /usr/bin/mysqld_safe: 129: /usr/bin/mysqld_safe: cannot create /var/lib/mysql/ubuntu2.err: Permission denied /usr/bin/mysqld_safe: 1: eval: cannot create /var/lib/mysql/ubuntu2.err: Permission denied touch: 无法创建"/var/lib/mysql/ubuntu2.err": 权限不够 chown: 无法访问"/var/lib/mysql/ubuntu2.err": 没有那个文件或目录 chmod: 无法访问"/var/lib/mysql/ubuntu2.err": 没有那个文件或目录 /usr/bin/mysqld_safe: 129: /usr/bin/mysqld_safe: cannot create /var/lib/mysql/ubuntu2.err: Permission denied

The server quit without updating PID file (/var/lib/mysql/ubuntu2.pid). fuying@ubuntu2:/usr/bin$ service mysql status

MySQL is not running fuying@ubuntu2:/usr/bin$ /etc/init.d/mysql start Starting MySQL .touch: 无法创建"/var/lib/mysql/ubuntu2.err": 权限不够 chmod: 无法访问"/var/lib/mysql/ubuntu2.err": 没有那个文件或目录 /usr/bin/mysqld_safe: 129: /usr/bin/mysqld_safe: cannot create /var/lib/mysql/ubuntu2.err: Permission denied /usr/bin/mysqld_safe: 1: eval: cannot create /var/lib/mysql/ubuntu2.err: Permission denied touch: 无法创建"/var/lib/mysql/ubuntu2.err": 权限不够 chown: 无法访问"/var/lib/mysql/ubuntu2.err": 没有那个文件或目录 chmod: 无法访问"/var/lib/mysql/ubuntu2.err": 没有那个文件或目录 /usr/bin/mysqld_safe: 129: /usr/bin/mysqld_safe: cannot create /var/lib/mysql/ubuntu2.err: Permission denied The server quit without updating PID file (/var/lib/mysql/ubuntu2.pid). fuying@ubuntu2:/usr/bin$ sudo /etc/init.d/mysql start [sudo] password for fuying: Starting MySQL . * The server quit without updating PID file (/var/lib/mysql/ubuntu2.pid). fuying@ubuntu2:/usr/bin$ ps -ef|grep mysqld fuying 18826 9873 0 08:58 pts/8 00:00:00 grep --color=auto mysqld fuying@ubuntu2:/usr/bin$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) fuying@ubuntu2:/usr/bin$ mysql -uroot -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) fuying@ubuntu2:/opt/JAVA/MYSQL$ /usr/bin/mysql_install_db --user=root WARNING: Could not write to config file /usr/my.cnf: 权限不够

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

./usr/sbin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory fuying@ubuntu2:/opt/JAVA/MYSQL$ sudo /usr/bin/mysql_install_db --user=root Installing MySQL system tables.../usr/sbin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

最后，终于成功做以下步骤： fuying@ubuntu2:/opt/JAVA/MYSQL$ sudo /usr/bin/mysql_install_db --user=rootInstalling MySQL system tables...2016-10-19 09:06:14 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-10-19 09:06:14 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap. 2016-10-19 09:06:14 0 [Note] /usr/sbin/mysqld (mysqld 5.6.34) starting as process 22513 ... 2016-10-19 09:06:14 22513 [Note] InnoDB: Using atomics to ref count buffer pool pages 2016-10-19 09:06:14 22513 [Note] InnoDB: The InnoDB memory heap is disabled 2016-10-19 09:06:14 22513 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-10-19 09:06:14 22513 [Note] InnoDB: Memory barrier is not used 2016-10-19 09:06:14 22513 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-10-19 09:06:14 22513 [Note] InnoDB: Using Linux native AIO 2016-10-19 09:06:14 22513 [Note] InnoDB: Using CPU crc32 instructions 2016-10-19 09:06:14 22513 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2016-10-19 09:06:14 22513 [Note] InnoDB: Completed initialization of buffer pool 2016-10-19 09:06:14 22513 [Note] InnoDB: Highest supported file format is Barracuda. 2016-10-19 09:06:14 22513 [Warning] InnoDB: Resizing redo log from 2320 to 23072 pages, LSN=1595685 2016-10-19 09:06:14 22513 [Warning] InnoDB: Starting to delete and rewrite log files. 2016-10-19 09:06:14 22513 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2016-10-19 09:06:15 22513 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2016-10-19 09:06:15 22513 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2016-10-19 09:06:15 22513 [Warning] InnoDB: New log files created, LSN=1595685 2016-10-19 09:06:15 22513 [Note] InnoDB: 128 rollback segment(s) are active. 2016-10-19 09:06:15 22513 [Note] InnoDB: Creating tablespace and datafile system tables. 2016-10-19 09:06:15 22513 [Note] InnoDB: Tablespace and datafile system tables created. 2016-10-19 09:06:15 22513 [Note] InnoDB: Waiting for purge to start 2016-10-19 09:06:15 22513 [Note] InnoDB: 5.6.34 started; log sequence number 1595685 ERROR: 1136 Column count doesn't match value count at row 1 2016-10-19 09:06:15 22513 [ERROR] Aborting

2016-10-19 09:06:15 22513 [Note] Binlog end 2016-10-19 09:06:15 22513 [Note] InnoDB: FTS optimize thread exiting. 2016-10-19 09:06:15 22513 [Note] InnoDB: Starting shutdown... 2016-10-19 09:06:17 22513 [Note] InnoDB: Shutdown completed; log sequence number 1625695 2016-10-19 09:06:17 22513 [Note] /usr/sbin/mysqld: Shutdown complete

OK

Filling help tables...2016-10-19 09:06:17 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-10-19 09:06:17 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap. 2016-10-19 09:06:17 0 [Note] /usr/sbin/mysqld (mysqld 5.6.34) starting as process 22543 ... 2016-10-19 09:06:17 22543 [Note] InnoDB: Using atomics to ref count buffer pool pages 2016-10-19 09:06:17 22543 [Note] InnoDB: The InnoDB memory heap is disabled 2016-10-19 09:06:17 22543 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-10-19 09:06:17 22543 [Note] InnoDB: Memory barrier is not used 2016-10-19 09:06:17 22543 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-10-19 09:06:17 22543 [Note] InnoDB: Using Linux native AIO 2016-10-19 09:06:17 22543 [Note] InnoDB: Using CPU crc32 instructions 2016-10-19 09:06:17 22543 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2016-10-19 09:06:17 22543 [Note] InnoDB: Completed initialization of buffer pool 2016-10-19 09:06:17 22543 [Note] InnoDB: Highest supported file format is Barracuda. 2016-10-19 09:06:17 22543 [Note] InnoDB: 128 rollback segment(s) are active. 2016-10-19 09:06:17 22543 [Note] InnoDB: Waiting for purge to start 2016-10-19 09:06:17 22543 [Note] InnoDB: 5.6.34 started; log sequence number 1625695 2016-10-19 09:06:17 22543 [Note] Binlog end 2016-10-19 09:06:17 22543 [Note] InnoDB: FTS optimize thread exiting. 2016-10-19 09:06:17 22543 [Note] InnoDB: Starting shutdown... 2016-10-19 09:06:19 22543 [Note] InnoDB: Shutdown completed; log sequence number 1625705 OK

To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h ubuntu2 password 'new-password'

Alternatively you can run:

/usr/bin/mysql_secure_installation

which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

cd mysql-test ; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/

The latest information about MySQL is available on the web at

http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

WARNING: Found existing config file /usr/my.cnf on the system. Because this file might be in use, it was not replaced, but was used in bootstrap (unless you used --defaults-file) and when you later start the server. The new default config file was created as /usr/my-new.cnf, please compare it with your file and take the changes you need.