i setup mysql connection for my server and now customers can add mysql user and database but,
when i want login to mysql user, phpmyadmin says ‘mysqli_real_connect(): (HY000/1045): Access denied for user ‘ali’@’localhost’ (using password: YES)’.
so i search and find the problem. it’s for solid cp mysql user creation Hostname type that is ‘%’ (anyhost) and must change to ‘localhost’.
how to fix this problem.
anyone know?so please help me.
Just to update anybody with the same issue this was resolved and the problem was a deny anyhost rule on the MySQL server.
did you import the users and databases ? if so you need to retype in the database password 2 times and save it, then your error will go away, it seems when the dbs usernames are imported solidcp doesnt see the passwords, once you overwrite the password using solidcp it works 100%
Hi i seem to have the same problem, mysql 5.6. Anyone able to point me in the right direction.