一、环境:
系统版本:CentOS5.5
MySQL版本:mysql-5.5.22
二、步骤:
1. 安装需要系统库相关库文件:
[root@localhost ~]# yum install -y gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel*
2.需要的两个包
[root@localhost /]# cd /usr/local/src/ [root@localhost src]# ll total 29332 -rw-r--r-- 1 root root 5517977 Jul 11 19:17 cmake-2.8.5.tar.gz -rw-r--r-- 1 root root 24464834 Jul 11 19:17 mysql-5.5.22.tar.gz
1) 安装cmake
[root@localhost src]# tar zxvf cmake-2.8.5.tar.gz [root@localhost src]# cd cmake-2.8.5 [root@localhost cmake-2.8.5]# ./bootstrap …… …… -- Build files have been written to: /usr/local/src/cmake-2.8.5 --------------------------------------------- CMake has bootstrapped. Now run gmake. [root@localhost cmake-2.8.5]# gmake …… …… [100%] Building CXX object Tests/CMakeLib/CMakeFiles/runcompilecommands.dir/run_compile_commands.cxx.o Linking CXX executable runcompilecommands [100%] Built target runcompilecommands [root@localhost cmake-2.8.5]# gmake install [root@localhost cmake-2.8.5]# cd ..
2)安装mysql
[root@localhost src]# groupadd mysql [root@localhost src]# useradd -g mysql mysql [root@localhost src]# tar zxvf mysql-5.5.22.tar.gz [root@localhost src]# cd mysql-5.5.22 [root@localhost mysql-5.5.22]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DWITH_EXTRA_CHARSETS:STRING=utf8,gbk \ -DWITH_MYISAM_STORAGE_ENGINE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_MEMORY_STORAGE_ENGINE=1 \ -DWITH_READLINE=1 \ -DENABLED_LOCAL_INFILE=1 \ -DMYSQL_DATADIR=/var/mysql/data \ -DMYSQL_USER=mysql …… …… CMake Warning: Manually-specified variables were not used by the project: MYSQL_USER WITH_MEMORY_STORAGE_ENGINE -- Build files have been written to: /usr/local/src/mysql-5.5.22 [root@localhost mysql-5.5.22]#make …… …… [100%] Building CXX object mysql-test/lib/My/SafeProcess/CMakeFiles/my_safe_process.dir/safe_process.cc.o Linking CXX executable my_safe_process [100%] Built target my_safe_process [root@localhost mysql-5.5.22]#make install …… …… -- Installing: /usr/local/mysql/man/man1/mysql_find_rows.1 -- Installing: /usr/local/mysql/man/man1/mysql_upgrade.1 -- Installing: /usr/local/mysql/man/man1/mysqlimport.1 -- Installing: /usr/local/mysql/man/man1/mysql_client_test.1 -- Installing: /usr/local/mysql/man/man8/mysqld.8 [root@localhost mysql-5.5.22]# chmod +w /usr/local/mysql/ [root@localhost mysql-5.5.22]# chown -R mysql:mysql /usr/local/mysql/ [root@localhost mysql-5.5.22]# ln -s /usr/local/mysql/lib/libmysqlclient.so.18 /usr/lib/libmysqlclient.so.18 [root@localhost mysql-5.5.22]# mkdir -p /var/mysql [root@localhost mysql-5.5.22]# mkdir -p /var/mysql/data/ [root@localhost mysql-5.5.22]# mkdir -p /var/mysql/log/ [root@localhost mysql-5.5.22]# chown -R mysql:mysql /var/mysql/ [root@localhost mysql-5.5.22]# cd support-files/ [root@localhost support-files]# cp my-medium.cnf /etc/my.cnf [root@localhost support-files]# cp mysql.server /etc/init.d/mysql
初始化安装。
[root@localhost support-files]# /usr/local/mysql/scripts/mysql_install_db \ --defaults-file=/etc/my.cnf \ --basedir=/usr/local/mysql \ --datadir=/var/mysql/data \ --user=mysql …… …… You can start the MySQL daemon with: cd /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd /usr/local/mysql/mysql-test ; perl mysql-test-run.pl Please report any problems with the /usr/local/mysql/scripts/mysqlbug script! [root@localhost support-files]# chmod +x /etc/init.d/mysql [root@localhost support-files]# vi /etc/init.d/mysql basedir=/usr/local/mysql datadir=/var/mysql/data [root@localhost support-files]#chkconfig --add mysql [root@localhost support-files]#chkconfig --level 345 mysql on [root@localhost support-files]# cd /usr/local/mysql [root@localhost mysql]# service mysql start Starting MySQL.. SUCCESS! [root@localhost mysql]# mysql -bash: mysql: command not found [root@localhost mysql]# /usr/local/mysql/bin/mysql -uroot mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.5.22 Source distribution Copyright (c) 2000, 2011, 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. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | +--------------------+ 4 rows in set (0.01 sec) mysql> exit Bye [root@localhost mysql]# ln -s /usr/local/mysql/bin/mysql /usr/bin [root@localhost mysql]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.5.22 Source distribution Copyright (c) 2000, 2011, 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. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | +--------------------+ 4 rows in set (0.00 sec) mysql> grant all privileges on *.* to root@'%' identified by 'joy' with grant option; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> exit Bye
//设置停止防火墙
[root@localhost mysql]# /etc/init.d/iptables stop; Flushing firewall rules: [ OK ] Setting chains to policy ACCEPT: filter [ OK ] Unloading iptables modules: [ OK ]或添加3306端口允许访问
相关推荐
源码安装linux下的mysql数据库。
RedHat Linux 源码安装MYSQL步骤.pdfRedHat Linux 源码安装MYSQL步骤.pdf
在Linux(我用的CentOS6.8)上用源码安装MySQL5.7.12需要的所有依赖都在(除gcc和gcc_c++外,一般系统都带)包括ncurses-devel-5.7-4.20090207.el6.x86_64、libarchive-2.8.3-7.el6_8.x86_64、cmake-2.8.12.2-4.el6.x86_...
linux下源码编译安装mysql-5.6.25版本
里面详细介绍了各种软件的源码安装过程,和遇到的一些错误解决方法,按照文档来操作肯定可以安装成功,里面有软件下载地址,和一些用到的资源网站,适用于该入行和安装容易出现问题的人群来使用,内容很详细 肯定...
mysql-5.5.27 linux源码安装文件
linux系统下源码版mysql安装,不需要安装cmake
ubuntu16.04环境测试正常,将各类头文件和编译出来的库加到的自己的代码工程
CentOS_6.3下MySQL_5.6源码安装,
本次采用二进制安装linux mysql数据库 二进制(Binary Package) 优点 安装简单;可以安装到任何路径下,灵活性好;一台服务器可以安装多个MySQL 缺点 已经经过编译,性能不如源码编译的好;不能灵活定制编译参数 ...
linux下源码安装mysql,值得学习和借鉴,希望对大家有用哦!
linux环境下MySQL源码编译安装及初始化,使用cmake安装,如何添加配置文件,配置客户端,以及初始化。
在正式项目部署到linux经常用到需要在内网环境下安装mysql数据库,可以通过离线安装包的形式,亲测可用
RockyLinux9.0 yum安装 mysql8.0 java linux Rocky9.0 mysql8.0 yum安装 Rocky 9.0 Mysql 8.0.28 启动服务,并添加自启动 登录并重置密码,开放远程链接 开放端口 防火墙开启 1、开启端口3306 firewall-cmd --zone=...
mysql 5.7 for linux源码编译安装。
Linux下离线安装MySQL的安装包,安装教程http://www.cnblogs.com/Luke-Me/p/9018903.html
linux下安装mysql5.0.18(源码包)详解
Linux下源码编译MySQL 5.5 与安装程全记录 详细步骤 亲测可用
linux下MySQL 5.6源码安装记录如下 1、下载:当前mysql版本到了5.6.20 http://dev.mysql.com/downloads/mysql 选择Source Code 2、必要软件包 代码如下:yum -y install gcc gcc-c++ gcc-g77 autoconf automake ...