Liunx下mysql源码安装步骤

这篇文章主要讲解了“Liunx下mysql源码安装步骤”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“Liunx下mysql源码安装步骤”吧！
环境：
虚拟机：CentOS-6.6-x86_64
mysql安装包：mysql-5.6.34

在安装源码包之前，需要安装一些rpm包
[root@potato ~]# rpm -qa|grep cmake
cmake-2.8.12.2-4.el6.x86_64
[root@potato ~]# rpm -qa|grep gcc
gcc-4.4.7-11.el6.x86_64
gcc-c++-4.4.7-11.el6.x86_64
[root@potato ~]# rpm -qa|grep make
make-3.81-20.el6.x86_64
[root@potato ~]# rpm -qa|grep make
[root@potato ~]# rpm -qa|grep libaio-devel
libaio-devel-0.3.107-10.el6.x86_64

创建用户mysql
[root@potato ~]# useradd mysql
从官网下载mysql数据库源码包，地址：
http://dev.mysql.com/downloads/mysql/
将下载的tar包进行解压
[root@potato ~]# cd Desktop/
[root@potato Desktop]#tar -zxvf /tmp/soft
创建软件存放目录
[root@potato Desktop]#mkdir /opt/mysql/mysql-5.6
[root@potato Desktop]#cd /tmp/soft
[root@potato soft]# cd mysql-5.6.34/
[root@potato mysql-5.6.34]#mkdir temp
开始编译，并指定软件存放目录
[root@potato temp]#cmake -DBUILD_CONFIG=mysql_release -DCMAKE_INSTALL_PREFIX=/opt/mysql/mysql-5.6 ..
[root@potato temp]#make –j
[root@potato temp]#make install
自此mysql软件安装完成

在/usr/local目录下配置mysql软连接，并设置PATH变量
[root@potato unbx]# cd /usr/local/
[root@potato local]# ln -s /opt/mysql/mysql-5.6 mysql
[root@potato local]# echo “PATH=$PATH:/usr/local/mysql/bin”>>/etc/profile
[root@potato local]# source /etc/profile
[root@potato mysql]# echo $PATH
/usr/local/sbin:/usr/sbin:/sbin:/usr/local/bin:/usr/bin:/bin:/root/bin:/usr/local/开发云主机域名mysql/bin

创建data目录并赋权
[root@potato local]# mkdir -p /data/mysql/mytest_3306
[root@potato local]# chown -R mysql:mysql /data/mysql/mytest_3306
[root@potato local]# cd /usr/local/mysql
[root@potato mysql]# chown -R mysql:mysql *
创建配置文件my.cnf
[root@potato mysql]# cd /etc
[root@potato mysql]# vi /etc/my.cnf
注：可以在https://tools.percona.com，按步骤自动生成my.cnf
初始化数据库，指定my.cnf文件
[root@potato mysql]# ./scripts/mysql_install_db –defaults-file=/etc/my.cnf –user=mysql

把mysql.server复制到/etc/init.d目录下，并开启mysql服务
[root@potato mysql]# cp support-files/mysql.server /etc/init.d/mysql
[root@potato mysql]# /etc/init.d/mysql start
Starting MySQL… SUCCESS!
连接mysql
[root@potato mysql]# mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1
Server version: 5.6.34-log Source distribution

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.

root@localhost:mysql.sock 14:22:29 [(none)]>s
————–
mysql Ver 14.14 Distrib 5.6.34, for Linux (x86_64) using EditLine wrapper

Connection id: 1
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ”
Using delimiter: ;
Server version: 5.6.34-log Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /tmp/mysql.sock
Uptime: 1 min 12 sec

Threads: 1 Questions: 6 Slow queries: 0 Opens: 70 Flush tables: 1 Open tables: 63 Queries per second avg: 0.083
————–
感谢各位的阅读，以上就是“Liunx下mysql源码安装步骤”的内容了，经过本文的学习后，相信大家对Liunx下mysql源码安装步骤这一问题有了更深刻的体会，具体使用情况还需要大家实践验证。这里是开发云，小编将为大家推送更多相关知识点的文章，欢迎关注！

相关推荐: MySql实现翻页查询功能

首先明确为什么要使用分页查询，因为数据庞大，查询不可能全部显示在页面上，如果全部显示在页面上，也会造成查询速度慢的情况，所以分页查询解决了①数据查开发云主机域名询；②性能优化，等（其他问题欢迎补充）的问题。分页查询也分为真分页和假分页：　　真分页：基于数据库查…