options file /root/.my.cnf ignored ???
I have inherited several mysql v4x servers. All but one of them works as expected with /root/.my.cnf files. That last server is driving me nuts ; I have RTFM, and I do not find this particular problem anywhere. Pointers to TFM are welcome. # mysql -h localhost -u root ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) # sudo cat /root/.my.cnf [client] user = root password = This works OK: # mysql -h localhost -u root -p Enter password: Yes, I do know that password, and the one in /root/.my.cnf is the same, and I have changed the password for root with the same results. My own user, mds, works as expected via options file ~/.my.cnf . What am I missing? -- Best Regards, mds mds resource 877.596.8237 - Dare to fix things before they break . . . - Our capacity for understanding is inversely proportional to how much we think we know. The more I know, the more I know I don't know . . . -- signature.asc Description: Digital signature
Re: transaction support
Bryan Koschmann - GKT [EMAIL PROTECTED] [2004:01:05:18:58:12-0800] scribed: snip / Here is the explanation I just received when asking for the difference between transaction support: - MySQL uses single-action implicit and explicit transactions, but they do not automatically roll back on failure. SQL Server user single action implicit and batch explicit transactions as well as supporting transaction nesting (transactions inside of parent transactions) and on failure the entire batch and any parent / peer transactions are rolled back. http://www.mysql.com/doc/en/InnoDB.html http://www.mysql.com/doc/en/InnoDB_Deadlock_detection.html http://www.mysql.com/doc/en/Error_handling.html hth -- Best Regards, mds mds resource 877.596.8237 - Dare to fix things before they break . . . - Our capacity for understanding is inversely proportional to how much we think we know. The more I know, the more I know I don't know . . . -- pgp0.pgp Description: PGP signature
Scheduling app examples ???
I am designing an web based application using MySQL and Perl. Part of the requirements include a somewhat complex scheduling module, which must accommodate scheduling multiple human and physical resources across multiple facilities. For example, medical patients will be scheduled for one or more pieces of equipment, in one or more rooms, at one or more facilities, by one or more doctors -- per visit. I would love to review how others have handled such tasks; but, I have reviewed the MySQL archives and googled without success. I am especially interested in the database design, since requirements indicate a need to schedule forward more than one year. I feel that a robust database design will simplify the logic code to make this work optimally. What do you think? -- Best Regards, mds mds resource 877.596.8237 - Dare to fix things before they break . . . - Our capacity for understanding is inversely proportional to how much we think we know. The more I know, the more I know I don't know . . . -- pgp0.pgp Description: PGP signature