How to restore Bitrix database on Ubuntu server?

Question

MySQL

Good day! I am restoring Bitrix on a server under ubuntu 16.
When restoring, I immediately get a
MySQL query error!
MySQL server has gone away
-- ---------------------------------- -- Dumping table b_admin_notify_lang -- - ---------------------------------- DROP TABLE IF EXISTS `b_admin_notify_lang`;
I bring error.log mysql

2018-03-16T05:07:22.957734Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-03-16T05:07:22.957775Z 0 [Note] IPv6 is available.
2018-03-16T05:07:22.957785Z 0 [Note]   - '::' resolves to '::';
2018-03-16T05:07:22.957814Z 0 [Note] Server socket created on IP: '::'.
2018-03-16T05:07:22.969721Z 0 [Note] Event Scheduler: Loaded 0 events
2018-03-16T05:07:22.969972Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.21-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2018-03-16T05:07:23.029338Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)

Apparently, he swears at an empty password? But in vestacp, the root password is set in the mysql config.
PS: I'm not a system administrator, this is not a profile matter for me, please don't hit me hard))

Answer 1

Create a user and database through the console.
1. Connect via ssh to the root user.
2. Connect to the console of the Mysql-server
If it asks for a password, do not enter anything, if you are executing a connection with the root user, it should be allowed there without a password.
3. Create a database
4. Create a user
5. Give privileges to this user to use this database
6. Apply the changes and disconnect from the console.

flush privileges;
exit;

Well, now indicate the database, user and password that you created here.