Mariadb not started


I installed nextcloud 12.0 on a clean DEBIAN 9 system including php7.0.
However when it come to the last screen I added all required information and I received the following error message:

SQLSTATE[HY000] (2002] Permission denied.

Starting mariadb
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (111 “Connection refused”)
What went wrong, and how can I fix it ??

Sorry, i am not an SQL expert! Many thanks in advance for your quick help!

regards, hitam

PS: Ok, I got mysql started included bind-adres=“” in /etc/mysql/conf.d(my.cnf and mysql started.

Installing nextcloud I received the following error message:

Error while trying to create admin user:
Failed to connect to database An exception occurred in the driver
ERROR [HY000] [1698] Access denied for user root@localhost !

I found out that the password for the NEXTCLOUD Admin (pw1) will be superseded with the SQL Password (pw2).

Very strange, that these passwords will be mixed up!

Very, very strange!

regards, hitam

Not entirely sure what you’re doing there, but avoid using the root account if you can.

Create a database
Create a user
Grant permissions on the database to the “user@host”

No need for duplicate, @JasonBayton can you merge?

I’ll just close, since you linked to the other :slight_smile: