Re: Create Table with password

[Mohammad H. Khan]

The following  Statement  ("GRANT ALL........ ") will create a user who will have access on mydatabase.MYTABLE only...
But My question was ...  .. okay, let me describe again..

In MySQL manual I was reading the sytax of CREATE TABLE
and I found the password option there... .. My Question is 'How this password option work in CREATE TABLE and What it do?

"Walther, Kurt (NRSW N92R63)" wrote:

GRANT ALL PRIVILEGES ON mydatabase.MYTABLE TO user@localhost
IDENTIFIED BY 'password';

It ain't hard when you know how. Get the book "MySQL" by Paul DuBois.

Read it, learn it, live it.

-----Original Message-----
From: Mohammad H. Khan [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 29, 2001 1:42 PM
To: [EMAIL PROTECTED]
Subject: Create Table with password

Hi All..

I created a table ..

create table A (
A1 int(4) auto_increment,
A2 varchar(16),
primary key (A1))
password='password';

'mysql --vesion' returns the following line on my system:
mysql  Ver 11.15 Distrib 3.23.39, for pc-linux-gnu (i686)

My question is ... How the password option work on a table...

Anybody .. Drop few lines... Please

--
Mohammad H. Khan
Web Architect
Legal Computer Solutions, Inc
Boston, MA 02109

-- 
Mohammad H. Khan
(Web Architect)
Legal Compute Solutions, Inc
107 Union Wharf
Boston, MA 02109
(617) 227-4469
http://www.lcsweb.com
http://www.lextranet.com
---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php