Cannot connect to Databse Server how to fix error?

Question

MySQL

As I understood this, because I installed the database as root, and I connect through the graphical interface as a regular user, if so, how can I run a local server as root? If this is not the case, I will be glad for your solution to the problem
-------------------------------------- -------------------------------------------------- --------------------------------------------------
Using

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';

achieved when starting to enter a password for root, but the error remained

Answer 1

The latest versions of MySQL and MariaDB do not allow connecting clients as root. You can only log in as root from a client running from sudo. Hence:

1. or run Workbench from under sudo (not an option);
   
2. or create a user with rights to everything (equivalent to the admin, we make an entrance sudo mysql -u root) and after that connect from the workbench on behalf of this user.