③开始安装
匿名 · 更新于 2017/10/24
[root@iZ2zef32qxgaqdo7w2m844Z ~]# cd /home/kxzl/tools //进入工具目录
[root@iZ2zef32qxgaqdo7w2m844Z tools]# tar xf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz //解压
[root@iZ2zef32qxgaqdo7w2m844Z tools]# mv mysql-5.7.18-linux-glibc2.5-x86_64 /application/mysql-5.7.18 //创建安装目录 移动并改名
[root@iZ2zef32qxgaqdo7w2m844Z tools]# ln -s /application/mysql-5.7.18 /application/mysql //设置软连接
[root@iZ2zef32qxgaqdo7w2m844Z /]# mkdir -p /application/mysql/data //建立MySql数据文件目录
[root@iZ2zef32qxgaqdo7w2m844Z /]# chown -R mysql.mysql /application/mysql/data //授权mysql用户管理数据文件目录
[root@iZ2zef32qxgaqdo7w2m844Z /]# chown -R mysql.mysql /application/mysql //授权mysql用户管理MySql的安装目录
查看support-files文件夹的内容,发现并没有my_default.cnf默认的配置文件,如果没有默认的配置文件,需要手动创建一个my_default.cnf配置文件,具体内容如下
# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the # *** default location during install, and will be replaced if you # *** upgrade to a newer version of MySQL. [mysqld] # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # These are commonly set, remove the # and set as required. basedir = /application/mysql datadir = /application/mysql/data # port = ..... # server_id = ..... # socket = ..... # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[root@iZ2zef32qxgaqdo7w2m844Z /]# /bin/cp /application/mysql/support-files/my_default.cnf /etc/my.cnf //初始化MySql配置文件my.cnf
[root@iZ2zef32qxgaqdo7w2m844Z /]# /application/mysql/bin/mysqld --initialize --user=mysql --basedir=/application/mysql --datadir=/application/mysql/data //初始化MySql(包括MySql初始数据库)
[root@iZ2zef32qxgaqdo7w2m844Z /]# cp /application/mysql/support-files/mysql.server /etc/init.d/mysqld //拷贝MySql启动脚本到MySql的命令路径
[root@iZ2zef32qxgaqdo7w2m844Z /]# chmod +x /etc/init.d/mysqld //使脚本可执行
[root@iZ2zef32qxgaqdo7w2m844Z /]# /etc/init.d/mysqld start //启动MySql数据库
Starting MySQL.Logging to '/application/mysql/data/iZ2zef32qxgaqdo7w2m844Z.err'.
[ OK ] //成功启动!
