are sure you enter the password correctly?
I have not entered any password before !!!
just creating site, I entered password like 123.
be sure via enter db first by this command and check if it success or not
mysql -u root -p
and check if it’s active
systemctl status mariadb
While setup mariadb and mysql, you set your mysql root password. Enter that password while creating site
when i creating site and ask for root password that time , I am going to set password like 123 that time I got error
sudo service mysql status
check the mysql is run or not?
sudo service mariadb status. Try this and give password that you added while installing db
try this
sudo systemctl status mariadb
search for error and slove it
check if mariadb installed first
mariadb --version
also
dpkg -l | grep mariadb
or
rpm -qa | grep mariadb
I think you should reinstall and try again with proper way. Otherwise, it will cause lots of time of yours