mysql 安装记录

一、安装编译工具及库文件

yum -y install gcc gcc-c++ make autoconf libtool-ltdl-devel gd-devel freetype-devel libxml2-devel libjpeg-devel libpng-devel openssl-devel curl-devel bison patch unzip libmcrypt-devel libmhash-devel ncurses-devel sudo bzip2 flex libaio-devel perl-Module-Install.noarch

二、 安装cmake 编译器

wget http://www.cmake.org/files/v3.1/cmake-3.1.1.tar.gz
2、解压安装包
tar zxvf cmake-3.1.1.tar.gz
3.进入安装包目录
cd cmake-3.1.1
4、编译安装
./bootstrap
make && make install

三、安装 MySQL
1、下载

wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.15.tar.gz

2、解压安装包
tar zxvf mysql-5.6.15.tar.gz
3、进入安装包目录

cd mysql-5.6.15

4、编译安装
cmake -DCMAKE_INSTALL_PREFIX=/home/work/soft/mysql/ -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_INNODB_MEMCACHED=1 -DWITH_DEBUG=OFF -DENABLED_PROFILING=ON -DMYSQL_MAINTAINER_MODE=OFF -DMYSQL_DATADIR=/home/work/soft/mysql/data -DMYSQL_TCP_PORT=3306

make && make install

MySQL 配置

1、创建mysql运行使用的用户mysql：
/usr/sbin/groupadd mysql
/usr/sbin/useradd -g mysql mysql

2、创建binlog存储路径并赋予mysql用户权限

mkdir -p /home/work/soft/mysql/binlog/mysql-binlog
chown mysql.mysql /home/work/soft/mysql/binlog/mysql-binlog/
3、授权用户
chown -R mysql:mysql /home/work/soft/mysql/

4创建my.cnf配置文件
cp support-files/my-default.cnf /etc/my.cnf

5.初始化数据库

/home/work/soft/mysql/scripts/mysql_install_db —user=mysql

6.设置环境变量
cd support-files/
cp mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig —add mysqld
chkconfig mysqld on

7启动

service mysqld start

service mysqld status#查看运行状态

8修改密码

mysql> use mysql;
mysql> update user set password=password(“你的新密码”) where user=“root”;
mysql> flush privileges;
mysql> exit;

9:权限添加

1、use mysql;
2、GRANT ALL ON . to root@’00.00.160.%’ IDENTIFIED BY ‘密码’;
3、FLUSH PRIVILEGES;