Running MySQL on Windows 10

[Dalemon1]

What are the best setup tips for installing MySQL CE on a laptop with Windows 10?

Two business partners are separating, and I was tasked with opening a backup of their CRM to extract certain records to Excel.

I’m okay with writing queries, but have had nothing but headaches trying to get MySQL Workbench installed and keep the server running, and re running the install to modify settings and have a root password and then WIN32 errors when trying to open the backup, etc.

Is this normal? Is there a step that you pros do that I’m missing?

I’m not planning to use MySQL long term. Just for this small project.

[TuqueroIMKJerna]

Download the MySQL community server. Once the installer has been downloaded, double-click the setup file to start the installation process. On the Choosing a Setup Type page, you can see four installation options.

Developer default: If you want to create a development machine, you can use this option. It installs the components which are required for application development, e.g., MySQL Server, MySQL Shell, MySQL connectors, MySQL
Server Only: If you want to create a standalone database server with specific components, you can use this option
Full: If you want to install MySQL Server with its all components, then you can use this option
Custom: If your requirements are limited to the few components, you can use this option
We are going to install MySQL Server with all components; hence, choose “Full” and click on Next.

Before installation begins, the installer checks all the prerequisites that are required to install all the components of the MySQL database server. If any software prerequisites are missing, then you can see the details of failing requirements on the “Check Requirements” screen. It shows the name of the product, required component/software, and its status. As you can see, to install the MySQL database server for visual studio, we must install visual studio 2015 or above. Similarly, to install Python connector, we must install python on the work station. Click on Next.

[ClaudeMjDevinHe]

The simplest and recommended method is to download MySQL Installer (for Windows) and let it install and configure a specific version of MySQL Server as follows:

Download MySQL Installer from https://dev.mysql.com/downloads/installer/ and execute it.

Determine the setup type to use for the initial installation of MySQL products. For example:

Developer Default: Provides a setup type that includes the selected version of MySQL Server and other MySQL tools related to MySQL development, such as MySQL Workbench.

Server Only: Provides a setup for the selected version of MySQL Server without other products.

Custom: Enables you to select any version of MySQL Server and other MySQL products.

Install the server instance (and products) and then begin the server configuration by following the onscreen instructions. For more information about each individual step, see Section 2.3.3.3.1, “MySQL Server Configuration with MySQL Installer”.

MySQL is now installed. If you configured MySQL as a service, then Windows automatically starts the MySQL server every time you restart the system. Also, this process installs the MySQL Installer application on the local host, which you can use later to upgrade or reconfigure MySQL server.

MySQL for Windows is available in several distribution formats, detailed here. Generally speaking, you should use MySQL Installer. It contains more features and MySQL products than the older MSI, is simpler to use than the compressed file, and you need no additional tools to get MySQL up and running. MySQL Installer automatically installs MySQL Server and additional MySQL products, creates an options file, starts the server, and enables you to create default user accounts. For more information on choosing a package, see Section 2.3.2, “Choosing an Installation Package”.

A MySQL Installer distribution includes MySQL Server and additional MySQL products including MySQL Workbench, and MySQL for Visual Studio. MySQL Installer can also be used to upgrade these products in the future (see https://dev.mysql.com/doc/mysql-compat-matrix/en/).

For instructions on installing MySQL using MySQL Installer, see Section 2.3.3, “MySQL Installer for Windows”.

The standard binary distribution (packaged as a compressed file) contains all of the necessary files that you unpack into your chosen location. This package contains all of the files in the full Windows MSI Installer package, but does not include an installation program.

For instructions on installing MySQL using the compressed file, see Section 2.3.4, “Installing MySQL on Microsoft Windows Using a noinstall ZIP Archive”.

The source distribution format contains all the code and support files for building the executables using the Visual Studio compiler system.

For shagle instructions on building omegle MySQL from source on Windows, voojio see Section 2.9, “Installing MySQL from Source”.