mysql5.7.9新建表格图解.doc

mysql5.7.9新建表格图解 篇一：mysql5.7.9安装步骤 安装版本：mysql-5.7.9-linux-glibc2.5-i686(二进制包) 操作环境：Red Hat Enterprise Linux Server release 5.8 (Tikanga) （lsb_release -a） 安装步骤： 准备：创建mysql组和用户 [root@hucc /]#groupaddmysql [root@hucc /]#useradd -r -g mysql mysql 1.rz将mysql安装包传到虚拟机的/usr/local/src [root@huccsrc]# tar zxvfmysql-5.7.9-linux-glibc2.5-i686.tar [root@huccsrc]#cpmysql-5.7.9-linux-glibc2.5-i686 /usr/local/mysql/ [root@hucc local]#chown –R mysql:mysqlmysql [root@huccmysql]# mkdir data [root@huccmysql]#pwd /var/lib/mysql [root@huccmysql]#chown –R mysql:mysql data [root@huccmysql]#sumysql [mysql@hucc /]$ /usr/local/mysql/bin/mysql_install_db --user=mysql --datadir=/var/lib/mysql/data 2.安装数据库 [mysql@huccmysql]$ /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#39;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