The required source code package:
/usr/local/src/mysql-5.5.25/cmake-2.8.8.tar.gz
/usr/local/src/mysql-5.5.25/mysql-5.5.25.tar.gz
1, installation CMake
MySQL has been removed from version 5.5, and is replaced by the CMake tool./configure.
Therefore, we first need to compile and install the CMake tool in the system source code.
#编译安装
1 |
cd /usr/ local /src/MySQL-5.5.25/cmake-2.8.8 |
2, compile and install the configuration MySQL
#切换至MySQL source extract directory
1 |
cd /usr/ local /src/MySQL-5.5.25/mysql-5.5.25 |
#创建所需目录
1 |
mkdir -pv /usr/ local /mysql/data |
#创建mysql用户和mysql组
2 |
useradd -g mysql -s /usr/sbin/nologin mysql |
#cmake编译
1 |
cmake -DCMAKE_INSTALL_PREFIX=/usr/ local /mysql -DMYSQL_DATADIR=/usr/ local /mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_unicode_ci -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_DEBUG=0 |
#安装
#复制配置文件
1 |
cp ./support-files/my-medium.cnf /etc/my.cnf |
#设置权限
1 |
chmod +x /usr/ local /mysql |
2 |
chown -R mysql:mysql /usr/ local /mysql |
3 |
chown -R mysql:mysql /usr/ local /mysql/data |
#配置开机自动启动
1 |
cp ./support-files/mysql.server /etc/init.d/mysqld |
2 |
chmod +x /etc/init.d/mysqld |
4 |
chkconfig --level 2345 mysqld on |
5 |
chkconfig --list mysqld #查看是否已应用上 |
#添加MySQL的软链接以适应init脚本
1 |
ln -sv /usr/ local /mysql/bin/mysql /usr/sbin/mysql |
2 |
ln -sv /usr/ local /mysql/bin/mysqladmin /usr/sbin/mysqladmin |
3 |
ln -sv /usr/ local /mysql/bin/mysqldump /usr/sbin/mysqldump |
#修改配置文件
add #在 the [mysqld] node:
1 |
datadir = /usr/ local /mysql/data |
2 |
log-error = /usr/ local /mysql/data/error.log |
3 |
pid- file = /usr/ local /mysql/data/mysql.pid |
#保存退出
#初始化数据库
1 |
/usr/ local /mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/ local /mysql --datadir=/usr/ local /mysql/data |
#修改root密码
1 |
/usr/ local /mysql/bin/mysqladmin -u root -p password "123456" |
Configure the firewall to turn on port 3306
1 |
vim /etc/sysconfig/iptables |
#添加如下规则到22 Ports under this rule, you can
1 |
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT |
#重启防火墙
1 |
/etc/init.d/iptables restart # 或 service iptables restart |
Start MySQL
1 |
service mysqld start # 或 /etc/init.d/mysqld start |
Test if MySQL is started
#查看是否有mysql进程
#查看是否有mysql端口
1 |
netstat -ntlp | grep 3306 |
#测试mysql, whether the mysqladmin,mysqldump command will work properly
#读取MySQL的版本信息
To this MySQL compilation installation is complete.
MySQL5.5 Previous versions (such as mysql5.1.x) . The/configure compilation reference is as follows:
1 |
./configure --prefix=/usr/ local /mysql/ --localstatedir=/usr/ local /mysql/data --without-debug --with-unix-socket-path=/tmp/mysql.sock --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static -- enable -assembler --with-extra-charsets=gbk,gb2312,utf8 --with-pthread |
Extended reading:
centos6.x Compile and install lamp (1): Ready to work
centos6.x Compile and install lamp (2): Compile and install Apache2.2.25
centos6.x Compile and install lamp (2): Compile and install Apache2.4.6
centos6.x Compile and install lamp (3): Compile and install MySQL5.5.25
centos6.x Compile and install lamp (4): Compile and install PHP5.2.17
centos6.x Compile and install lamp (4): Compile and install PHP5.3.27
PHP5 do not recompile, how do I install a self-installed extension, such as a SOAP extension?
Related logs:
In CentOS5.5, compile and install mysql-5.5.32.tar.gz times wrong: ' ssl_op_no_compression ' is not declared (first used within this function)
Linux, how to install Pdo_mysql extensions to PHP
centos6.x Compile and install lamp (1): Ready to work
centos6.x Compile and install lamp (2): Compile and install Apache2.2.25
centos6.x Compile and install lamp (2): Compile and install Apache2.4.6
centos6.x Compile and install lamp (4): Compile and install PHP5.2.17
Lamp One-click installation package-centos 5/6 automatically compile and install Apache, MySQL, PHP
centos6.x Compile and install lamp (4): Compile and install PHP5.3.27
CentOS compile install Apache 2.4.x times wrong: configure:error:Bundled APR requested but not found at./srclib/. Download and unpack the corresponding APR and Apr-util packages to./srclib/.
PHP5 do not recompile, how do I install a self-installed extension, such as a SOAP extension?
centos6.x Compile and install lamp (3): Compile and install MySQL5.5.25