mysql 配置安装和 root password 更改

第一步：

修改my.ini文件，替换为以下内容（skip_grant_tables***重点）

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html 

# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the

# *** default location during install, and will be replaced if you

# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at % of total RAM for dedicated server, else %.

# 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 = .....

# datadir = .....

# port = .....

# server_id = .....

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M 

#########################################################

    [client]

    port=

    default-character-set=utf8

    [mysqld]

    skip_grant_tables

    port=

    character_set_server=utf8

    basedir=E:\mysql-5.7.-winx64

    #解压目录

    datadir=E:\mysql-5.7.-winx64\data

    #解压目录下data目录

    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

    [WinMySQLAdmin]

    E:\mysql-5.7.-winx64\bin\mysqld.exe

########

第二步：

进入到MySQL的安装目录，按 shift+(鼠标右键) 点击命令行窗口使用mysqld --initialize 进行初始化（会在安装目录下创建一个data文件夹）

第三步：

在安装目录文件夹下进入命令行模式 shift+(鼠标右键) 使用 net start mysql 启动服务

使用 mysql -uroot -p无密码登录

进入之后

mysql> use mysql;

mysql> update user set authentication_string=password("123") where user="root";（别忘了最后加分号)

mysql>flush privileges;

mysql>quit;

第四步：

进入my.ini文件将skip_grant_tables注释

重新进入命令行

net stop mysql

net start mysql (重新启动服务)

mysql -uroot -p

(使用更改后的密码登录)

succeed;

************************************************************************************************************************

最后温馨提示：如果net start mysql 提示无法启动服务，且没有提示错误可以将 data 文件夹删除重新初始化启动一下

巴特西

mysql 配置安装和 root password 更改

最新文章

热门文章

巴特西

mysql 配置 安装和 root password 更改

最新文章

热门文章

mysql 配置安装和 root password 更改