mysql安装详细指南

来源：互联网发布：amd优化什么意思编辑：程序博客网时间：2024/05/19 16:05

1.下载安装包mysql-5.7.14-win32.msi

2.安装MySQL，我安装在D:\MySQL\MySQL Server 5.7目录下

3.将目录下的默认文件 my-default.ini 改名为my.ini

4.打开my.ini,添加配置：

[WinMySQLAdmin]
Server=D:\MySQL\MySQL Server 5.7\bin\mysqld.exe

[mysqld]

    basedir = D:\MySQL\MySQL Server 5.7
    datadir = D:\MySQL\MySQL Server 5.7\data
    port = 3306
    server_id = 1
    max_connections=1024

    log_bin = mysql-bin
    explicit_defaults_for_timestamp = TRUE
    sql_mode=ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,

ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,PIPES_AS_CONCAT,ANSI_QUOTES

5.在D:\MySQL\MySQL Server 5.7目录下创建data文件夹用来存放数据

6.我的电脑->属性->高级系统设置(高级)->环境变量，

添加MYSQL_HOME变量，值为D:\MySQL\MySQL Server 5.7

在Path变量中添加%MYSQL_HOME%\bin用分号（；）隔开

7.cmd进入到bin下输入初始化命令(管理员方式打开cmd)：

D:\MySQL\MySQL Server 5.7\bin>mysqld --initialize --user=mysql --console

2016-08-07T02:57:11.678911Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2016-08-07T02:57:11.678911Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2016-08-07T02:57:16.351247Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-08-07T02:57:17.335589Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-08-07T02:57:18.054363Z 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: a700687c-5c4a-11e6-830e-e89a8ffd15e0.
2016-08-07T02:57:18.132545Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-08-07T02:57:18.210786Z 1 [Note] A temporary password is generated for root@localhost: dei05oKloX)k

此时产生一个随机密码请记住：dei05oKloX)k

如果出现如下告警,:

2016-08-07T02:19:28.889373Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

检查你的my.ini 中explicit_defaults_for_timestamp = TRUE是否配置正确

2016-08-07T02:19:28.904984Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.

这是前面安装失败导致D:\MySQL\MySQL Server 5.7\data下产生了旧数据，将旧数据删掉。

8.cmd进入bin输入安装命令：

D:\MySQL\MySQL Server 5.7\bin>mysqld --install
Service successfully installed.

表示安装成功

9.cmd进入bin输入启动命令：

           D:\MySQL\MySQL Server 5.7\bin>net start MySQL
          MySQL 服务正在启动 ..
           MySQL 服务已经启动成功。

10.cmd进入bin输入进入mysql命令：

D:\MySQL\MySQL Server 5.7\bin>mysql -u root -p

Enter password:输入第7步产生的随机密码

           Welcome to the MySQL monitor. Commands end with ; or \g.
           Your MySQL connection id is 3
           Server version: 5.7.14-log

           Oracle is a registered trademark of Oracle Corporation and/or its
           affiliates. Other names may be trademarks of their respective
           owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

出现mysql>表示成功进入到了mysql

11.对初始的随机密码进行修改

mysql>set password for root@localhost = password('root')；

Query OK, 0 rows affected, 1 warning (0.25 sec)

将root用户的初始随机密码修改为root（自己设定的密码）

12.查看数据库mysq>show databases;

+--------------------+
| Database           |
+--------------------+
| information_schema |
| myoneweb           |
| mysql              |
| performance_schema |
| sys                |
+--------------------+

恭喜你至此你已经成功安装完MySQL！

0 0