Submitted to cPanel support 6+ hours ago, 0 response, so asking for help here. The issue occurs for months with multiple accounts. Now it happens with ALL accounts (both old and newly created ones).
This is what I expect:
hours of debugging I found it's possible to add user to database via CLI using cPanel API, and it works for all MySQL commands EXCEPT "set_privileges_on_database".
So even if I can add user to database via cPanel API, calling "set_privileges_on_database" fails, and MySQL connection doesn't work as a result. How can I add user to database and grant him privileges? This is a huge issue since I can't even launch new websites because it's impossible to add user to database.
This is what I expect:
- Go to cPanel account and select "MySQL Databases"
- Under "Add User To Database" section select user/database and add user to database
- Make changes, go back, and user should be added to database.
- Nothing, user is never added to database.
hours of debugging I found it's possible to add user to database via CLI using cPanel API, and it works for all MySQL commands EXCEPT "set_privileges_on_database".
So even if I can add user to database via cPanel API, calling "set_privileges_on_database" fails, and MySQL connection doesn't work as a result. How can I add user to database and grant him privileges? This is a huge issue since I can't even launch new websites because it's impossible to add user to database.