Mysql5.5源码安装步骤笔记记录

1.cmake软件的安装
wget https://cmake.org/files/v3.5/cmake-3.5.0-rc3.tar.gz
tar xf cmake-3.5.0.tar.gz
cd cmake-3.5.0
./configure
gmake
gmake install

2.依赖包 ncurses-devel
yum install ncurses-devel
#apt-get install libncurses5-dev

3.创建用户和组
groupadd mysql
useradd mysql -s /sbin/nologin -M -g mysql

4.安装mysql
wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.48.tar.gz
tar zxf mysql-5.5.32.tar.gz
cd mysql-5.5.32

cmake . -CMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DSYSCONFDIR=/usr/local/mysql/etc \
-MYSQL_DATADIR=/usr/local/mysql/data \
-DMYSQL_UNIX_ADDR=/usr/local/mysql/tmp/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DENABLED_LOCAL_INFILE=ON \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITHOUT_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_EXAMPLE_STORAGE_ENGINE=1 \
-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \

-DWITH_FAST_MUTEXES=1 \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DWITH_DEBUG=0

5.编译安装
make && make install

6.获取配置文件
ll mysql-5.5.32/support-files/*.cnf
cp support-files/my-default.cnf /usr/local/mysql/etc/my.cnf

7.创建mysql数据库文件
mkdir -p /usr/local/mysql/data
chown -R mysql.mysql /usr/local/mysql/data
chmod -R 1777 /tmp
/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql

8.启动mysql数据库
/usr/local/mysql/bin/mysqld_safe --user=mysql &

9.检查mysql数据库是否启动
netstat -lnt|grep 3306

10.配置mysql命令全局使用路径
vi /etc/profile 在底部加入
export PATH="/usr/local/mysql/bin:$PATH"
# echo ‘export PATH="/usr/local/mysql/bin:$PATH"‘ >>/etc/profile
使其生效，执行下面命令：
source /etc/profile

11.启动和停止方式
cp mysql-5.5.32/support-files/mysql.server /etc/init.d/mysqld
chmod 700 /etc/init.d/mysqld
/etc/init.d/mysqld stop
这样就可以停止或启动mysql服务了

12.配置Mysql数据库开机启动
chkconfig --add mysqld
chkconfig mysqld on
chkconfig --list mysqld

13.为mysql中的root增加密码
mysqladmin -uroot password ‘root‘

14.清理多余的用户和不用的数据库
select USER,HOST from mysql.user;

delete from mysql.user where USER=‘‘;
delete from mysql.user where HOST=‘::1‘; # 这个是IPV6的，可以删除

+------+-----------+
| USER | HOST |
+------+-----------+
| root | 127.0.0.1 |
| root | localhost |
+------+-----------+

最后保留这样就可以了，到此mysql源码安装完毕

Mysql5.5源码安装步骤笔记记录

原文：http://www.cnblogs.com/ahwu/p/5227173.html