1 本地下载，用rz操作导到/usr/local/
我的版本是mysql5.6.19
2 安装cmake yum install cmake
3 安装需要用到的二个插件
ncurses
ncurses-devel
yum install ncurses ncurses-devel
4 创建mysql需要用到的组和用户
groupadd mysql
useradd -g mysql mysql
5 到对应的目录下面
cd /usr/local/
tar zxvf mysql-5.6.19
cd mysql-5.6.19
6 cmake命令安装
cmake命令：注意：路径要对应自己的目录
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1 -DMYSQL_TCP_PORT=3306 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_DEBUG=0
如果出现
CMake Error: The source directory "/opt/mysql-5.7.3-m13-linux-glibc2.5-x86_64" does not appear to contain CMakeLists.txt.
把路径再确认下。
出现如下结果说明成功了。
-- Running cmake version 2.6.4
-- MySQL 5.6.19
-- Packaging as: mysql-5.6.19-Linux-x86_64
-- HAVE_VISIBILITY_HIDDEN
-- HAVE_VISIBILITY_HIDDEN
-- HAVE_VISIBILITY_HIDDEN
-- Using cmake version 2.6.4
-- Not building NDB
-- Library mysqlclient depends on OSLIBS -lpthread;m;rt;dl
Warning: Bison executable not found in PATH
-- Library mysqlserver depends on OSLIBS -lpthread;m;rt;crypt;dl
-- Configuring done
-- Generating done
-- Build files have been written to: /usr/local/mysql
6 make
7 make install
8 vim /etc/my.cnf 编辑下mysql配置文件
写入当前安装的地址
9 cd /usr/local/mysql
./scripts/mysql_install_db --user=mysql
遇到一个问题 这个mysql_install_db没有执行权限
chmod a+x scripts/mysql_install_db
然后再次执行
出现如下提示就成功了
PLEASE REMEMBER TO
SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password ‘new-password‘
./bin/mysqladmin -u root -h localhost.localdomain password ‘new-password‘
Alternatively you can run:
./bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &
如果报错：
查看日志
Table ‘mysql.plugin‘ doesn‘t exist
这个是找不到数据文件，原因是我当时配置数据文件的时候写错了。
解决方法：
Vim /etc/my.cnf 把配置路径写对了。
10 ../bin/mysqld_safe&
启动
11 把启动脚本放到/etc/init.d/mysql那 方便管理
mv support-files/mysql.server /etc/init.d/mysql
同时加上执行权限 chmod a+x /etc/init.d/mysql
12 service mysql restart
如果遇到报pid错，查看配置是否正确
vim /etc/init.d/mysql
添加pid的路径
我的是
mysqld_pid_file_path=/var/run/mysqld/mysqld.pid
13 设置开机启动
查看是否有mysql
chkconfig list | grep mysql
添加mysql
chkconfig --add mysql
设置on
chkconfig --level 3 mysql
最后remove安装包
Rm –rf /usr/local/mysql5.6.19