centos下mysql 5源码安装全过程记录

mofdan

　　参考：http://blog.csdn.net/mycwq/article/details/24488691

• 安装cmake，mysql 5.5以后的版本要通过cmake进行编译
  

　　在新装的CentOS 5.7系统中，先安装了nginx（含nginx必备依赖：gzip 模块需要 zlib 库；rewrite 模块需要 pcre 库；ssl 功能需要 openssl 库），结果安装cmake过程中在./bootstrap这一步无法通过，原因未知。后通过VM快照恢复到未安装nginx前，顺利安装cmake。
　　安装步骤：

• 官网下载http://www.cmake.org/files/v2.8/cmake-2.8.10.2.tar.gz
  
• tar zxvf cmake-2.8.10.2.tar.gz
  
• cd cmake-2.8.10.2
  
• ./bootstrap
  
• make
  
• make install
  
• cmake –h      验证安装结果
  

• 开始安装mysql
  

　　官网下载源码安装包：https://cdn.mysql.com//Downloads/MySQL-5.5/mysql-5.5.57.tar.gz
　　安装mysql

• [iyunv@local ~]# wget http://cdn.mysql.com/Downloads/MySQL-5.5/mysql-5.5.37.tar.gz
  
• [iyunv@local ~]# tar xvf mysql-5.5.37.tar.gz
  
• [iyunv@local ~]# cd mysql-5.5.37
  
• [iyunv@local mysql-5.5.37]# cmake ./
  

　　可能还会报这个错，没有就跳过

• CMake Error at cmake/readline.cmake:83(MESSAGE):
  
• Curses library not found.  Pleaseinstall appropriate package,
  
• remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name islibncurses5-dev, on Redhat and derivates it is ncurses-devel.
  
• Call Stack (most recent call first):
  
• cmake/readline.cmake:127 (FIND_CURSES)
  
• cmake/readline.cmake:217 (MYSQL_USE_BUNDLED_LIBEDIT)
  
• CMakeLists.txt:355 (MYSQL_CHECK_READLINE
  
• -- Configuring incomplete, errors occurred!
  
• See also "/root/my/mysql-5.5.37/CMakeFiles/CMakeOutput.log".
  
• See also"/root/my/mysql-5.5.37/CMakeFiles/CMakeError.log".
  

　　说明centos系统没有ncurses-devel

• [iyunv@local ~]# wget http://invisible-island.net/datafiles/release/ncurses.tar.gz
  
• [iyunv@local ~]# cd ncurses-5.9
  
• [iyunv@local ncurses-5.9]#./configure
  
• [iyunv@local ncurses-5.9]# make
  
• [iyunv@local ncurses-5.9]# make install
  

　　再删除刚才编译生成的 CMakeCache.txt 文件，否则无法进行下一步

• [iyunv@local mysql-5.5.37]# rm -f CMakeCache.txt
  

　　继续编译mysql

• [iyunv@local ~]# cmake ./
  
• [iyunv@local ~]# make
  
• [iyunv@local ~]# make install
  

　　这样，mysql默认将成功安装到/usr/local/mysql
　　创建mysql用户组

• [iyunv@local ~]# groupadd mysql
  
• [iyunv@local ~]# useradd –r –g mysql mysql
  
• [iyunv@local ~]# chown –R mysql.mysql /usr/local/mysql
  

　　
启动mysql

• [iyunv@local ~]# /usr/local/mysql/bin/mysqld_safe --user=mysql
  

　　这里可能会发生错误，没有就跳过：

• FATAL ERROR: Could not find./bin/my_print_defaults
  
• If you compiled from source, you need torun 'make install' to
  
• copy the software into the correct locationready for operation.
  
• If you are using a binary release, you musteither be at the top
  
• level of the extracted archive, or pass the --basedir option
  
• pointing to that location.
  

　　解决方法：

• [iyunv@local ~]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
  

　　再启动mysql

• [iyunv@local ~]# /usr/local/mysql/bin/mysqld_safe --user=mysql
  

　　注册mysql服务，开机自动启动
　　1.设置mysql配置文件到/etc目录

• [iyunv@local ~]# cp /usr/local/mysql/support-files/my-medium.cnf/etc/my.cnf
  

　　2.设置mysql开机自启

• [iyunv@local ~]# cp/usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
  
• [iyunv@local ~]# chmod +x /etc/init.d/mysql
  
• [iyunv@local ~]# /sbin/chkconfig --add mysql
  

　　3.启动mysql服务

• [iyunv@local ~]# service mysql start
  

　　测试mysql是否安装成功

• [iyunv@local ~]# /usr/local/mysql/bin/mysql -u root -p
  
• Enter password:
  
• Welcome to the MySQL monitor.  Commands end with ; or \g.
  
• Your MySQL connection id is 1
  
• Server version: 5.5.37 Source distribution
  
• 
  
• Copyright (c) 2000, 2014, Oracle and/or itsaffiliates. All rights reserved.
  
• 
  
• Oracle is a registered trademark of OracleCorporation and/or its
  
• affiliates. Other names may be trademarksof their respective
  
• owners.
  
• 
  
• Type 'help;' or '\h' for help. Type '\c' toclear the current input statement.
  
• 
  
• mysql> show databases;
  
• +--------------------+
  
• | Database           |
  
• +--------------------+
  
• | information_schema |
  
• | mysql              |
  
• | performance_schema |
  
• | test               |
  
• +--------------------+
  
• 4 rows in set (0.03 sec)
  

　　参考：
　　http://blog.csdn.net/mycwq/article/details/24488691
　　最后启动mysql的时候报错，出现The serverquit without updating PID file错误
　　解决过程：http://blog.sina.com.cn/s/blog_637e04c9010117ri.html

[iyunv@localhost ~]# cd/usr/local/mysql

[iyunv@localhost mysql]# chown-R mysql.mysql .
[iyunv@localhost mysql]# su - mysql
[mysql@localhost ~]$ cd/usr/local/mysql
[mysql@localhost mysql]$ scripts/mysql_install_db
Installing MySQL system tables...
OK
Filling help tables...
OK

　　To start mysqld at boot time youhave to copy
support-files/mysql.server to the right place for your system
　　PLEASE REMEMBER TO SET A PASSWORDFOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
　　./bin/mysqladmin -u root password'new-password'
./bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
　　Alternatively you can run:
./bin/mysql_secure_installation
　　which will also give you the optionof removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.
　　See the manual for moreinstructions.
　　You can start the MySQL daemonwith:
cd . ; ./bin/mysqld_safe &
　　You can test the MySQL daemon withmysql-test-run.pl
cd ./mysql-test ; perl mysql-test-run.pl
　　Please report any problems with the./bin/mysqlbug script!

[mysql@localhost mysql]$ /usr/local/mysql/bin/mysqld_safe--user=mysql &
[1] 11767
[mysql@localhost mysql]$ 120502 07:01:17 mysqld_safe Logging to'/usr/local/mysql/data/localhost.localdomain.err'.
120502 07:01:17 mysqld_safe Starting mysqld daemon with databases from/usr/local/mysql/data
[mysql@localhost mysql]$ /etc/rc.d/init.d/mysql status
MySQL running(11830)                                     [  OK  ]
[mysql@localhost mysql]$ /etc/rc.d/init.d/mysql start
StartingMySQL                                             [  OK  ]

　　最后这里↗$ /etc/rc.d/init.d/mysqlstart可能需要切回root用户才能成功启动
　　额外配置
　　如果非本地环境无法登陆mysql，做如下更改
　　1.Centos中防火墙开放3306端口：
　　-A INPUT -p tcp-m tcp --dport 3306 -j ACCEPT
　　2.Mysql中允许root用户任意IP登陆：
　　Update user sethost=”%” where user=”root”;
　　3. mysql取消表名区分大小写
　　修改 /etc/my.cnf：在[mysqld]节点下，加入一行： lower_case_table_names=1
　　4.使用mysql-workbench工具导入.sql文件