Linux下SOURCE源码安装mysql5.5

Linux下SOURCE源码安装mysql5.5

操作系统：centos6.6 mysql版本:5.5.44

安装必要的包
[root@mysql01 ~]# yum install gcc-c++
[root@mysql01 ~]# yum install libaio
[root@mysql01 ~]# yum install ncurses-devel
[root@mysql01 ~]# yum install bison
添加组和用户
[root@mysql01 ~]# groupadd mysql
[root@mysql01 ~]# useradd -r -g mysql mysql
添加目录
[root@mysql01 ~]# mkdir -p /usr/local/mysql
[root@mysql01 ~]# mkdir -p /usr/local/mysql/data
安装cmake
[root@mysql01 soft]# tar -zxvf cmake-3.3.0-rc4.tar.gz
[root@mysql01 cmake-3.3.0-rc4]# ./configure
[root@mysql01 cmake-3.3.0-rc4]# make
[root@mysql01 cmake-3.3.0-rc4]# make install
安装mysql
[root@mysql01 soft]# tar -zxvf mysql-5.5.44.tar.gz
[root@mysql01 soft]# cd mysql-5.5.44
[root@mysql01 mysql-5.5.44]# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all
[root@mysql01 mysql-5.5.44]# make
[root@mysql01 mysql-5.5.44]# make install
设置目录权限
[root@mysql01 mysql-5.5.44]# cd /usr/local/mysql/
[root@mysql01 mysql]# chown -R root:mysql .
[root@mysql01 mysql]# chown -R mysql:mysql data
添加参数文件
[root@mysql01 mysql]# cp support-files/my-medium.cnf /etc/my.cnf
创建系统数据库表
[root@mysql01 mysql]# scripts/mysql_install_db –user=mysql

环境变量：
[root@mysql01 ~]# vi .bash_profile
PATH=$PATH:$HOME/bin:/usr/local/mysql/bin:/usr/local/mysql/lib
添加mysql到服务：
[root@mysql01 ~]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
原始启停
[root@mysql01 mysql]# ./bin/mysqld_safe –user=mysql &
[root@mysql01 mysql]# mysqladmin -u root -p shutdown
添加服务后：
[root@mysql01 ~]# service mysql restart
修改mysql的root用户的密码以及打开远程连接
[root@mysql01 ~]# service mysql start
Starting MySQL.. [ OK ]
[root@mysql01 ~]# mysql -u root mysql
mysql> use mysql;
mysql> grant all privileges on . to root@”%” identified by “root”;
mysql> update user set Password=password(‘tan’) where user=’root’;
mysql> select host,user,password from user where user=’root’;
mysql> flush privileges;