Ubuntu下安装MySQL 5.6.23

最新推荐文章于 2024-07-06 13:11:09 发布

vonzhou

最新推荐文章于 2024-07-06 13:11:09 发布

阅读量1.8k

点赞数

分类专栏： MySQL 文章标签： mysql install

本文链接：https://blog.csdn.net/vonzhoufz/article/details/44452771

版权

本文档详细介绍了在Ubuntu系统上安装MySQL 5.6.23的步骤，包括下载源码包、创建用户和组、安装依赖、配置文件、启动服务以及设置开机启动等，确保MySQL顺利安装并正常运行。

摘要由CSDN通过智能技术生成

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]