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
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
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 mysql;
select Host,User from user where User='YOUR_USER_NAME
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 |
get this going?
Thanks in advance
- chris walcott
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL