linux装mysql源码

[root@ db84 ~]# wget -c http://www.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.25.tar.gz/from/http://cdn.mysql.com/
[root@ db84 ~]# mv index.html mysql-5.6.25.tar.gz
[root@ db84 ~]# tar zxvf mysql-5.6.25.tar.gz
[root@ db84 ~]# cd mysql-5.6.25
[root@ db84 ~]# mkdir -p /Java/databases
[root@ db84 ~]# useradd mysql -d /Java/databases/mysql/
[root@ db84 ~]# yum -y install cmake ncurses-devel gcc gcc-c++ bison


[root@ db84 mysql-5.6.25]#cmake -DCMAKE_INSTALL_PREFIX=/Java/databases/mysql \
-DSYSCONFDIR=/Java/databases/mysql/etc \
-DMYSQL_DATADIR=/Java/databases/mysql/data \
-DMYSQL_TCP_PORT=3306 \
-DMYSQL_UNIX_ADDR=/Java/databases/mysql/run/mysqld.sock \
-DMYSQL_USER=mysql \
-DEXTRA_CHARSETS=all \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1




[root@ db84 mysql-5.6.25] #make
[root@ db84 mysql-5.6.25] #make install
[root@ db84 mysql-5.6.25] #mkdir -p /Java/databases/mysql/{etc,data,tmp,run,binlogs,log}
[root@ db84 mysql-5.6.25] #chown mysql:mysql -R /Java/databases/mysql/




[root@ db84 mysql-5.6.25]#vi /Java/databases/mysql/etc/my.cnf


[mysqld]
# basic settings
datadir = /Java/databases/mysql/data
tmpdir = /Java/databases/mysql/tmp
socket = /Java/databases/mysql/run/mysqld.sock
port = 3306
pid-file = /Java/databases/mysql/run/mysqld.pid
skip-external-locking
max_allowed_packet = 16M
# innodb settings
default-storage-engine = INNODB
binlog_format = ROW
innodb_file_per_table = 1
log-bin = /Java/databases/mysql/binlogs/bin-log-mysqld
log-bin-index = /Java/databases/mysql/binlogs/bin-log-mysqld.index
innodb_data_home_dir = /Java/databases/mysql/data
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /Java/databases/mysql/data
# relay log settings
relay-log = /Java/databases/mysql/log/relay-log-mysqld
relay-log-index = /Java/databases/mysql/log/relay-log-mysqld.index
# increase the max connections
max_connections = 200
# the expiration time for logs, including binlogs
expire_logs_days = 7
# set the character as utf8
character-set-server = utf8
collation-server = utf8_unicode_ci
# server id
server-id=33061
# other settings
[mysqld_safe]
log-error = /Java/databases/mysql/log/mysqld.log
pid-file = /Java/databases/mysql/run/mysqld.pid
open-files-limit = 8192
[mysqlhotcopy]
interactive-timeout
[client]
port = 3306
socket = /Java/databases/mysql/run/mysqld.sock
default-character-set = utf8






[root@ db84 mysql-5.6.25]#chmod +x scripts/mysql_install_db
[root@ db84 mysql-5.6.25]#scripts/mysql_install_db \
--user=mysql --basedir=/Java/databases/mysql \
--datadir=/Java/databases/mysql/data/ \
--defaults-file=/Java/databases/mysql/etc/my.cnf






[root@ db84 mysql-5.6.25]# cp /Java/databases/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@ db84 mysql-5.6.25]# chmod 755 /etc/init.d/mysqld
[root@ db84 mysql-5.6.25]# chkconfig --add mysqld
[root@ db84 mysql-5.6.25]# chkconfig --level 35 mysqld on
[root@ db84 mysql-5.6.25]# chkconfig --list | grep mysqld
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
[root@ db84 mysql-5.6.25]#echo "PATH=$PATH:/Java/databases/mysql/bin" >>/etc/profile
[root@ db84 mysql-5.6.25]# source /etc/profile




[root@ db84 mysql-5.6.25]# vi /etc/init.d/mysqld
修改”basedir”,”datadir”的路径如下：
basedir=/Java/databases/mysql/
datadir=/Java/databases/mysql/data/
[root@ db84 mysql-5.6.25]# /etc/init.d/mysqld start
Starting MySQL. [ OK ]
[root@ db84 mysql-5.6.25]# netstat -tunlp | grep :3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 5904/mysqld




设置root密码
  # mysqladmin -u root password '1234567'


登陆账号
  # mysql -uroot -p1234567


#mysql指令下
grant all privileges on *.* to 'root'@'%'identified by '1234567';
flush privileges;