SOLVED [CPANEL-22282] No MySQL for clients on MariaDB 10.2

Dogs DB

Nov 7, 2018
United States
cPanel Access Level
Website Owner
Hello and thank you for your prompt reply!

In mysql 5.6 i was able to open the mysql terminal via root and user profile.
Now after the upgrade, (MariaDB 10.2) i am able to open the mysql terminal only via root user.

The result is:

[[email protected] ~]$ mysql -u veto --password='PASSWORD' veto_products<mysqlupdate.sql
mysql: Can't read dir of '/etc/my.cnf.d' (Errcode: 2 "No such file or directory")
Fatal error in defaults handling. Program aborted
With --no-defaults WORKS FINE!!!
 mysql --no-defaults -u veto --password='PASSWORD' veto_products<mysqlupdate.sql
Thinking that the problem is my.cnf file. Any idea how i should fix it to work correctly?

I want to be able to run my mysql cron jobs again via clients cpanel.

About the permissions:
View attachment 52851

View attachment 52855

And this is my.cnf file:

View attachment 52859

View attachment 52863