Resolved mariadb user cannot connect

[tkalfaoglu]

I created a database in plesk under my own account, created a user for it, and then made copies of that database.
I set the user to have access to ALL databases, from all hosts.. However:

# mysql -utrinity -pKsHar223rw.a  turgut_wow_auth
ERROR 1044 (42000): Access denied for user 'trinity'@'%' to database 'turgut_wow_auth'

mariadb log shows:
2021-07-15 13:11:54 710905 [Warning] Access denied for user 'trinity'@'%' to database 'turgut_wow_auth'

In PLESK interface the user has access to ALL databases, both local and remote.. the password has been verified several times to be the same in GUI and CLI..

Any ideas whats going on?
ty, -t

 

[tkalfaoglu]

Folowup: I see the user in the mysql.user table.. but it has NO privs.. despite setting them in the PLESK interface.. it has R/W privs and ALL checkboxes selected in PLESK. But somehow this did not transfer to the mysql tables.. PS: I XX'd some fields:

MariaDB [mysql]> SELECT * FROM mysql.user where User='trinity';
+------+---------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+------------
-+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+--
----------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+--------
----------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-
------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+---------+-----
---------+--------------------+
| Host | User    | Password                                  | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv
| Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | L
ock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_
user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | Delete_history_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions |
max_updates | max_connections | max_user_connections | plugin                | authentication_string                     | password_expired | is_role | defa
ult_role | max_statement_time |
+------+---------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+------------
-+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+--
----------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+--------
----------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-
------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+---------+-----
---------+--------------------+
| %    | trinity | *3D75XXXXXXXXXXXXXXXXXXXDD6B | N           | N           | N           | N           | N           | N         | N         
| N             | N            | N         | N          | N               | N          | N          | N            | N          | N                     | N
| N            | N               | N                | N                | N              | N                   | N                  | N     
| N          | N            | N                      | N                   |          |            |             |              |             0 |
0 |               0 |                    0 | mysql_native_password | *3D754XXXXXXXXXXXXXXXXXXXXXXXXXX | N                | N       |   
|           0.000000 |
+------+---------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+------------
-+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+--
----------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+--------
----------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-
------------+-----------------+----------------------+-----------------------+-------------------------------------------+------------------+---------+-----
---------+--------------------+
1 row in set (0.000 sec)

 

[tkalfaoglu]

PS: I see the user in the GRANTS table.. so maybe all is well.. Don't know how to change the thread to SOLVED.