Mysql/Mariadb account permissions

[jair101]

I know its a bad practice, but for quite a while I am using the root mysql user in conf_global.php to connect to the database. For some reason I was not able to connect with a normal regular user. 

Today I tried again: create new user, grant all privileges to the needed database, flush privileges, modified conf_global.php and again - unable to connect. At the same time, I can connect via the console with the new user, view the database and select data from it. 

Is there something obvious I am missing and in fact what should be the mysql user permissions?

[b416]

Is your database on the same server?   try switching the server from localhost to 127.0.0.1 (or the other way around). 

 

[jair101]

1 hour ago, b416 said:

Is your database on the same server?   try switching the server from localhost to 127.0.0.1 (or the other way around). 

 

Yeah, I tried both 😕