编译安装MySQL

编译环境

yum -y install gcc gcc-c++ make wget autoconf perl-Time-HiRes
yum install zlib libxml libjpeg freetype libpng gd curl libiconv zlib-devel libxml2-devel libjpeg-devel freetype-devel libpng-devel gd-devel curl-devel openssl openssl-devel libxslt-devel
wget -c http://www.cmake.org/files/v3.0/cmake-3.0.1.tar.gz
tar zxvf cmake-3.0.1.tar.gz && cd cmake-3.0.1
./configure && make && make install

安装MySQL

建立目录

mkdir -p /usr/local/mysql/data && cd /usr/local/mysql

创建mysql组

groupadd mysql

创建MySQL用户并且不让shell登录

useradd -g mysql mysql -s /sbin/nologin

修改mysql文件夹所属用户和组

chown -R mysql:mysql /usr/local/mysql

下载mysql

wget -c https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.42.tar.gz
这里还有一个5.7版本的路径https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.24.tar.gz

解压并且进入目录

tar -zxvf mysql-5.6.42.tar.gz && mv mysql-5.6.42 mysql && cd /usr/local/mysql/mysql

使用cmake编译

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql

编译并安装

make && make install

给执行权限

chmod -R 777 /usr/local/mysql/mysql/scripts/mysql_install_db

初始化MySQL

/usr/local/mysql/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=root
创建了mysql用户就把root换成mysql用户

编辑vi /usr/local/mysql/my.cnf

MySQL配置文件

[mysqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
log-error = /usr/local/mysql/mysql_error.log
pid-file = /usr/local/mysql/mysql.pid
user = mysql
tmpdir = /tmp

创建log文件

touch /usr/local/mysql/mysql_error.log

如果这个配置文件不在，则

cp support-files/my-medium.cnf /usr/local/mysql/my.cnf

启动mysql

/usr/local/mysql/bin/mysqld_safe --user=root &

建立软连接添加环境变量

ln -s /usr/local/mysql/bin/mysql /usr/bin
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
/etc/init.d/mysqld start

修改mysql表

登陆

mysql -u root

切换库

use mysql;

查询用户权限

select User,authentication_string,Host from user ;

修改密码和给权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' ;
set password for root@localhost = password('root');
select User,authentication_string,Host from user ;
exit

重启mysql

/etc/init.d/mysqld restart