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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
@echo off

rem https://blog.csdn.net/weixin_42373448/article/details/81275655
rem 参考上述链接，里面有对“ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passwor”的描述
rem 主要是初始密码的问题
rem **********************************MySQL环境变量部署*****************************************
cd /d %~dp0
del /F %cd%my.ini 
echo 删除完成
echo [client]>> my.ini 
rem echo port = 3306>> my.ini 
echo default-character-set=utf8mb4>>my.ini
echo [mysqld]>> my.ini 
echo ft_min_word_len=2>>my.ini
echo character-set-client-handshake = FALSE>>my.ini
echo collation-server=utf8mb4_unicode_ci>>my.ini
echo init_connect=’SET NAMES utf8mb4'>>my.ini
echo log-error=%cd:=\%\error>>my.ini
echo character_set_server=utf8mb4>>my.ini
echo default_storage_engine=INNODB>> my.ini 
echo basedir=%cd:=\%\>>my.ini 
echo datadir=%cd:=\%\data>> my.ini 
rem echo innodb_data_file=ibdata1:50M;ibdata2:10M:autoextend>> my.ini 
rem echo transaction-isolation=READ-COMMITTED>> my.ini 
echo explicit_defaults_for_timestamp=true>> my.ini
echo port=3306>> my.ini 
echo max_connections=200>>my.ini
echo max_allowed_packet=64M>> my.ini 
echo tmp_table_size=64M>> my.ini 
echo [mysql]>>my.ini
echo default-character-set=utf8mb4>>my.ini 
echo my.ini生成成功
cd /d %~dp0


echo "注册MySql服务开始"
echo "停止已存在的服务MySQL"
net stop MySQL
echo "删除已存在的服务MySQL"
sc delete MySQL

"%~dp0"binmysqld.exe --initialize

echo "删除服务执行文件项"
"%~dp0"binmysqld.exe -romve
REG Delete HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesMySQL /v ImagePath /f
"%~dp0"binmysqld.exe  -install
echo "添加服务执行文件项"
REG add HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesMySQL /v ImagePath /t REG_EXPAND_SZ /d "%cd%binMySqld.exe --defaults-file="%cd%my.ini" MySQL" /f
net start mysql

1
2
2018-08-03T05:40:23.440594Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: SEVo?sluU3lV

1
mysql -u root -p

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

1
2
3
4
5
6
7
#select id, from_remark_name, from_nick_name,  msg_id, msg_digest, create_time from messages where wx_uin='2441227902' and which_day=CURDATE();
#select count(*) from messages where wx_uin='2441227902' and which_day=CURDATE() and is_self=1;

#truncate taobao_order
#ALTER TABLE `messages` ADD FULLTEXT INDEX ft_actual_content  (`actual_content`)
SELECT * FROM `messages` WHERE MATCH(`actual_content`) AGAINST('人才' IN BOOLEAN MODE)
#ALTER TABLE `messages` ADD FULLTEXT INDEX `ft_actual_content` (`actual_content`)  WITH PARSER ngram;

1
2
3
4
5
6
7
8
9
10
11
[client]
default-character-set=utf8mb4 

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect=’SET NAMES utf8mb4'

[mysql]
default-character-set=utf8mb4

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
[client] 
default-character-set=utf8mb4
[mysqld] 
ngram_token_size=2
collation-server=utf8mb4_unicode_ci
log-error=D:\Tools\mysql-8.0.12-winx64\error
character_set_server=utf8mb4
init_connect=’SET NAMES utf8mb4'
character-set-client-handshake = FALSE
default_storage_engine=INNODB 
basedir=D:\Tools\mysql-8.0.12-winx64\ 
datadir=D:\Tools\mysql-8.0.12-winx64\data 
explicit_defaults_for_timestamp=true
port=3306 
max_connections=300
max_allowed_packet=64M 
tmp_table_size=64M  
[mysql]
default-character-set= utf8mb4

1
2
3
[mysqld]
default_authentication_plugin=mysql_native_password
validate_password=OFF