Database
Mysql Tutorial
Tutorial on how to install and configure the decompressed version of MySql under Windows 10
Tutorial on how to install and configure the decompressed version of MySql under Windows 10
This article mainly introduces the tutorial on the installation and configuration method of the decompressed version of MySql under Windows 10 in detail. It has certain reference value. Interested friends can refer to it. I hope it can help you.
Install the decompressed version of MySql database under windows 10
Step one:Extract the zip file to (my) D:\MyGreenSoftware\mysql-5.7.10- winx64
Step 2:Add environment variables (Windows 10 operating system): Right-click Computer->Properties->Advanced System Settings->Environment Variables Find path and edit path in Add ;D:\MyGreenSoftware\mysql-5.7.10-winx64\bin
at the end. Step 3: Add the configuration file in the directory where MySQL is decompressed (for example, mine is D: \MyGreenSoftware\mysql-5.7.10-winx64), find the my-default.ini file and add
(here you need to find it under D:\MyGreenSoftware\mysql-5.7.10-winx64\data Create a data folder)
[mysqld] basedir=D:\MyGreenSoftware\mysql-5.7.10-winx64 datadir=D:\MyGreenSoftware\mysql-5.7.10-winx64\data port = 3306
If the my-default.ini file is not found, create a my.ini file yourself (create it first A txt file, add the above four lines of code, save it and then change the file suffix to ini) Create a new text file txt and name it my.ini (note that the extension must also be modified).
Step 4: Initialize the database, open CMD as an administrator and execute the following command (enter cmd and right-click to run the following command as an administrator) mysqld –initialize –user= mysql –console
The console appears: [Note] A temporary password is generated for root@localhost: XXXXXXX
XXXXXX is a randomly generated password (copy it and save it) )
Step 5:Add MySQL to the system service, open CMD as an administrator and execute the following command
mysqld –install MySQL and then execute net start MySQL console appears The service starts successfully
Step 6:Change the password (the string just generated is a random string that is difficult to remember, so change it to one that is easy for you to remember)
Execute the command mysql -u root -p in the CMD console and press Enter. Enter the random password you just saved. After successful execution, the console will display mysql>
and then execute set password for root@localhost = password ('123456');
Your password has been changed to 123456
Related recommendations:
Detailed graphic explanation of encoding settings for MySQL installation
MySQL installation graphic and text explanation
Summary of issues regarding MySQL installation methods and configuration methods
The above is the detailed content of Tutorial on how to install and configure the decompressed version of MySql under Windows 10. For more information, please follow other related articles on the PHP Chinese website!
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
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1378
52
How to open phpmyadmin
Apr 10, 2025 pm 10:51 PM
You can open phpMyAdmin through the following steps: 1. Log in to the website control panel; 2. Find and click the phpMyAdmin icon; 3. Enter MySQL credentials; 4. Click "Login".
MySQL: An Introduction to the World's Most Popular Database
Apr 12, 2025 am 12:18 AM
MySQL is an open source relational database management system, mainly used to store and retrieve data quickly and reliably. Its working principle includes client requests, query resolution, execution of queries and return results. Examples of usage include creating tables, inserting and querying data, and advanced features such as JOIN operations. Common errors involve SQL syntax, data types, and permissions, and optimization suggestions include the use of indexes, optimized queries, and partitioning of tables.
Why Use MySQL? Benefits and Advantages
Apr 12, 2025 am 12:17 AM
MySQL is chosen for its performance, reliability, ease of use, and community support. 1.MySQL provides efficient data storage and retrieval functions, supporting multiple data types and advanced query operations. 2. Adopt client-server architecture and multiple storage engines to support transaction and query optimization. 3. Easy to use, supports a variety of operating systems and programming languages. 4. Have strong community support and provide rich resources and solutions.
phpmyadmin connection mysql
Apr 10, 2025 pm 10:57 PM
How to connect to MySQL using phpMyAdmin? The URL to access phpMyAdmin is usually http://localhost/phpmyadmin or http://[your server IP address]/phpmyadmin. Enter your MySQL username and password. Select the database you want to connect to. Click the "Connection" button to establish a connection.
phpMyAdmin comprehensive use guide
Apr 10, 2025 pm 10:42 PM
phpMyAdmin is not just a database management tool, it can give you a deep understanding of MySQL and improve programming skills. Core functions include CRUD and SQL query execution, and it is crucial to understand the principles of SQL statements. Advanced tips include exporting/importing data and permission management, requiring a deep security understanding. Potential issues include SQL injection, and the solution is parameterized queries and backups. Performance optimization involves SQL statement optimization and index usage. Best practices emphasize code specifications, security practices, and regular backups.
MySQL's Place: Databases and Programming
Apr 13, 2025 am 12:18 AM
MySQL's position in databases and programming is very important. It is an open source relational database management system that is widely used in various application scenarios. 1) MySQL provides efficient data storage, organization and retrieval functions, supporting Web, mobile and enterprise-level systems. 2) It uses a client-server architecture, supports multiple storage engines and index optimization. 3) Basic usages include creating tables and inserting data, and advanced usages involve multi-table JOINs and complex queries. 4) Frequently asked questions such as SQL syntax errors and performance issues can be debugged through the EXPLAIN command and slow query log. 5) Performance optimization methods include rational use of indexes, optimized query and use of caches. Best practices include using transactions and PreparedStatemen
Solution to MySQL encounters 'Access denied for user' problem
Apr 11, 2025 pm 05:36 PM
How to solve the MySQL "Access denied for user" error: 1. Check the user's permission to connect to the database; 2. Reset the password; 3. Allow remote connections; 4. Refresh permissions; 5. Check the database server configuration (bind-address, skip-grant-tables); 6. Check the firewall rules; 7. Restart the MySQL service. Tip: Make changes after backing up the database.
Oracle database uninstall tutorial
Apr 11, 2025 pm 06:24 PM
To uninstall an Oracle database: stop the Oracle service, remove the Oracle instance, delete the Oracle home directory, clear the registry key (Windows only), and delete the environment variables (Windows only). Please back up the data before uninstalling.
