一、创建msql用户

#添加运行mysql的用户，禁止该用户登录系统[root@openstack-01~]#useraddmysql-s/sbin/nologin

二、创建相关目录

#创建目录[root@openstack-01~]#mkdir/data/mysql/mysql3306/{conf,data,logs,tmp}-p#修改目录权限[root@openstack-01~]#chown-Rmysql.mysql/data/mysql

三、创建配置文件

[root@openstack-01~]#cat/data/mysql/mysql3306/conf/mysql_3306.cnf#my.cnf[client]port=3306socket=/tmp/mysql3306.sock[mysql]prompt="\\u@\\h[\\d]>"#pager="less-i-n-S"#tee=/opt/mysql/query.logno-auto-rehash[mysqld]#miscuser=mysqlbasedir=/usr/local/mysqldatadir=/data/mysql/mysql3306/dataport=3306socket=/tmp/mysql3306.sockevent_scheduler=0tmpdir=/data/mysql/mysql3306/tmp#timeoutinteractive_timeout=300wait_timeout=300#charactersetcharacter-set-server=utf8open_files_limit=65535max_connections=100max_connect_errors=100000lower_case_table_names=1#symireplication#rpl_semi_sync_master_enabled=1#rpl_semi_sync_master_timeout=1000#1second#rpl_semi_sync_slave_enabled=1#logslog-output=fileslow_query_log=1slow_query_log_file=slow.loglog-error=error.loglog_warnings=2pid-file=mysql.pidlong_query_time=1#log-slow-admin-statements=1#log-queries-not-using-indexes=1log-slow-slave-statements=1#binlog#binlog_format=STATEMENTbinlog_format=rowserver-id=1003306log-bin=/data/mysql/mysql3306/logs/mysql-binmax_binlog_size=256Msync_binlog=0expire_logs_days=10#procedurelog_bin_trust_function_creators=1#gtid-mode=onenforce-gtid-consistency=1#relaylogskip_slave_start=1max_relay_log_size=128Mrelay_log_purge=1relay_log_recovery=1relay-log=relay-binrelay-log-index=relay-bin.indexlog_slave_updates#slave-skip-errors=1032,1053,1062#skip-grant-tables#buffers&cachetable_open_cache=2048table_definition_cache=2048table_open_cache=2048max_heap_table_size=96Msort_buffer_size=128Kjoin_buffer_size=128Kthread_cache_size=200query_cache_size=0query_cache_type=0query_cache_limit=256Kquery_cache_min_res_unit=512thread_stack=192Ktmp_table_size=96Mkey_buffer_size=8Mread_buffer_size=2Mread_rnd_buffer_size=16Mbulk_insert_buffer_size=32M#myisammyisam_sort_buffer_size=128Mmyisam_max_sort_file_size=10Gmyisam_repair_threads=1#innodbinnodb_buffer_pool_size=100Minnodb_buffer_pool_instances=1innodb_data_file_path=ibdata1:100M:autoextendinnodb_flush_log_at_trx_commit=2innodb_log_buffer_size=8Minnodb_log_file_size=100Minnodb_log_files_in_group=3innodb_max_dirty_pages_pct=50innodb_file_per_table=1innodb_rollback_on_timeoutinnodb_io_capacity=2000transaction_isolation=READ-COMMITTEDinnodb_flush_method=O_DIRECT

四、初始化mysql

#开始初始化[root@openstack-01~]#/usr/local/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld--defaults-file=/data/mysql/mysql3306/conf/mysql_3306.cnf--basedir=/usr/local/mysql-5.7.17-linux-glibc2.5-x86_64/--initialize#查看初始化后的结果[root@openstack-01~]#ll/data/mysql/mysql3306/data/total409648-rw-r-----1mysqlmysql56Jun1017:27auto.cnf-rw-r-----1mysqlmysql6236Jun1017:27error.log-rw-r-----1mysqlmysql413Jun1017:27ib_buffer_pool-rw-r-----1mysqlmysql104857600Jun1017:27ibdata1-rw-r-----1mysqlmysql104857600Jun1017:27ib_logfile0-rw-r-----1mysqlmysql104857600Jun1017:27ib_logfile1-rw-r-----1mysqlmysql104857600Jun1017:27ib_logfile2drwxr-x---2mysqlmysql4096Jun1017:27mysqldrwxr-x---2mysqlmysql8192Jun1017:27performance_schema-rw-r-----1mysqlmysql217Jun1017:27slow.logdrwxr-x---2mysqlmysql8192Jun1017:27sys#获取root用户密码[root@openstack-01~]#greppassword/data/mysql/mysql3306/data/error.log|awk'{print$11}'_:;II,r0I;oo

五、启动mysql

[root@openstack-01~]#/usr/local/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld--defaults-file=/data/mysql/mysql3306/conf/mysql_3306.cnf&[1]14632[root@openstack-01~]#psaux|grepmysql|grep-vgrepmysql146322.79.81067652184596pts/0Sl17:300:00/usr/local/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld--defaults-file=/data/mysql/mysql3306/conf/mysql_3306.cnf[root@openstack-01~]#ss-tnl|grep3306LISTEN070:::3306:::*#登录mysql[root@openstack-01~]#/usr/local/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysql-uroot-p-S/tmp/mysql3306.sockEnterpassword:#输入上文中获取到的密码WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis3Serverversion:5.7.17-logCopyright(c)2000,2016,Oracleand/oritsaffiliates.Allrightsreserved.OracleisaregisteredtrademarkofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.mysql>#修改root密码mysql>alteruser'root'@'localhost'identifiedby'123456';QueryOK,0rowsaffected(0.00sec)mysql>flushprivileges;QueryOK,0rowsaffected(0.00sec)#用新密码重新登录[root@openstack-01~]#/usr/local/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysql-uroot-p-S/tmp/mysql3306.sockEnterpassword:#输入新设置的密码，测试正常WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis4Serverversion:5.7.17-logMySQLCommunityServer(GPL)Copyright(c)2000,2016,Oracleand/oritsaffiliates.Allrightsreserved.OracleisaregisteredtrademarkofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.mysql>