PDA

View Full Version : User can see other databases


bernholdt
13th October 2008, 20:15
I have a old user account luckily my own, today when i logged into phpmy admin i discovered that i can see 2 other users databases, This behaviour has come after the lates update Version: 2.2.26.

http://share.x-host.dk/files/2/sql.jpg

I have also updated phpmyadmin to latest version but i dont think thats the issue
how can i fix this :confused:

web51u1 and web52u1 can only see their own databases

till
13th October 2008, 23:43
The problem is the username with the underscore in it as mysql handles a underscore in usernames like a wildcard. Thats why ispconfig chnaged the username scheme. There is not much that you can do except to create new databases / users for all users with underscore, migrate the data to the new databases and then delete the old database and user.

bernholdt
14th October 2008, 09:13
Looks like im gonna get my weekend busy then :)

bernholdt
15th October 2008, 08:57
How it happens that other databases appear in your account.I think so each user name has his own password.

Did u read Till's reply ?