Liunx下mysql源码安装过程
发布时间:2022-01-20 14:17:02 所属栏目:MySql教程 来源:互联网
导读:这篇文章主要讲解了Liunx下mysql源码安装步骤,文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习Liunx下mysql源码安装步骤吧! 环境: 虚拟机:CentOS-6.6-x86_64 mysql安装包:mysql-5.6.34 创建用户mysql [
这篇文章主要讲解了“Liunx下mysql源码安装步骤”,文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习“Liunx下mysql源码安装步骤”吧! 环境: 虚拟机:CentOS-6.6-x86_64 mysql安装包:mysql-5.6.34 创建用户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 Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. 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 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源码安装步骤这一问题有了更深刻的体会,具体使用情况还需要大家实践验证。 (编辑:丽水站长网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |