Add to Favorites
Hosting Discussion
 

Hosting Discussion > Web Hosting Forums > Hardware and Server Configuration > Solution: phpMyAdmin shows ALL databases
forgot password?


Reply


Old
  Post #1 (permalink)   02-26-2002, 11:48 AM
HD Addict
 
Homer's Avatar
 
Join Date: Jan 2002
Posts: 122

Status: Homer is offline
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.
 
 
 
Reply

Thread Tools

New Post New Post   Old Post Old Post
Posting Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On