Solution: phpMyAdmin shows ALL databases

[Homer]

Ok,

we assume that you installed phpMyAdmin and it works okay...
Now your only problem is that, when a user logs on, he can see all other databases (of other clients)...

Here is what you do:
How to add a user

• Create the database first
• Open the "mysql" database and click the table that says "users"
• Click "Insert"
• Enter the following values:
  

  [*]Host name: localhost
  [*]Username: desired-username
  [*]Password: desired-password (make sure "Function" is set to "PASSWORD"!!)
  [*]Leave all other options set to "N"
  [*]Submit this.

• Now click the "db" table (under the "mysql" database)
• Click "Insert"
• Enter the following values:
  

  [*]Host name: localhost
  [*]DB: The database you just created
  [*]User: The user you want to assign (The one you just created)
  [*]Set all other options to "Y"
  [*]Submit

Now click on "Home" (left frame - top) and click "Reload mySQL".

Done.