FKs in InnoDB
Hi, I'm using MySQL 4.0.16 with InnoDB tables. From the command-line mysql console Is there an easy way to see all the names of the foreign keys in my db? Basically I want to generate a file that drops all the foreign keys currently in my db. thanks, Don
RE: FKs in InnoDB
Thanks, marc. -Don -Original Message- From: Mechain Marc [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 12:23 PM To: Don Vu; [EMAIL PROTECTED] Subject: RE: FKs in InnoDB SHOW TABLE STATUS In the Comment Column you have the definition of the foreign keys. Marc. -Message d'origine- De : Don Vu [mailto:[EMAIL PROTECTED] Envoyé : mardi 27 janvier 2004 17:48 À : [EMAIL PROTECTED] Objet : FKs in InnoDB Hi, I'm using MySQL 4.0.16 with InnoDB tables. From the command-line mysql console Is there an easy way to see all the names of the foreign keys in my db? Basically I want to generate a file that drops all the foreign keys currently in my db. thanks, Don -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
INNODB vs MyISAM
Hi guys, Do both MyISAM tables and INNODB tables support foreign keys in 4.0.15? If so, are the main advantages of using INNODB tables the added features of transactions, cascading deletes, and it's other more robust features? Any thoughts on any disadvantages of INNODB to MyISAM? I know that INSERTS, UPDATES and DELETES will be slower with INNODB cuz of the transaction overhead, but do you think the SELECT speed is about the same? any feedback appreciated. thanks, Don
locked threads
Hi guys, Do you have any thoughts on how to track down a locked thread/query? Basically we've had instances where a query locks up and causes a cascade of locked queries and the db freezes up. By the time it's had enough of an effect for us to see the symptoms (no new queries run) there are a bunch of locked queries and no real way to see which one is the initial culprit. So I was wondering: 1) is there an easy way to monitor whether or not a query is locking up the db? does anyone have a script handy that checks for locks that can be cronned and then an email is sent? 2) in the instance of having a bunch of locks, is there any way to track down the query that orignated a cascade of locks? thanks in advance for the help. -Don -- Don Vu Madstone Theaters 85 fifth avenue, 12th floor new york new york 10003 p 212.379.1545 f 212.989.7744 http://www.madstonefilms.com http://www.madstonefilms.com/ http:// http://www.madstonefilms.com/ www.madstonetheaters.com http://www.madstonetheaters.com/
Invalid Date Bug
Is it just me, or does Mysql allow invalid dates to be entered into columns with date datatype? I found some data that blew up in a perl script when doing some date manipulation, and it turns out I have invalid dates in my database, such as June 31, 2003. Of course June never has 31 days. Is this a known bug? honestly, this seems like a pretty basic thing to validate. Is there a patch/fix for it? here's a transcript of a quick test i did afterwards...june 31 enters successfully but not june 33: mysql create table DateTest ( id integer(11), - startDate date); Query OK, 0 rows affected (0.01 sec) mysql desc DateTest; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | id| int(11) | YES | | NULL| | | startDate | date| YES | | NULL| | +---+-+--+-+-+---+ 2 rows in set (0.00 sec) mysql insert into DateTest values (1, '2002-06-31'); Query OK, 1 row affected (0.00 sec) mysql select * from DateTest; +--++ | id | startDate | +--++ |1 | 2002-06-31 | +--++ 1 row in set (0.00 sec) -- Don Vu Madstone Theaters 85 fifth avenue, 12th floor new york new york 10003 p 212.379.1545 f 212.989.7744 www.madstonefilms.com - 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
RE: Invalid Date Bug
thanks for the thoughts guys...we've already taken steps to validate on the client side. I just never knew about this aspect of date columns and it struck me as odd that a database would allow invalid data to go in...interesting feature. Personally I place a higher premium on data integrity over speed but that's just me... take care, d -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, February 14, 2003 5:00 PM To: Peter Grigor; Don Vu; MySQL Mailing List (E-mail) Subject: Re: Invalid Date Bug At 16:55 -0500 2/14/03, Peter Grigor wrote: Yep, you're right. Never noticed that before :) I think that would probably be considered a bug. But possibly for efficiency's sake the check was made ultra simple. It can be argued either way. You could just as well consider it a bug that you try to shove garbage into your database. :-) Client-side validation has the disadvantage that you must do it in each client, of course. On the other hand, for things like web apps, you may as well validate the data in the client anyway: Suppose MySQL validated the date and returned an error for a bad data. You'd just have to tell the user that anyway, plus you wasted time sending a bad query to the server. If you check the date in your app, you can tell the user immediately and skip the bad query. Peter ^_^ - Peter Grigor Hoobly Free Classifieds http://www.hoobly.com - 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
running sql scripts with 'source'
Hi guys, I have a script in my home directory that i want others to be able to run. I 'chmod 777'ed the file and the folder it lives in and people still can't run it when they are at the mysql prompt and type source /path/to/script/scriptname.sql. I can execute that script, even when i log into mysql from a different folder than where it lives. Can people just not run scripts which they own? What am I missing? thanks, Don -- Don Vu Database Engineer Madstone Theaters 85 fifth avenue, 12th floor new york new york 10003 p 212.989.4500 f 212.989.7744 www.madstonefilms.com - 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
RE: Grants UGGH! Not working for some reason ...
if you don't restart MySQL after changing the grants priviliges, you have to issue the flush privileges command from the MySQL Monitor. If you don't do either one your privilege changes will not take affect. not sure if when you said reloaded you meant flush privileges but if not try it and see how it goes. hope that helps, Don -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 12:02 PM To: [EMAIL PROTECTED] Subject: Grants UGGH! Not working for some reason ... Hi all! I have a user that I am specifying for one database within the system. I have granted, reloaded, deleted, re-done, and screamed at the server. None the less, it still will not allow this user to do mysqlimport, as follows; mysqlimport --user=rcr_user --password=thepassword -f --fields-terminated-by =, rcr tblCDR.tmp mysqlimport: Error: Access denied for user: 'rcr_user@localhost' (Using password: YES), when using table: tblCDR I have 3 rcr_users now, one at 'localhost' one at '127.0.0.1' and one at 'theservername'. All have been granted select, insert, update, delete on the database in question. I also have this user in a PHP script that is able to do an INSERT INTO from the script that works fine. So, have I lost it completely? (I knew that this day would come :^) ) Any hints? I have read everything at http://www.mysql.com, I have looked all through my trusty MySQL book, I have made offerings to the gawds of database(s). Thanks in advance... Jay sql, mysql, query - 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
dba scripts
Hi guys, Does anyone know any sources on good DBA procedures for MySQL specifically? Or a source for MySQL DBA scripts that might do some of the following tasks? - check if mysqld is up and running and email a user if it is - a script to give process/connection information (I'd like more info than show processlist - other userful dba stuff? thanks, Don -- Don Vu Database Guy Madstone Films 85 fifth avenue, 12th floor new york new york 10003 p 212.989.4500 f 212.989.7744 www.madstonefilms.com - 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
RE: Separate List For administration
agreed... -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 12:06 PM To: Nilesh Shah; [EMAIL PROTECTED] Subject: Re: Separate List For administration ..Subscribe - Original Message - From: Nilesh Shah [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 19, 2002 11:27 PM Subject: Separate List For administration MySQL Team, Can we have separate list for MySQL administration and replication?. I am sure there are lots of people here are only interested in Advance things in mysql. This is very general list. Any one agrees with me?. Nilesh - 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 - 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
RE: How to duplicate records
mabye an insert into...select will work, something like: INSERT INTO new tablename SELECT Code, Model, Units from original table where Year=2003 and ((Code = 'N200') or (Code='N205')); http://www.mysql.com/doc/I/N/INSERT_SELECT.html -Don -Original Message- From: Carlos Fernando Scheidecker Antunes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 10:25 AM To: MySQL List Subject: How to duplicate records Importance: High Hello all, I've got some records of a Database that I would like to duplicate if possible with an statement. The table has Code, Model, Year, units. The primary key is Code, Model and Year. What I need is to duplicate Code, Model and units for a different year. Say I want to duplicate all records which Code are N200 and N205 with the same model and same units but for year 2003. Is there any select and insert/replace statement to acomplish this? There are about 3.000 records and doing that manually is impossible. I am considering dump the whole file to a .csv and change year to 2003 and then reinsert it. Is there any way to do it in a smart way? Meaning an SQL statement. Thank you, Carlos Fernando. - 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
RE: Reconstructing SQL create table statements
if you do mysqldump -d -p -u USERNAME DATABASENAME FILENAME then it will pipe only the CREATE TABLE statements and no insert statements into FILENAME. -Don -Original Message- From: Erik Price [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 4:39 PM To: Hihn Jason Cc: [EMAIL PROTECTED] Subject: Re: Reconstructing SQL create table statements On Friday, June 14, 2002, at 04:06 PM, Hihn Jason wrote: I have a large number of tables that have been created through the years, and I wish to obtain the SQL statements used to create them. I can go through and do it all by hand, but that would take forever. Is there a way to run a script against the database that will generate them for me? If it misses the occasional additional index, then that is fine. If you have the mysql client programs and are using a Unix machine (maybe even Win but I'm not sure) you can use the mysqldump program. It is usually located in the bin directory of your MySQL distribution. Mine is /usr/local/mysql/bin/mysqldump. Read up on it, it can dump all data from your database and does so with the CREATE TABLE statements attached so that the whole thing can literally be rebuilt from scratch. Just chop off the contents if you only want the CREATE TABLE statements. Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - 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
files in /tmp
Hey guys, there are 2 files in my /tmp directory that look like mysql datafiles: #sql208_ecc_0.MYD #sql208_ecc_0.MYI They're on the same box as our development mysql instance but I don't see them on any of our other instances. Anyone have any idea what they are/if I can delete them? They're clogging up disk space... thanks, Don - 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
data warehousing
Hi guys, Does anyone have any thoughts on using MySQL for a datawarehousing application? Problems I've run in to are with mining data from a data warehouse because of the lack of sub-selects, stored procs, and views. Should I be looking more at InnoDB or MyISAM table types? any thoughts are appreciated, Don -- Don Vu Database Guy Madstone Films 85 fifth avenue, 12th floor new york new york 10003 p 212.989.4500 f 212.989.7744 www.madstonefilms.com - 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
RE: MySQL From Windows to Linux
there are limitations of course but you could also just do a mysqldump of all the data and re-create the database -Don -Original Message- From: Gelu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 12:31 PM To: Yvon Darang; [EMAIL PROTECTED] Subject: Re: MySQL From Windows to Linux Hi, Yes. 1.You must shutdown mysqld from Windows and from Linux. 2.Copy files from Windows to Linux. ...optional shutdown Windows ... for ever.(Ha,ha,ha...just a joke) 3.Change owner of the files to mysql. 4.Check access permision to files and directory. Anyway, is recomended to use mysql utility administration software. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Yvon Darang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 07, 2002 4:04 PM Subject: MySQL From Windows to Linux Hi everybody. If I start a database using MySQL for Windows, can I later transfer it to MySQL for Linux by just copying the database directory. Or will I have redo it from scratch. What about my odcb connections will they continue to work without modification on the client side. TIA - 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 - 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
RE: Two database servers, same physical server
more detail on this can be found here http://www.mysql.com/doc/M/u/Multiple_servers.html -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 3:10 PM To: Luc Foisy; MYSQL-List (E-mail) Subject: RE: Two database servers, same physical server Hi, To run multiple mysqld servers, you at least have to specify a different port number, different socket file path, different pid and error log file to get it started. Different mysqld servers may point to the same database. To do this, just define the necessary information for your new mysqld server in a my.cnf file, and start it with ./bin/safe_mysqld --defaults-file=/path/to/new/my.cnf . Gurhan -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 1:33 PM To: MYSQL-List (E-mail) Subject: Two database servers, same physical server Has someone done this before? What things do I have to take into consideration The following are things I know that may be issues reading mysql.sock reading my.cnf database directory ( there is a parameter for command line operation ) I would suppose I would have to create a dual instance of the daemon script Anything else I might be missing? What should I do to make this work? --- Why do I want to do this? Replication. One slave can not be slave to mulitple masters. ( as far as I know ). I do not want to have a so many servers as I have clients ( the replication is a saftey thing offered by us, most clients still have thier own replication server, but some just can not afford it, so we replicate for them. ) Now that I have written the above R word, this mail will be completely ignored. Why is that? I have yet to see answers to any questions in regards to replication. Is it that nobody else uses replication except the people who have problems, or just that no person has extended knowlegde on the issue and they just keep their mouths shut so they don't lead others astray. Just curious. - 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 - 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
RE: OSX Mysqladmin and Cron
make sure the directory where mysqladmin lives is in your $PATH in that script, i.e. add $PATH=$PATH:/usr/local/bin (or where ever it is...) in the beginning of your script where environment variables are set. -Don -Original Message- From: Dion Wickander [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 2:50 PM To: MySQL Help Subject: OSX Mysqladmin and Cron I set up a script to rotate my logs for mysql and cron fires it off perfectly the logs are rotated but when the shell script gets to the last line which is... mysqladmin -u usernam -pPassword flush-logs it will not execute it - my file that logs the execution of the cron script says it doesn't recognize the command mysqladmin any ideas??? - 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
char() function
Hi guys, Our java code blows up when we try to insert a string with a ';' inside of it. So we tried to do a work-around by replacing ';' with '||CHAR(59)||' to insert it, using the char function and the character's respecitve ascii value. So instead of: insert into table (key, field) values (1, 'test;string'); we had: insert into table (key, field) values (1, 'test'||CHAR(59)||' string'); it seems to work initially...(Query OK, 1 row affected (0.00 sec)) but when I try to select the value of the field I get just the value '0' (string of zero). Anyone know what gives? If not, any ideas on another way to handle the problem? It seemed like the CHAR() function was made for situations like this thanks, Don - 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
RE: char() function
nevermind...instead of using '||' to concat the fields i needed to use the CONCAT() function. So the syntax should have been: insert into table (key, field) values (1, CONCAT('test',CHAR(59), ' string')); still...I wonder why I got a 'Query OK, 1 row affected' message -Don -Original Message- From: Don Vu Sent: Monday, April 08, 2002 11:08 AM To: MySQL Mailing List (E-mail) Subject: char() function Hi guys, Our java code blows up when we try to insert a string with a ';' inside of it. So we tried to do a work-around by replacing ';' with '||CHAR(59)||' to insert it, using the char function and the character's respecitve ascii value. So instead of: insert into table (key, field) values (1, 'test;string'); we had: insert into table (key, field) values (1, 'test'||CHAR(59)||' string'); it seems to work initially...(Query OK, 1 row affected (0.00 sec)) but when I try to select the value of the field I get just the value '0' (string of zero). Anyone know what gives? If not, any ideas on another way to handle the problem? It seemed like the CHAR() function was made for situations like this thanks, Don - 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
authentication problem
Hey guys, We're having a weird authentication problem. We have a .jsp (on box1) that tries to connect to a MySQL database (on box2). The privileges have been set to give insert, update, delete to the user. GRANT select, insert, update on d_name.* to d_user IDENTIFIED by d_user; It works fine one day and then the next morning it doesn't work. To hack around, we changed the .jsp to use the root user login (only in our development environment to find the error) and it worked, only to have it broken again the next morning! The only thing that runs overnight is a mysqldump script, which calls this command: mysqldump -u$USERNAME -p$PASSWORD --all-databases It seems like the privileges get messed up by mysqldump? We've also been doing a flush privileges after any change to the grant tables (db, user, host). to isolate the problem, we've removed all related d_user entries. The way it looks now is that the db table is empty, the host table has an entry so that box1 has access to the databases on box2, and user has an entry for root coming from localhost, box1, box2, and to be safe, '%'. does mysql get confused when there's an '%', and then also other entries in the host column of the user table for the same user? Any help would be great...it's been really frustrating. thanks, Don - 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