Add users for the sync

Our database sync

For all MySQL-Sync settings, a database user must always be specified. To make this more secure for you, we have put together a guide here.

Important in advance

The sync does not require root access to your database. So you should not connect the user root to the database. For the sync to work, you must give the user you create the following permissions: Select and Show View. You can also get some security under the Host point. Here it is also not necessary to allow the user for the DB to connect from anywhere (this is done with the % entry). The needed IPs you can read out below.

As you can see above, it is highly recommended to create a database user for VPC.

Creating users in the Console

One of the ways to create a user is to go through the console. For this you connect to your server, where the database is located. To now create new users in MySQL, you must first execute the command mysql . If your root user is protected with a password, you must execute the following command mysql -u NUTZERNAME -p. After the login you have to enter the following command to get into the right section of the database use mysql;. To create the users now you have to execute the following commands: It is still important to adjust the placeholders password (i.e. your desired password for the user) and databse_name (i.e. the name of your database) to your values. Create VPC user :

CREATE USER 'vpc'@'91.197.55.200' IDENTIFIED BY 'password';
GRANT SELECT, SELECT ON `database_name`.* TO 'vpc'@'91.197.55.200';
FLUSH PRIVILEGES;

To get out of MySQL now, enter the command quit;. Done. You have now created the user.

Create the users in phpMyAdmin

A second way to create a user would be to create the user with phpMyAdmin.

For this you open the page of your phpMyAdmin and log in with a user who has sufficient rights. Once there, press the SQL face at the top of the bar.

Here you can now insert the commands to create the database user and execute them with the OK button at the bottom right. It is still important to adjust the placeholders password (i.e. your desired password for the user) and databse_name (i.e. the name of your database) to your values. Create VPC user:

CREATE USER 'vpc'@'91.197.55.200' IDENTIFIED BY 'password';
GRANT SELECT, SELECT ON `database_name`.* TO 'vpc'@'91.197.55.200';
FLUSH PRIVILEGES;

Done. You have now created the users.