Dear community, I would like to create a new Wordpress site on a subdomain. I already have 3 users and 3 databases working (created years ago), however when I try to create a new one using cPanel, it works until a certain point.
I am able to create a new db, I am able to create a new user, however when I try to add user to db, then the error appears:
Error from MySQL query: (XID t266xf) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table) The system could not perform “GRANT” statements on the database “dbname_wp” for the user “username” due to an error: (XID t266xf) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table)
This happens if I use Wordpress Application manager, if I use MySql DB creation wizard or if I do it step by step with the MySQL database window. The only difference with the latter approach is that when using: “Add User To Database” in the moment of selecting privileges and granting them, it does not proceed. I select all privileges, then “make changes”, it loads for a second and then nothing happens.
Looking online in Cpanel support forums, people say to remove ```
grep skip-name-resolve /etc/my.cnf
So right now I am unable to use new MySQL db. And if I click phpMYadmin in Cpanel, I see I am not a root user so I can't change privileges, create users, etc. from there. Could you please point me to the right direction?