here is the output.
[root@cwp ~]# mysql --defaults-extra-file=/root/.my.cnf root_cwp -B -N -s -e "SELECT * FROM user"
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
This worths for you:
Check your MySQL root password are exactly the same in files:
/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
and
/root/.my.cnf
If the passwords are
exactly the same, so you have problems in your "/root/.my.cnf" file.
you
must have something like this in that file:
[client]
password=Wr3rT9r4tO8c
user=root
(obviously, the password is ficticious, adapt it to your case)
Anyway, if it still does not work, try to access
directly your mysql/mariadb server, with the command:
# mysql -p root_cwp -B -N -s -e "SELECT * FROM user"
...and provide that password directly, as it ask it. It
must access. If the system complains of "Access denied" then your password is wrong, you will need to reassign it.