Re: mysql install problem Continued

2004-06-26 Thread Technical Director
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

Re: mysql install problem Continued

2004-06-26 Thread LW Ellis
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

Re: mysql install problem Continued

2004-06-19 Thread Kjell Midtseter
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

Solved mysql install problem

2004-06-19 Thread LW Ellis
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: >

mysql install problem Continued

2004-06-18 Thread LW Ellis
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

Re: mysql install problem

2004-06-18 Thread Kjell Midtseter
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

Re: mysql install problem

2004-06-18 Thread LW Ellis
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

Re: mysql install problem

2004-06-18 Thread Kjell Midtseter
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

mysql install problem

2004-06-18 Thread LW Ellis
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