In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Editor to share with you the operation steps of installing mysql5.1, I hope you will gain a lot after reading this article, let's discuss it together!
Installation steps: 1, download the mysql5.1 package on the official website and decompress it; 2, click to run the mysql5.1 installation program to enter the installation wizard interface, follow the instructions step by step, select the installation type, select the installation path, etc.; 3, click Install to start the installation; 4, after the installation is complete, you can proceed with the relevant configuration step by step through the instructions.
Mysql5.1 installation illustration tutorial
In order to build a simulation platform, to learn from mainland websites to Taiwan websites, one of the indispensable items is MySQL, which was widely used at that time, so I am used to using MySQL5.1 version!
Here is an installation diagram based on MySQL5.1. Download details can be found on the MySQL official website: http://www.mysql.com/
Or http://dev.mysql.com/downloads/mysql/
What appears is the welcome interface of the installation wizard, just like other windows installers!
Click "Next" directly, continue, and select the installation type
There are three types: Typical (typical), Complete (complete), and Custom (custom). Select "Custom" installation (default is Typical, it is recommended to change it to Custom, because Typical mode does not allow you to change the installation path, you can only install it on disk C.) Then click "Next" next and the custom installation interface appears.
To this point, you need to select the component and change the folder location. The component uses the default, and the location can be changed by selecting Change.
Note: the path where mysql is installed cannot contain Chinese! Everything is ready, click Install to start the installation, click "Install" to start the installation
After the installation, the narration screen appears and goes on to the next step.
Note that there is an option for the configuration wizard (Configure the MySQL Server now). It is recommended to check to configure your MySQL immediately. Many say that they cannot start after installing MySQL because MySQL is not configured. Click "Finish" to complete the installation and start configuring MySQL
Click "Next" to go to the configuration type selection page. Select "Detailed configuration" (detailed configuration)
Click "Next" to go to the service type selection page. Select "Developer Machine" (developer machine) so that it won't take up a lot of system resources. (the first kind is the development server, will use as little memory as possible, the second kind is the ordinary WEB server, will use the medium amount of memory, the last kind is this server above only runs the mysql database, will occupy all the memory, I am just an example here, choose the development server, occupy as little memory as possible, the user can choose other options according to their own needs (figure 11), click Next to continue. Machine memory first in the general election)
After clicking "Next", go to the database usage selection page. Select "Multifunctional Database".
The first is multi-functional use, will optimize the database into a good innodb storage type and efficient myisam storage type, the second is only used for transaction types, the best optimization innodb, but also supports myisam, the last is a non-transaction type, suitable for simple applications, only myisam types that do not support transactions are supported. Generally choose the first kind of multi-function.
Click "Next" to go to the page of selecting the location of InnoDB data. It defaults by default and does not need to be changed.
No need to change the setting, just put it in the Installation Path installation directory, and then click "Next" to select the number of simultaneous connections of MySQL.
(the first is a maximum of 20 concurrent connections, the second is a maximum of 500 concurrent connections, and the last one is custom, which you can choose according to your needs.)
Select "Manual Setting", set it to 100 (according to your needs, as appropriate), click "Next", and configure the port of MySQL in TCP/IP communication environment.
Select the default port 3306. Click "Next" and select the character setting in MySQL.
(you can also select enable Standard Mode (Enable Strict Mode) so that MySQL does not allow minor syntax errors. If you are still a novice, I suggest you cancel the standard mode to reduce hassle. However, once you are familiar with MySQL, try to use standard mode because it reduces the possibility of harmful data entering the database.)
Note that the choice here will affect whether you can use Chinese in MySQL. We chose more character sets supported by GBK. Click "Next" to set the Windows service options
Note that the choice here is critical. "Install As Windows Service" must be checked, this is to run MySQL as a Windows service. "Service Name" uses the default "MySQL" or your favorite service name (default "MySQL" is recommended). Be sure to check the "Launch the MySQL Server automatically" below so that MySQL will start the service automatically when Windows starts, otherwise MySQL will be started manually. Many people say that after installing MySQL, they can't start up, can't connect, and have a 10061 error. That's why. Click "Next" to set the login password for the root account root
This step is whether to set mysql as a windows service, generally choose to set it as a service, so that you can start and shut down the mysql database through the service later. Recommendation: check the check box below, too, so that in cmd mode, you don't have to execute commands other than to mysql's bin directory (figure 18).
"Modify Security Settings" is to set the password for the root account. Enter the password you set. "Create An Anonymous Account" is to create an anonymous account, which will cause unauthorized users to illegally access your database. It is recommended that you do not check this box. Click "Next" and the MySQL configuration wizard will configure MySQL according to all your above settings so that MySQL runs according to your needs
Click "Execute" to start the configuration. When "Service started successfully" appears, your configuration is complete and the MySQL service starts successfully.
Click "Finish" to complete the configuration of the entire MySQL, and all that is left is to connect to the MySQL server with a MySQL client and then use it.
After setting up, press "Finish" to end the installation and configuration of mysql-there is a common error here, that is, it cannot be "Start service", which generally occurs on servers where mysql has been installed before. The solution is to ensure that the previously installed mysql server is completely uninstalled; if not, check whether the previous password has been modified as mentioned in the above step, and follow the above operation. If it still fails, back up the data folder under the mysql installation directory, and then delete it. After the installation is complete, delete the data folder generated by the installation, move the backup data folder back, and then restart the mysql service. In this case, you may need to check the database and repair it again to prevent data errors.
Possible problems:
If you show up in step 16, the interface looks like this
Figure 22
There are three places to enter a password, and it is possible that you installed it on the basis of the original. You enter the password of the original root in the first text box, enter the new password of root in the next two text boxes, and click on the Next base (figure 23).
Figure 23
I recommend several solutions:
1) Click Retry and try again
2) run the settings again, see the option to "remove the original settings", select remove, and then reset.
3) reinstall.
Reinstall note: it is best to delete all the original files, if necessary, you can clean the registry, if you do not have other mysql-related programs on your machine. And be sure not to keep the original my.ini file. There is to delete the files under the original installation path, and delete the ibdata1 files under the data directory.
Then download the Chinese version of HAP_SQLyog_Enterprise_7.14, install it and use it.
After reading this article, I believe you have a certain understanding of the steps of installing mysql5.1, want to know more about it, welcome to follow the industry information channel, thank you for reading!
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.