Re: Do I specify a primary key to be primary, unique and index ?
From the MySQL documentation: * A PRIMARY KEY is a unique KEY where all key columns must be defined as NOT NULL. KEY is a synonym for INDEX. So, specifying PRIMARY KEY implies UNIQUE and INDEX.. You don't have to specify them yourself. At 01:11 am 4/11/2004, you wrote: I learned that there are three types of indexes (PRIMARY, UNIQUE, and INDEX). Now assuming I create a performance-critical PRIMARY key, will I better have to specify UNIQUE and INDEX for this column also !? It should be obvious that a primary key is unique anyway, and an index as well, shouldnt it !? Please note, I am not after saving disk space here, performance is all I am after, and such a three-fold indexing exercise just seems redundant to me in the best case scenario, or harmful even, am I right there !? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
stressing mysql - configuration advice
Hi there, I just installed the newest mysql 4.x server on a suse9.0 system with apache 1.x and php4.x The system is a p4 2.4G with 1GB of RAM. It serves one LAMP application. Now I am trying to configure the server for huge load. To stress test it, I installed the Microsoft stress test tool which simulates 300 threads in this case. I configureed the server with following settings: key_buffer = 348M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 Problem is: The server can't satisfy each query request once more than 200 threads are issued. Result is that the application does not respond anymore. I have a php script which redirects users if the db does not respond to a query. This is the only site they get with the current settings. Is it possible to increase the number of users? I think this might be the main problem in my case. Any advice is apreciated. I am just starting to understand how to configure mysql server. Thank you in advance, Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Do I specify a primary key to be primary, unique and index ?
As I discovered recently, thanks to another user on this list, there is at least one situation where you WILL need to also create a KEY index on a PRIMARY KEY column - If you have a composite primary key such as (col1, col2) and you wish to place a foreign key on col2, you will ALSO have to add a KEY on col2 to be able to do so. Cheers, Matt. -Original Message- From: Eldon Ziegler [mailto:[EMAIL PROTECTED] Sent: 11 April 2004 08:53 To: [EMAIL PROTECTED] Subject: Re: Do I specify a primary key to be primary, unique and index ? From the MySQL documentation: * A PRIMARY KEY is a unique KEY where all key columns must be defined as NOT NULL. KEY is a synonym for INDEX. So, specifying PRIMARY KEY implies UNIQUE and INDEX.. You don't have to specify them yourself. At 01:11 am 4/11/2004, you wrote: I learned that there are three types of indexes (PRIMARY, UNIQUE, and INDEX). Now assuming I create a performance-critical PRIMARY key, will I better have to specify UNIQUE and INDEX for this column also !? It should be obvious that a primary key is unique anyway, and an index as well, shouldnt it !? Please note, I am not after saving disk space here, performance is all I am after, and such a three-fold indexing exercise just seems redundant to me in the best case scenario, or harmful even, am I right there !? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
stressing mysql - configuration advice
Hi there, I just installed the newest mysql 4.x server on a suse9.0 system with apache 1.x and php4.x The system is a p4 2.4G with 1GB of RAM. It serves one LAMP application. Now I am trying to configure the server for huge load. To stress test it, I installed the Microsoft stress test tool which simulates 300 threads in this case. I configureed the server with following settings: key_buffer = 348M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 Problem is: The server can't satisfy each query request once more than 200 threads are issued. Result is that the application does not respond anymore. I have a php script which redirects users if the db does not respond to a query. This is the only site they get with the current settings. Is it possible to increase the number of users? I think this might be the main problem in my case. Any advice is apreciated. I am just starting to understand how to configure mysql server. Thank you in advance, Merlin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
stressing mysql - configuration advice
Hi there, I just installed the newest mysql 4.x server on a suse9.0 system with apache 1.x and php4.x The system is a p4 2.4G with 1GB of RAM. It serves one LAMP application. Now I am trying to configure the server for huge load. To stress test it, I installed the Microsoft stress test tool which simulates 300 threads in this case. I configureed the server with following settings: key_buffer = 348M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 Problem is: The server can't satisfy each query request once more than 200 threads are issued. Result is that the application does not respond anymore. I have a php script which redirects users if the db does not respond to a query. This is the only site they get with the current settings. Is it possible to increase the number of users? I think this might be the main problem in my case. Any advice is apreciated. I am just starting to understand how to configure mysql server. Thank you in advance, Merlin _ Der WEB.DE Virenschutz schuetzt Ihr Postfach vor dem Wurm Netsky.A-P! Kostenfrei fuer alle FreeMail Nutzer. http://f.web.de/?mc=021157 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MSSQL to MYSQL
Yep. Theres no reason at all why this sort of thing won't work for MSSQL too. Use SQL Enterprise Manager to generate a create script for all objects in the database, and also tell it to script referential integrity (FKs, etc). Then add anything MySQL specific, such as Type=InnoDB (which you will need for transactions/FKs, although I believe BDB works as well?). The only possible problem you will run into is with any code that is embedded into the database - stored procedures shouldn't be too bad, as the syntax in MySQL is fairly similar, you'll just end up changing some function names and tweaking (unless you have very complicated MS SPs). Remember that there are no table variables in MySQL, and that the syntax to create a temporary table is 'create temporary table xyz' not 'create #xyz'. Views of course, are a different matter. In terms of the database structure itself, without embedded code though, it should work perfectly... Cheers, Matt -Original Message- From: David Carlos Brunstein [mailto:[EMAIL PROTECTED] Sent: 11 April 2004 05:23 To: 'Rodrigo Galindez' Cc: [EMAIL PROTECTED] Subject: RE: MSSQL to MYSQL Hi Rodrigo. I'm facing a similar task but from Informix to MySQL. What I do is: 1. Obtain a SQL script to create the logical database (an Informix tool give it). You can use Erwin, with reverse engineer and the save the script. 2. Add the Type=INNODB clause for each CREATE sentence. 3. Divide the scritp into tow: one for the tables creation (with its primary key) (CreateDB.sql) and another one for the alter tables to create the foreing keys (AlterDB.sql). 4. Create a script for loading data from TXT files. First you have to save every table data from SQL Server into TXT files, then load them into MySQL tables (LoadDB.sql). 5. Run the AlterDB.sql script (step 3). It works fine to me. Regards, David. == David Carlos Brunstein System Analyst / Software Developer Buenos Aires, Argentina Mail to: David _ Brunstein @ Yahoo . Com . ar IM: DavidBrunstein @ Hotmail . Com -Original Message- From: Rodrigo Galindez [mailto:[EMAIL PROTECTED] Sent: Saturday, April 10, 2004 3:38 AM To: [EMAIL PROTECTED] Subject: MSSQL to MYSQL Hello list, I have to move a database in MSSQL to MYSQL, with the table structures and all the respective data. I tested one product to do this, SQLyog, and it works fine, except for some little problems with indexes and primary/secondary keys. I want to know if anyone have been dealing with the same problem to recommend me some suggestions/tips/tricks. Do you know another program/script/ways to do this migration ? I want to migrate everything from the original MSSQL database, like indexes, relationships, and so on. Can you guys recommend me some actions or tips to take ? Thanks in advance, -- Rodrigo Galindez Information Management Assistant Center for Human Rights and Environment (CEDHA) Gral Paz 186 10 A 5000 - Cordoba - Argentina Tel/fax 54-351-4256278 [EMAIL PROTECTED] www.cedha.org.ar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: sql join help
Hmm. SELECT o.* FROM orders o INNER JOIN orderitems oi ON o.orderid = oi.orderid INNER JOIN products p ON p.productid = oi.productid AND p.productparentid 2 WHERE o.orderstatus =2 Not sure why you are checking for a NULL ordered in orderitems? That would suggest you get back only items that have no associated order? The above should do what you state below, though - I think! Cheers, Matt -Original Message- From: Michael Collins [mailto:[EMAIL PROTECTED] Sent: 11 April 2004 05:14 To: [EMAIL PROTECTED] Subject: sql join help I suppose this would be easier with subselects but I am using MySQL 4: I want all orders that are of orderStatus 2 and whose orderitems contain a product that is in a productparent category greater than 2. An orderitem can only have one product, and that product has a single certain product parent (defined in the products table). This is how the tables are related: members - orders - orderitems - products - productparents I have tried the following, but I know it is not correct: SELECT count(*) FROM orders AS o LEFT JOIN members AS m USING (memberId) LEFT JOIN orderItems AS oi ON (o.orderId=oi.orderId) LEFT JOIN products AS p ON (oi.productId=p.productId) AND (p.productParentId 2) WHERE (oi.orderId IS NULL) AND (o.orderStatus=2); -- Michael __ ||| Michael Collins ||| Kuwago Inc mailto:[EMAIL PROTECTED] ||| Seattle, WA, USAhttp://michaelcollins.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
stressing mysql - configuration advice
Received: from 213.39.151.4 by freemailng1402.web.de with HTTP; Sun, 11 Apr 2004 12:47:20 +0200 Date: Sun, 11 Apr 2004 12:47:20 +0200 Message-Id: [EMAIL PROTECTED] --- END HEADERS --- Hi there, I just installed the newest mysql 4.x server on a suse9.0 system with apache 1.x and php4.x The system is a p4 2.4G with 1GB of RAM. It serves one LAMP application. Now I am trying to configure the server for huge load. To stress test it, I installed the Microsoft stress test tool which simulates 300 threads in this case. I configureed the server with following settings: key_buffer = 348M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 Problem is: The server can't satisfy each query request once more than 200 threads are issued. Result is that the application does not respond anymore. I have a php script which redirects users if the db does not respond to a query. This is the only site they get with the current settings. Is it possible to increase the number of users? I think this might be the main problem in my case. Any advice is apreciated. I am just starting to understand how to configure mysql server. Thank you in advance, Merlin _ Der WEB.DE Virenschutz schuetzt Ihr Postfach vor dem Wurm Netsky.A-P! Kostenfrei fuer alle FreeMail Nutzer. http://f.web.de/?mc=021157 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Change the date format.
David Carlos Brunstein [EMAIL PROTECTED] wrote: Hi Egor. Thanks for your answer. I'm relatively new to MySQL. Isn't any way -like an environment variable or configuration file setting or something like that- to change the date format at the MySQL side, not at client side ? No. You can change format only with DATE_FORMAT() function for the DATE and TIME column types. -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Saturday, April 10, 2004 8:53 AM To: [EMAIL PROTECTED] Subject: Re: Change the date format. David Carlos Brunstein [EMAIL PROTECTED] wrote: By these days I'm facing a system DB migration to MySQL (the last production version) and I have the followin problem. All the SELECTs sentences are all over the application, and for date/datetime filters are using the dd/mm/ format in the WHERE clause. Is the same in the INSERT/UPDATE statementes. I've studied with MySQL documentation, that use the -mm-dd format for the internal storage and for the data interchange with the clients. So the questions are: Is there any way to set the date/datetime format to MySQL engine, so the client can see it as dd/mm/? Is there any solution with no change to the client application code? Use DATE_FORMAT() function to retrieve dates in the specific format: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html But in this case you should rewrite your queries. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
5.0.0a stored procedure crash
Hi folks. I've just submitted the following as a 'bug' via the MySQL website, and was wondering if anyone out there had experienced the same problem? It only seems to cause a crash when a nested IF is put into a stored procedure, so the work-around is obvious - don't nest 'em! As posted to mysql.com: Description: Using mysqld-opt on Windows 2000 Professional (5.0.0a-alpha), and the stored procedure shown below is created and called, the error: The instruction at 0x referenced memory at 0x. The memory could not be read Is displayed, and the server shuts down 'unexpectedly'. I have tried different permutations of the procedure, and it is the addition of a 'nested' if statement which triggers the problem - if this is removed, the code will execute with no problems and give the expected result. All tables referenced are InnoDB, and are simple tables with two columns (an auto increment primary key and a unique indexed value column of type VARCHAR(6)). How to repeat: From the command line: delimiter // CREATE PROCEDURE name_test (OUT sFragment VARCHAR(6), OUT iRand INT) BEGIN DECLARE bContinue INT; --DECLARE iRand INT; SELECT 1 INTO bContinue; WHILE bContinue = 1 DO SELECT CAST((RAND() * 100)/33 AS UNSIGNED) INTO iRand; IF iRand = 0 THEN SELECT Fragment INTO sFragment FROM namefragmentvowel ORDER BY RAND() LIMIT 1; ELSE IF RAND = 1 THEN SELECT Fragment INTO sFragment FROM namefragmentconsonant ORDER BY RAND() LIMIT 1; END IF; END IF; SELECT 0 INTO bContinue; END WHILE; END // Then from MySQLCC: call name_test(@sTest, @iRand); select @sTest AS frag, @iRand AS rng; Cheers, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: sql join help
Thanks Matt. But, what I am attempting to do with (oi.orderId IS NULL) is to eliminate the orders that have at least one order item with products of product parents not equal to 2. What you show finds all orders that have orderitems that have a product parent greater than 2, however, if that orderitem is in an order that also has a product parent of 1 or 2, I don't want to show that order. For example, I have these product Ids: 1 - hats - product parent 2 (clothes) 2 - shoes - product parent 2 (clothes) 3 - water pistols - product parent 3 (toys) 4 - rubber chickens - product parent 3 (toys) And order ids: 222 has: 1 and 3 product Ids, o.orderstatus =2 333 has: 3 and 4 product Ids , o.orderstatus =2 What you propose would find both order id 222 and 333 since both contain a product Id greater than 2. What I want is to only find those orders that do not have 1 or 2, in other words just order id 333 (from the two examples shown above). Help would be greatly appreciated! Michael At 11:10 AM +0100 4/11/04, Matt Chatterley wrote: Hmm. SELECT o.* FROM orders o INNER JOIN orderitems oi ON o.orderid = oi.orderid INNER JOIN products p ON p.productid = oi.productid AND p.productparentid 2 WHERE o.orderstatus =2 Not sure why you are checking for a NULL ordered in orderitems? That would suggest you get back only items that have no associated order? The above should do what you state below, though - I think! Cheers, Matt -Original Message- From: Michael Collins [mailto:[EMAIL PROTECTED] Sent: 11 April 2004 05:14 To: [EMAIL PROTECTED] Subject: sql join help I suppose this would be easier with subselects but I am using MySQL 4: I want all orders that are of orderStatus 2 and whose orderitems contain a product that is in a productparent category greater than 2. An orderitem can only have one product, and that product has a single certain product parent (defined in the products table). This is how the tables are related: members - orders - orderitems - products - productparents I have tried the following, but I know it is not correct: SELECT count(*) FROM orders AS o LEFT JOIN members AS m USING (memberId) LEFT JOIN orderItems AS oi ON (o.orderId=oi.orderId) LEFT JOIN products AS p ON (oi.productId=p.productId) AND (p.productParentId 2) WHERE (oi.orderId IS NULL) AND (o.orderStatus=2); -- Michael __ ||| Michael Collins ||| Kuwago Inc mailto:[EMAIL PROTECTED] ||| Seattle, WA, USAhttp://michaelcollins.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Michael __ ||| Michael Collins ||| Kuwago Inc mailto:[EMAIL PROTECTED] ||| Seattle, WA, USAhttp://michaelcollins.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
free software and open source
Dear Users Can anyone in your own words clarify the difference between open source and free software. Many Thanks Saurabh Data ___ Saurabh Data School of Computing University of Leeds Leeds LS2 9JT U.K. one who seeketh , will findeth and all door shall open - james Allen ___ _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: free software and open source
On Sunday 11 April 2004 10:58 am, Saurabh Data wrote: Dear Users Can anyone in your own words clarify the difference between open source and free software. Many Thanks Saurabh Data This is off topic for this list, but I'll provide a quick answer. Free software is software that's free to use however you like (its only restriction is that it remain free to all... no one may take it and make changes to it and hide those changes). It's free to share and free to modify. In fact, this is encouraged. The phrase was first used by Richard Stallman. Read the book Free as in Freedom to better understand why he feels that software should be free. You can find it online... it too is free. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: free software and open source
Can anyone in your own words clarify the difference between open source and free software. Free Software: You can make changes in the sourcecode for your own and you can redistribute it again. Open Source: The sourcecode is only open... Cheers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Best practice on table design
Cities (CityID, Name) People (PersonID, Name) Travel_Exp (ExpID, Date, PersonID, Per_Diem) Travel_Exp_Cities (CityID, ExpID) Based on the descriptions I'd tend to go with a normalized table set of this nature: Cities (CityID, Name) People (PersonID, Name) Travel_Exp (ExpID, Date, PersonID, CityID, Exp) This provides consistent use of person and city. Along with gathering related data into the same record. It is doubtful that an expense would reference more than one person or city. Normalizing to this table set provides a simple means of querying related data, without undue duplication of data elements with the possibility of errors creeping in during the data input. But these observations are based upon my own common sense view of the kinds of business rules/processes that are likely to be used. If your business processes would not follow the described mechanisms, say you do indeed share travel_expenses between individuals, or the expense can be across cities, the normalization I've described would not fit. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: free software and open source
Can anyone in your own words clarify the difference between open source and free software. Interesting question, though you missed one other label 'public domain'. These are all interesting elements of who controls the source and to what extent. MySQL as I understand it, allows the source to be distributed with the proviso that if it is utilized in a for profit manner a license is necessary. This comes from either charging for the distribution, or for use by a company to make money. I will hope that the people at MySQL will correct me if I am mistaken in this opinion. Open Source, usually based upon the GPL means that the source can be distributed, but the source must be made available to someone you've given binaries to, if asked. This would also include any incorporated changes made before distribution. Public domain means you can do anything you want with the source or binaries. Including modifying, distributing, or selling, the original or derivatives. Most source is at least copyrighted to prevent someone claiming what is not rightfully theirs. But public domain does not fall in this category. And copyright is inherent to the creation, unless released to the public domain due to expressed permission, or copyright expiration. Please be aware these are my own opinions, and not any form of legal advice. If you are looking for such legal advice, please get advice from someone in the legal profession (a lawyer :) My views are based upon my own experience with the libdbf library that I created for accessing and manipulating dBase files/indexes back in '90. Which I have copyrighted yet have seen no compensation from during that entire period. Not sure if anybody even uses them any more? Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: free software and open source
Dear Peter As you said that access to the source code for a free software may or may not be give. Looking at the FSF website and definition of free software, freedom 1 states that access to the source code is given to study how the program works So there is a small contradiction here . Please can you clarify this ? Manth Thanks Saurabh In a nutshell, Open source means you have free access to the source code. Generally you are free to modify the code as you see fit. Free software means you don`t have to pay for it! You may or may not have access to the source code. Both types are subject to a licence, so copyright stays with the original owner and you are using the software under licence. Often Open Source licences allow unrestricted free distribution subject to passing on the conditions of the original licence, but this is not always the case. MySql is open source but there are times when you need to pay for a licence. Other times you can use it for free. This is why they stopped calling it Free Software. The original meaning was free as in speech, not as in beer :) We all have to make a living and making money from your work often matters. HTH Peter -Original Message- From: Saurabh Data [mailto:[EMAIL PROTECTED] Sent: 11 April 2004 15:59 To: [EMAIL PROTECTED] Subject: free software and open source Dear Users Can anyone in your own words clarify the difference between open source and free software. Many Thanks Saurabh Data _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
compiling mysql with intel icc
Hi there, I am trying to compile mysql 4.x with intel compiler for maximum performance. On my research I have found that following line will squese more performance out of mysql: CFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict CC=icc CXX=icc CXXFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysqladm --without-debug --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --disable-shared --localstatedir=/home/mysqladm/data --enable-assembler The fun stops right away with following message: checking for gcc... icc checking for C compiler default output... configure: error: C compiler cannot create executables See `config.log' for more details. Whats wrong? I did not tell mysql to drop the c compiler?! Did I? Thanx for any help, Andy _ Der WEB.DE Virenschutz schuetzt Ihr Postfach vor dem Wurm Netsky.A-P! Kostenfrei fuer alle FreeMail Nutzer. http://f.web.de/?mc=021157 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: compiling mysql with intel icc
Walter Andreas wrote: CFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict CC=icc CXX=icc CXXFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict ./configure --prefix=/usr/local/mysql--with-mysqld-user=mysqladm --without-debug --with-client-ldflags=-all-static--with-mysqld-ldflags=-all-static --disable-shared--localstatedir=/home/mysqladm/data --enable-assembler The fun stops right away with following message: checking for gcc... icc checking for C compiler default output... configure: error: C compiler cannot create executables See `config.log' for more details. What did config.log have in it? -- jimoe at sohnen-moe dot com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Long numbers
Hi There: I have a query where I get an average of weekly miles. For example: Average Weekly Miles: 3.4285714285714 How would I get this number into a more read format? Such as 3.42. I have tried the truncate but I can't seem to get it to work. Does any one have any suggestions? SELECT TURNCATE(AVG(distance)), rest of the query Thanks - CH __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: free software and open source
On Sun, 11 Apr 2004, Saurabh Data wrote: Can anyone in your own words clarify the difference between open source and free software. Don't take our words for it, get it from the Gnu's mouth: http://www.gnu.org/philosophy/free-software-for-freedom.html -sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Long numbers
I think your looking for the ROUND(N,D) function, IE:
select round('3.4285714285714',2) as miles;
3.43 miles
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.justlightening.net
MSN: [EMAIL PROTECTED]
1.985.320.1191
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Craig Hoffman wrote:
Hi There:
I have a query where I get an average of weekly miles.
For example:
Average Weekly Miles:
3.4285714285714
How would I get this number into a more read format? Such as 3.42. I
have tried the truncate but I can't seem to get it to work. Does any
one have any suggestions?
SELECT TURNCATE(AVG(distance)), rest of the query
Thanks - CH
__
Craig Hoffman - eClimb Media
v: (847) 644 - 8914
f: (847) 866 - 1946
e: [EMAIL PROTECTED]
w: www.eclimb.net
_
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Long numbers
that worked - Thanks a bunch!
CH
__
Craig Hoffman - eClimb Media
v: (847) 644 - 8914
f: (847) 866 - 1946
e: [EMAIL PROTECTED]
w: www.eclimb.net
_
On Apr 11, 2004, at 3:14 PM, Mike Blezien wrote:
I think your looking for the ROUND(N,D) function, IE:
select round('3.4285714285714',2) as miles;
3.43 miles
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.justlightening.net
MSN: [EMAIL PROTECTED]
1.985.320.1191
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Craig Hoffman wrote:
Hi There:
I have a query where I get an average of weekly miles.
For example:
Average Weekly Miles:
3.4285714285714
How would I get this number into a more read format? Such as 3.42. I
have tried the truncate but I can't seem to get it to work. Does any
one have any suggestions?
SELECT TURNCATE(AVG(distance)), rest of the query
Thanks - CH
__
Craig Hoffman - eClimb Media
v: (847) 644 - 8914
f: (847) 866 - 1946
e: [EMAIL PROTECTED]
w: www.eclimb.net
_
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mac Installation
I am trying to install MySql on MAC OS X. After the pkg is installed I am not able to start the MySql server due to the Socket error. ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Now, when I check the /tmp folder I see that there is no file by that name 'mysql.sock'. Has anyone faced a similar problem? Thanks, Mustafa. _ Contact brides grooms FREE! http://www.shaadi.com/ptnr.php?ptnr=hmltag Only on www.shaadi.com. Register now! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Constraining MySQL Replication
Hello all: I understand that MySQL Replication can be configured to replicate selected tables in a Database. Is there anyway to further constrain the replicate, say based on a query of these tables etc..? Thank you Gowtham. __ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
unified encoding
MySQLers: When I started porting an app from MSSQL to MySQL, I got a flurry of error messages complaining of Illegal mix of collations for operation ' IN '. I want to set all encodings to utf8 and leave them there. I finally managed (despite help from winmysqladmin.exe and the Services Control Panel applet) to start mysqld-nt with --default-character-set=utf8 (from a batch file). But the problem remains. Prefixing every string in the database with _utf8 is not an option, because then some statements still collide with them. How do I put a bullet in this problem? = Phlip http://www.xpsd.org/cgi-bin/wiki?TestFirstUserInterfaces __ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How can I avoid filesort with BETWEEN and ORDER BY
I am trying to optimize a query using both BETWEEN and ORDER BY but after months of reading and research I still can not get the hang of this. Details are as follows: 2 Tables CREATE TABLE `p_ad` ( `id` int(11) NOT NULL auto_increment, `cat` mediumint(9) NOT NULL default '0', `title` varchar(50) default NULL, `description` text, `location` varchar(50) default NULL, `pcode` varchar(8) default NULL, `pcode_id` smallint(4) default NULL, `ph` varchar(50) default NULL, `email` varchar(50) default NULL, `user_id` int(11) NOT NULL default '0', `date` timestamp(14) NOT NULL, `price` decimal(10,2) default NULL, `email_priv` tinyint(1) default '0', PRIMARY KEY (`id`), KEY `cat_pc_date` (`cat`,`pcode_id`,`date`), KEY `c_p_d` (`cat`,`pcode`,`date`), KEY `user` (`user_id`), KEY `cat_date` (`cat`,`date`) ) TYPE=MyISAM; CREATE TABLE `p_cat` ( `id` mediumint(9) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `parent` mediumint(11) default '0', `lft` mediumint(11) NOT NULL default '0', `rgt` mediumint(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `LFT` (`lft`), KEY `PARENT` (`parent`) ) TYPE=MyISAM; Query as follows: EXPLAIN SELECT p.* FROM p_cat c, p_ad p WHERE p.cat = c.id AND c.lft BETWEEN 4 AND 5 ORDER BY p.date DESC LIMIT 0,30; +---+---++--+-+--+---+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+---++--+-+--+---+-+ | p | ALL | cat_pc_date,c_p_d,cat_date | NULL |NULL | NULL 60002 | Using temporary; Using filesort | | c | range | PRIMARY,LFT | LFT| 3 | NULL | 1 | Using where | +---+---++--+-+--+---+-+ Is there any way I can get a query like this to avoid using a temporary table and filesort. ?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Set Password
Okay, I've been googling for about half an hour, found several useful links but I'm still having a problem with the password for the initial mysql db that is created when you follow the install instructions. Here is the problem I'm having: joseph-a-nagy-jr root # /usr/bin/mysqladmin -u root -h joseph-a-nagy-jr.homelinux.org password 'somepassword' /usr/bin/mysqladmin: connect to server at 'joseph-a-nagy-jr.homelinux.org' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' joseph-a-nagy-jr root # /usr/bin/mysqladmin -u [EMAIL PROTECTED] -h joseph-a-nagy-jr.homelinux.org password 'somepassword' /usr/bin/mysqladmin: unable to change password; error: 'Access denied for user: '@localhost' to database 'mysql'' joseph-a-nagy-jr root # when I do mysql -u root -p and it asks for me to enter the pwd, I enter somepassword and it allows me access to the mysql prompt. Do I need to set my router to forward the default mysql port to my box? I'm trying to set up a db driven game (which I posted about earlier) as well as create an ebuild for it and this is an essential part. I'm fixing to sub to the mysql mailing list and forward my problem there too as their archives show they've had similar problems but nothing exactly like mine and nothing (so far as I've looked on my own already) that would come close to being able to solve my problem. -- Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homelinux.org Political Activist Extraordinaire Peace, Life, Liberty The only fallacy is the inaction on our part to stave off the worst of horrors, the stripping of personal freedom. -- Joseph A. Nagy, Jr. January 2004 pgp0.pgp Description: PGP signature
Re: Set Password [SOLVED]
Problem solved. ): -- Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homelinux.org Political Activist Extraordinaire Peace, Life, Liberty The only fallacy is the inaction on our part to stave off the worst of horrors, the stripping of personal freedom. -- Joseph A. Nagy, Jr. January 2004 pgp0.pgp Description: PGP signature
Re: Mac Installation
on 04/11/2004 03:00 PM, Mustafa Hakim at [EMAIL PROTECTED] wrote: I am trying to install MySql on MAC OS X. After the pkg is installed I am not able to start the MySql server due to the Socket error. ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Now, when I check the /tmp folder I see that there is no file by that name 'mysql.sock'. Has anyone faced a similar problem? Look in your mysql directory for a .err file, what does it say in there? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How can I avoid filesort with BETWEEN and ORDER BY
Steven, In your case, you query doesn't even use an index. And you are using an order by DESC. Now what I would recommend is something like this, change your query just to test this out. SELECT p.* FROM p_cat c, p_ad p WHERE p.cat = c.id AND c.lft BETWEEN 4 AND 5 ORDER BY p.date DESC LIMIT 0,30; Select * from p_cat inner join p_ad on p_cat.id = p_ad.cat and p_cat.lft = 4 Order by p_ad.date ASC limit 0,30. Also add an index on id + lft on the p_cat table. And you also don't have an index on p_ad.date which is what you are trying to order by. Sorry, I had to rewrite the query because aliases drive me insane. Now in this case, you will see that with lft I have it set to do an exact match, not a range which is what between will give you. If you only were doing between two numbers like 4,5 or 100,101, I would personally recommend using IN. But that's my preference. Now with your order by, if you do the order by ASC, you won't have many if any problems. But you as a lot of people need to order by DESC, which mysql doesn't support very well, at least if you use explain. But there are work arounds to solve the problem, if you are like me and want to have 0 slow queries. Donny -Original Message- From: Steven Ducat [mailto:[EMAIL PROTECTED] Sent: Sunday, April 11, 2004 5:32 PM To: [EMAIL PROTECTED] Subject: How can I avoid filesort with BETWEEN and ORDER BY I am trying to optimize a query using both BETWEEN and ORDER BY but after months of reading and research I still can not get the hang of this. Details are as follows: 2 Tables CREATE TABLE `p_ad` ( `id` int(11) NOT NULL auto_increment, `cat` mediumint(9) NOT NULL default '0', `title` varchar(50) default NULL, `description` text, `location` varchar(50) default NULL, `pcode` varchar(8) default NULL, `pcode_id` smallint(4) default NULL, `ph` varchar(50) default NULL, `email` varchar(50) default NULL, `user_id` int(11) NOT NULL default '0', `date` timestamp(14) NOT NULL, `price` decimal(10,2) default NULL, `email_priv` tinyint(1) default '0', PRIMARY KEY (`id`), KEY `cat_pc_date` (`cat`,`pcode_id`,`date`), KEY `c_p_d` (`cat`,`pcode`,`date`), KEY `user` (`user_id`), KEY `cat_date` (`cat`,`date`) ) TYPE=MyISAM; CREATE TABLE `p_cat` ( `id` mediumint(9) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `parent` mediumint(11) default '0', `lft` mediumint(11) NOT NULL default '0', `rgt` mediumint(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `LFT` (`lft`), KEY `PARENT` (`parent`) ) TYPE=MyISAM; Query as follows: EXPLAIN SELECT p.* FROM p_cat c, p_ad p WHERE p.cat = c.id AND c.lft BETWEEN 4 AND 5 ORDER BY p.date DESC LIMIT 0,30; +---+---++--+-+--+ ---+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+---++--+-+--+ ---+-+ | p | ALL | cat_pc_date,c_p_d,cat_date | NULL |NULL | NULL 60002 | Using temporary; Using filesort | | c | range | PRIMARY,LFT | LFT| 3 | NULL | 1 | Using where | +---+---++--+-+--+ ---+-+ Is there any way I can get a query like this to avoid using a temporary table and filesort. ?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Set Password [SOLVED]
On Sun, Apr 11, 2004 at 06:34:28PM -0500, Joseph A. Nagy, Jr. wrote the following: Problem solved. ): snip Well, it wasn't a problem with mysql per sey but a problem with how I was entering the command. The man page says /usr/bin/mysqladmin -u user -p somepassword is correct as is /usr/bin/mysqladmin -u user --password(or pwd)=somepassword but the correct, undocumented way is /usr/bin/mysqladmin -u user -p password 'somepassword' The spaces are important. The mysql man page REALLY needs to be updated to reflect that the other methods DO NOT WORK. The way I had to do it is the only way it works, at least on my install. I'm running Gentoo Linux and the above way, according to what I've seen in the archives, seems to be the only real way to do it. -- Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homelinux.org Political Activist Extraordinaire Peace, Life, Liberty The only fallacy is the inaction on our part to stave off the worst of horrors, the stripping of personal freedom. -- Joseph A. Nagy, Jr. January 2004 pgp0.pgp Description: PGP signature
FBSD 5.2.CURRENT-p4 and mysqld problems
Hi, I found some problematic queries which locks mysql server any further processing. I'm using mysql-4.0.18 from FreeBSD ports collection. I'm using FreeBSD-5.2-CURRENT. Some of the queries like : select sum(total_amount) pbc from customers.payment where contract_id=0 and contract_id=4999 and from_unixtime(time_stamp,'%Y-%m')='2004-03'; Above query is not using any index. It locks mysql server and all other following queries go into queue until I kill locked mysqld thread. After killing locked mysqld thread everything goes back to function normally. I made composite index on contract_id,time_stamp,total_amount and let's see what will happen. In the meantime, can somebody explain me what the problem is? I already sent email to freebsd-current and freebsd-ports mailing list about this problem. Does somebody have this problem before? Let me know if there is any solution. I know I should use FreeBSD 4.9 stable since it doesn't have any problem with this issue. However I need to solve this problem on FreeBSD-5.2-CURRENT. thanks in advance, Ganbold At 01:36 PM 05.04.2004, you wrote: yes, we resolved the issue it looks like. I wanted to hold off on announcing this until i was sure, but it's been running for about 24 hours now without a lockup. options MAXDSIZ=(1024*1024*1024) # change max from 512M to 1G add that to your kernel config. basically whats happening ( and i'm probably wrong with the technicals on this, but bear with me :D ) is that mysqld would aquire a lock (on a table more then likely) and then try to allocate above the FBSD 5.2 max default memory size (512M). when it did this, it crashed and left the lock on the table. from there it just froze. making that change seems to have fixed it. it was never evident before because we had a slower webserver that wasn't loading the sql server all that much. now it is, and we started developing problems. :). as you can tell with this link: http://sql.tribalwar.com/before-ps.txt the mysqld proc wen't above 512M. check your sql.err log, if you're getting a malloc error, then this is more then likely your problem. Thanks to everyone for the help in tracking this down. Let me know if this fixes the problem for you. Also, are you running -CURRENT in production? or testing? I had given some thought to upgrading the box to -CURRENT after the commit for the network stack settled. But I first need to get serial console enabled on it :). Daryl --- Ganbold [EMAIL PROTECTED] wrote: Hi Daryl, I have exactly same problem as you. I have FreeBSD 5.2-CURRENT (did cvsup on March 23) with mysql-4.0.18 from ports collection. It is compiled with linuxthreads. Mysql is working fine, except it sometimes freezes, sometimes one or two tables get corrupted. Usually freezes once per day. Just freezes and I had to kill mysql process and start. Did you solve your problem? I also downloaded latest snapshot from mysql.com web site and installed, but nothing changes. Let me know if you find something. TIA, Ganbold At 12:48 PM 03.04.2004, you wrote: ah! thanks :) It just happened again and I was able to collect the data again. Before I did mysqladmin shutdown/killall -11 mysqld http://sql.tribalwar.com/before-ps.txt a few times the 3 giant processes would show as -, but then it got to the point where they weren't changing one bit (staying at Giant) after I did mysqladmin shutdown/killall -11 mysqld http://sql.tribalwar.com/after-ps.txt this eventually cleared up after a minute or so. I've given some serious thought to upgrading to -CURRENT, but with the network stack commit comming soon (or happening now), I don't want to get caught in the middle of it and have severe problems. Perhaps I should use a tag for the time right around the sysctl change for the mp stack? The guy running the site just wants me to (have someone at the colo) format the machine and go back to 4.9. Oh, I now have witness in the kernel...no deadlocks from what I've seen. HTH, Daryl --- Doug White [EMAIL PROTECTED] wrote: On Fri, 2 Apr 2004, Daryl Chance wrote: Thanks for your response. It just happened a few minutes ago and i was able to capture all the output into a text file. http://sql.tribalwar.com/ps.txt oops, sorry, I get those confused. You want 'ps axlwww'. WCHAN will be a string like select. I have WITNESS* options compiled into the kernel and am going to reboot soon. Do you think it would help in debugging this to see if there are any deadlocks? Potentially, although I get 100% cpu loops with kde that won't trigger any witness or invariants checks. -- Doug White| FreeBSD: The Power to Serve [EMAIL PROTECTED] | www.FreeBSD.org __ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/
Re: backup
Don't use rsync. Try rdiff-backup, its much more reliable and offers rolling restoration. On Sat, 2004-04-10 at 02:08, Matt W wrote: Hi Steve, You might want to look at FLUSH TABLES WITH READ LOCK. That's a query to run from mysql, but I'm sure you can get it to work in your shell script (you need to maintain the MySQL connection while doing the backup). I don't know much about that, though. I think you just run UNLOCK TABLES when you're finished. Matt - Original Message - From: Steve Sills Sent: Tuesday, April 06, 2004 8:17 PM Subject: backup I want to use rsync to backup my db server, how do i lock all the tables for all the db's to read only so i cando my backup, then unlock them again. It needs to be done from the command line, not the mysql program. Anyone have any ideas? I have looked and couldn't find the answer i was looking before. Its running from a shell script, from my backup machine. Its currently setup to shut down the server, however i don't want to have to do this. Thanks in advance. Steve Sills Platnum Computers, President http://www.platnum.com [EMAIL PROTECTED] Benjamin Arai Araisoft Email: [EMAIL PROTECTED] Website: http://www.araisoft.com
Re[2]: backup
Hi Matt, if Steve can accept the limitations, mysqlhotcopy might work for him: http://dev.mysql.com/doc/mysql/en/mysqlhotcopy.html If not, mysqldump with --add-locks could do it fairly easily, I should think... http://dev.mysql.com/doc/mysql/en/mysqldump.html Saturday, April 10, 2004, 5:08:43 AM, you wrote: MW Hi Steve, MW You might want to look at FLUSH TABLES WITH READ LOCK. That's a query MW to run from mysql, but I'm sure you can get it to work in your shell MW script (you need to maintain the MySQL connection while doing the MW backup). I don't know much about that, though. I think you just run MW UNLOCK TABLES when you're finished. MW Matt MW - Original Message - MW From: Steve Sills MW Sent: Tuesday, April 06, 2004 8:17 PM MW Subject: backup MW I want to use rsync to backup my db server, how do i lock all the tables MW for all the db's to read only so i cando my backup, then unlock them MW again. It needs to be done from the command line, not the mysql MW program. Anyone have any ideas? I have looked and couldn't find the MW answer i was looking before. Its running from a shell script, from my MW backup machine. Its currently setup to shut down the server, however i MW don't want to have to do this. Thanks in advance. MW Steve Sills MW Platnum Computers, President MW http://www.platnum.com MW [EMAIL PROTECTED] -- Best regards, Carsten R. Dreesbach mailto:[EMAIL PROTECTED] Senior Consultant Systar, Inc. 8000 Westpark Dr Suite 450 McLean, VA 22102 USA Tel: (703) 556-8436 Fax: (703) 556-8430 Cel: (571) 213-7904 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Getting mysql to work in Panther
I have been trying for months to set up mysql on my Mac (Panther) with no success. I can't run mysqladmin as root. I get an access denied error message. If I try to use SHELLmysqladmin -u root password 'password' I get access denied as either root or the regular user. I can't run mysql as root. 'access denied' I can't create databases. I can run mysql as the regular user and mess with the test db, and that's about all I can do. I've followed every instruction I could find online at the command line. I've tried CocoaMySQL. I have practically resorted to prayer. Are there step-by-step instructions anywhere? I would be eternally grateful for any help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
