alhelal@VimLaTeX:~$ mysql -u root -p Enter password: ERROR 1698 (28000): Access denied for user 'root'@'localhost' alhelal@VimLaTeX:~$ sudo mysql -u root -p [sudo] password for alhelal: Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 35 Server version: 10.1.29-MariaDB-6 Ubuntu 18.04 Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
Why mariadb doesn't allow normal ubuntu user to enter mysql as mysql root user?
I also tried ERROR 1698 (28000): Access denied for user 'root'@'localhost' at Ubuntu 18.04 but failed?
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test'' at line 1