Mysql初次安装后怎么修改密码

梦里梦外; 2024-04-19 06:26 74阅读 0赞

Mysql下载地址：[https://dev.mysql.com/downloads/mysql/][https_dev.mysql.com_downloads_mysql]

根据电脑位数下载相应的zip文件包（还有.msi的文件，那个安装过程略）

配置好相应变量后，安装mysql：mysqld -install 并初始化：mysqld --initialize

启动Mysql:

![20190915001946430.png][]

在mysql根目录下的my.ini下\[mysqld\]下添加一句代码 “skip-grant-tables”如下：

[client]
    
    port=3306
    default-character-set=utf8
    
    [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.
    
    character-set-server = utf8
    port = 3306
    
    bind-address = 127.0.0.1
    
    basedir=D:\mysql-5.7.27-winx64
    
    # 设置为MYSQL的数据目录 
    datadir=D:\mysql-5.7.27-winx64\data
    
    
    #开启查询缓存
    explicit_defaults_for_timestamp=true
    
    skip-grant-tables

保存后，再重新启动MySQL。

登入mysql：在输入密码一栏，直接回车跳过，便会自动跳过输密码直接进入。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hfdHJ1c2hlcg_size_16_color_FFFFFF_t_70][]

之后执行以下语句（不要忘了加分号！）

![20190915002736357.png][]

若出现下面的错误

![2019091500283860.png][]

解决办法：先执行 flush privileges; 再执行一次上次指令即可，如下：

![2019091500312576.png][]

然后退出，将my.ini中的 skip-grant-tables 删除掉，保存，然后重启Mysql，再次登录便需要密码。

[https_dev.mysql.com_downloads_mysql]: https://dev.mysql.com/downloads/mysql/
[20190915001946430.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/fb546af2a3fb4206bab109beb88592b4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hfdHJ1c2hlcg_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/18701b09280a43debee5f2c6a0300935.png
[20190915002736357.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/09fdaa245faa41ec995b48939c2ac9a0.png
[2019091500283860.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/edc000c9766d48cfa0c4c145ffc1a494.png
[2019091500312576.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/028422ea7a9740a18751c13363b8a9a2.png