hj_mysql5.7.36免安装版

官网下载地址 -> https://dev.mysql.com/downloads/mysql/    选择 Windows (x86, 64-bit), ZIP Archive;

解压文件->配置系统环境变量到bin目录. 系统变量:  MY_SQL57_HOME  D:\SYS\ISP\mysql-5.7.36-winx64   Path: %MY_SQL57_HOME\bin

如果电脑缺乏 msvcr120.dll等俩文件,去Microsoft官网(https://www.microsoft.com/zh-cn/download/confirmation.aspx?id=40784)

单机手动下载,有三个.exe文件. 下载 执行;

新建my.ini文件,内容如下.放置到解压后与 bin平级的目录下.

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

[mysql] # 设置mysql客户端默认字符集 default-character-set=utf8 [mysqld] # 服务端使用的字符集默认为8比特编码的latin1字符集 character-set-server=utf8 #设置3308端口 默认是3306 port=3308 # 设置mysql的安装目录 basedir="D:\SYS\ISP\mysql-5.7.36-winx64" # 设置mysql数据库的数据的存放目录 datadir="D:\SYS\ISP\mysql-5.7.36-winx64\data" # 设置mysql数据库的数据存放临时文件目录 tmpdir="D:\SYS\ISP\mysql-5.7.36-winx64\data" log-error="D:\SYS\ISP\mysql-5.7.36-winx64\data\mysql57_error.log" # 设置mysql的socket目录 socket="D:\SYS\ISP\mysql-5.7.36-winx64\data\mysql.sock" # 允许最大连接数 max_connections=200 # 创建新表时将使用的默认存储引擎 default-storage-engine=INNODB # 其他先使用默认配置咯~

以管理员的身份运行cmd,切入到bin目录下---->

1->mysqld --initialize -insecure --user=hj_mysql  创建data目录,服务命名为 hj_mysql ;

     ps:mysqld --initialize -insecure 这个命令会生成无密码的root用户,而命令 mysqld --initialize自动生成带随机密码的root用户

2->mysqld --install hj_mysql --defaults-file="D:\SYS\ISP\mysql-5.7.36-winx64\my.ini" 

若报错: The service already exists! 需要执行以下操作,然后彻底干掉mysql残留文件,注册表. 然后再执行安装

?

1 2 3 4 5 6 7 8 9 10 11 12

D:\SYS\ISP\mysql-5.7.36-winx64\bin>sc query mysql    查询mysql服务 mysql/hj_mysql 服务名   SERVICE_NAME: mysql         TYPE               : 10  WIN32_OWN_PROCESS         STATE              : 1  STOPPED         WIN32_EXIT_CODE    : 0  (0x0)         SERVICE_EXIT_CODE  : 0  (0x0)         CHECKPOINT         : 0x0         WAIT_HINT          : 0x0   D:\SYS\ISP\mysql-5.7.36-winx64\bin>sc delete mysql 删除服务 [SC] DeleteService 成功

D:\SYS\ISP\mysql-5.7.36-winx64\bin>mysqld -install hj_mysql --defaults-file="D:\SYS\ISP\mysql-5.7.36-winx64\bin\my.ini"
Service successfully installed.

 ps: 若是报错 mysql57 服务正在启动 . mysql57 服务无法启动。 服务没有报告任何错误。

  可运行 mysqld --console 命令.根据里面信息再排错,或者查看mysql57_error.log日志...

例如:Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 等,若是这个错,删除掉data目录,

   执行 mysqld --initialize --user=hj_mysql --console 重新生成data文件. 

3->启动服务 net strat hj_mysql  mysql -uroot -p 进入.若老是报错ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061),

    请千万主意是不是没带端口号...如果改了默认端口的话..  net strat hj_mysql  -> mysql -uroot -P3308 -p

   也可用免密方式进入再置空密码,流程如下;

  net stop hj_mysql 停止服务 ,然后运行 mysqld --console --skip-grant-tables --shared-memory 如下显示:

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

D:\SYS\ISP\mysql-5.7.36-winx64\bin>net stop hj_mysql hj_mysql 服务正在停止. hj_mysql 服务已成功停止。   D:\SYS\ISP\mysql-5.7.36-winx64\bin>mysqld --console --skip-grant-tables --shared-memory 2021-12-07T09:07:54.182983Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-12-07T09:07:54.183042Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2021-12-07T09:07:54.183571Z 0 [Note] mysqld (mysqld 5.7.36) starting as process 6380 ... 2021-12-07T09:07:54.187450Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-12-07T09:07:54.188386Z 0 [Note] InnoDB: Uses event mutexes 2021-12-07T09:07:54.188801Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2021-12-07T09:07:54.189158Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-12-07T09:07:54.189461Z 0 [Note] InnoDB: Number of pools: 1 2021-12-07T09:07:54.189757Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2021-12-07T09:07:54.191818Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2021-12-07T09:07:54.196132Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-12-07T09:07:54.240463Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-12-07T09:07:54.271125Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-12-07T09:07:54.271694Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-12-07T09:07:54.279638Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2021-12-07T09:07:54.280919Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-12-07T09:07:54.281177Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-12-07T09:07:54.281740Z 0 [Note] InnoDB: Waiting for purge to start

　　再另开一个cmd窗口---> mysql -uroot -p 无密码直接回车(这可不带端口号).

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

D:\SYS\ISP\mysql-5.7.36-winx64\bin>mysql -uroot -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.36 MySQL Community Server (GPL)   Copyright (c) 2000, 2021, Oracle and/or its affiliates.   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> use mysql Database changed mysql>

　密码置空:  mysql -u root -p 直接回车进入. use mysql  update user set authentication_string='' where user='root';  flush privileges; exit;

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

D:\SYS\ISP\mysql-5.7.36-winx64\bin>mysql -u root -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.7.36 MySQL Community Server (GPL)   Copyright (c) 2000, 2021, Oracle and/or its affiliates.   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> ; ERROR: No query specified   mysql> update user set authentication_string='' where user='root'; ERROR 1046 (3D000): No database selected mysql> use mysql Database changed mysql> update user set authentication_string='' where user='root'; Query OK, 1 row affected (0.00 sec) Rows matched: 1  Changed: 1  Warnings: 0   mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> exit; Bye

关闭免密模式的cmd窗口.启动服务 net start hj_mysql mysql -uroot -p   

修改密码 alter user 'root'@'localhost' identified with mysql_native_password by '123456';

flush privileges; exit;

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

mysql> alter user 'root'@'localhost' identified with mysql_native_password by '123456'; Query OK, 0 rows affected (0.00 sec)   mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)   mysql> show databases; +--------------------+ | Database           | +--------------------+ | information_schema | | mysql              | | performance_schema | | sys                | +--------------------+ 4 rows in set (0.00 sec)   mysql>          ps:mysql cmd下若语句写错一直->这样,可 Ctrl+c 同时按退出那错误语句.

 大功告成~