Off-topic: I haven’t installed mysql for a long time. I bought a new computer today and reinstalled it. It’s really tiring, so I wrote a tutorial to avoid forgetting it in the future.
Enter the formal tutorial below:
Step 1: Download the latest MySQL file and unzip it :
Download the latest version of MySQL–mysql-5.7.12 download
Unzip the downloaded file to your favorite location, for example, my location is D:\MySQL\mysql-5.7.12-winx64
Step 2: Configure environment variables
Not much to say here, just configure the bin directory under the path.
Step 3: Add configuration file
Directly copy the my-default.ini file under the decompression path, rename it to my.ini and edit it The content of this file is as follows:
[mysqld]basedir=D:\MySQL\mysql-5.7.12-winx64\datadir=D:\MySQL\mysql-5.7.12-winx64\data\port=3306
There are two main issues that need to be noted here:
1. basedir is the decompression of your mysql file above path.
2. Create a new empty folder named data under the path, which is datadir.
Step 4: Initialize the database and configure the service
Before doing this step, you must pay attention to two issues! ! ! Remember! ! !
First: Open CMD as an administrator;
Second: Use the cd command to enter the decompression path of your MySQL file!
Then executemysqld --initialize --user=mysql --console
After successful execution, after the printed text The last part is the initial password of the database. Remember to copy it, select it with the mouse, press Enter and find a place to ctrl+v.
After completing the above, open CMD as an administrator and execute mysqld --install MySQL
–>Add to System servicenet start mysql
–>Start mysql service
Step 5: Modify mysql Initial password
1. Open CMD and execute: mysql -u root -p
2. Enter what you just entered The initial password for the saved database.
3. Execute set password = password(‘***NewPassword***‘);
Just enter your own new password in the position of NewPassword.
This is all over, let’s start using it.
Recommended related articles:
Detailed steps to install MySQL 5.7.12 under CentOS 6.5 (pictures and text)
mysql 5.7.12 win64 Manual installation tutorial steps (pictures and text)
The above is the detailed content of Mysql-5.7.12 decompressed version installation steps tutorial. For more information, please follow other related articles on the PHP Chinese website!

MySQLviewshavelimitations:1)Theydon'tsupportallSQLoperations,restrictingdatamanipulationthroughviewswithjoinsorsubqueries.2)Theycanimpactperformance,especiallywithcomplexqueriesorlargedatasets.3)Viewsdon'tstoredata,potentiallyleadingtooutdatedinforma

ProperusermanagementinMySQLiscrucialforenhancingsecurityandensuringefficientdatabaseoperation.1)UseCREATEUSERtoaddusers,specifyingconnectionsourcewith@'localhost'or@'%'.2)GrantspecificprivilegeswithGRANT,usingleastprivilegeprincipletominimizerisks.3)

MySQLdoesn'timposeahardlimitontriggers,butpracticalfactorsdeterminetheireffectiveuse:1)Serverconfigurationimpactstriggermanagement;2)Complextriggersincreasesystemload;3)Largertablesslowtriggerperformance;4)Highconcurrencycancausetriggercontention;5)M

Yes,it'ssafetostoreBLOBdatainMySQL,butconsiderthesefactors:1)StorageSpace:BLOBscanconsumesignificantspace,potentiallyincreasingcostsandslowingperformance.2)Performance:LargerrowsizesduetoBLOBsmayslowdownqueries.3)BackupandRecovery:Theseprocessescanbe

Adding MySQL users through the PHP web interface can use MySQLi extensions. The steps are as follows: 1. Connect to the MySQL database and use the MySQLi extension. 2. Create a user, use the CREATEUSER statement, and use the PASSWORD() function to encrypt the password. 3. Prevent SQL injection and use the mysqli_real_escape_string() function to process user input. 4. Assign permissions to new users and use the GRANT statement.

MySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand

ToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith

ToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters


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

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

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

Zend Studio 13.0.1
Powerful PHP integrated development environment

Notepad++7.3.1
Easy-to-use and free code editor
