![]() |
|
|
#1 |
|
Junior Member
Join Date: Aug 2005
Posts: 1
|
Hi
I want a client to be able to connect to his MySql DB on my webserver and so I have created an account that only has rights on his DB, but when connecting using Navicat he can see all the DB's on the server listed on the left but he can't look at thier data as his permissions don't allow it. How can I setup his account so he can only see his own DB and none of the others? Thanks in advance |
|
|
|
|
|
#2 |
|
Senior Member
Join Date: Jul 2004
Posts: 167
|
Re: User privs
Good question. I noticed on some configurations phpmyadmin used to do that too. I don't know if the host I was using changed configuration or phpmyadmin improved their handling of this.
|
|
|
|
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| HELP! PHP Login that redirects to user page | dorgs | PHP | 2 | 10-30-2004 10:06 AM |
| assigning user variables to return values | scotthpa | General | 7 | 10-21-2004 02:12 PM |
| MySQL user settings | René van Buuren | Database Design | 2 | 10-19-2004 07:29 PM |
| User managment and phpMyAdmin | aweraw | General | 1 | 09-20-2004 08:13 PM |
| 3.6 Examples of Common Queries | Administrator | Documentation | 9 | 06-29-2004 09:07 AM |