Mysql初次安装后怎么修改密码 梦里梦外; 2024-04-19 06:26 15阅读 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
还没有评论,来说两句吧...