TransWikia.com

How to log into a fresh MariaDB install?

Database Administrators Asked on October 28, 2021

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 [email protected]. 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)

2 Answers

check your services and be sure mysql80 is in running.

Answered by Hewarathna Ashen Iranga on October 28, 2021

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...

Answered by MortenSickel on October 28, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP