linux centos mysql5.7.18 安装教程 Linux CentOS MySQL 5.7.18 5.7.X安装教程
Star-Guo 人气:2想了解Linux CentOS MySQL 5.7.18 5.7.X安装教程的相关内容吗,Star-Guo在本文为您仔细讲解linux centos mysql5.7.18 安装教程的相关知识和一些Code实例,欢迎阅读和指正,我们先划重点:linux,centos,mysql5.7.18,下面大家一起来学习吧。
废话不多说了,直接给大家贴代码了,具体代码如下所示:
#安装依赖包 yum search libaio # search for info yum install libaio # install library #新建用户组合用户 groupadd mysql useradd mysql -g mysql #解压到data下面 tar -zxvf /data/software/mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz -C /data #重命名 mv mysql-5.7.18-linux-glibc2.5-x86_64/ mysql #安装 cd mysql/ mkdir data 更改所有者 cd ../ chown -R mysql:mysql mysql/ #授权755 chmod -R 755 mysql/ cd mysql ./bin/mysqld --user=mysql --basedir=/data/mysql --datadir=/data/mysql/data --initialize #注意最下面的密码 2017-04-21T02:36:14.351072Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-04-21T02:36:15.174993Z 0 [Warning] InnoDB: New log files created, LSN=45790 2017-04-21T02:36:15.331692Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-04-21T02:36:15.608132Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 4ab0413b-263b-11e7-9795-8e59748c97ed. 2017-04-21T02:36:15.615879Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2017-04-21T02:36:15.620346Z 1 [Note] A temporary password is generated for root@localhost: o*s#gqh)F4Ck #先简单测试一下
执行 ./support-files/mysql.server start
如果提示下面错误
./support-files/mysql.server: line 239: my_print_defaults: command not found ./support-files/mysql.server: line 259: cd: /usr/local/mysql: No such file or directory Starting MySQL ERROR! Couldn't find MySQL server (/usr/local/mysql/bin/mysqld_safe)
那就正常了,哈哈
1.cp support-files/mysql.server /etc/init.d/mysqld
2.chmod 755 /etc/init.d/mysqld
3.vi /etc/init.d/mysqld
将66-73行/usr/local/修改为/data/
修改前
then basedir=/usr/local/mysql bindir=/usr/local/mysql/bin if test -z "$datadir" then datadir=/usr/local/mysql/data fi sbindir=/usr/local/mysql/bin libexecdir=/usr/local/mysql/bin else
修改后,根据你的实际目录修改
then basedir=/data/mysql bindir=/data/mysql/bin if test -z "$datadir" then datadir=/data/mysql/data fi sbindir=/data/mysql/bin libexecdir=/data/mysql/bin else
service mysqld start
如果提示Starting MySQL.Logging to '/data/mysql/data/MyServer.err'.
不管它就行,以后重启就不会提示了
接下来来配置my.cnf
先清理一下内存
sync echo 3 > /proc/sys/vm/drop_caches 下面是my.cnf的具体配置 [client] no-beep socket =/data/mysql/mysql.sock # pipe # socket=0.0 port=3306 [mysql] default-character-set=utf8 [mysqld] basedir=/data/mysql datadir=/data/mysql/data port=3306 pid-file=/data/mysql/mysqld.pid #skip-grant-tables skip-name-resolve socket = /data/mysql/mysql.sock character-set-server=utf8 default-storage-engine=INNODB explicit_defaults_for_timestamp = true # Server Id. server-id=1 max_connections=2000 query_cache_size=0 table_open_cache=2000 tmp_table_size=246M thread_cache_size=300 #限定用于每个数据库线程的栈大小。默认设置足以满足大多数应用 thread_stack = 192k key_buffer_size=512M read_buffer_size=4M read_rnd_buffer_size=32M innodb_data_home_dir = /data/mysql/data innodb_flush_log_at_trx_commit=0 innodb_log_buffer_size=16M innodb_buffer_pool_size=256M innodb_log_file_size=128M innodb_thread_concurrency=128 innodb_autoextend_increment=1000 innodb_buffer_pool_instances=8 innodb_concurrency_tickets=5000 innodb_old_blocks_time=1000 innodb_open_files=300 innodb_stats_on_metadata=0 innodb_file_per_table=1 innodb_checksum_algorithm=0 back_log=80 flush_time=0 join_buffer_size=128M max_allowed_packet=1024M max_connect_errors=2000 open_files_limit=4161 query_cache_type=0 sort_buffer_size=32M table_definition_cache=1400 binlog_row_event_max_size=8K sync_master_info=10000 sync_relay_log=10000 sync_relay_log_info=10000 #批量插入数据缓存大小,可以有效提高插入效率,默认为8M bulk_insert_buffer_size = 64M interactive_timeout = 120 wait_timeout = 120 log-bin-trust-function-creators=1 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
修改密码
/data/mysql/bin/mysql -uroot -p 密码初装的时候有 SET PASSWORD = PASSWORD('mima123'); grant all privileges on *.* to root@'%' identified by 'mima123'; flush privileges;
以上所述是小编给大家介绍的Linux CentOS MySQL 5.7.18 5.7.X安装教程,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对网站的支持!
加载全部内容