search
HomeDatabaseMysql TutorialDetailed tutorial on MySql installation and uninstallation
Detailed tutorial on MySql installation and uninstallationJan 06, 2018 pm 01:49 PM
mysqlTutorialdetailed

This article mainly introduces you to the detailed tutorial of MySql installation and uninstallation. It has certain reference value. Interested friends can refer to it. I hope it can help you.

1. MYSQL installation

1. Open the downloaded mysql installation file and double-click to run mysql-5.5.40-win32.msi.

2. Select the installation type. There are three options: "Typical (default)", "Complete (complete)" and "Custom (user-defined)". Select "Custom" and press "next" ” key to continue.

3. Left-click on "Developer Components" and select "This feature,
and all subfeatures, will be installed on local hard drive.", that is, "This section, and the contents of its subsections, are all installed on the local hard drive." Do the same with "MySQL Server (mysql server)", "Client Programs (mysql client program)", and "Documentation (documentation)" above to ensure that all files are installed. Click "Change..." to manually specify the installation directory.

4. Fill in the installation directory. Mine is "E:\software\install\mysql\". It is also recommended not to put it in the same partition as the operating system. This can prevent system backup and restore. , the data is cleared. Press "OK" to continue.

Confirm the previous settings. If there are errors, press "Back" to return and redo. Press "Install" to start the installation.

5. Installation is in progress, please wait. After the installation is completed, a success interface will appear. After clicking "next" successfully, the following interface will appear.

Here you are asked whether to continue configuring the parameters of MySQL data, check it, and then click "Finish"

2. MYSQL configuration

1. After the installation is completed, the following interface will appear and you will enter the mysql configuration wizard.

2. Select the configuration method, "Detailed Configuration (manual precise configuration)", "Standard Configuration (standard configuration)", we select "Detailed Configuration" to facilitate familiarity with the configuration process.

3. Select the server type, "Developer Machine (development and testing class, mysql takes up few resources)", "Server Machine (server type, mysql takes up more resources)", "Dedicated MySQL Server Machine (specialized database server, mysql occupies all available resources)"

4. Select the general purpose of the mysql database, "Multifunctional Database (universal multi-functional, good)", "Transactional Database Only ( Server type, focused on transaction processing, general)", "Non-Transactional Database Only (non-transactional, relatively simple, mainly used for some monitoring and counting, support for MyISAM data types is limited to non-transactional), press "Next" to continue.

5. Select the number of concurrent connections to the website and the number of simultaneous connections, "Decision Support (DSS)/OLAP (about 20)", "Online Transaction Processing (OLTP)" (About 500)", "Manual Setting (manual setting, enter a number yourself)".

6. Whether to enable TCP/IP connection and set the port. If not enabled, you can only Access the mysql database on your own machine. On this page, you can also select "Enable Strict Mode" so that MySQL will not allow minor syntax errors. If you are a novice, it is recommended that you cancel the standard mode. Reduce trouble. But after becoming familiar with MySQL, try to use the standard mode, because it can reduce the possibility of harmful data entering the database. Press "Next" to continue

7, which is to set the default database language encoding of MySQL. (Important), generally select UTF-8 and press "Next" to continue.

8. Choose whether to install mysql as a windows service. You can also specify the Service Name (service identification name) and whether to install mysql as a windows service. The bin directory is added to Windows PATH (after adding it, you can directly use the files under bin without pointing out the directory name, such as connecting, "mysql.exe -uusername -ppassword;" is enough, without pointing out the complete name of mysql.exe Address, very convenient), I checked all the boxes here, and the Service Name remains unchanged. Press "Next" to continue.

9. Ask if you want to change the password of the default root user (super administrator). "Enable root access from remote machines (whether to allow root users to log in on other machines, if you want security, don't check it, if you want convenience, check it)". Finally, "Create An Anonymous Account (create a new anonymous user, anonymous users can connect to the database, but cannot operate data, including queries)". Generally, there is no need to check it. After the settings are completed, press "Next" to continue.

The username and password are set to:
Username: root
User password: root

10. Confirm that the settings are correct, and press "Execute" to enable The settings take effect, that is, the installation and configuration of MYSQL is completed.

Note: After setting up, there is a common error after pressing "Finish", that is, you cannot "Start service", which usually occurs on servers where mysql has been installed before. The solution is to first ensure that the previously installed mysql server is completely uninstalled; if not, check whether the previous password has been modified as mentioned in the step above, and follow the above operations; if it still does not work, change the data in the mysql installation directory Back up the folder and then delete it. After the installation is completed, delete the data folder generated by the installation, move the backed up data folder back, and then restart the mysql service. In this case, you may need to check the database, and then Repair it once to prevent data errors.

3. Uninstall

How to completely delete the MySQL database, the following operations take the Window7 operating system as an example:

1) Stop the MySQL service of window.
Find "Control Panel"-> "Management Tools"-> "Services" and stop the MySQL background service.
2) Uninstall the MySQL installer. Find "Control Panel" -> "Programs and Features" and uninstall the MySQL program.
3) Delete all files in the MySQL installation directory.
4) Delete the MySQL directory in the ProgramData hidden directory on drive c.
4.1 Turn on the "Show hidden files" function of the window system to view all hidden files in the system
4.2 Find the ProgramData directory
4.3 Delete the MySQL directory

Related recommendations:

Tutorial on how to install and configure the decompressed version of MySql under windows 10

Mysql installation method in CentOS

MySQL installation Detailed graphic explanation of encoding settings

The above is the detailed content of Detailed tutorial on MySql installation and uninstallation. 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
图文详解mysql架构原理图文详解mysql架构原理May 17, 2022 pm 05:54 PM

本篇文章给大家带来了关于mysql的相关知识,其中主要介绍了关于架构原理的相关内容,MySQL Server架构自顶向下大致可以分网络连接层、服务层、存储引擎层和系统文件层,下面一起来看一下,希望对大家有帮助。

mysql怎么替换换行符mysql怎么替换换行符Apr 18, 2022 pm 03:14 PM

在mysql中,可以利用char()和REPLACE()函数来替换换行符;REPLACE()函数可以用新字符串替换列中的换行符,而换行符可使用“char(13)”来表示,语法为“replace(字段名,char(13),'新字符串') ”。

mysql的msi与zip版本有什么区别mysql的msi与zip版本有什么区别May 16, 2022 pm 04:33 PM

mysql的msi与zip版本的区别:1、zip包含的安装程序是一种主动安装,而msi包含的是被installer所用的安装文件以提交请求的方式安装;2、zip是一种数据压缩和文档存储的文件格式,msi是微软格式的安装包。

mysql怎么去掉第一个字符mysql怎么去掉第一个字符May 19, 2022 am 10:21 AM

方法:1、利用right函数,语法为“update 表名 set 指定字段 = right(指定字段, length(指定字段)-1)...”;2、利用substring函数,语法为“select substring(指定字段,2)..”。

mysql怎么将varchar转换为int类型mysql怎么将varchar转换为int类型May 12, 2022 pm 04:51 PM

转换方法:1、利用cast函数,语法“select * from 表名 order by cast(字段名 as SIGNED)”;2、利用“select * from 表名 order by CONVERT(字段名,SIGNED)”语句。

MySQL复制技术之异步复制和半同步复制MySQL复制技术之异步复制和半同步复制Apr 25, 2022 pm 07:21 PM

本篇文章给大家带来了关于mysql的相关知识,其中主要介绍了关于MySQL复制技术的相关问题,包括了异步复制、半同步复制等等内容,下面一起来看一下,希望对大家有帮助。

带你把MySQL索引吃透了带你把MySQL索引吃透了Apr 22, 2022 am 11:48 AM

本篇文章给大家带来了关于mysql的相关知识,其中主要介绍了mysql高级篇的一些问题,包括了索引是什么、索引底层实现等等问题,下面一起来看一下,希望对大家有帮助。

mysql怎么判断是否是数字类型mysql怎么判断是否是数字类型May 16, 2022 am 10:09 AM

在mysql中,可以利用REGEXP运算符判断数据是否是数字类型,语法为“String REGEXP '[^0-9.]'”;该运算符是正则表达式的缩写,若数据字符中含有数字时,返回的结果是true,反之返回的结果是false。

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尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

EditPlus Chinese cracked version

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function

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

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

mPDF

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),