Author Topic: mysql user issues  (Read 27 times)

0 Members and 1 Guest are viewing this topic.

Offline
**
mysql user issues
« on: April 16, 2025, 06:44:32 AM »
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.