Installing MySQL never causes problems likeon the Windows platform, and on the whole family of Linux. On the official site, you can find the MySQL Installer, answer all of its questions and immediately get a working database management system.
Options for which a standard installerit does not work as it should be, it's negligible, but even if they happen, you can try another version, double-check my.ini, and simply allow access to port 3306, which is usually the cause of the problems.
Using MySQL in real projects will necessarily lead to the need to work with the command line server, to solve administrative tasks:
When creating large web projects,Use fine-tuning MySQL and manage its functions in full. When a website goes to the bar of a highly loaded resource, you need to adjust and test my.ini - the configuration of the data management system.
In the Windows environment, it is not uncommon for cases where it is difficult or impossible to import a database using convenient means (for example, phpMyAdmin), but you can always do everything with a command line.
If once the server was installed and working fine, then the first reason for this problem is my.ini settings (my.cnf for linuxoids).
MySQL installation can be performed on a different port (standard - 3306), and therefore, there is no need to demolish what already stands.
"Magic" packages and repositories in linuxoids - guaranteeing continuous updating with an extremely clear movement to the goal: under no circumstances should the system panic.
Ability to install, update and remove, up to automatic, any software in Windows environment when moving in the direction of "we know what the user needs, and we can always help him."
На основании данных обстоятельств с течением time in the depths of operating systems, garbage accumulates from the installation / uninstallation of programs, many of them leave traces in the system registry, important files, hang in work processes.
Reinstall the operating system to few peopleit would be desirable, therefore any installation of the responsible software should be carried out by surgically accurate methods on absolutely prepared system.
The installation of MySQL is preceded by the removal of the previous installation:
and installing packages:
Removing the previous version is done fromcommand line in administrator mode. It is not always possible to remove the previous installation in the "Add or Remove Programs" section. It's not enough just to stop the service or clean the registry.
The process presents no problems either for the professional or for the beginner. The main rule to trust and follow when installing: MySQL works reliably and irreproachably.
Ancillary rule:should rely on the installation of the zip-archive and own strength. Using a loyal and "stand-alone" MySQL installer is just for getting to know the question and the process.
Only when installing via MySQL Installer will it be possible to remove the product in the "Add or Remove Programs" section.
Installing Apache, MySQL, PHP on Windows -"Centuries" spent process. Everything always works stably, reliably, effectively. If something goes wrong, then there is an error in the configuration or initialization files, the hosts file is undeservedly forgotten, the conflicting application is running, there are problems from the previous installation (service, registry).
The first step: on the official site to download the zip-archive of the desired version. Last for today 5.7.21 and unzip it.
The second step:select the disk and the folder in which the database and its databases will be located. Best of all, when you install Apache, MySQL and PHP in one place. But this circumstance is absolutely not important. A different solution will simply create difficulties in the execution of real projects. Access to the folders of these products will be necessary from time to time and remember where something is installed - a waste of time.
The third step is to write the file "my.ini". This is a very important file, but for a start this pattern is suitable:
This content of the file allows you to start the serverno problem. If you leave the indication only to the MySQL folder and its data folder, the server will also start, but at the beginning of the installation, it is not planned to plan and design my.ini. Too many parameters, but to understand their use without practice is not a very promising idea.
Essential circumstance:on the Internet, you can find a ton of my.ini samples. It is important to look at the date of the proposed option. The world changes so quickly that the old versions of important files do not always correspond to the latest versions of programs.
After the zip-archive has been unzipped, it should be supplemented with the following folders:
The names of these folders can be any, but the package tothe installation should be completed with an indication of the place for import / export of files, a place for the log, a place for temporary files and a folder where the MySQL databases will be located.
After everything is ready, you shouldrun the command line in administrator mode and execute only two commands. It should be noted that the commands are executed in the bin folder of the MySQL package, in the place where it is placed.
Процедура не занимает много времени, но после completion of the "mysqld --console" operation, the command line "hangs". You should run the second command line in Administrator mode to set the user's password - root.
A temporary password is created and displayed on the first command. You should write it down so that you do not repeat the process again. In this example, the temporary password was oRJiT% Im5eBA.
After these three commands, the server "became", but not ready for use: MySQL - appeared in the list of services. You need to set a password for root, add a couple of administrators and restart the computer.
The MySQL installation is complete, the command line in administrator mode (2) is restarted to create the root password.
In the second window, enter: mysql -u root -p.Here, the server is called, not its daemon. You will be prompted for the password: you need to enter that time line that was issued earlier. In this case: oRJiT% Im5eBA.
The only first and correct command is to set a password for root:
Вместо "sc" - следует написать желаемый пароль с security requirements, that is, not two simple characters, but something more or less complex. Be sure to write at the end of the command character ";" - this is a team! This symbol is required.
The screenshot shows the addition of two more administrators and the transfer of full control rights to the installed MySQL system.
This procedure is completed, it is no more difficult thaninstalling MySQL on Ubuntu, CentOS, FreeBSD, or another Linux user. It should be noted: the installation option under Windows is a simple use of a powerful tool for creating and using databases.
MySQL has almost no competition.It happened so: its own niche, its developers, its own direction of development. MySQL has its own place in the "registry" of popular database management systems, ideal for small and large projects.
Installing Apache, MySQL and PHP on a localA computer is a kind of qualification attribute of a developer (programmer). The ability to set LAMP and navigate in all parameters of configuration files is very important.
Excellent PHP programming is not real withoutconfident knowledge of the language itself, database management system MySQL and Apache. And the knowledge of “httpd.conf”, “php.ini” and “my.ini” is important and significantly affects the speed, quality and reliability of the development.
Installing MySQL in conjunction with Apache and PHP is a good practice, setting it up for the optimal mode of operation is a demanded knowledge and skill.
