DatabaseMysql TutorialDetailed introduction to the installation and configuration steps of mysql5.6.21 (pictures and texts)
This article mainly introduces mysql5.6.21 installation and configuration The detailed steps of have certain reference value. Interested friends can refer to
1. Overview
MySQL version: 5.6.21
Client tool: NavicatforMySQL
2. MySQL installation
1. The file name of MySQL after downloading is: mysql_installer_community_V5.6.21.1_ setup.1418020972.msi, the diagram is as follows:
2. After double-clicking, the following window will pop up: (If the system prompts, select Allow)
3. Installation start interface
4. Check I accept the license terms, as shown below:
5. Select Next and the following window will pop up:
The options are as follows: install all including development environment, install only sever, only install client, install all but not Including development environment, customization
If When such a prompt appears, you can select the project to see if there is an uninstalled environment
#This is where the vc++2013 environment is not installed. .
8. After the installation is complete, next step
##13 ,
type and port number, the default is
14. Fill in the Root user password, please remember the password
15. Fill in the password
16. Set the user and service to start up. The default is
17. Confirm the configuration
18. During the process of confirming the configuration,
, the diagram is as follows:
19. Complete configuration
20.Complete
21. Installation completed
1. Open the command line window
2. Enter the password
3. Enter the Root password and press Enter
4. Display MySQL>input mark
5. Enter the command to display all databases: show databases; There must be a semicolon and press Enter
6. Display the four default databases of the system
4. Download and use of NavicatforMySQL
1. The downloaded file name is: NavicatforMySQL .zip, the diagram is as follows:
2. Unzip it to the D drive, the diagram is as follows:
3. Execution file Schematic diagram:
4. Double-click to display the main interface
5. Install the input in the downloaded file
6. Main interface
7.Connect to databaseConfiguration
8. Enter the Root password
9. Display the connection
10. All database details
#11. Right-click and select Run SQL file...
12. Select the SQL to run File
#13. The database table execution file selected here is executed after clicking Start.
#14. Display the execution result and close it successfully.
15. Run the user SQL file
The above is the detailed content of Detailed introduction to the installation and configuration steps of mysql5.6.21 (pictures and texts). For more information, please follow other related articles on the PHP Chinese website!
MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AMMySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand
MySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AMToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith
MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AMToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters
MySQL: String Data Types and ENUMs?May 13, 2025 am 12:05 AMMySQloffersechar, Varchar, text, Anddenumforstringdata.usecharforfixed-Lengthstrings, VarcharerForvariable-Length, text forlarger text, AndenumforenforcingdataAntegritywithaetofvalues.
MySQL BLOB: how to optimize BLOBs requestsMay 13, 2025 am 12:03 AMOptimizing MySQLBLOB requests can be done through the following strategies: 1. Reduce the frequency of BLOB query, use independent requests or delay loading; 2. Select the appropriate BLOB type (such as TINYBLOB); 3. Separate the BLOB data into separate tables; 4. Compress the BLOB data at the application layer; 5. Index the BLOB metadata. These methods can effectively improve performance by combining monitoring, caching and data sharding in actual applications.
Adding Users to MySQL: The Complete TutorialMay 12, 2025 am 12:14 AMMastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.
Mastering MySQL String Data Types: VARCHAR vs. TEXT vs. CHARMay 12, 2025 am 12:12 AMChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic
MySQL: String Data Types and Indexing: Best PracticesMay 12, 2025 am 12:11 AMBest practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.
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
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.
EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function
VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft
ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment
PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool
