Environment: windwos 10 (1511) 64bit, mysql 5.7.14
1. Download mysql
1. Open the official website of mysql in the browser http://www.mysql.com/
2. Go to "Downloads" at the top of the page
3. Open “Community(GPL) Downloads” at the bottom of the page
4. Find the download page "MySQL on Windows (Installer & Tools)" that we want to use on windows in the middle of the page
5. Select the first item "MySQL Installer"
6. Find the download entrance "Windows (x86,
32-bit), MSI Installer" at the bottom of the page, click the Download button to start the download, a total of 381.4M
Note: MSI format refers to the Windows installation program. After downloading, you can directly double-click to enter the installation wizard. It is different from the installation method of decompressing the file;
7. This page will ask you whether you are logged in and tell you what benefits you will get after logging in. We do not log in. Click the "No thanks, just start my download." button at the bottom of the page to enter the download page
8. Start downloading and wait for the download to complete (because the direct download speed is too slow, I later downloaded it using Thunder)
9. Download completed
2. Install mysql
1. Double-click the downloaded mysql installation file "mysql-installer-community-5.7.14.0.msi" to open the installation program. You need to wait a moment after opening
2. Select the installation type (according to personal needs)
3. I only need to install mysql server, so select the last item "Custom". After selecting Custom, the installation process on the left and the description text on the right will change, then click the "Next" button to continue
4. Here we need to select the mysql server we need from the installable products (Products) provided by the installer
We expand the first item "MySQL Servers" in Available Products and expand its sub-nodes in order until its terminal node. My operation is 64-bit, so I selected "MySQL Server 5.7.14 - X64"
Then click the green right arrow to move the current Product to the list that needs to be installed, then expand the "MySQL Server 5.7.14 - X64" item on the right and uncheck "Development Components" (because we only need to install mysql server) , then click the "Next" button to proceed to the next step
5. Click "Execute" to start the installation. During the installation process, the Progress of the installation will be displayed. After the installation is completed, the Status will display Complete. A green check will appear in front of the mysql icon, and then click the "Next" button. Enter the product configuration interface
6. Click the "Next" button to enter the configuration of MySQL Server
Select "Development Machine" for Config Type. Selecting this option will use smaller content to run our mysql server, which is sufficient for small software and learning. "Next"
Set the password of the database root account in Root Account Password. I filled in 123456, so the program reminded me that the password strength is weak. We need to remember this password and click "Next"
Here you can set the name of the mysql server and whether to start it at startup. I changed the name to "MySQLZzz1" and canceled the startup. No other changes were made. Click "Next"
Click "Next"
This interface applies the previously set configuration content to our mysql server, click "Execute" and wait for completion
Configuration is complete, click "Finish" to complete the configuration process
7. After the configuration is completed, we will return to the installation program, we click "Next" to continue
It prompts us that the installation is complete, click "Finish"
8. After clicking "Finish" in the previous step, the computer is so calm that people don't know what to do next! According to past experience in installing software, the computer should automatically start the newly installed software at this time. So I searched in the process and found no process similar to mysql, so let's go to the next step.
3. Configure mysql environment variables (not necessary)
Note: After configuring environment variables for mysql, we can run mysql in cmd (start, stop, etc.)
1. In the same way as the actual environment variable configuration, we open the environment variable configuration window (key combination win+Pause -> Change settings -> Select "Advanced" in the system properties -> Environment variables)
2. Select "path" in the system variable, enter the path of the bin folder in the mysql installation directory at the beginning of the path value: C:Program FilesMySQLMySQL Server 5.7bin, save and exit
Note: The default path for mysql server installation is: C:Program FilesMySQLMySQL Server 5.7
3. Test whether the configuration is successful: open cmd, enter "mysql -u root -p" and press Enter, then enter the password of the root account (123456) set during mysql installation. If it prompts "Welcome to the MySQL monitor.", explain the configuration. It worked.
4. Start mysql
Yes, we haven’t started our mysql yet! So how to start it?
(based on configured environment variables)
1. Run cmd as administrator and enter "net start mysqlzzz1" (MySQLZzz1 is the server name filled in when configuring mysql server. It can also be used in cmd without case sensitivity)
2. After prompting that the startup is successful, we can see the "mysqld.exe" process in the process of the task manager.
Attachment:
If you are prompted when executing the command: The service name is invalid. Please type NET HELPMSG 2185 for additional help.
Solution: Execute the mysqld -install command with administrator privileges in the mysql bin directory
Attached is the method to uninstall the mysql service.
1. Use net stop mysql as administrator to close the mysql service
2. Use administrator rights mysqld -remove to uninstall the mysql service
5. Test whether the installation is successful
We use MySQL management software (Navicat for MySQL) to conduct connection testing to ensure that mysql is ready to use:
1. Open Navicat for MySQL
2. Create a new connection and fill in the connection information:
Connection name: used to distinguish different connections, just name it yourself
Hostname: localhost
Port: 3306
Username: root
Password: 123456 (the password filled in when configuring mysql before)
3. Click the "Connection Test" button and a successful connection dialog box will pop up, indicating that the mysql server has been started
4. Next is the use of Navicat for MySQL software
Another:
We can also enter "net start mysqlzzz1" again in cmd. If it prompts "The requested service has been started.", it means that the mysql server has started normally;
At this point, the installation of mysql server on Windows 10 64-bit is complete.

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、还原系统。

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

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

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

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


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

Atom editor mac version download
The most popular open source editor

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

SublimeText3 Linux new version
SublimeText3 Linux latest version

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment
