CentOS完整安装编译MySQL-By杨宏伟.doc

/hongweiyangblog杨宏伟 - List:Centos 5.5 X32 安装 MySQL (需要网络支持！或自行下载相关软件！)此版本为完整版MySQL编译，以及各种问题的解决,非常详细！1软件全部下载到/usr/local/src2安装目录/usr/local/f目录/etc/f4Socket文件目录/tmp/mysql.sock5data目录/usr/local/mysql/data1、用户管理rootmysql-master cmake-2.8.5# groupadd mysqlrootmysql-master cmake-2.8.5# useradd -r -g mysql mysql2、安装cmakerootmysql-master # cd /usr/local/src/若未安装GCCrootmysql-master cmake-2.8.5# yum -y install gccrootmysql-master cmake-2.8.5# yum -y install gcc-c+1)、下载cmakerootmysql-master src# wget /files/v2.8/cmake-2.8.5.tar.gz2)、解压cmakerootmysql-master src# tar -zxvf cmake-2.8.5.tar.gz3)、配置编译rootmysql-master src# cd cmake-2.8.5rootmysql-master cmake-2.8.5# ./configurerootmysql-master cmake-2.8.5# gmakerootmysql-master cmake-2.8.5# gmake install或如下：/rootmysql-master cmake-2.8.5# ./bootstrap/rootmysql-master cmake-2.8.5# make/rootmysql-master cmake-2.8.5# make install/查看 cmake版本rootmysql-master cmake-2.8.5# cmake versionrootmysql-master cmake-2.8.5# cd /usr/local/src/3、安装ncursesrootmysql-master src# wget /pub/gnu/ncurses/ncurses-5.6.tar.gzrootmysql-master src# tar -zxvf ncurses-5.6.tar.gzrootmysql-master src# cd ncurses-5.6rootmysql-master ncurses-5.6# ./configure -prefix=/usr -with-shared -without-debug -without-ada -enable-overwriterootmysql-master ncurses-5.6# makerootmysql-master ncurses-5.6# make install4、安装bisonrootmysql-master src# wget /gnu/bison/bison-2.4.3.tar.gzrootmysql-master src# tar -zxvf bison-2.4.3.tar.gzrootmysql-master src# cd bison-2.4.3rootmysql-master src# ./configurerootmysql-master bison-2.4.3# makerootmysql-master bison-2.4.3# make install5、安装MySQL移除MySQL: rootmysql-master # yum remove mysql1)、下载MySQLrootmysql-master src # wget /Downloads/MySQL-5.5/mysql-5.5.27.tar.gz 2)、解压MySQLrootmysql-master src# tar -zxvf mysql-5.5.27.tar.gz 3)、配置编译rootmysql-master mysql-5.5.27# mkdir /usr/local/mysqlrootmysql-master mysql-5.5.27# mkdir /usr/local/mysql/datarootmysql-master mysql-5.5.27# cd /usr/local/src/mysql-5.5.27/以下部分建议黏贴到记事本,整理为一行(-DMYSQL_USER建议去除,或报一个warning，但可忽略！)rootmysql-master mysql-5.5.27# 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 -DEXTRA_CHARSETS=all -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/usr/local/mysql/data -DMYSQL_TCP_PORT=3306 -DMYSQL_USER=mysql/注意:上面的一段字符串是一条命令语句。参数说明：-DCMAKE_INSTALL_PREFIX=/usr/local/mysql/安装目录-DMYSQL_UNIX_ADDR=/tmp/mysql.sock-DDEFAULT_CHARSET=utf8/使用utf8字符-DDEFAULT_COLLATION=utf8_general_ci/校验字符-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk-DEXTRA_CHARSETS=all/安装所有扩展字符集-DWITH_MYISAM_STORAGE_ENGINE=1/MYISAM引擎-DWITH_INNOBASE_STORAGE_ENGINE=1/INNODB引擎-DWITH_MEMORY_STORAGE_ENGINE=1-DWITH_READLINE=1-DENABLED_LOCAL_INFILE=1/允许从本地导入数据-DMYSQL_DATADIR=/usr/local/mysql/data/数据库存放位置-DMYSQL_TCP_PORT3306-DMYSQL_USER=mysql可能报错：Warning1：/忽略编译去掉编译用户参数即可-DMYSQL_USER=mysqlWarning 2：- Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH)CMake Error at cmake/readline.cmake:82 (MESSAGE): Curses library not found. Please install appropriate package,remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.Call Stack (most recent call first): cmake/readline.cmake:126 (FIND_CURSES) cmake/readline.cmake:216 (MYSQL_USE_BUNDLED_LIBEDIT) CMakeLists.txt:256 (MYSQL_CHECK_READLINE)- Configuring incomplete, errors occurred!-解决方法-rootmysql-master # find / -name CMakeCache.txt /查找所有CMakeCache.txt 文件命令会显示下列内容:rootmysql-master # /usr/local/src/cmake-2.8.5/CMakeCache.txtrootmysql-master # /usr/local/src/cmake-2.8.5/Tests/ComplexOneConfig/Cache/CMakeCache.txtrootmysql-master # /usr/local/src/cmake-2.8.5/Tests/CMakeFiles/CheckFortran/CMakeCache.txtrootmysql-master # /usr/local/src/cmake-2.8.5/Tests/Complex/Cache/CMakeCache.txtrootmysql-master # /usr/local/src/cmake-2.8.5/Tests/ComplexRelativePaths/Cache/CMakeCache.txtrootmysql-master # /usr/local/src/mysql-5.5.8/CMakeCache.txt/删除下列内容:rootmysql-master # rm -rf /usr/local/src/cmake-2.8.6/Tests/Complex/Cache/CMakeCache.txtrootmysql-master # rm -rf /usr/local/src/cmake-2.8.6/Tests/ComplexOneConfig/Cache/CMakeCache.txtrootmysql-master # rm -rf /usr/local/src/cmake-2.8.6/Tests/ComplexRelativePaths/Cache/CMakeCache.txtrootmysql-master # rm -rf /usr/local/src/mysql-5.5.8/CMakeCache.txt/再次执行命令:rootmysql-master mysql-5.5.27# 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 -DEXTRA_CHARSETS=all -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/usr/local/mysql/data -DMYSQL_TCP_PORT=3306 -DMYSQL_USER=mysql/配置成功！rootmysql-master mysql-5.5.27# makeWarning3：/过程中出现 警告:类型双关作用在不完全类型上可能被破坏强重叠规则rootmysql-master mysql-5.5.27# echo $?/返回值：0,则此警告可以忽略;rootmysql-master mysql-5.5.27# make install4)、设置目录权限rootmysql-master mysql-5.5.27# cd /usr/local/mysql/rootmysql-master mysql# chown -R root:mysql ./注意 “.”不能漏掉，当前目录中所有文件的所有者所有者设为root，所属组为mysqlrootmysql-master mysql# chown -R mysql:mysql data5)、配置文件rootmysql-master # cp /usr/local/mysql/support-files/f /etc/frootmysql-master # vi /etc/f/打开innodb注释：innodb_data_home_dir = /usr/local/mysql/datainnodb_data_file_path = ibdata1:10M:autoextendinnodb_log_group_home_dir = /usr/local/mysql/datainnodb_buffer_pool_size = 16Minnodb_additional_mem_pool_size = 2Minnodb_log_file_size = 5Minnodb_log_buffer_size = 8Minnodb_flush_log_at_trx_commit = 1innodb_lock_wait_timeout = 50/添加内容:mysqld38 max_connections = 10000/根据服务器性能设置值39 basedir = /usr/local/mysql/设置安装目录，这样在系统启动时才能正确运行到/etc/rc.d/init.d/mysql start6)、创建系统数据库的表rootmysql-master # cd /usr/local/mysql/rootmysql-master mysql# scripts/mysql_install_db -user=mysql7)、设置权限启动设置环境变量：（mysql uroot mysql .环境变量）rootmysql-master # vi /root/.bash_profile/PATH=$PATH:$HOME/bin添加参数如下：PATH=$PATH:$HOME/bin:/usr/local/mysql/bin:/usr/local/mysql/librootmysql-master # source /root/.bash_profile手动启动MySQL:/启动MySQL，不能停止rootmysql-master # cd /usr/local/mysql/rootmysql-master mysql# ./bin/mysqld_safe -user=mysql &/启动日志写在此文件下：/usr/local/mysql/data/ localhost.localdomain.err关闭MySQL:rootmysql-master mysql# mysqladmin -u root -p shutdown/这里MySQL的root用户还没有配置密码，所以为空值。8)将MySQL添加为系统服务并启动/复制 mysql.server 到/etc/init.d目录下,并重命名为mysqlrootmysql-master # cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqlrootmysql-master # chmod +x /etc/init.d/mysqlrootmysql-master # vi /etc/init.d/mysqlbasedir=/usr/local/mysql/添加系统服务rootmysql-master mysql# cd /etc/init.d/rootmysql-master init.d# chkconfig -add mysqlrootmysql-master init.d# chkconfig -level 345 mysql on通过服务 启动 & 关闭 测试rootmysql-master # service mysql startrootmysql-master # service mysql stop通过脚本启动MySQL：9)、修改MySQL的root用户的密码:rootmysql-master # mysql -uroot mysql mysql show databases;+-+| Database |+-+| information_schema | mysql | performance_schema | test |+-+4 rows in set (0.07 sec)mysqluse mysql;mysqldesc user;mysql update user set Password = password(123456) where User=root;mysql select Host,User,Password from user where User=root;+-+-+-+| Host | User | Password |+-+-+-+| localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | mysql-master | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | :1 | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |+-+-+-+4 rows in set (0.00 sec)/mysql 新设置用户或更改密码后需用flush privileges刷新MySQL的系统权/限相关表，否则会出现拒绝访问mysqlflush privileges; mysqlexitrootmysql-master # netstat -tnl | grep 3306/如果登陆不了MySQL:ERROR 1045 (28000): Access denied for user rootlocalhost (using password: NO)/如下照做：rootmysql-master # mysql -pERROR 1045 (28000): Access denied for user rootlocalhost (using password: YES)rootmysql-master # mysql -pOK!（别忘了flush privileges;）/*一些错误处理*/MySQL-Font 远程链接(个人喜好)/远程连接出错但服务器本机能启动数据库:SQL Error (2003):Cant connect to MySQL server on (1065)远程ping服务器端口 telnet ip 3306命令行出现：连接中。表示失败，原因是被服务器的防火墙拦截。处理方法:在服务器终端运行以下命令(服务器防火墙归0)rootmysql-master # iptables Frootmysql-master # iptables X/再次连接数据库服务器:出错: SQL Error (1130): Host IP is not allowed t