数据库|mysql教程
下编,实战,源码
数据库-mysql教程
A、关闭防火墙
c 开发网站源码分享,ubuntu与主机复制,怎么看tomcat浏览器,爬虫技术抓取价格,php网站建设的四个步骤,南京seo代理lzw
chkconfig iptables off service iptables stop
java整站源码,vscode c语言环境,ubuntu字体好看,tomcat 8 api,sqlite正确的去重方法,爬虫技术是怎么做的图片,php 股票交易,吴川seo优化排名软件,手机网站模板 html5 下载,php视频课程网站模板lzw
C、删除MyQL(redhat6.3服务器自带的mysql-libs是mysql-libs-5.1.61-4.el6.x86_64,可能会和高版本的mysql-libs有冲突)
易乐圈源码,vscode的设置面板,ubuntu查看3264,tomcat个端口作用,python爬虫起家,php网络开发详解,咸宁房产seo推广开户,商城网站html模板,dede 培训 模板lzw
groupadd mysql #增加用户组useradd -d /home/mysql -g mysql mysql
<br -="" br="" p="" path="$PATH:$HOME/bin:/u01/my3306/bin
H、创建目录及授权
mkdir -p /u01/my3306/datamkdir -p /u01/my3306/log/iblogmkdir -p /u01/my3306/log/binlogmkdir -p /u01/my3306/log/relaylogmkdir -p /u01/my3306/runmkdir -p /u01/my3306/tmpchown -R mysql:mysql /u01/my3306chmod -R 777 /u01/my3306
K、编译并安装
cmake \-DCMAKE_INSTALL_PREFIX=/u01/my3306 \-DINSTALL_DATADIR=/u01/my3306/data \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DEXTRA_CHARSETS=all \-DWITH_SSL=yes \-DWITH_EMBEDDED_SERVER=1 \-DENABLED_LOCAL_INFILE=1 \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_ARCHIVE_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \-DWITH_FEDERATED_STORAGE_ENGINE=1 \-DWITH_PARTITION_STORAGE_ENGINE=1 \-DMYSQL_UNIX_ADDR=/u01/my3306/run/mysql.sock \-DMYSQL_TCP_PORT=3306 \-DENABLED_LOCAL_INFILE=1 \-DSYSCONFDIR=/etc \-DWITH_READLINE=onmakemake install
[client]port=3306socket=/u01/my3306/mysql.sock[mysql]pid_file=/u01/my3306/run/mysqld.pid[mysqld]# disable autocommitautocommit=0general_log=offexplicit_defaults_for_timestamp=truesha256_password_private_key_path=/u01/my3306/mykey.pemsha256_password_public_key_path=/u01/my3306/mykey.pub# systembasedir=/u01/my3306datadir=/u01/my3306/datamax_allowed_packet=134217728max_connections=8192max_user_connections=8000open_files_limit=65535pid_file=/u01/my3306/run/mysqld.pidport=3306server_id=101skip_name_resolve=ONsocket=/u01/my3306/run/mysql.socktmpdir=/u01/my3306/tmp#binlog#log-bin=/u01/my3306/log/binloglog_bin=/u01/my3306/log/binlog/binlogbinlog_cache_size=32768binlog_format=rowexpire_logs_days=7log_slave_updates=ONmax_binlog_cache_size=2147483648max_binlog_size=524288000sync_binlog=100#logginglog_error=/u01/my3306/log/alert.logslow_query_log_file=/u01/my3306/log/slow.loglog_queries_not_using_indexes=1slow_query_log=1log_slave_updates=ONlog_slow_admin_statements=1long_query_time=1#relayrelay_log=/u01/my3306/log/relaylogrelay_log_index=/u01/my3306/log/relay.indexrelay_log_info_file=/u01/my3306/log/relay-log.info#slaveslave_load_tmpdir=/u01/my3306/tmpslave_skip_errors=OFF#innodbinnodb_data_home_dir=/u01/my3306/log/ibloginnodb_log_group_home_dir=/u01/my3306/log/ibloginnodb_adaptive_flushing=ONinnodb_adaptive_hash_index=ONinnodb_autoinc_lock_mode=1innodb_buffer_pool_instances=8#defaultinnodb_change_buffering=insertsinnodb_checksums=ONinnodb_buffer_pool_size= 128Minnodb_data_file_path=ibdata1:32M;ibdata2:16M:autoextendinnodb_doublewrite=ONinnodb_file_format=Barracudainnodb_file_per_table=ONinnodb_flush_log_at_trx_commit=1innodb_flush_method=O_DIRECTinnodb_io_capacity=1000innodb_lock_wait_timeout=10innodb_log_buffer_size=67108864innodb_log_file_size=1048576000innodb_log_files_in_group=4innodb_max_dirty_pages_pct=60innodb_open_files=60000innodb_purge_threads=1innodb_read_io_threads=4innodb_stats_on_metadata=OFFinnodb_support_xa=ONinnodb_use_native_aio=OFFinnodb_write_io_threads=10[mysqld_safe]datadir=/u01/my3306/data
rm -rf /u01/my3306/data/*rm -rf /u01/my3306/log/iblog/*rm -rf /u01/my3306/log/binlog/*chmod -R 777 /u01/my3306/data/chmod -R 777 /u01/my3306/log/iblog/chmod -R 777 /u01/my3306/log/binlog/chmod 755 /u01/my3306/f./scripts/mysql_install_db --defaults-file=/u01/my3306/f --datadir=/u01/my3306/data --user=mysqlchmod -R 777 /u01/my3306/data/chmod -R 777 /u01/my3306/log/iblog/chmod -R 777 /u01/my3306/log/binlog/
说明:defaults-file表示指定默认的配置文件,如果不指定,系统默认的优先级是先使用/etc/f作为mysql的配置文件,那之前make的那些参数就白设置了.
十C、启动mysql
vi .bash_profile ---root用户下添加PATH=$PATH:$HOME/bin:/u01/my3306/binmysqld_safe --defaults-file=/u01/my3306/f --user=mysql &
[root@uubee8 ~]# mysql -h127.0.0.1 -urootWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.6.23-log Source distributionCopyright (c) 2000, , Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type help; or \h for help. Type \c to clear the current input statement.mysql> show variables like \%log-bin%;Empty set (0.00 sec)mysql> show variables like \%bin%;+-----------------------------------------+------------------------------+| Variable_name | Value |+-----------------------------------------+------------------------------+| bind_address | * || binlog_cache_size | 32768 || binlog_checksum | CRC32 || binlog_direct_non_transactional_updates | OFF|| binlog_error_action| IGNORE_ERROR || binlog_format | ROW|| binlog_gtid_simple_recovery | OFF|| binlog_max_flush_queue_time | 0 || binlog_order_commits | ON || binlog_row_image | FULL || binlog_rows_query_log_events | OFF|| binlog_stmt_cache_size | 32768 || binlogging_impossible_mode | IGNORE_ERROR || innodb_api_enable_binlog| OFF|| innodb_locks_unsafe_for_binlog| OFF|| log_bin | ON || log_bin_basename | /u01/my3306/log/binlog || log_bin_index | /u01/my3306/log/binlog.index || log_bin_trust_function_creators | OFF|| log_bin_use_v1_row_events| OFF|| max_binlog_cache_size | 2147483648 || max_binlog_size | 524288000 || max_binlog_stmt_cache_size | 18446744073709547520 || simplified_binlog_gtid_recovery | OFF|| sql_log_bin | ON || sync_binlog | 100|+-----------------------------------------+------------------------------+26 rows in set (0.00 sec)
##################################################################################################################################
1.初始化MySQL脚本:sh init3306.shrm -rf /u01/my3306/data/*rm -rf /u01/my3306/log/iblog/*rm -rf /u01/my3306/log/binlog/*chmod -R 777 /u01/my3306/data/chmod -R 777 /u01/my3306/log/iblog/chmod -R 777 /u01/my3306/log/binlog/chmod 755 /u01/my3306/f./scripts/mysql_install_db --defaults-file=/u01/my3306/f --datadir=/u01/my3306/data --user=mysqlchmod -R 777 /u01/my3306/data/chmod -R 777 /u01/my3306/log/iblog/chmod -R 777 /u01/my3306/log/binlog/2.启动MySQL脚本sh start3306.shmysqld_safe --defaults-file=/u01/my3306/f --user=mysql &3.登录MySQL脚本sh logon3306.shmysql -h127.0.0.1 -uroot