RE: my host IP changed

2002-11-14 Thread Chris Walcott
Thursday, November 14, 2002 11:47 AM > To: Chris Walcott; Mysql-L (E-mail) > Subject: Re: my host IP changed > > > Hi, > > It's possible that in mysql.user table to exist the old IP > address of your > machine.You should check the field Host using: > > use

assigning a user/passwd to a database

2002-11-14 Thread Chris Walcott
How do I set a username/passwd to a specific database for authentication? I know how to create users but I can't find anything in the docs about how to password protect a database that is publicly available. I'm using mysql with ColdFusion and one of the things you are aupposed to supply when b

my host IP changed

2002-11-14 Thread Chris Walcott
I just got mysql up and running (I'm a new user). I'm using it with ColdFusionMX. Just as I was about to bind a database to coldfusion, my IT department decided to move my server to a new IP address. Now I can't get a database to bind to coldFusion and I'm wondering if it's because the IP addr

trouble with LOAD command

2002-11-13 Thread Chris Walcott
How do I LOAD a text file into a table that has a Primary Key defined? I have the following table defined: mysql> describe phoneList; +--+-+--+-+-++ | Field| Type| Null | Key | Default | Extra | +--+--

new user, new install

2002-11-07 Thread Chris Walcott
I can't afford to sign up for the 30 day install support. Is there anyone willing to help me get this going? Thanks in advance - chris walcott - Before posting, please check: http://www.mysql.com/manual.php (the man