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:
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.
mysqld --initialize
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)
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: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.Don’t worry about it at all, let’s see if our mysql is actually installed successfully:
mysql -uroot to enter the database (provided that the password has not been modified and is still empty)
show databases; create test; use test; and a series of commands. Remember to add a semicolon to operate, and a semicolon at the end! !
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!

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

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

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

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

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

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

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

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


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Zend Studio 13.0.1
Powerful PHP integrated development environment

SublimeText3 English version
Recommended: Win version, supports code prompts!

Dreamweaver Mac version
Visual web development tools

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools