mysql免安装版提示启动报错_mysql免安装版，服务无法启动没有抱任何错误

1.解压

2.新建my.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.

basedir = "D:\mysql-5.7.26-winx64\mysql-5.7.26-winx64"

datadir = "D:\mysql-5.7.26-winx64\mysql-5.7.26-winx64\data"

character-set-server = utf8

port = 3306

skip-grant-tables

3.在bin目录下执行一下命令，会自动创建data文件夹

mysqld --initialize

4.在bin目录下输入下面命令，启动服务

mysqld –install

5.启动mysql服务

net start mysql

6.输入命令进入mysql，更新密码

update mysql.user set authentication_string=password('123456789') where user='root';

7.刷新权限

flush privileges

8.删除my.ini中最后一句：skip-grant-tables

9.重启mysql

net stop mysql

net start mysql