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.