MySQL+Redis+nodejs服务器搭建及工具安装笔记（Windows）

安装后启动出现报错

“MySQL启动服务提示：某些服务在未由其他服务或程序使用时将自动停止”

清空 data文件夹

在运行一下命令

删除数据库

C:\Program Files\mysql\mysql-8.0.15-winx64\bin>mysqld --remove mysql

重新安装

C:\Program Files\mysql\mysql-8.0.15-winx64\bin>mysqld --install mysql66

Service successfully installed.

初始化数据库

C:\Program Files\mysql\mysql-8.0.15-winx64\bin>mysqld --initialize-insecure --user=mysql66

启动数据库

C:\Program Files\mysql\mysql-8.0.15-winx64\bin>net start mysql66

mysql66 服务正在启动 ..

mysql66 服务已经启动成功。

初始密码：GJ_N15?-vas_     （这个初始密码是安装以后自动生产的，在.err文件中查找）

D:\Program Files\mysql\mysql-8.0.15-winx64\bin>mysql -u root -p

Enter password: GJ_N15?-vas_

修改密码为：xxxxxxx，以下为修改密码命令

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'xxxxxxx';

D:\Program Files\mysql\mysql-8.0.15-winx64\bin>mysql -u root -p

Enter password: ************

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 12

Server version: 8.0.15

Copyright (c) 2000, 2019, 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

owners.

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'xxxxxxx';

Query OK, 0 rows affected (0.10 sec)

显示数据库表命令

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

+--------------------+

4 rows in set (0.00 sec)

创建数据库命令

mysql> Create database test_database;

Query OK, 1 row affected (0.20 sec)

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

| test_database |

+--------------------+

5 rows in set (0.00 sec)

修改数据库存储类型（按照项目要求修改）

mysql> ALTER DATABASE test_database CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

Query OK, 1 row affected (0.12 sec)

创建子用户

mysql> create user mylocal @'%' identified by 'xxxxxx';

Query OK, 0 rows affected (0.08 sec)

修改用户

mysql> use mysql

Database changed

mysql> update user set host='%' where user='mylocal';

Query OK, 0 rows affected (0.00 sec)

Rows matched: 1 Changed: 0 Warnings: 0

mysql>

navicat 安装

下载地址：NavicaSetup安装包.rar_navicat安装-其它文档类资源-CSDN下载 

安装 Redis 数据库

设置密码：

另开一个cmd切换到redis根目录，启动客户端

>redis-cli.exe -h 127.0.0.1 -p 6379

客户端使用config get requirepass命令查看密码

>config get requirepass
1)"requirepass"
2)""    //默认空

客户端使用config set requirepass yourpassword命令设置密码

>config set requirepass 12345678
 
 

一旦设置密码，必须先验证通过密码，否则所有操作不可用

>config get requirepass
(error)NOAUTH Authentication required

使用auth password验证密码

>auth 123456
>OK
>config get requirepass
1)"requirepass"
 
 

Cmd 运行数据

127.0.0.1:6379> config get requirepass

(error) NOAUTH Authentication required.

127.0.0.1:6379> auth 12345678

OK

127.0.0.1:6379> config get requirepass

1) "requirepass"

2) "12345678"

127.0.0.1:6379>

Redis安装成功！！

nodejs安装