安装版本：mysql-5.7.9-linux-glibc2.5-i686  (二进制包)
操作环境：Red Hat Enterprise Linux Server release 5.8 (Tikanga)
（lsb_release -a）
安装步骤：
mysql下载starting the server准备：创建mysql组和用户
[root@hucc /]#groupadd mysql
[root@hucc /]#useradd -r -g mysql mysql
1.rz将mysql安装包传到虚拟机的/usr/local/src
[root@hucc src]# tar zxvf mysql-5.7.9-linux-glibc2.5-i686.tar
[root@hucc src]#cp mysql-5.7.9-linux-glibc2.5-i686 /usr/local/mysql/
[root@hucc local]#chown –R mysql:mysql mysql
[root@hucc mysql]# mkdir data
[root@hucc mysql]#pwd
/var/lib/mysql
[root@hucc mysql]#chown –R mysql:mysql data
[root@hucc mysql]#su mysql
[mysql@hucc /]$ /usr/local/mysql/bin/mysql_install_db --user=mysql --datadir=/var/lib/mysql/data
2.安装数据库
[mysql@hucc mysql]$ /usr/local/mysql/bin/mysql_install_db --user=mysql --datadir=/var/lib/mysql/data/
2015-11-11 11:16:51 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2015-11-11 11:17:02 [WARNING] The bootstrap log isn't empty:
2015-11-11 11:17:02 [WARNING] 2015-11-11T03:16:51.695249Z 0 [Warning] --bootstrap is deprecated. Please consider using --initialize instead
2015-11-11T03:16:51.696235Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2015-11-11T03:16:51.696248Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
注：datadir 参数：该参数指定了 MySQL 的数据库文件放在什么路径下。数据库文件即我们常说的 MySQL data 文件
basedir 参数：该参数指定了安装 MySQL 的安装路径，填写全路径可以解决相对路径所造成的问题。
每次执行命令，都要注意这两个参数的路径是否正确
3.初始化数据库
[mysql@hucc data]$ /usr/local/mysql/bin/mysqld --initialize  --datadir=/var/lib/mysql/data/
2015-11-11T03:21:48.753914Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2015-11-11T03:21:48.754043Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2015-11-11T03:21:48.754228Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-11T03:21:53.407740Z 0 [Warning] InnoDB: New log files created, LSN=45790
2015-11-11T03:21:53.835859Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2015-11-11T03:21:53.902132Z 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: 5b2484fb-8823-11e5-861b-000c2939111e.
2015-11-11T03:21:53.906476Z 0 [Warning] Gtid table is not ready to be used. Table 'id_executed' cannot be opened.
2015-11-11T03:21:53.934071Z 1 [Note] A temporary password is generated for root@localhost: gp1qA233.s4W
问题：
[mysql@hucc mysql]$ /usr/local/mysql/bin/mysqld --initialize  --datadir=/var/lib/mysql/data/
2015-11-11T03:19:58.580635Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2015-11-11T03:19:58.580897Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2015-11-11T03:19:58.581086Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-11T03:19:58.583953Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2015-11-11T03:19:58.584183Z 0 [ERROR] Aborting
处理方法
cd /var/lib/mysql/data 目录下执行 rm –rf  *
在安装前执行过这个步骤，为什么初始化还要再执行一次
4.启动mysql服务
[mysql@huccmysql]$/usr/local/mysql/bin/mysqld_safe --basedir=/usr/local/mysql --datadir=/var/lib/mysql/data/
151111 11:48:24 mysqld_safe Logging to '/var/lib/mysql/data//'.
151111 11:48:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/data/
[mysql@hucc root]$ /usr/local/mysql/bin/mysqld_safe --basedir=/usr/local/mysql --datadir=/var/lib/mysql/data/
Usage: grep [OPTION]... PATTERN [FILE]...
Try `grep --help' for more information.
grep: write error: 断开的管道
151111 11:52:27 mysqld_safe Logging to '/var/lib/mysql/data//'.
151111 11:52:27 mysqld_safe A mysqld process already exists
[mysql@hucc root]$ netstat -altn | grep 3306
tcp        0      0 :::3306                    :::*                        LISTEN 
[mysql@hucc root]$ /usr/local/mysql/bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.9
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。