[ILUG] MySQL

[Anton Mc Kee]

INSERT INTO user (Host, User, Password, Select_priv, Insert_priv,
Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv,
Shutdown_priv,
 Process_priv, File_priv, Grant_priv, References_priv, Index_priv,
Alter_priv) VALUES ('localhost', 'UserName', 'PassWord', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y', 'Y', 'Y',
 'Y', 'Y', 'Y', 'Y', 'Y')


Then do a reload that should work


aj

> -----Original Message-----
> From: ilug-admin at linux.ie [mailto:ilug-admin at linux.ie]On Behalf Of John
> P. Looney
> Sent: Tuesday, April 11, 2000 2:32 PM
> To: ilug at linux.ie
> Subject: Re: [ILUG] MySQL
>
>
> On Tue, Apr 11, 2000 at 02:16:29PM +0100, adam beecher mentioned:
> > > I don't think you can use a blob or text column as a
> key/index. In fact,
> > > to use it in a where statement you have to use a substring of the blob
> > > AFAIR. It's in the manual, ALT-F for "blob" in the toc..
> > Depends on the version. If it's >= 3.23.2, you can use a BLOB
> or TEXT as an
> > index:
> > http://www.mysql.com/Manual_chapter/manual_Reference.html#BLOB
> > Does that solve it? :)
>
>  As if I'm gonna do that any time soon. Mutter. I can live with URL's
> being less than 256 chars, for the time being, I suppose ;)
>
>  I notice that the MySQL manual says "References is understood, but not
> supported" - so, when I want to do something like;
>
>  create table skin (id int not null primary key, texture_id
> references textures(id), create_id references samples(id),
> destroy_id references samples(id), normal_id references
> samples(id), colour char (7), skin_type ENUM('texture','colour'));
>
>  What's the story ?
>
> Kate
>
> --
> "The fool must be beaten with a stick, for an intelligent person
> the merest hint is sufficient"                -- Zen Master Greg
>
> --
> Irish Linux Users' Group: ilug at linux.ie
> http://www.linux.ie/mailman/listinfo/ilug for (un)subscription
> information.
> List maintainer: listmaster at linux.ie
>