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)
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
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP