1.解压MysqL
tar-xfMysqL-5.6.30-linux-glibc2.5-x86_64.tar.gz-C/usr/local mvMysqL-5.6.30-linux-glibc2.5-x86_64MysqL-5.6.30
groupaddMysqL useradd-gMysqLMysqL-s/sbin/nologin chown-RMysqL:MysqLMysqL-5.6.30
3.安装数据库
mkdir/usr/local/MysqL-5.6.30/data3306 cdMysqL-5.6.21/scripts ./MysqL_install_db--user=MysqL--basedir=/usr/local/MysqL-5.6.30/--datadir=/usr/local/MysqL-5.6.30/data3306/
4.配置文件
cd/usr/local/MysqL-5.6.30/support-files cpmy-default.cnf/etc/my.cnf cpMysqL.server/etc/init.d/MysqL vim/etc/init.d/MysqL
[MysqLd] port=3306 socket=/var/lib/MysqL/MysqL.sock max-connections=800 skip-name-resolve skip-external-locking key_buffer_size=384M max_allowed_packet=1073M table_open_cache=512 sort_buffer_size=512K read_buffer_size=512K read_rnd_buffer_size=512K join_buffer_size=128K myisam_sort_buffer_size=64M thread_cache_size=256 query_cache_size=0 query_cache_type=0 tmp_table_size=64M max_heap_table_size=64M basedir=/usr/local/MysqL-5.6.30/ datadir=/usr/local/MysqL-5.6.30/data3306 pid-file=/usr/local/MysqL-5.6.30/data3306/MysqL.pid log_error=/var/log/MysqLd.log #setbinaryloggingisrequiredforreplication log-bin=MysqL-bin binlog_cache_size=32M #event_schedulershutoffinMysqLdslave event_scheduler=1 binlog_format=row expire_logs_days=3 #setslowlog slow_query_log=1 long_query_time=2 #set字符 character_set_server=utf8 #set大小写敏感 lower_case_table_names=1 #setinnodbparams innodb_data_home_dir=/usr/local/MysqL-5.6.30/data3306 innodb_data_file_path=ibdata1:2000M;ibdata2:10M:autoextend innodb_log_group_home_dir=/usr/local/MysqL-5.6.30/data3306 innodb_buffer_pool_size=5972M innodb_additional_mem_pool_size=10M innodb_log_file_size=512M innodb_log_buffer_size=16M innodb_flush_log_at_trx_commit=2 innodb_flush_method=O_DIRECT innodb_file_per_table=1 innodb_lock_wait_timeout=10 [client] default-character-set=utf8
5.配置环境变量
vi/etc/profile exportMysqL_HOME="/usr/local/MysqL-5.6.30" exportPATH="$PATH:$MysqL_HOME/bin"
6.添加自启动服务
chkconfigMysqLon
7.启动MysqL
serviceMysqLstart
MysqLadmin-urootpassword'your_password'#修改root用户密码 MysqL-uroot-p#登录MysqL,需要输入密码原文链接：https://www.f2er.com/centos/381252.html
