search
HomeDatabaseMysql TutorialGraphical tutorial on installing Mysql5.7.17 under win10 system

Because I wanted to install Mysql on the company computer, I downloaded the latest version of Mysql-5.7.17 from the official website. In fact, the installation method is also very simple. Here is the editor Share the installation process to the Script Home platform for your reference

Operating system win10 MySQL is the 64-bit zip decompression Community version downloaded from the official website.

Because I wanted to install Mysql on the company computer, I downloaded the latest version of Mysql-5.7.17 from the official website. First, install it through the online tutorial, decompress it, and then create a new Mysql0104 directory on the C drive ( As the installation directory of Mysql), copy the contents of the decompressed Mysql-5.7.17 folder to the installation directory Mysql.

The content of the file is as follows:

Graphical tutorial on installing Mysql5.7.17 under win10 system

Then follow the online guide: run the command line window as an administrator, mysqld -install to install mysql; this step is not theoretically possible Any problem with normal installation. There will be feedback that the installation has been successful (I forgot to take a screenshot at this step)

In order to avoid subsequent unsuccessful installation, set up the configuration file first, right-click on the MyPC computer, select Properties, click to enter and select Advanced System settings Advanced system settings, click to enter and select Environment Variables, select System variables selected in the red box in the figure below, New adds a system variable MYSQL_HOME, the value is the installation path of mysql, on my computer the value is: C:\mysql0104 , then click Path (generally there will be PATH on the computer, if not, create it yourself), then copy and paste the string of values ​​​​;%MYSQL_HOME%\bin, and the environment variables will be configured, as shown in the figure below.

Graphical tutorial on installing Mysql5.7.17 under win10 system

Graphical tutorial on installing Mysql5.7.17 under win10 system

Graphical tutorial on installing Mysql5.7.17 under win10 system

# Next, you need to perform some installation and configuration of mysql. It's not the same as the old version. Because there is no data file under the mysql0104 folder, we need the system to generate it.

So run the command line window as administrator. Use the cd command to switch directories and make sure the directory is under the bin directory (an error may occur under the system directory, but I have not tried it). Enter the command in the bin directory:

mysqld --initialize

Also available online Say input command:

mysqld --initialize -insecure I have tried both methods, both of which generate a data folder with an empty password. (It is also said on the Internet that a string of passwords will be generated through mysql-console and the like, which need to be written down. It feels very complicated, so don’t bother with it. Just follow the instructions above)

I am also at this step There have been several errors. If an error occurs, just delete the data folder. Then run this line of code again.

But if there is a data folder, an error will definitely be reported when running the above initialization command.

Initialization is very important. After executing the initialization command, the following files will be newly generated in the empty data directory:

Graphical tutorial on installing Mysql5.7.17 under win10 system

Some people on the Internet said that they can be copied Put the data files in the old version of mysql into the installation directory, so that there is no need for system generation. However, I have seen many people saying that this method will cause many problems, so it is not recommended to use it. After all, different versions of

UpdateThere should be some differences in the contents of the data folder.

The next step is to start the mysql service, which is net start mysql. Theoretically, it should start successfully, but mine keeps reporting errors. And it was still an unexplained error. I struggled with this step for a long time, and later found out that in fact, this command does not care about the feedback at all, because as long as the database can operate normally, there will be no other problems.

Graphical tutorial on installing Mysql5.7.17 under win10 system

Don’t worry about it at all, let’s see if our mysql is actually installed successfully:

In the command Enter in the line:

mysql -uroot to enter the database (provided that the password has not been modified and is still empty)

Graphical tutorial on installing Mysql5.7.17 under win10 system

Look, the system feedback has actually been After successfully logging into the database, you can then operate through some commands, such as:

show databases; create test; use test; and a series of commands. Remember to add a semicolon to operate, and a semicolon at the end! !

Graphical tutorial on installing Mysql5.7.17 under win10 system

Then you can create tables in the database normally, query, insert, delete, etc., and the mysql environment will be installed.

The above is the detailed content of Graphical tutorial on installing Mysql5.7.17 under win10 system. For more information, please follow other related articles on the PHP Chinese website!

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
win10中提示80070035找不到网络路径怎么办win10中提示80070035找不到网络路径怎么办May 12, 2023 pm 05:17 PM

win10中提示80070035找不到网络路径的解决办法:1、单击“网络”,“打开网络和Internet设置”,选择“网络和共享中心”后再选择“更改高级共享设置”,然后勾选“启用共享以便可以访问网络的用户读取公用文件夹中的文件”;2、返回“网络和共享中心”单击“宽带连接”并选择“属性”,点击“网络”,勾选“microsoft网络客户端”即可。

win10找不到网络适配器驱动怎么办win10找不到网络适配器驱动怎么办Jul 06, 2023 pm 12:00 PM

win10找不到网络适配器驱动的解决办法:1、更新驱动程序,可以使用设备管理器来更新驱动程序;2、重新安装驱动程序,先卸载设备,再重启电脑;3、从制造商网站下载驱动程序;4、检查硬件故障。

win10自带的看图软件叫什么win10自带的看图软件叫什么Oct 18, 2022 pm 02:48 PM

win10自带的看图软件叫“Microsoft照片”,其下载方法是:1、打开win10电脑;2、在Microsoft Store中搜索“Microsoft照片”并下载;3、将照片查看器的默认软件设置为【照片】即可。

win10任务栏经常假死的原因是什么win10任务栏经常假死的原因是什么Jun 19, 2023 am 10:37 AM

win10任务栏经常假死的原因是win10 64位系统可靠性不佳造成的,其解决方法:1、重启“windows资源管理器”;2、卸载冲突软件;3、重新“部署操作进程”;4、修复系统服务;5、通过powershell命令尝试修复;6、cmd中执行修复命令;7、针对右击任务栏应用图标时弹出菜单缓慢的情况;8、通过新建Windows用户来重置系统设置;9、还原系统。

win10底部任务栏无响应怎么办win10底部任务栏无响应怎么办Mar 17, 2023 am 11:47 AM

解决方法:1、先重启“Windows资源管理器”;然后以管理员身份运行powershell,执行命令重新部署进程;最后在“个性化”设置界面中,关闭加载最常访问列表功能。2、打开powershell窗口,利用命令检查并修复Windows文件。3、打开“本地组策略编辑器”,进入“内置管理员帐户的管理员批准模式”的属性窗口;然后在“本地安全设置”选项卡中,点击“启用”;最后重启电脑。

win10更新后无法上网怎么办win10更新后无法上网怎么办Jun 21, 2023 pm 01:58 PM

win10更新后无法上网解决方法:1、检查网络连接,使用其他设备连接同一网络来确认网络是否可用;2、检查网络驱动程序,找到网络适配器,并检查是否有任何驱动程序更新可用;3、重置网络设置,打开“命令”窗口,输入“netsh winsock reset”和“netsh int ip reset”,然后重启;4、更新网络驱动程序;5、检查防火墙和安全软件设置,暂时禁用重新连接即可。

4g内存win10够用吗4g内存win10够用吗Mar 15, 2023 pm 02:28 PM

不够用。虽然4G内存足够满足Windows 10系统的安装需求,但问题是不可能只在电脑里安装一个系统,还要安装其他应用,而这些应用也会占用一定的内存空间;先不考虑CPU、硬盘和显卡等配件是否能够满足需求,只单独说内存,假设用户安装的Windows 10系统占用了2G内存,但其他的辅助插件和应用可能还会占去2G内存,一旦内存被占满,必然会导致电脑出现卡顿、运行慢的情况。

win10右键没有管理员权限怎么办win10右键没有管理员权限怎么办Feb 21, 2023 pm 04:22 PM

win10右键没有管理员权限的解决办法:1、在电脑桌面右键点击“此电脑”;2、在弹出的列表中找到“管理”,点击打开;3、依次选取“系统工具”->“本地用户和组”->“用户”;4、在中间栏找到并点击打开“Administrator”;5、取消勾选“账户已禁用”,然后点击“应用”和“确定”即可。

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools