New in CWP Edge-LatestFree with every CWPpro licenceWebsites up to 300x faster

CWP now includes LSPHP, LSAPI-Cache and CWP Cage at no extra cost with all CWPpro licences. The LSAPI-Cache plugin is integrated into our WordPress and other script installers, and CWP Cage gives every user complete isolation. Available now in the CWP Edge-Latest version.

Get CWPpro ›

mysql user issues

Started by anandmys, April 16, 2025, 06:44:32 AM

Previous topic - Next topic

anandmys

1. I am trying to add an user from user panel.

I am trying to create mysql db 'user_db' with db user 'user_db_usr'

I get success message. But the db and user are not visible.

I logged in as user. I see db '_db' with db user '_db_usr' instead of db 'user_db' with db user 'user_db_usr'

Ignoring this, I created db 'user_db' with db user 'user_db_usr' from admin panel. Now I can see this db and user from user panel login

But if I try to login to phpmyadmin with the crerdentials, I get the error "mysqli::real_connect(): (HY000/1045): Access denied for user 'user_db_usr'@'localhost' (using password: YES)"

I taught maybe I have to add local host or IP. I tried adding an existing user in userpanel with IP / hostname / %. But select user doesnt show the user (I can see the user in "List database and users" and "List Users" options)

Please suggest.