Check you users table under 'mysql' database. This is what controls access. Here, check the 'hosts' column. Update the old IP/DSN to the new ones and then do a 'flush privileges' and you should be fine. If you don't want to update but add a new record that should be fine to. Do a GRANT ..... for the new 'user'@'host'.
Regards, Bhavin. ----- Original Message ----- From: "Ingrid Kast Fuller" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 24, 2002 4:58 AM Subject: MySQL - Ecommerce problem > > I just moved my servers and have new DNS names and IP addresses. > > I need to update my MySQL databases because our Ecommerce sites are giving > "Internal Server Errors" in Apache, see this link: > http://www.toyotaworld.com/cart/toyotaecommerce.cgi?store=toyotaecommerce&ac > tion=file&file=home.tmpl > > I used PhpAdmin to make some changes in the Shopping Cart main database > (from cs1.cityscope.net to ns1.cityscope.net), but I am still getting the > errors. Can anyone tell me where I need to change the server info and what > are the commands to do it? I appreciate your help, thanks. > > Ingrid Kast Fuller > CityScope Net > 3910 Fairmont Parkway #264 > Pasadena, TX 77504-3066 > (713) 477-6161 > > > --------------------------------------------------------------------- > 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
