DevShed - The MySQL Grant Tables

★ wanayoo — archive 1999 http://www.devshed.com/Server_Side/MySQL/Grant_Tables/comments.html/c6260/

Nouvelle recherche | Portail wanayoo

Thursday, 08.17.2000

HOME > SERVER SIDE > MYSQL > ARTICLE > COMMENTS

PHP SOURCE

Power Search

Client Side
•
•
•
•
•

Server Side
•
•
•
•
•
•
•
•
•

Tools
•
•
•

Dev Talk
•
•
•
•
•
•

ClipScripts
•
•

Other Stuff
• DevShed RDF
• Propaganda!

.

The MySQL Grant Tables
One of the most powerful aspects of the MySQL server is the amazing amount of control the administrator has over each user's intended behavior. This control can restrict user privileges over a general part of the server, such as limited access to an entire database, but can also be as specific as limiting privileges for a specific table or even column.

Name:	Pinkey
Subject:	Re: Grant table does not work
Date:	07-20-2000 02:35AM

Yip, it worked. Selecting from user table shows host = '%' for my user I am having problems with. Changed this to localhost, and all is well, can connect do DB now. (thanx to rdj)

Other posts in this thread:

Top
• Grant table does not work	Steve Nguyen	06-30-1999 09:07AM
• Re: Grant table does not work	rdj	07-08-1999 03:20PM
• Re: Grant table does not work	Pinkey	07-20-2000 02:35AM
• how to create a table	queny	04-26-2000 12:15AM

Reply to this post:

Name:		Preview Comment. Notify me of replies to this message.
Email:
Subject:

Tip: Put any source code between [code][/code] tags to increase readability

Visit the MySQL Forum!

New On DevShed:

• MySQL Developer Contests PostgreSQL Benchmarks
• PHP 101 (part 3) - Chocolate Fudge And Time Machines
• MaxSQL Announced
• PHP 101 (Part 2) - Shakespeare's Rose
• PHP 101 (Part 1) - Secret Agent Man
• The Search For The Perfect Web Host
• Perl 101 (Part 5) - Sub-Zero Code

• Submit Your News..

Hot Forum Topics:

• Credit Cards

• Backing-up in Netscape

• Want help from advanced PHP users

• making mysql timestamp look friendly

• display performance

• display performance