One thing you can do to get around large INSERT collumn count matching is
use this syntax:
INSERT INTO user SET Host='localhost', User='username',
Password=password('very_secret'), Select_priv='Y', Insert_priv='Y',
etc.etc.etc.
You will have to identify your table first, use:
desc user
Maybe t
Kjell,
I tried setting up the following line (from you)
INSERT INTO
VALUES
('localhost','username',password('very_secret'),
'Y','Y',etc...);
I have used anywhere from 6 to 14 'Y' (from the MySQL handbook)
I get the following error
Column count doesn't match value count at row 1
Where did I go wro
On 19 Jun 2004 at 0:26, LW Ellis wrote:
> OK force didn't work, but I renamed hostname to localhost,
> until the install was done.
> When I rebooted it showed mysql started.
First you have to let the SQL server know what databases and users you want to use:
1) Set password for root user after init
Thanx I muddle thru it from here.
Have a good weekend.
Leon
- Original Message -
From: Kjell Midtseter
To: LW Ellis
Cc: [EMAIL PROTECTED]
Sent: Saturday, June 19, 2004 12:52 AM
Subject: Re: mysql install problem Continued
On 19 Jun 2004 at 0:26, LW Ellis wrote:
>
OK force didn't work, but I renamed hostname to localhost,
until the install was done.
When I rebooted it showed mysql started.
Now please can you tell me how to access it.
In Dreamweaver, I need a SQL (server) generally an IP address.
I have named running on my machine, do I need to configure
this
TED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Friday, June 18, 2004 11:15 PM
> Subject: Re: mysql install problem
>
>
> > On 18 Jun 2004 at 22:08, LW Ellis wrote:
> >
> > > I get the following error when I try to install mysql40-server from the
> > &g
ROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 18, 2004 11:15 PM
Subject: Re: mysql install problem
> On 18 Jun 2004 at 22:08, LW Ellis wrote:
>
> > I get the following error when I try to install mysql40-server from the
> > ports.
> > Neither host '1
On 18 Jun 2004 at 22:08, LW Ellis wrote:
> I get the following error when I try to install mysql40-server from the
> ports.
> Neither host '192' or 'localhost' could be resolved with
> usr/local/bin/resolveip
> I went thru something similar when I was configuring apache.
> I had to resolve it by s
I get the following error when I try to install mysql40-server from the
ports.
Neither host '192' or 'localhost' could be resolved with
usr/local/bin/resolveip
I went thru something similar when I was configuring apache.
I had to resolve it by setting the host name to the name assigned by my
router
