mysql数据库源码安装1、安装环境系统： Red Hat Enterprise Linux Server release 6.4 (Santiago)64位CUP 4核内存8G硬盘空间160G系统分区 /boot 300M /swap 4096M /home 102400M把剩余全部空间分给根分区。
mysql源码包版本:mysql-5.7.4-m14.tar.gz2 、升级cmake到2.8.9版本查看系统cmake 版本rpm -qa cmake 或cmake --version[root@gztestC118 home]# rpm -qa cmakecmake-2.6.4-5.el6.x86_64[root@gztestC118 home]# cmake --versioncmake version 2.6-patch 4[root@gztestC118 home]#rpm -e cmake-2.6.4-5.el6.x86_64 删除旧的cmake[root@gztestC118 home]# tar –zxvf cmake-2.8.9.tar.gz[root@gztestC118 home]# cd cmake-2.8.9[root@gztestC118 home]./configure[root@gztestC118 home]make &&make install[root@gztestC118 ~]# cmake –version 检查新版本号cmake version 2.8.9 升级成功。
3、拷贝好RHEL系统镜像进入目录Packages[root@gztestC117 Packages]# ll *curses* 把下面安装包安装下。
-r--r--r--. 1 root root 274016 5月 12 06:16 ncurses-5.7-3.20090208.el6.x86_64.rpm-r--r--r--. 1 root root 62400 5月 12 06:16 ncurses-base-5.7-3.20090208.el6.x86_64.rpm-r--r--r--. 1 root root 656772 5月 12 06:16 ncurses-devel-5.7-3.20090208.el6.i686.rpm-r--r--r--. 1 root root 657088 5月 12 06:16 ncurses-devel-5.7-3.20090208.el6.x86_64.rpm-r--r--r--. 1 root root 256596 5月 12 06:16 ncurses-libs-5.7-3.20090208.el6.i686.rpm-r--r--r--. 1 root root 251756 5月 12 06:16 ncurses-libs-5.7-3.20090208.el6.x86_64.rpm-r--r--r--. 1 root root 559700 5月 12 06:16 ncurses-term-5.7-3.20090208.el6.x86_64.rpm [root@gztestC117 Packages]# rpm -ivh ncurses-5.7-3.20090208.el6.x86_64.rpmwarning: ncurses-5.7-3.20090208.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing... ########################################### [100%] package ncurses-5.7-3.20090208.el6.x86_64 is already installed[root@gztestC117 Packages]# rpm -ivh ncurses-base-5.7-3.20090208.el6.x86_64.rpmwarning: ncurses-base-5.7-3.20090208.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing... ########################################### [100%] package ncurses-base-5.7-3.20090208.el6.x86_64 is already installed[root@gztestC117 Packages]# rpm -ivh ncurses-devel-5.7-3.20090208.el6.x86_64.rpmwarning: ncurses-devel-5.7-3.20090208.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing... ########################################### [100%] 1:ncurses-devel ########################################### [100%] [root@gztestC117 Packages]# rpm -ivh ncurses-libs-5.7-3.20090208.el6.x86_64.rpmwarning: ncurses-libs-5.7-3.20090208.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key IDfd431d51: NOKEYPreparing... ########################################### [100%] package ncurses-libs-5.7-3.20090208.el6.x86_64 is already installed[root@gztestC117 Packages]# rpm -ivh ncurses-term-5.7-3.20090208.el6.x86_64.rpmwarning: ncurses-term-5.7-3.20090208.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEYPreparing... ########################################### [100%] 1:ncurses-term ########################################### [100%]利用新安装的cmake指定mysql安装路径解压mysql包，进入mysql源目录cmake -DCMAKE_INSTALL_PREFIX=/home/mysqlinstall/mysql如果未安装curses相关包则会报错CMake Error at cmake/readline.cmake:64 (MESSAGE):Curses library not found. Please install appropriate package。
如果报错则删除Cmake源目录下CMakeCache.txt文件。
再重新指令安装路径。
然后在cmake源目录删除CMakeLists.txt，重新cmake -DCMAKE_INSTALL_PREFIX=/home/mysqlinstall/mysql指定路径正常会有以下提示：cmake -DCMAKE_INSTALL_PREFIX=/home/mysqlinstall/mysql-- Build files have been written to: /home/mysqlinstall/mysql4、[root@gztestC118 mysql-5.7.4-m14] #cd /home/mysql-5.7.4-m14[root@gztestC118 mysql-5.7.4-m14]# make && make install5、创建mysql用户[root@gztestC118 home]#useradd mysql6、root用户下执行visudo,添加mysql用户执行root操作权限(mysql ALL=(ALL) ALL)7、[root@gztestC118 home]# su mysql[mysql@gztestC118 home]$切换到mysql账户，cd /home/mysqlinstall/mysql/scripts*/mysql/scripts目录下执行[mysql@gztestC118 scripts]$ sudo ./mysql_install_db --basedir=/home/mysqlinstall/mysql --datadir=/home/mysql/data/ --user=mysql8.[root@gztestC118 support-files]#cd/home/mysqlinstall/mysql/support-files[root@gztestC118 support-files]#cp f /etc/f && cp mysql.server/etc/init.d/mysqld[root@gztestC118 etc]# vi /etc/f 加入以下配置character-set-server=utf8port = 8808datadir = /home/mysql/datalog-error = /home/mysql/data/error.logpid-file = /home/mysql/data/mysql.piduser = mysqltmpdir = /tmp启动mysql服务：root@gztestC118 etc]# service mysqld start || /etc/init.d/mysql start添加到开机自启动root@gztestC118 etc]#chkconfig --add mysqld && chkconfig mysqld on9.创建库、用户、并把库赋与用户权限1)创建库：CREATE DATABASE testDB ;2)创建用户：CREATE USER 'gztestuser'@'192.168.%' IDENTIFIED BY 'gztestC119';3)给用户赋权：grant all on gztestuser.* to 'testDB'@'192.168.%' identified by 'gztestC119';4)刷新权限：flush privileges;10、修改防火墙设置开启数据库指定端口/sbin/iptables -I INPUT -p tcp --dport 8808 -j ACCEPT/sbin/iptables -I OUTPUT -p tcp --sport 8808 -j ACCEPT/etc/rc.d/init.d/iptables save/etc/init.d/iptables restartiptables -L -n至此，大功告成，数据库开始正常访问！！！远程连接反应慢，解决方法编辑/etc/f 配置中加入skip-name-resolve，然后flush privileges;mysql接收到连接请求后，获得的是客户端的ip，为了更好的匹配er里的权限记录（某些是用hostname定义的）。