MySqlTalk.com  

Go Back   MySqlTalk.com > MySQL > General
User Name
Password
FAQ Members List Calendar Search Today's Posts Mark Forums Read


Reply
 
Thread Tools Search this Thread
Old 08-19-2005, 11:20 AM   #1
robkelley
Junior Member
 
Join Date: Aug 2005
Posts: 1 robkelley is on a distinguished road
Question User privs

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
robkelley is offline   Fork this post Reply With Quote
Old 08-26-2005, 12:03 AM   #2
Azkaban
Senior Member
 
Join Date: Jul 2004
Posts: 167 Azkaban is on a distinguished road
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.
Azkaban is offline   Fork this post Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 On
HTML code is Off
Forum Jump

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



All times are GMT -4. The time now is 08:55 PM.



Powered by: vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Limited.
Google
  Web http://www.mysqltalk.com
DISCLAIMERS:
1. We have no commercial interest in this site.
Banner Ads and Subscriptions will only be used to help pay for hosting and maintenance costs.
2. MySQLTalk.com is NOT affiliated with MySQL AB in any way.
3. MySQLTalk.com is NOT endorsed by MySQL AB in any way.
4. Please do not post any content that is harmful to MySQL or MySQL AB, meaning no misleading or obsolete information will be tolerated.
Well-founded constructive criticism meant to help the community is permitted.
5. This website is founded with the goal of improving the MySQL community.
We not only tolerate newbies, we encourage them.
Please do not ask newbies to "read the manual".