本文共 2777 字,大约阅读时间需要 9 分钟。
首先把源码下载下来,上传后解压:
tar -zxvf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
这里我创建了一个目录,把解压的东西放到了/u01/mysql3306
如下:
这里有几个新创建的文件夹:
tmp,run,log,data,
随后创建一个文件夹:/etc/my.cnf
内容如下:
[client]port=3306socket=/u01/mysql3306/run/mysql.sock[mysql][mysqld]autocommit=1general_log=offexplicit_defaults_for_timestamp=true# systembasedir=/u01/mysql3306datadir=/u01/mysql3306/datamax_allowed_packet=1gmax_connections=3000max_user_connections=2800open_files_limit=65535port=3306server_id=101skip_name_resolve=ONsocket=/u01/mysql3306/run/mysql.socktmpdir=/u01/mysql3306/tmp#binloglog_bin=/u01/mysql3306/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/mysql3306/log/error.logslow_query_log_file=/u01/mysql3306/log/slow.loglog_queries_not_using_indexes=0slow_query_log=1log_slave_updates=ONlog_slow_admin_statements=1long_query_time=1#relayrelay_log=/u01/mysql3306/log/relaylogrelay_log_index=/u01/mysql3306/log/relay.indexrelay_log_info_file=/u01/mysql3306/log/relay-log.info#slaveslave_load_tmpdir=/u01/mysql3306/tmpslave_skip_errors=OFF#innodbinnodb_data_home_dir=/u01/mysql3306/log/ibloginnodb_log_group_home_dir=/u01/mysql3306/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#skip-grant-tables[mysqld_safe]datadir=/u01/mysql3306/data
添加系统用户
groupadd mysqluseradd -r -g mysql mysql
设置环境变量
vim /etc/profile
在末尾添加
export PATH=$PATH:/u01/mysql3306/bin
初始化mysqld
mysqld --initialize --user=mysql --basedir=/u01/mysql3306 --datadir=/u01/mysql3306/data/
设置开机启动
复制启动脚本到资源目录:
cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
增加 mysqld 服务控制脚本执行权限:
chmod +x /etc/rc.d/init.d/mysqld
将 mysqld 服务加入到系统服务
chkconfig --add mysqld
检查mysqld服务是否已经生效
chkconfig --list mysqld
这里如果出现问题记得查log下的error.log
随后启动关闭即可:
servcie mysqld startservcie mysqld stop
这里就搭建好了,但估计mysql登录不进去
放开上面的skip-grant-tables(my.cnf)然后重启mysql,再使用mysql -uroot -p进行登录
use mysql;update user set authentication_string=password('root') where user='root';
然后把my.cnf中的skip-grant-tables注释,在重启mysql。
即可用root登录了!就可以添加远程及其他用户了。
转载地址:http://inmif.baihongyu.com/