MYSQL安装及SQLAdvisor配置

1.MYSQL安装

1.yum install mysql mysql-server mysql-devel -y
2.chkconfig --list |grep mysql 
3.chkconfig mysqld on 
4.service mysqld start

2.初始化MYSQL密码

use mysql;
update user set password=password("123456") where user="root";
flush privileges;

3.SQLAdvisor安装配置

1.git clone https://github.com/Meituan-Dianping/SQLAdvisor.git
2.yum install cmake libaio-devel libffi-devel glib2 glib2-devel
3.yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
4.yum install --enablerepo=Percona56 Percona-Server-shared-56
5.yum install bison
6.cmake -DBUILD_CONFIG=mysql_release -DCMAKE_BUILD_TYPE=debug -DCMAKE_INSTALL_PREFIX=/usr/local/sqlparser ./
7.make && make install
8.cd sqladvisor/
9.cmake -DCMAKE_BUILD_TYPE=debug ./
10.cd /usr/lib64/   
11.ln -s libperconaserverclient_r.so.18 libperconaserverclient_r.so
12.make
参考官网总不会有错：https://github.com/Meituan-Dianping/SQLAdvisor