> For the complete documentation index, see [llms.txt](https://enterprise.hideez.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://enterprise.hideez.com/hideez-enterprise-server/deployment/database-installation/mysql-on-windows.md).

# MySQL on Windows

#### 1. Download [MySQL](https://dev.mysql.com/downloads/installer)

#### 2. Installation

You can read the documentation for installing MySQL at [this](https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-setup.html) address.

* When installing MySQL to run our software, you can select the Server only option.
* During installation, you may be asked to install Microsoft Visual C ++ 2019 Redistributable Package. Agree, and perform the installation.
* Also, during the installation process, you will be prompted to enter a strong password for the root user. Don't forget this password, we'll need it later.

#### 3. Creating MySQL User and Database

{% embed url="<https://www.youtube.com/watch?v=kQto0YkuqWk>" %}

3.1. Start the MySQL Command Line Client (type "MySQL 8.0 Command Line Client" in Windows search).

3.2. The following lines create a database `hesdb`, the user with name `hesuser` and password `<user_password>`. Сhange `<user_password>` to a strong password, otherwise you may get a password validator error.

```
mysql> CREATE DATABASE hesdb;
mysql> CREATE USER 'hesuser'@'%' IDENTIFIED BY '<user_password>';
mysql> GRANT ALL ON hesdb.* TO 'hesuser'@'%';
mysql> FLUSH PRIVILEGES;
```
