; From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, May 06, 2001 6:36 PM
> To: Simon Chan; mysql Mail List
> Subject: Re: users and passwords...users and passwords...
>
> At 12:16 PM -0700 5/6/01, Simon Chan wrote:
> >NEWBIE QUESTION
> >Hello,
> >
>
]]
Sent: Sunday, May 06, 2001 6:36 PM
To: Simon Chan; mysql Mail List
Subject: Re: users and passwords...users and passwords...
At 12:16 PM -0700 5/6/01, Simon Chan wrote:
>NEWBIE QUESTION
>Hello,
>
>Just installed mysql on a solaris2.7 sparc machine, but I don't seem
>to have
At 12:16 PM -0700 5/6/01, Simon Chan wrote:
>NEWBIE QUESTION
>Hello,
>
>Just installed mysql on a solaris2.7 sparc machine, but I don't seem
>to have permission to do
>anything! I add a user by typing
>
>useradd username
That creates a UNIX user account, not a MySQL user account. They have not
Use
\u mysql;
to select the database
In the query:
insert into user (host, user, password) values
('localhost', 'myname' password('testpass');
you are missing a bracket after ...('testpass')
--zak
- Original Message -
From: "Simon Chan" <[EMAIL PROTECTED]>
To: "mysql Mail Li