MySql User Hostname
 
Notifications
Clear all

MySql User Hostname

4 Posts
4 Users
0 Reactions
954 Views
Posts: 1
Topic starter
(@foxallies)
New Member
Joined: 7 years ago

hi
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.
thanks.

3 Replies
Posts: 1509
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

Hello,

Just to update anybody with the same issue this was resolved and the problem was a deny anyhost rule on the MySQL server.

Thanks,

Trevor Robinson

Reply
Posts: 237
(@hxkd)
Reputable Member
Joined: 8 years ago

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%

Reply
Posts: 43
(@mastercodefu)
Trusted Member
Joined: 8 years ago

Hi i seem to have the same problem, mysql 5.6. Anyone able to point me in the right direction.

Regards

Craig

Reply
Share: