Re: mysql Create table in system database

2009-11-16 Thread Johan De Meersman
File permissions ? SE Linux ? AppArmor ? On Mon, Nov 16, 2009 at 7:48 AM, Manasi Save manasi.s...@artificialmachines.com wrote: Thanks Shawn for the quick response. But then What I am doing is I am doing copy paste of one database and rename it to another. but I cannot read the tables

2d line plot graph vs. time

2009-11-16 Thread Mikie
Hello MySQL list people! I need software that will graphically plot 2d line charts vs. time for various data points from a MySQL database. Any ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: 2d line plot graph vs. time

2009-11-16 Thread Kemin Zhou
Gnuplot Mikie wrote: Hello MySQL list people! I need software that will graphically plot 2d line charts vs. time for various data points from a MySQL database. Any ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: 2d line plot graph vs. time

2009-11-16 Thread Phil
Try Chartdirector, available in many languages.. http://www.advsofteng.com Regards Phil On Mon, Nov 16, 2009 at 12:38 PM, Mikie k...@mikienet.com wrote: Hello MySQL list people! I need software that will graphically plot 2d line charts vs. time for various data points from a MySQL

Re: How to change root password?

2009-11-16 Thread Michael Wilson
None, of these suggestions worked... Tried the following ways to reset the password: (1) Shut down MySQL via System Preferences pane (2) Placed the following in a text file: UPDATE mysql.user SET Password=PASSWORD('') WHERE User='root'; FLUSH PRIVILEGES; (3 Invoked the following command from

Re: How to change root password?

2009-11-16 Thread John Daisley
Make sure your mysql server is not accessible to anyone else, its a good idea to disconnect all network connections because the server will be totally insecure for a short period of time! Start your MySQL server with the --SKIP-GRANT-TABLES option. At a shell prompt type mysql -uroot

Database design and query help

2009-11-16 Thread Eskil Kvalnes
Hello, Currently, I have four tables (Items, UpdatePrice, UpdateStatus and UpdateRelease). All the Update tables are linked to Items.ItemID via Update(Price|Status|Release)ItemKey. Personally, I don't feel that this is the best database design I could have, but I can't seem to come up with one

Re: How to change root password?

2009-11-16 Thread Michael Wilson
Okay, that worked, thank you! -Mike On Nov 16, 2009, at 6:49 PM, Hassan Schroeder wrote: On Mon, Nov 16, 2009 at 6:15 PM, Michael Wilson michaelwilso...@gmail.com wrote: I don't know what the password is for the Unix mysql user... You mean sign in as mysql in the OS X Login Window?

Strange mysql NDB Cluster error The table '' is full

2009-11-16 Thread Manasi Save
Hi All, I am facing a strange error in my NDB Cluster database. When I am trying to insert record in one table using mysql command line. But when I try to insert record in same table using my java application it is getting inserted properly. Through command-line I am getting following error. |