MySQL学习日记1入门-安装MySQL

最新推荐文章于 2025-07-08 15:27:02 发布

原创最新推荐文章于 2025-07-08 15:27:02 发布 · 239 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MySQL

MySQL学习笔记专栏收录该内容

3 篇文章

订阅专栏

本文详细介绍如何在CentOS 6.5环境下从源码编译安装MySQL 5.5.22及更新版本5.6.26的过程, 包括依赖安装、配置文件调整、初始化数据库及启动服务等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

编译安装MySQL5.5.22

在Centos6.5中实现

1. yum -y install ncurses-devel
2. tar zxf cmake-2.8.6.tar.gz 
3. cd cmake-2.8.6
4. ./configure && gmake && gmake install
5. tar zxf /usr/local/src/mysql-5.5.22.tar.gz
6. cd /usr/local/src/mysql-5.5.22
7. cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DSYSCONFDIR=/etc/ -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all && make && make install

优化调整

1. cp support-files/my-medium.cnf /etc/my.cnf 
2. cp support-files/mysql.server /etc/init.d/mysqld
3. chmod +x /etc/init.d/mysqld 
4. chkconfig --add mysqld
5. chkconfig mysqld on
6. echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
7. . /etc/profile

初始化数据库

1. groupadd mysql
2. useradd -M -s /sbin/nologin -g mysql mysql
3. chown -R mysql:mysql /usr/local/mysql
4. /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

启动MySQL服务

service mysqld start

5.6.26版本

[root@localhost ~]# yum remove -y mysql mysql-devel mysql-server
[root@localhost ~]# cd /usr/local/src/
[root@localhost src]# tar xvf mysql-5.6.26.tar.gz
[root@localhost src]# cd mysql-5.6.26
[root@localhost mysql-5.6.26]# useradd -u 8003 -M -s /sbin/nologin mysql
[root@localhost mysql-5.6.26]# yum -y install ncurses-devel cmake
[root@localhost mysql-5.6.26]#cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_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_USER=mysql
[root@localhost mysql-5.6.26]# make && make install
[root@localhost mysql-5.6.26]# chown -R mysql:mysql /usr/local/mysql/
[root@localhost mysql-5.6.26]# cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
[root@localhost mysql-5.6.26]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@localhost mysql-5.6.26]# cd
[root@localhost ~]# vim /etc/init.d/mysqld
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
[root@localhost ~]# chkconfig mysqld on
[root@localhost ~]# /usr/local/mysql/scripts/mysql_install_db
–defaults-file=/etc/my.cnf
–basedir=/usr/local/mysql
–datadir=/usr/local/mysql/data –user=mysql
[root@localhost ~]# service mysqld start
[root@localhost ~]# ln -s /usr/local/mysql/bin/* /usr/bin/