RE: my host IP changed
right now the host field has 2 entries: localhost and newpop (the name of the server). There are no IP numbers. Should I replace the host name entry with the new IP address? thanks! - chris > -Original Message- > From: Gelu Gogancea [mailto:ggelu@;arctic.ro] > Sent: 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 mysql; > select Host,User from user where User='YOUR_USER_NAME'; > > If in the Host field you see the '%' character that means > your problem is > not from MySQL... else you should to update the new IP address in the > mysql.user table using "update" or "replace". > Finally you must do: > flush privileges; > > Regards, > > Gelu > _ > G.NET SOFTWARE COMPANY > > Permanent e-mail address : [EMAIL PROTECTED] > [EMAIL PROTECTED] > - Original Message - > From: "Chris Walcott" <[EMAIL PROTECTED]> > To: "Mysql-L (E-mail)" <[EMAIL PROTECTED]> > Sent: Thursday, November 14, 2002 9:22 PM > Subject: my host IP changed > > > > 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 address changed. Is this something that is > stored in the > mysql database? > > > > If so, how so I change that? I'd rather not have to rerun > mysql_install_db. > > > > - chris > > > > > - > > 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 PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
assigning a user/passwd to a database
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 binding a database to CF is a username and password - chris - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
my host IP changed
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 address changed. Is this something that is stored in the mysql database? If so, how so I change that? I'd rather not have to rerun mysql_install_db. - chris - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
trouble with LOAD command
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 | +--+-+--+-+-++ | ID | int(11) | | PRI | NULL| auto_increment | | First_Name | varchar(20) | YES | | NULL|| | Last_Name| varchar(20) | YES | | NULL|| | Phone_Number | varchar(20) | YES | | NULL|| +--+-+--+-+-++ I'm attempting to load a comma delimited list using load. The text file looks like this: Abe,Lincoln,8347 Herb,Albert,9387 George,Washington,9283 ... When I do this: mysql> load data local infile "/home/cwalcott/PhoneList_b.txt" into table phoneList -> fields terminated by ',' (First_Name, Last_Name, Phone_Number); I get this on select * ++++--+ | ID | First_Name | Last_Name | Phone_Number | ++++--+ |e| Lincoln| 8347 |rb | Albert | 9387 |orge | Washington | 9283 ++++--+ if I do this: load data local infile "/home/cwalcott/PhoneList_b.txt" into table phoneList; I get: +++---+--+ | ID | First_Name | Last_Name | Phone_Number | +++---+--+ | 1 | NULL | NULL | NULL | | 2 | NULL | NULL | NULL | | 3 | NULL | NULL | NULL | +++---+--+ I've also tried using a text file with the first column set to index numbers but the results are very similar. If I do this: mysql> load data local infile "/home/cwalcott/PhoneList_small.txt" into table phoneList -> fields terminated by ',' (First_Name, Last_Name, Phone_Number); I get: +++---+--+ | ID | First_Name | Last_Name | Phone_Number | +++---+--+ | 1 | 1 | Abe | Lincoln | | 2 | 2 | Herb | Albert | | 3 | 3 | George| Washington | +++---+--+ If I do this: mysql> load data local infile "/home/cwalcott/PhoneList_small.txt" into table phoneList -> fields terminated by ',' (ID, First_Name, Last_Name, Phone_Number); I get this: ++++--+ | ID | First_Name | Last_Name | Phone_Number | ++++--+ |e| Lincoln| 8347 |rb | Albert | 9387 |orge | Washington | 9283 +-++---+--+ - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
new user, new install
I just installed onto a solaris 8 machine. I've run mysql_install_db The script says to change the root password by doing this: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h myhost password 'new-password' When I do that I get ./bin/mysqladmin: No match. Is password the already established password? I'm totally new to mysql. I'm just trying to run the tutorial but I can't seem to do anything until I have established a root password. BTW - I can run safe_mysqld when I'm logged in as root but not as a user. I can't run ./bin/mysqld at all. If I try when logged in as root I get a message that I should read the security section of the manual about how to log in as root. If I run it as a user I get: 021107 13:39:19 ./bin/mysqld: Can't create/write to file '/usr/local/mysql-3.23.52-sun-solaris2.8-sparc/var/newpop.pid' (Errcode: 13) 021107 13:39:19 ./bin/mysqld: Table 'mysql.host' doesn't exist 021107 13:39:19 ./bin/mysqld: Error on delete of '/usr/local/mysql-3.23.52-sun-solaris2.8-sparc/var/newpop.pid' (Errcode: 2) I'm totally lost and 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 manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php