MySQL is one of the most popular relational database management systems currently. Both developers and system administrators need to install MySQL on their computers or servers. However, for some users who need to update frequently or use it on multiple computers, it seems a bit cumbersome to install and configure MySQL every time. To solve this problem, MySQL provides an installation-free version. The following is how to configure the installation-free version of MySQL.
First, you need to download the installation-free version of the MySQL compressed package from the MySQL official website. On the official website, select the "Download" button to enter the download page.
Select the required operating system, such as Windows system, you can select Windows Zip/Setup.EXE to download the installation-free version of MySQL compressed package.
After the download is complete, unzip the compressed package to any folder. You can choose C drive or other disks, just make sure there are no special characters such as Chinese in the MySQL directory.
Before opening MySQL, you need to configure it through environment variables, so that you can use MySQL directly in any folder.
First, find the "Advanced System Settings" interface in the computer's property settings. On this page, find "Path" in "System Variables" in the "Environment Variables" button below, and click "Edit".
In the pop-up interface, select "New", enter the installation path of MySQL, such as "D:mysql-5.7.24-winx64 in" and save it.
After decompression is completed, you need to modify the MySQL configuration file to ensure the normal operation of MySQL.
First, find the my.ini configuration file in the MySQL directory. You can use Notepad or other text editor to open the file. Find the "[mysqld]" section in the file and add the following options in this section.
basedir = D:/mysql-5.7.24-winx64
datadir = D:/mysql-5.7.24-winx64/data
These two items set the MySQL installation directory respectively. and data directory.
After editing the configuration file, you need to initialize MySQL and create the necessary databases and users. Open a command prompt and enter the following command.
D:mysql-5.7.24-winx64 in> mysqld --initialize-insecure --user=mysql
This command will initialize MySQL and create user "mysql".
Enter the following command to start the MySQL service.
D:mysql-5.7.24-winx64 in> net start mysql
If an error occurs during startup, you can check the error log for troubleshooting.
Use the following command to log in to MySQL.
D:mysql-5.7.24-winx64 in> mysql -u root -p
After entering the password, you can log in to MySQL.
Note: If the MySQL default root account already has a password, you need to use that password to log in.
Now MySQL has been successfully installed and can be managed and operated using various MySQL commands. After configuring the environment variables, you can enter commands directly in any folder.
Summary
Through the installation and configuration of the installation-free version of MySQL, you can omit the installation and uninstallation of MySQL, reducing the difficulty and time cost of use. It should be noted that the data used by the installation-free version of MySQL is stored locally and does not support external connections, so it is only suitable for small scenarios such as personal computers or development and testing servers. For large enterprise applications or systems that require external access, they still need to be managed through formal MySQL installation and configuration.
The above is the detailed content of Installation-free version of mysql configuration. For more information, please follow other related articles on the PHP Chinese website!