windows安装多个mysql

windows安装多个mysql

下载mysql

配置mysql的文件

启动数据库

如何破解，修改数据库的用户名和密码

 

一：下载mysql

下载地址：

https://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.43-winx64.zip

链接：https://pan.baidu.com/s/1kEFQ_AC56eFUnGwZ44NIwg
提取码：piq1
复制这段内容后打开百度网盘手机App，操作更方便哦

复制下面的文件：如图

我在c盘下面放了这些文件：创建了两个目录3306，3307，将这些文件放在下面：

C:\database\3307

C:\database\3306

二：修改配置文件

‪C:\database\3306\my-default.ini

[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.

port=3306

basedir=C:/database/3306

datadir=C:/database/3306/data

 

C:\database\3307\my-default.ini

[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.

port=3307

basedir=C:/database/3307

datadir=C:/database/3307/data

总结：配置文件只要修改三个内容：port ,basedir ,datadir

三：启动3306，3307的数据库

注意：cmd命令行需要以管理员的身份运行，管理员的权限

执行下面的命令启动3306的mysql

cd C:\database\3306\bin

mysqld install 3306 --defaults-file="C:\database\3307\my-default.ini"

net start 3306

mysql -u root

mysql> update mysql.user set password=password("123") where user="root" and host="localhost";

Query OK, 0 rows affected (0.00 sec)

Rows matched: 1 Changed: 0 Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> exit

执行下面的命令启动3306的mysql

cd C:\database\3307\bin

mysqld install 3307 --defaults-file="C:\database\3307\my-default.ini"

net start 3307

mysql -u root

mysql> update mysql.user set password=password("123") where user="root" and host="localhost";

Query OK, 0 rows affected (0.00 sec)

Rows matched: 1 Changed: 0 Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> exit

测试：

由于没有设置环境变量，所以测试的时候需要切换到bin目录下，使用mysql客户端的命令来测试数据库服务器是否可以连接，切换到3306或3307的任意一个bin目录下就可以了。

cd c:\database\3307\bin

mysql -u root -p -P 3307

mysql -u root -p -P 3307

四：如果你忘了自己数据库的用户名和密码：

你需要跳过授权表登录，就是不需要输入密码就可以进入数据库，然后通过sql命令修改数据库root的密码：

1：关闭mysql服务

net stop 3306

2：启动mysql服务

cd c:\database\3307\bin

mysql --skip-grant-tables

3：进入mysql

mysql -u root -p 直接回车，按enter键

4：修改密码

mysql> update mysql.user set password=password("123") where user="root" and host="localhost";

Query OK, 0 rows affected (0.00 sec)

Rows matched: 1 Changed: 0 Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> exit

5：杀掉这个mysql服务的进程

在2步骤直接按ctrl+c 就可以停止服务了

或者

tasklist | findstr mysql

taskkill /F /PID 进程的pid

这个命令适用于单个服务。

6：启动mysql服务

net start 3306

测试：略

7：补充添加字符编码：utf-8

[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

8：重新启动mysql服务3306，3307

c:\database\3306\bin>net stop 3306
3306 服务正在停止.
3306 服务已成功停止。
c:\database\3306\bin>mysqld --remove 3306
Service successfully removed.

c:\database\3306\bin>mysqld install 3306 --defaults-file="c:\database\3306\my.ini"
Service successfully installed.

c:\database\3306\bin>net start 3306
3306 服务正在启动 .
3306 服务已经启动成功。


c:\database\3306\bin>mysql -u root -p123
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.43 MySQL Community Server (GPL)

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.

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

mysql> show variables like "%char%"
    -> ;
+--------------------------+----------------------------------+
| Variable_name            | Value                            |
+--------------------------+----------------------------------+
| character_set_client     | utf8                             |
| character_set_connection | utf8                             |
| character_set_database   | utf8                             |
| character_set_filesystem | binary                           |
| character_set_results    | utf8                             |
| character_set_server     | utf8                             |
| character_set_system     | utf8                             |
| character_sets_dir       | C:\database\3306\share\charsets\ |
+--------------------------+----------------------------------+
8 rows in set (0.00 sec)

mysql> exit
Bye

c:\database\3306\bin>net stop 3307
3307 服务正在停止.
3307 服务已成功停止。


c:\database\3306\bin>mysqld --remove 3307
Service successfully removed.
c:\database\3306\bin>mysqld --remove 3307
Service successfully removed.

c:\database\3306\bin>mysqld install 3307 --defaults-file="c:\database\3307\my.ini"
Service successfully installed.

c:\database\3306\bin>net start 3307
3307 服务正在启动 .
3307 服务已经启动成功。


c:\database\3306\bin>mysql -u root -p123 -P 3307
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.43 MySQL Community Server (GPL)

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.

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

mysql> show variables like "%char%";
+--------------------------+----------------------------------+
| Variable_name            | Value                            |
+--------------------------+----------------------------------+
| character_set_client     | utf8                             |
| character_set_connection | utf8                             |
| character_set_database   | utf8                             |
| character_set_filesystem | binary                           |
| character_set_results    | utf8                             |
| character_set_server     | utf8                             |
| character_set_system     | utf8                             |
| character_sets_dir       | C:\database\3307\share\charsets\ |
+--------------------------+----------------------------------+
8 rows in set (0.00 sec)

mysql> exit
Bye