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:
Quote:
- 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:
Quote:
- 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.