[MySQL] Linux下MySQL-5.6源码安装(二)
odb plugin
#innodb
default-storage-engine = INNODB
innodb_flush_method = O_DIRECT
innodb_file_per_table = 1
innodb_open_files=60000
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 100
innodb_additional_mem_pool_size = 20M
innodb_buffer_pool_size = 16G
innodb_log_buffer_size= 400M
innodb_log_file_size = 100M
innodb_log_files_in_group = 4
innodb_file_io_threads = 4
innodb_thread_concurrency = 16
innodb_max_dirty_pages_pct = 50
transaction-isolation = READ-COMMITTED
innodb_data_file_path = ibdata1:10G;ibdata2:5G:autoextend
innodb_buffer_pool_instances=4
innodb_thread_concurrency=32
### Server id ####
log_bin_trust_function_creators=1
read_only=0
server_id=5
8）创建
数据库
[plain]
cd /opt/
mysql
./scripts/mysql_install_db --user=mysql
上述建库语句将根据my.cnf里设置的数据文件目录和日志文件目录，生成相应的数据文件和日志文件，并创建
系统数据库（如mysql,test,information_schema,performance_schema)
9）设置root密码，创建只读账号
[plain]
export PATH=$PATH:/opt/mysql/bin
mysqladmin -u root password '***'
mysql -uroot -p
root@(none) 06:08:34>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '***' WITH GRANT OPTION;
root@(none) 06:08:44>GRANT SELECT ON *.* TO 'rnd'@'%' IDENTIFIED BY '***';
10）最后，把MySQL加入系统启动项和开机启动
[plain]
cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld #把Mysql加入系统启动
chmod 755 /etc/init.d/mysqld #增加执行权限
chkconfig mysqld on #加入开机启动
这样，执行service mysqld start即可启动MySQL了：）。