RE: stupid newbie question

[Mike Johnson]

From: Scott Yamahata [mailto:[EMAIL PROTECTED]

> At the command prompt, I'm supposed to type:
> 
> mysql -h host -u user -p
> 
> Does that mean that I type, for example:
> 
> mysql -h localhost -u admin -p
> 
> with localhost=host and admin=user?
> 
> When I'm asked for the password, I hit return and it lets me in.
> 
> But if I try to create a database, by using:
> 
> GRANT ALL ON store.* TO  [EMAIL PROTECTED];
> 
> I get an ERROR 1044:  Access denied for user:  '@localhost' 
> to database 
> 'store'
> 
> Any help is appreciated.


Unless you've previously granted GRANT permissions to [EMAIL PROTECTED] (as the MySQL 
root user), then this will, and should, fail.

In addition, though I'm not entirely certain, I think you need to delimit [EMAIL 
PROTECTED] as two different strings -- GRANT ALL ON store.* TO 'admin'@'localhost'

If you need help giving GRANT permissions to [EMAIL PROTECTED], let us know or check 
out:
http://www.mysql.com/doc/en/GRANT.html



-- 
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Stupid newbie question - adding comments for columns & tables?

[Victoria Reznichenko]

Randy Burgess <[EMAIL PROTECTED]> wrote:
> Apologies for what is a pitifully simple question from someone who has 
> just started using MySQL 4.0. I've looked in the documentation and 
> elsewhere, but can't find the exact syntax for adding comments to 
> columns when creating a table. My attempts at guessing the syntax so far 
> have failed. Tips, hints, examples? Thanks--
> 

Comment on the column level is supported from version 4.1.

 CREATE TABLE t1(id int COMMENT 'comment');


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]