centos6 mysql5.6 编译安装

安装依赖包：

#yum install gcc gcc-c++ ncurses-devel perl cmake

添加mysql组

#groupadd mysql

添加mysql用户，不可用于登录

#useradd mysql -g mysql -s /sbin/nologin

#cd /data/tools

下载源码：

#wget http://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.43.tar.gz

#tar -zxvf mysql-5.6.43.tar.gz

#cd mysql-5.6.12

#cmake -DCMAKE_INSTALL_PREFIX=/data/soft/mysql -DMYSQL_UNIX_ADDR=/data/soft/mysql/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DMYSQL_DATADIR=/data/soft/mysql/data -DMYSQL_TCP_PORT=3306 -DSYSCONFDIR=/data/soft/mysql/ -DENABLE_DOWNLOADS=1

 

#make

#make install

#chown mysql:mysql /data/soft/mysql -R

#cd /data/soft/mysql

#./scripts/mysql_install_db --user=mysql --datadir=/data/soft/mysql/data

修改默认配置文件（先备份）

#vim my.cnf

[mysqld_safe] log-error=/data/soft/mysql/mysql.log pid-file=/data/soft/mysql/mysql.pid [mysqld] datadir = /data/soft/mysql/data innodb_file_per_table = 1 log-bin = mysql-bin log-bin-index = matser-bin.index binlog_format = row skip-name-resolve pid-file = /data/soft/mysql/mysql.pid socket = /data/soft/mysql/mysql.sock server_id = 1 log-slave-updates=true gtid-mode=on enforce-gtid-consistency=true master-info-repository=TABLE relay-log-info-repository=TABLE sync-master-info=1 slave-parallel-workers=2 binlog-checksum=CRC32 master-verify-checksum=1 slave-sql-verify-checksum=1 binlog-rows-query-log-events=1 port=3306 max_connections=2500 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES expire_logs_days = 32

#cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld #把Mysql加入系统启动

#chmod 755 /etc/init.d/mysqld #增加执行权限

#chkconfig mysqld on #加入开机启动

#vi /etc/rc.d/init.d/mysqld #编辑

basedir=/data/soft/mysql #MySQL程序安装路径 datadir=/data/soft/mysql/data#MySQl数据库存放目录

:wq! #保存退出

#service mysqld start #启动

#vi /etc/profile #把mysql服务加入系统环境变量：在最后添加下面这一行

PATH=/data/soft/mysql/bin:/data/soft/mysql/lib:$PATH export PATH

:wq! #保存退出

#source /etc/profile #使配置立刻生效.

初次安装mysql是root账户是没有密码的

设置密码的方法

# mysql 

mysql> set password for 'root'@'localhost' = password('123456');

mysql> exit

 

添加新的mysql登录用户并授权(all:所有权限,%:不限制ip)

grant all on *.* to 'newuser'@'%' identified by 'password';