我在Oracle官网mysql-5.7.10-winx64的tar的版本(非安装版),解压后发现没有data文件夹,于是在mysql-5.7.10-winx64下自己手动新建了data目录,并写入了人my.ini的文件
datadir=D:\Program Files\mysql-5.7.10-winx64\data
D:\Program Files\mysql-5.7.10-winx64\bin>net start mysql
MySQL 服务正在启动 ….
MySQL 服务无法启动。
服务没有报告任何错误。请键入 NET HELPMSG 3534 以获得更多的帮助。
输入net start mysql启动Mysql服务时,显示MySQL 服务正在启动 …. MySQL 服务无法启动。
使用Windows服务中打开MySQL服务时,显示:本地计算机上的MySQL服务启动后停止,某些服务在未由其他服务或程序使用时将自动停止,也无法启动。
于是根据网上的资料看了一下日志,输入mysqld –console
1
|
D:\Program
Files\mysql
-5.7.10
-winx64\
bin
>mysqld
--console
|
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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
|
2016
-
01
-
21T07
:
25
:
01.465815Z
0
[
Warning
]
TIMESTAMP
with
implicit
DEFAULT
value
is
deprecated
.
Please
use
--
explicit_defaults_for_timestamp
server
option
(
see
documentation
for
more
details
)
.
2016
-
01
-
21T07
:
25
:
01.465815Z
0
[
Warning
]
'NO_ZERO_DATE'
,
'NO_ZERO_IN_DATE'
and
'ERROR_FOR_DIVISION_BY_ZERO'
sql
modes
should
be
used
with
strict
mode
.
They
willbe
merged
with
strict
mode
in
a
future
release
.
2016
-
01
-
21T07
:
25
:
01.465815Z
0
[
Warning
]
'NO_AUTO_CREATE_USER'
sql
mode
was
not
set
.
2016
-
01
-
21T07
:
25
:
01.465815Z
0
[
Warning
]
Insecure
configuration
for
--
secure
-
file
-
priv
:
Current
value
does
not
restrict
location
of
generated
files
.
Consider
setting
it
to
a
valid
,
non
-
empty
path
.
2016
-
01
-
21T07
:
25
:
01.467815Z
0
[
Note
]
mysqld
(
mysqld
5.7.10
-
log
)
starting
as
process
3708
.
.
.
2016
-
01
-
21T07
:
25
:
01.491816Z
0
[
Warning
]
No
argument
was
provided
to
--
log
-
bin
,
and
--
log
-
bin
-
index
was
not
used
;
so
replication
may
break
when
this
MySQL
server
acts
as
a
master
and
has
his
hostname
changed
!
!
Please
use
'--log-bin=PC201305252052-bin'
to
avoid
this
problem
.
2016
-
01
-
21T07
:
25
:
01.527818Z
0
[
Note
]
InnoDB
:
Mutexes
and
rw_locks
use
Windows
interlocked
functions
2016
-
01
-
21T07
:
25
:
01.528818Z
0
[
Note
]
InnoDB
:
Uses
event
mutexes
2016
-
01
-
21T07
:
25
:
01.531819Z
0
[
Note
]
InnoDB
:
_mm_lfence
(
)
and
_mm_sfence
(
)
are
used
for
memory
barrier
2016
-
01
-
21T07
:
25
:
01.535819Z
0
[
Note
]
InnoDB
:
Compressed
tables
use
zlib
1.2.3
2016
-
01
-
21T07
:
25
:
01.540819Z
0
[
Note
]
InnoDB
:
Number
of
pools
:
1
2016
-
01
-
21T07
:
25
:
01.544819Z
0
[
Note
]
InnoDB
:
Not
using
CPU
crc32
instructions
2016
-
01
-
21T07
:
25
:
01.654826Z
0
[
Note
]
InnoDB
:
Initializing
buffer
pool
,
total
size
=
128M
,
instances
=
1
,
chunk
size
=
128M
2016
-
01
-
21T07
:
25
:
01.705829Z
0
[
Note
]
InnoDB
:
Completed
initialization
of
buffer
pool
2016
-
01
-
21T07
:
25
:
01.834836Z
0
[
Note
]
InnoDB
:
Highest
supported
file
format
is
Barracuda
.
2016
-
01
-
21T07
:
25
:
01.991845Z
0
[
Note
]
InnoDB
:
Creating
shared
tablespace
for
temporary
tables
2016
-
01
-
21T07
:
25
:
01.994845Z
0
[
Note
]
InnoDB
:
Setting
file
'.\ibtmp1'
size
to
12MB.
Physically
writing
the
file
full
;
Please
wait
.
.
.
2016
-
01
-
21T07
:
25
:
02.264861Z
0
[
Note
]
InnoDB
:
File
'.\ibtmp1'
size
is
now
12
MB
.
2016
-
01
-
21T07
:
25
:
02.275861Z
0
[
Note
]
InnoDB
:
96
redo
rollback
segment
(
s
)
found
.
96
redo
rollback
segment
(
s
)
are
active
.
2016
-
01
-
21T07
:
25
:
02.276861Z
0
[
Note
]
InnoDB
:
32
non
-
redo
rollback
segment
(
s
)
are
active
.
2016
-
01
-
21T07
:
25
:
02.284862Z
0
[
Note
]
InnoDB
:
Waiting
for
purge
to
start
2016
-
01
-
21T07
:
25
:
02.335865Z
0
[
Note
]
InnoDB
:
5.7.10
started
;
log
sequence
number
1209980
2016
-
01
-
21T07
:
25
:
02.338865Z
0
[
Note
]
Plugin
'FEDERATED'
is
disabled
.
2016
-
01
-
21T07
:
25
:
02.339865Z
0
[
Note
]
InnoDB
:
Loading
buffer
pool
(
s
)
from
F
:
\
mysqldata
\
ib_buffer
_pool
2016
-
01
-
21T07
:
25
:
02.339865Z
0
[
Note
]
InnoDB
:
not
started
mysqld
:
Table
'mysql.plugin'
doesn
't exist
2016-01-21T07:25:02.348865Z 0 [Note] InnoDB: Buffer pool(s) load completed at 151221 15:25:02
2016-01-21T07:25:02.351865Z 0 [ERROR] Can'
t
open
the
mysql
.
plugin
table
.
Please
run
mysql_upgrade
to
create
it
.
2016
-
01
-
21T07
:
25
:
02.396868Z
0
[
Warning
]
Gtid
table
is
not
ready
to
be
used
.
Table
'mysql.gtid_executed'
cannot
be
opened
.
2016
-
01
-
21T07
:
25
:
02.401868Z
0
[
Warning
]
Failed
to
set
up
SSL
because
of
the
following
SSL
library
error
:
SSL
context
is
not
usable
without
certificate
and
private
key
2016
-
01
-
21T07
:
25
:
02.402868Z
0
[
Note
]
Server
hostname
(
bind
-
address
)
:
'*'
;
port
:
3306
2016
-
01
-
21T07
:
25
:
02.415869Z
0
[
Note
]
IPv6
is
available
.
2016
-
01
-
21T07
:
25
:
02.416869Z
0
[
Note
]
-
'::'
resolves
to
'::'
;
2016
-
01
-
21T07
:
25
:
02.419869Z
0
[
Note
]
Server
socket
created
on
IP
:
'::'
.
2016
-
01
-
21T07
:
25
:
02.430870Z
0
[
Warning
]
Failed
to
open
optimizer
cost
constant
tables
2016
-
01
-
21T07
:
25
:
02.436870Z
0
[
ERROR
]
Fatal
error
:
Can
't open and lock privilege tables: Table '
mysql
.
user
' doesn'
t
exist
2016
-
01
-
21T07
:
25
:
02.440871Z
0
[
ERROR
]
Aborting
2016
-
01
-
21T07
:
25
:
02.441871Z
0
[
Note
]
Binlog
end
2016
-
01
-
21T07
:
25
:
02.457872Z
0
[
Note
]
Shutting
down
plugin
'ngram'
2016
-
01
-
21T07
:
25
:
02.457872Z
0
[
Note
]
Shutting
down
plugin
'partition'
2016
-
01
-
21T07
:
25
:
02.460872Z
0
[
Note
]
Shutting
down
plugin
'BLACKHOLE'
2016
-
01
-
21T07
:
25
:
02.463872Z
0
[
Note
]
Shutting
down
plugin
'ARCHIVE'
2016
-
01
-
21T07
:
25
:
02.468872Z
0
[
Note
]
Shutting
down
plugin
'PERFORMANCE_SCHEMA'
2016
-
01
-
21T07
:
25
:
02.468872Z
0
[
Note
]
Shutting
down
plugin
'MRG_MYISAM'
2016
-
01
-
21T07
:
25
:
02.475873Z
0
[
Note
]
Shutting
down
plugin
'MyISAM'
2016
-
01
-
21T07
:
25
:
02.476873Z
0
[
Note
]
Shutting
down
plugin
'INNODB_SYS_VIRTUAL'
2016
-
01
-
21T07
:
25
:
02.480873Z
0
[
Note
]
Shutting
down
plugin
'INNODB_SYS_DATAFILES'
2016
-
01
-
21T07
:
25
:
02.482873Z
0
[
Note
]
Shutting
down
plugin
'INNODB_SYS_TABLESPACES'
2016
-
01
-
21T07
:
25
:
02.493874Z
0
[
Note
]
Shutting
down
plugin
'INNODB_SYS_FOREIGN_COLS'
2016
-
01
-
21T07
:
25
:
02.495874Z
0
[
Note
]
Shutting
down
plugin
'INNODB_SYS_FOREIGN'
2016
-
01
-
21T07
:
25
:
02.498874Z
0
[
Note
]
Shutting
down
plugin
'INNODB_SYS_FIELDS'
2016
-
01
-
21T07
:
25
:
02.503874Z
0
[
Note
]
Shutting
down
plugin
'INNODB_SYS_COLUMNS'
2016
-
01
-
21T07
:
25
:
02.509875Z
0
[
Note
]
Shutting
down
plugin
'INNODB_SYS_INDEXES'
2016
-
01
-
21T07
:
25
:
02.513875Z
0
[
Note
]
Shutting
down
plugin
'INNODB_SYS_TABLESTATS'
2016
-
01
-
21T07
:
25
:
02.518875Z
0
[
Note
]
Shutting
down
plugin
'INNODB_SYS_TABLES'
2016
-
01
-
21T07
:
25
:
02.521875Z
0
[
Note
]
Shutting
down
plugin
'INNODB_FT_INDEX_TABLE'
2016
-
01
-
21T07
:
25
:
02.524875Z
0
[
Note
]
Shutting
down
plugin
'INNODB_FT_INDEX_CACHE'
2016
-
01
-
21T07
:
25
:
02.528876Z
0
[
Note
]
Shutting
down
plugin
'INNODB_FT_CONFIG'
2016
-
01
-
21T07
:
25
:
02.531876Z
0
[
Note
]
Shutting
down
plugin
'INNODB_FT_BEING_DELETED'
2016
-
01
-
21T07
:
25
:
02.537876Z
0
[
Note
]
Shutting
down
plugin
'INNODB_FT_DELETED'
2016
-
01
-
21T07
:
25
:
02.539876Z
0
[
Note
]
Shutting
down
plugin
'INNODB_FT_DEFAULT_STOPWORD'
2016
-
01
-
21T07
:
25
:
02.542876Z
0
[
Note
]
Shutting
down
plugin
'INNODB_METRICS'
2016
-
01
-
21T07
:
25
:
02.545877Z
0
[
Note
]
Shutting
down
plugin
'INNODB_TEMP_TABLE_INFO'
2016
-
01
-
21T07
:
25
:
02.553877Z
0
[
Note
]
Shutting
down
plugin
'INNODB_BUFFER_POOL_STATS'
2016
-
01
-
21T07
:
25
:
02.555877Z
0
[
Note
]
Shutting
down
plugin
'INNODB_BUFFER_PAGE_LRU'
2016
-
01
-
21T07
:
25
:
02.558877Z
0
[
Note
]
Shutting
down
plugin
'INNODB_BUFFER_PAGE'
2016
-
01
-
21T07
:
25
:
02.561878Z
0
[
Note
]
Shutting
down
plugin
'INNODB_CMP_PER_INDEX_RESET'
2016
-
01
-
21T07
:
25
:
02.563878Z
0
[
Note
]
Shutting
down
plugin
'INNODB_CMP_PER_INDEX'
2016
-
01
-
21T07
:
25
:
02.566878Z
0
[
Note
]
Shutting
down
plugin
'INNODB_CMPMEM_RESET'
2016
-
01
-
21T07
:
25
:
02.572878Z
0
[
Note
]
Shutting
down
plugin
'INNODB_CMPMEM'
2016
-
01
-
21T07
:
25
:
02.574878Z
0
[
Note
]
Shutting
down
plugin
'INNODB_CMP_RESET'
2016
-
01
-
21T07
:
25
:
02.577878Z
0
[
Note
]
Shutting
down
plugin
'INNODB_CMP'
2016
-
01
-
21T07
:
25
:
02.580879Z
0
[
Note
]
Shutting
down
plugin
'INNODB_LOCK_WAITS'
2016
-
01
-
21T07
:
25
:
02.582879Z
0
[
Note
]
Shutting
down
plugin
'INNODB_LOCKS'
2016
-
01
-
21T07
:
25
:
02.584879Z
0
[
Note
]
Shutting
down
plugin
'INNODB_TRX'
2016
-
01
-
21T07
:
25
:
02.586879Z
0
[
Note
]
Shutting
down
plugin
'InnoDB'
2016
-
01
-
21T07
:
25
:
02.587879Z
0
[
Note
]
InnoDB
:
FTS
optimize
thread
exiting
.
2016
-
01
-
21T07
:
25
:
02.589879Z
0
[
Note
]
InnoDB
:
Starting
shutdown
.
.
.
2016
-
01
-
21T07
:
25
:
02.690885Z
0
[
Note
]
InnoDB
:
Dumping
buffer
pool
(
s
)
to
F
:
\
mysqldata
\
ib_buffer
_pool
2016
-
01
-
21T07
:
25
:
02.698885Z
0
[
Note
]
InnoDB
:
Buffer
pool
(
s
)
dump
completed
at
151221
15
:
25
:
02
2016
-
01
-
21T07
:
25
:
03.850951Z
0
[
Note
]
InnoDB
:
Shutdown
completed
;
log
sequence
number
1209999
2016
-
01
-
21T07
:
25
:
03.853951Z
0
[
Note
]
InnoDB
:
Removed
temporary
tablespace
data
file
:
"ibtmp1"
2016
-
01
-
21T07
:
25
:
03.863952Z
0
[
Note
]
Shutting
down
plugin
'MEMORY'
2016
-
01
-
21T07
:
25
:
03.866952Z
0
[
Note
]
Shutting
down
plugin
'CSV'
2016
-
01
-
21T07
:
25
:
03.876953Z
0
[
Note
]
Shutting
down
plugin
'sha256_password'
2016
-
01
-
21T07
:
25
:
03.879953Z
0
[
Note
]
Shutting
down
plugin
'mysql_native_password'
2016
-
01
-
21T07
:
25
:
03.882953Z
0
[
Note
]
Shutting
down
plugin
'binlog'
2016
-
01
-
21T07
:
25
:
03.892954Z
0
[
Note
]
mysqld
:
Shutdown
complete
|
我们看到三个错误:(也可以在data文件夹中找到.err文件用记事本打开)
[ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
[ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist
[ERROR] Aborting
这个时候输入命令mysqld –initialize
1
|
D:\Program
Files\mysql
-5.7.10
-winx64\
bin
>mysqld
--initialize
|
1
2
3
4
5
|
2016
-
01
-
21T07
:
28
:
50.310904Z
0
[
Warning
]
TIMESTAMP
with
implicit
DEFAULT
value
is
deprecated
.
Please
use
--
explicit_defaults_for_timestamp
server
option
(
see
documentation
for
more
details
)
.
2016
-
01
-
21T07
:
28
:
50.311904Z
0
[
Warning
]
'NO_ZERO_DATE'
,
'NO_ZERO_IN_DATE'
and
'ERROR_FOR_DIVISION_BY_ZERO'
sql
modes
should
be
used
with
strict
mode
.
They
willbe
merged
with
strict
mode
in
a
future
release
.
2016
-
01
-
21T07
:
28
:
50.311904Z
0
[
Warning
]
'NO_AUTO_CREATE_USER'
sql
mode
was
not
set
.
2016
-
01
-
21T07
:
28
:
50.318904Z
0
[
ERROR
]
--
initialize
specified
but
the
data
directory
has
files
in
it
.
Aborting
.
2016
-
01
-
21T07
:
28
:
50.324905Z
0
[
ERROR
]
Aborting
|
又有两个错误:
1
2
3
|
[ERROR]
--initialize
specified
but
the
data directory
has
files
in
it.
Aborting.
[ERROR]
Aborting
|
这是由于自己建了data文件夹造成,这时候删掉data文件夹之后再注释my.init文件下的datadir
再次输入命令
1
|
mysqld
--initialize
|
1
2
|
D:\Program
Files\mysql
-5.7.10
-winx64\
bin
>mysqld
-
-initialize
D:\Program
Files\mysql
-5.7.10
-winx64\
bin
>net
start
mysql
|
MySQL 服务正在启动…
MySQL 服务已经启动成功。
成功。
更新:出现该错误,很可能是错误的配置,mysql-5.7.10-winx64mysql-5.7.11-winx64已经更新了配置方式,例如初始root用户的密码是随机生成的,更新密码的方式也进行了改进。以下是正确的免安装版MySQL配置方式。
我习惯把软件安装在 D:\Program Files 下面, 所以我解压到 D:\Program Files 目录下面,
然后进入 D:\Program Files\mysql-5.7.10-winx64\bin 目录, 复制目录路径, 配置环境变量(配置用户环境变量也可以, 系统环境变量也可以), 在 PATH后面追加上 ;D:\Program Files\mysql-5.7.10-winx64\bin
(注意, 前边有一个分号, 这是windows的要求, 在Linux系统下面是以 : 为间隔, windows下面是用 ; 来间隔, 注意: 必须是英文的.)
然后, 确定….., 配置完成.
三: 编辑MySQL的配置文件
进入 MySQL 的安装目录, 在安装目录下面有一个 my-default.ini 的文件, MySQL启动时会读取这个文件, 我们配置一下这个文件
然后在 bin 目录下面输入 mysqld –install
这个命令就是安装服务, 执行完后, 提示英文的成功, 这时候你可以在你的 windows 服务中看到 MySQL 的服务.
(由于我已经安装好了 MySQL 数据库, 所以这里显示已启动, 你的一定没有”已启动”.)
五: 初始化 MySQL
继续在命令提示符中输入: mysqld –initialize –console
这是初始化数据库, 然后你可以在初始化的最后面看到有一个 root@localhost: 后面有一连串的字母数字符号, 这是 MySQL 为你自动生成的随机密码. 要记下来, 一会我们登陆 MySQL 数据库的时候要用.
六: 启动MySQL服务
启动 MySQL 服务, 启动了你才能用 MySQL 数据库.
有两种方式可以启动 MySQL:
方法一: 用命令启动
net start mysql
方法二: 从 windows 服务中启动
七: 修改MySQL默认密码
启动了之后, 我们登陆 MySQL 数据库, 输入命令
mysql -uroot -p
回车, 要求你输入密码, 这时, 把刚才 MySQL 随机生成的密码输入, 然后回车, 就登陆进去了.
登陆进去之后, 直接输入:
SET PASSWORD = PASSWORD(‘你的新密码’);
在 mysql-5.7.10 中, 系统的 user 表中没有 password 这一列了, 在 mysql-5.6.* 中还有.
以前我们用 mysql-5.6.* 的时候, 直接用 update 语句来更新root密码.
这种方法在 mysql-5.7.10 中没法用了, 我们只能用 SET PASSWORD = PASSWORD(‘你的新密码’); 来修改密码.
修改完密码之后, 需要重启 MySQL 服务才生效.
Tags
源处:http://www.ixingo.cn/2016/01/22/mysql-5-7-10-winx64/