在bin目录:D:\Java\mysql-8.0.11-winx64\bin
新建 mysql_default.ini文件,
文件内容:
----------------------------------------------------------------------------------------
[client]
port=3306
default-character-set=utf8
[mysqld]
port=3306
character_set_server=utf8
#安装路径
basedir=D:\Java\mysql-8.0.11-winx64
#数据路径
datadir=D:\Java\mysql-8.0.11-winx64\data
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[WinMySQLAdmin]
D:\Java\mysql-8.0.11-winx64\bin\mysqld.exe
------------------------------------------------------------------------------------------
安装:cmd 以管理员身份运行 cmd 以管理员身份运行 cmd 以管理员身份运行
D:\Java\mysql-8.0.11-winx64\bin>mysqld install
Service successfully installed.
初始化:
D:\Java\mysql-8.0.11-winx64\bin>mysqld --initialize
注意:data文件夹不能自己去建
启动:
D:\Java\mysql-8.0.11-winx64\bin>net start mysql
MySQL 服务正在启动 ..
MySQL 服务已经启动成功。
登陆:
D:\Java\mysql-8.0.11-winx64\bin>mysql -u root -p
Enter password: ************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2174
Server version: 8.0.11
初始密码查找路径:
D:\Java\mysql-8.0.11-winx64\data\DESKTOP-J0ONGFT.err
此文件中的 :
2018-07-10T03:01:16.503849Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: lh0wXAqEae-K
什么都不能操作,提升先 修改密码 :
You must reset your password using ALTER USER statement before executing this statement.
修改命令如下:必须同时包含大写 小写 数字 特殊符号,
mysql> ALTER user 'root'@'localhost' IDENTIFIED BY 'SFFGfrs@#123#';