-
第一步:去官网下载压缩包这个很简单,就不再赘述了 ,然后解压到一个合适的地方,我是直接在C盘解压的。
-
第二步:配置环境变量 找到这个位置 C:\Program Files (x86)\Mysql\mysql-5.7.17-winx64\bin。你自己解压到什么地方就是哪个位置 。这是相对与我的电脑而言的,然后在系统变量的path中加上这个值。
-
第三步:就是配置对应的my.ini文档,注意:5.7.17是有默认文档的,可以复制粘贴然后改为my.ini然后放入bin目录下
-
不放入Bin目录会出错,反正我自己老是出问题。具体配置如下:
-
# 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 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 = C:\Program Files (x86)\Mysql\mysql-5.7.17-winx64 datadir = C:\Program Files (x86)\Mysql\mysql-5.7.17-winx64\data port = 3306 character-set-server=utf8 # server_id = ..... [client] port=3306 character-set=utf8 # 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 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
-
第四步:在mysql根目录下新建data文件夹,安装前务必保证data为一个空文件夹。不新建也会出错的。
-
第五:初始化以及安装步骤 :
以管理员身份运行cmd命令
输入cd G:\Program Files\MySQL\MySQL Server 5.7\bin进入bin目录下
输入mysqld --initialize --user=mysql --console
记下最后一行产生的随机密码
接着输入mysqld --install
成功会显示Servers Successfully installed
控制台下输入net start mysql 启动mysql服务
-
可使用mysql -uroot -p命令来登录数据库,密码为上一步中生成的随机密码
-
第六步: 修改初始密码,按照随机密码登陆的很多操作不能进行。会报错:
mac mysql error You must reset your password using ALTER USER statement before executing this statement.
需要按照以下操作改密码: -
step 1: SET PASSWORD = PASSWORD('your new password');
step 2: ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
step 3: flush privileges;
完成以上三步退出再登,使用新设置的密码就行了,以上除了红色的自己修改成新密码外,其他原样输入即可
mysql 5.7.17解压缩版本安装过程
最新推荐文章于 2022-08-28 01:56:48 发布