0

I am usually using Postgres, now I have had to install MySQL/MariaDB to help a friend with some issues.

The problem is just - I am not able to log into the freshly installed database on Debian 9.

When searching for default user name, I am told to use "root" with a blank password. But no matter what I have tried, I am just greeted with Access denied.

mysql -u root mysql -u root -p

and then repeat with root@localhost and root@127.0.0.1. I have tried to use the description in the accepted answer of https://superuser.com/questions/603026/mysql-how-to-fix-access-denied-for-user-rootlocalhost but to no avail.

Where am I messing up? Are there any command line utilities similar to Postgres' createuser to create a new user?

mysqld 10.1.26-MariaDB-0+deb9u1 on debian stretch (9.3)

0

Turned out I had to run mysql_install_db before I was able to do anything - although when trying to log in before that everything seemed to work...

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.