mysqlcc / mysql query browser
Hi, MysqlCC not being in developement anymore and not working properly with a server 5.0, we are trying to use MySQL Query browser, but there are few things which are less than efficient compared to mysqlCC. - you can't execute several queries ! The query tab executes them one by one, and if you use a script tab, you don't have any results displayed... quite annoying. - edition of results are a pain, instead of a double-click, one need to click on edit, then double-click on the cell to edit (spacebar would have been quicker) and press enter. and you can't use the arrows to move around cells when you are editing (!). To commit you need to press Apply changes. It would be nice to have be able to edit cells without clicking on Edit and be able to move with the arrows (Apply changes is a good one though). - to open a connection on another server you need to do New instance connection, it would be great to have the same thing than MySQLCC, where you can see others server in the sidebar. It's easier to move around several servers and run query through them, instead of having several separate windows. What are your usual workarounds for these ? Is there any better interface to do some queries ? -- http://www.myspace.com/sakuradrop : forget the rest http://www.w-fenec.org/ Webzine rock/metal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlcc / mysql query browser
I use EMS MySQL Manager. You can buy it here: http://www.sqlmanager.net/en/products/mysql/manager/buy No, I am not affiliated with them, but I use the product everyday and I love it. Steve Musumeche CIO, Internet Retail Connection [EMAIL PROTECTED] Pooly wrote: Hi, MysqlCC not being in developement anymore and not working properly with a server 5.0, we are trying to use MySQL Query browser, but there are few things which are less than efficient compared to mysqlCC. - you can't execute several queries ! The query tab executes them one by one, and if you use a script tab, you don't have any results displayed... quite annoying. - edition of results are a pain, instead of a double-click, one need to click on edit, then double-click on the cell to edit (spacebar would have been quicker) and press enter. and you can't use the arrows to move around cells when you are editing (!). To commit you need to press Apply changes. It would be nice to have be able to edit cells without clicking on Edit and be able to move with the arrows (Apply changes is a good one though). - to open a connection on another server you need to do New instance connection, it would be great to have the same thing than MySQLCC, where you can see others server in the sidebar. It's easier to move around several servers and run query through them, instead of having several separate windows. What are your usual workarounds for these ? Is there any better interface to do some queries ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MysqlCC
Hi, i used MysqlCC for a long time with mysql 4.0 on my remote server... Now i've installed mysql 5.0 on my PC and i'd like to use MysqlCC but it doesn't work. It responds: [localhost] ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client You have something similar about mysql client last week but what about MysqlCC? Thanks for your answers... Vittorio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MysqlCC
Use old-passwords on the server or upgrade your client library. Regards Dominik [localhost] ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client You have something similar about mysql client last week but what about MysqlCC? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlcc temp table created for queries
Song Ken Vern-E11804 wrote:
It seems like different version are doing things differently.
This is the most normal thing in the world!
Looking through the newsgroups forums, I understand that that mysql5.0
will
prepend the tablename to each column.
But I don't understand what does 'test.1' refer to.
Test.1 is table 1 of the Database test.
database test
Table {1}
Table {anyname}
Table {insertnamehere}
Like: SELECT * FROM 1
i can't tell you what exactly is causing that error but i think
somewheer in that code there is a bug which causes this.
Regards
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlcc temp table created for queries
Hi, I am using mysqlcc 0.9.4-beta to browse my DB. Server side am using 5.0.18-nt. However, when I try to double click on a table to see the data, it will always return the error. [localhost] ERROR 1146: Table 'test.1' doesn't exist The SQL query for this is SELECT * FROM `test` The query is still sucessful but I would like to know what causes this error. However, when I try to browse another server running 4.1.10-nt, double clicking produces no such error. Setup is similiar to the above. It seems like different version are doing things differently. Looking through the newsgroups forums, I understand that that mysql5.0 will prepend the tablename to each column. But I don't understand what does 'test.1' refer to. Can anyone help explain? Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqlcc
Hi Robin Have you checked you have INSERT authorities to the database as the user you connected as? I have mysqlcc 0.9.2-beta (on Win2k) connecting to a mySQL 4.0.20 (Linux) database and it's been working fine for months. Graham -Original Message- From: Robin Lynn Frank [mailto:[EMAIL PROTECTED] Sent: 11 December 2004 01:23 To: MySQL Mailing List Subject: mysqlcc I'm obviously missing something. I can use mysqlcc to change data in a row of a table and save it. But, if I try to insert a row, add data and save it, it never gets saved. What am I overlooking? -- /\ ASCII RIBBON Robin Lynn Frank \ / CAMPAIGN Director of Operations X AGAINST Paradigm-Omega, LLC / \ HTML MAILhttp://www.paradigm-omega.com/ = Spambots visit http://paradigm-omega.net/cgi-bin/custmail.cgi = Don't mind me. I am having a bad (day|week|month|year). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlcc
I'm obviously missing something. I can use mysqlcc to change data in a row of a table and save it. But, if I try to insert a row, add data and save it, it never gets saved. What am I overlooking? -- /\ ASCII RIBBON Robin Lynn Frank \ / CAMPAIGN Director of Operations X AGAINST Paradigm-Omega, LLC / \ HTML MAILhttp://www.paradigm-omega.com/ = Spambots visit http://paradigm-omega.net/cgi-bin/custmail.cgi = Don't mind me. I am having a bad (day|week|month|year). signature.asc Description: This is a digitally signed message part
Re: mysqlcc
MySQL CC seems to be discontinued. Nowadays I prefer SQLyog (http://www.webyog.com) Karam --- Robin Lynn Frank [EMAIL PROTECTED] wrote: I'm obviously missing something. I can use mysqlcc to change data in a row of a table and save it. But, if I try to insert a row, add data and save it, it never gets saved. What am I overlooking? -- /\ ASCII RIBBON Robin Lynn Frank \ / CAMPAIGN Director of Operations X AGAINST Paradigm-Omega, LLC / \ HTML MAILhttp://www.paradigm-omega.com/ = Spambots visit http://paradigm-omega.net/cgi-bin/custmail.cgi = Don't mind me. I am having a bad (day|week|month|year). ATTACHMENT part 2 application/pgp-signature name=signature.asc __ Do you Yahoo!? The all-new My Yahoo! - What will yours do? http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Running mysql-administrator and mysqlcc graphical clients
Hi list, i've installed mysql-administrator and mysqlcc graphical clients downloaded from mysql.com. As i read in doc from the site, i unzipped the downloaded files in /usr/local. It seems to be ok, but i cannot execute the apps. [EMAIL PROTECTED] bin]$ ls mysql-administrator mysql-administrator-bin [EMAIL PROTECTED] bin]$ mysql-administrator bash: mysql-administrator: command not found [EMAIL PROTECTED] bin]$ The system shows mysql-administrator file in green and it looks like the bash shell cannot execute it. I have the same problems when trying to run mysqlcc. Any help? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Running mysql-administrator and mysqlcc graphical clients
On Tuesday 13 July 2004 08:12, A. Lanza might have typed: Hi list, i've installed mysql-administrator and mysqlcc graphical clients downloaded from mysql.com. As i read in doc from the site, i unzipped the downloaded files in /usr/local. It seems to be ok, but i cannot execute the apps. [EMAIL PROTECTED] bin]$ ls mysql-administrator mysql-administrator-bin [EMAIL PROTECTED] bin]$ mysql-administrator bash: mysql-administrator: command not found You don't have . in your path most likely. ./mysql-administrator -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Databases not seen in MySQLCC
Marvin Cummings wrote: Have a strange problem where only one of my databases shows up in the MySQLCC console, yet if I look in the MySQL Admin console all databases are seen. Anyone experience this before? If you right-click the server entry in MySQLCC and select Edit, there is a Databases tab where you can select the databases to be shown. Check whether the Show all Databases checkbox is enabled. Hans-Peter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Databases not seen in MySQLCC
Have a strange problem where only one of my databases shows up in the MySQLCC console, yet if I look in the MySQL Admin console all databases are seen. Anyone experience this before?
How to configure MySQLCC so that it can display utf8/utf16 string s correctly
Hi, I wrote an jdbc application and inserted strings data into the database. I can correctly selected them back. However, I can not visually see the data stored in the data through the MySQLCC GUI. Is there a way to explicitly specify the character set for MySQLCC? Any idea? Regards, Michael Wu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL takes 8Sek, MySQLcc takes 0.1Sek to run the same query. WHY???
MySQL puts an automatic limit of 1000 on all select queries. Try adding LIMIT 10, and perhaps then it will take a good long time like you want. Tom. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL takes 8Sek, MySQLcc takes 0.1Sek to run the same query. WHY???
Hi! I'm trying to run the following query. (SELECT Priority, OnDateExt, OnTime, OnMilli, OffDateExt, OffTime, Name, Native_SumDesc, Comment FROM history.alarm_summary WHERE OnDateExt DATE_SUB(CURDATE(), INTERVAL 14 DAY) ) UNION (SELECT Priority, OnDateExt, OnTime, OnMilli, OffDateExt, OffTime, Name, Native_SumDesc, Comment FROM history.event_summary WHERE OnDateExt DATE_SUB(CURDATE(), INTERVAL 14 DAY) ) ORDER BY 2 DESC, 3 DESC, 4 DESC LIMIT 0,38 The alarm_summary and event_summary contains about 150k records and OnDateExt, OnTime, OnMilli is indexed. The fun part is that this this query takes about 8-10 sek to complete with excel(import external data), the mysql client (command prompt) and a using odbc mfc classes but with MySQLcc it takes only 0.1sek to run??? I've tried to change the query so there's no possibility that MySQLcc has cached something but cannot make mysqlcc run the query under 0.2 sek. Can anybody have any clue on why this is happening. This is a quite serious issue because if the query takes 8sek i have to seriously rethink things to make it run faster because the mysql server is running at high cpu usage during the query and i have other tasks at that computer that also needs a little cpu time. Perhaps move the last 14 days of data into a separate table instead of running the query in the large table but how can the mysqlcc be that fast???, it has to be an illusion but i cant figure out why i'm seeing it. Any thoughts Cheers Fredrik Högberg
Re: mysqlcc syntax file?
Alaios [EMAIL PROTECTED] wrote: Hi there. I am trying to create a table using the mysql control center but i am taking the error. Unable to locate syntax.txt Please locate the file. Any sugestion? Find where syntax.txt is located and set up path to this file in the General Configuration Dialog window. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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]
mysqlcc syntax file?
Hi there. I am trying to create a table using the mysql control center but i am taking the error. Unable to locate syntax.txt Please locate the file. Any sugestion? __ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. 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]
MySQLCC - Garbage Display
Hello: I'm using mysqlcc version 0.9.3 on RH 9.0. When I upgraded from RH 7.2, the application seems to have changed into a bizarre, unreadable font. Does anyone know what could be the problem? Obviously, this renders the application entirely unusable. I suspect a QT problem, will look for source and try to compile, if no other solution offered. Thanks tim -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlfront versus mysqlcc
I currently use the excellent mysqlfront which is sadly no longer supported. I've tried mysqlcc but it seems non-intuitive, and missing loads of features. It also has a problem working with old versions of mysql 3.23.47 Or have I missed something, does anyone recommend mysqlcc??? zzapper -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlfront versus mysqlcc
Try SQLyog at www.sqlyog.com It is pretty good, and full of interesting features. Bye I currently use the excellent mysqlfront which is sadly no longer supported. I've tried mysqlcc but it seems non-intuitive, and missing loads of features. It also has a problem working with old versions of mysql 3.23.47 Or have I missed something, does anyone recommend mysqlcc??? zzapper -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlfront versus mysqlcc
It looks nice. Too bad it's not Linux, yet. Hopefully in 2004. -Marc On Fri, 2003-11-14 at 08:51, Daniel Kiss wrote: Try SQLyog at www.sqlyog.com It is pretty good, and full of interesting features. I currently use the excellent mysqlfront which is sadly no longer supported. I've tried mysqlcc but it seems non-intuitive, and missing loads of features. -- Marc [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't Access DB from MySQLCC
Randy Chrismon [EMAIL PROTECTED] wrote: Don't think this is the issue. If it were, I wouldn't be able to use MySQLCC on my own local database which is also 4.1.0 alpha, would I? Do you use password when you connect to the local 4.1 MySQL server? Yes. No password, no entry. This is the answer why you can connect to the local 4.1 MySQL server with MySQLCC. Set up a password and you should get Client does not support .. error, too. Can you connect without --protocol option using 4.1 mysql command-line client program? No. If I leave off the --protocol option, I get the error message saying I should upgrade my client, even though both sides of the transaction are 4.1.0 alpha. Well, now that I read your response more carefully, no, I don't need the --protocol option if I am connecting to my local 4.1.0 database using the command line. I DO need it, however, to connect to the 4.1.0 database on the other machine. On the other hand, I do NOT need the option if I connect to a 4.0.15 database on yet another machine. With MySQLCC, I can connect to the local 4.1.0 database and the remote 4.0.15 database. Trying to connect to the 4.1.0 database yields the same upgrade-your-client error message I get with the command line if I leave off the ---protocol=TCP option. Hmm .. strange I can connect with 4.1 client to the 4.1 server without any problem (with or without --protocol option). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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]
Re: Can't Access DB from MySQLCC
Randy Chrismon [EMAIL PROTECTED] wrote: Victoria Reznichenko wrote: MySQL 4.1 provides new password hashing mechanism. This error appears if you connect with pre-4.1 client to the server 4.1. ook at: http://www.mysql.com/doc/en/Password_hashing.html In the above section of the manual you can find description of possible scenarios for 4.1 server. Don't think this is the issue. If it were, I wouldn't be able to use MySQLCC on my own local database which is also 4.1.0 alpha, would I? Do you use password when you connect to the local 4.1 MySQL server? The only way that I can get the command line on my laptop to connect to my linux box is to include the protocol option (--protocol=TCP), even though the laptop is purely a 4.1.0 install. Can you connect without --protocol option using 4.1 mysql command-line client program? MySQLCC, apparently, does not accept the protocol command line parameter and it gives me the same error message I get when I don't use the protocol parameter on the command line. Of course, MySQLCC connects just fine to my other MySQL database which also happens to be a 4.0.15 setup on a Win2K desktop. So, I guess it's one of those things where it's both fish and fowl. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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]
Re: Can't Access DB from MySQLCC
Don't think this is the issue. If it were, I wouldn't be able to use MySQLCC on my own local database which is also 4.1.0 alpha, would I? Do you use password when you connect to the local 4.1 MySQL server? Yes. No password, no entry. Can you connect without --protocol option using 4.1 mysql command-line client program? No. If I leave off the --protocol option, I get the error message saying I should upgrade my client, even though both sides of the transaction are 4.1.0 alpha. Well, now that I read your response more carefully, no, I don't need the --protocol option if I am connecting to my local 4.1.0 database using the command line. I DO need it, however, to connect to the 4.1.0 database on the other machine. On the other hand, I do NOT need the option if I connect to a 4.0.15 database on yet another machine. With MySQLCC, I can connect to the local 4.1.0 database and the remote 4.0.15 database. Trying to connect to the 4.1.0 database yields the same upgrade-your-client error message I get with the command line if I leave off the ---protocol=TCP option. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't Access DB from MySQLCC
This irritating rather than life-threatening: I can connect to the MySQL database on my Linux box, from my Win2K box, using the command line environment just fine: c:mysql --protocol=TCP -h host_name -u my_name -p mysql No matter what I try, however, I can't connect using MySQLCC. I always get this error: [Lucifer] ERROR 1249: Client does not support authentication protocol requested by server. Consider upgrading MySQL client. This is the same error my test user gets trying to connect to this database using MyODBC 3.51. Of course, I'm not using ODBC from MySQLCC. MySQL 4.1.0 alpha is running on the Linux box. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't Access DB from MySQLCC
Randy Chrismon [EMAIL PROTECTED] wrote: This irritating rather than life-threatening: I can connect to the MySQL database on my Linux box, from my Win2K box, using the command line environment just fine: c:mysql --protocol=TCP -h host_name -u my_name -p mysql No matter what I try, however, I can't connect using MySQLCC. I always get this error: [Lucifer] ERROR 1249: Client does not support authentication protocol requested by server. Consider upgrading MySQL client. This is the same error my test user gets trying to connect to this database using MyODBC 3.51. Of course, I'm not using ODBC from MySQLCC. MySQL 4.1.0 alpha is running on the Linux box. MySQL 4.1 provides new password hashing mechanism. This error appears if you connect with pre-4.1 client to the server 4.1. Look at: http://www.mysql.com/doc/en/Password_hashing.html In the above section of the manual you can find description of possible scenarios for 4.1 server. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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]
Re: Can't Access DB from MySQLCC
Victoria Reznichenko wrote: MySQL 4.1 provides new password hashing mechanism. This error appears if you connect with pre-4.1 client to the server 4.1. ook at: http://www.mysql.com/doc/en/Password_hashing.html In the above section of the manual you can find description of possible scenarios for 4.1 server. Don't think this is the issue. If it were, I wouldn't be able to use MySQLCC on my own local database which is also 4.1.0 alpha, would I? The only way that I can get the command line on my laptop to connect to my linux box is to include the protocol option (--protocol=TCP), even though the laptop is purely a 4.1.0 install. MySQLCC, apparently, does not accept the protocol command line parameter and it gives me the same error message I get when I don't use the protocol parameter on the command line. Of course, MySQLCC connects just fine to my other MySQL database which also happens to be a 4.0.15 setup on a Win2K desktop. So, I guess it's one of those things where it's both fish and fowl. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 1000 rows in MySQLcc
Oscar (TOMCAT) [EMAIL PROTECTED] wrote: I'm using MySQLcc version 0.9.2-beta... I want to recover more than 1000 rows in a select statement... What is the command to alter this setting ??? Open the Register Server window, go to the MySQL Options, there you can find Automatically limit SELECT queries to. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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]
Re: 1000 rows in MySQLcc
On Wednesday, September 24, 2003, at 03:25 PM, Oscar (TOMCAT) wrote: I'm using MySQLcc version 0.9.2-beta... I want to recover more than 1000 rows in a select statement... What is the command to alter this setting ??? You can always explicitly add the LIMIT clause to change this for your queries. The 1000 limit only kicks in as a default. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1000 rows in MySQLcc
Title: Mensagem Hi, everybody, I'm using MySQLcc version 0.9.2-beta... I want to recover more than 1000 rows in a select statement... What is the command toalter this setting ??? Thanks, ===José Oscar de Souza EduardoCoordenador de Projetostel: 3047-4541fax: 3047-4550[EMAIL PROTECTED]===
mysqlcc 0.9.2 no connections...
I installed and linked 0.9.2 on RH9 as instructed, and when I start mysqlcc, I get the server registration dialog. When I attempt to connect, I get a message in the message dialog which says connecting and thats it! It never actually connects. I have checked to make sure that mysqld is, in fact, running (it is). What have I missed ?
Re: mysqlcc 0.9.2 no connections...
John, John Dangler said: I installed and linked 0.9.2 on RH9 as instructed, and when I start mysqlcc, I get the server registration dialog. When I attempt to connect, I get a message in the message dialog which says connecting. and that's it! It never actually connects. I have checked to make sure that mysqld is, in fact, running (it is). What have I missed ? is the CC on the same machine as the Deamon? I had trouble connecting to a different machine. With both on the same computer I did not have any problems. I didn't get into it too much so I don't really have a solution myself. Sorry. -- Once a problem is defined - it is half way solved. (Henry Ford) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysqlcc vs Phpmyadmin
Hello again people, Can someone tell me if mysqlcc does the same thing as phpmyadmin. Thank you all Ola
mysqlcc LIMIT
mysqlcc has a limit of 1000 on all queries I run. I can understand this for SELECT queries, but it makes no sense for INSERT... SELECT queries. Is there a way to override this limit? -Jackson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysqlcc vs Phpmyadmin
No. Ones a client application the other is a web app. The client application has SQL completion, the web app does not. ---Original Message- --From: Ola Ogunneye [mailto:[EMAIL PROTECTED] --Sent: Thursday, July 31, 2003 11:52 AM --To: [EMAIL PROTECTED] --Subject: Mysqlcc vs Phpmyadmin -- --Hello again people, -- --Can someone tell me if mysqlcc does the same thing as phpmyadmin. -- --Thank you all -- --Ola -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysqlcc vs Phpmyadmin
Contents are Direct Alliance Corporation CONFIDENTIAL - - For writing long sql statements I prefer mysqlcc, and the tab feature is nice. - Phpmyadmin also has some handy feature. Most of it is preference... If learn to use both then all the better... -Original Message- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 1:15 PM To: 'Ola Ogunneye'; [EMAIL PROTECTED] Subject: RE: Mysqlcc vs Phpmyadmin No. Ones a client application the other is a web app. The client application has SQL completion, the web app does not. ---Original Message- --From: Ola Ogunneye [mailto:[EMAIL PROTECTED] --Sent: Thursday, July 31, 2003 11:52 AM --To: [EMAIL PROTECTED] --Subject: Mysqlcc vs Phpmyadmin -- --Hello again people, -- --Can someone tell me if mysqlcc does the same thing as phpmyadmin. -- --Thank you all -- --Ola -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This message is for the designated recipient(s) only and contains Direct Alliance Corporation privileged and confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this email is prohibited.
Re: mystry about mysqlcc
Andreas wrote: I got me a copy of mysqlcc 0.9.2-beta and installed it on my win 2000 box. No complaints so far. There is an icon on the desktop. I click it and for a really short moment there is a sandclock and then nothing happens. Mysqlcc just dosn't bother to appear. I went to the c:\programme\mysqlcc directory on the console and tried to start it on the command line to catch some error messages but still nothing happens. Then I copied the zip to my notebook which has more or less the same windows on it. There everything works fine. Any hints what there's wrong with my desktop-comp ? I had the same problem with mysqlcc working on a win2k desktop but not working on a win2k notebook, so probably the desktop isn't the problem. Using some trace utility, I found that mysqlcc.exe exited soon after reading C:\WINNT\my.ini on the bad computer (without the mysqlcc windows appearing). The good computer had no MySQL installed thus it had no C:\WINNT\my.ini file. Looking at the my.ini file for suspicious options, I found that changing the line socket = /tmp/mysql.sock to #socket = /tmp/mysql.sock (commmenting it out) makes mysqlcc work again. Renaming/removing my.ini works as well, but is probably not what you want. Does this help? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mystry about mysqlcc
Hans-Peter Grimm wrote: Looking at the my.ini file for suspicious options, I found that changing the line socket= /tmp/mysql.sock to #socket= /tmp/mysql.sock (commmenting it out) makes mysqlcc work again. Does this help? YES ! Perfectly ! :) Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mystry about mysqlcc
Hi list, I got me a copy of mysqlcc 0.9.2-beta and installed it on my win 2000 box. No complaints so far. There is an icon on the desktop. I click it and for a really short moment there is a sandclock and then nothing happens. Mysqlcc just dosn't bother to appear. I went to the c:\programme\mysqlcc directory on the console and tried to start it on the command line to catch some error messages but still nothing happens. Then I copied the zip to my notebook which has more or less the same windows on it. There everything works fine. Any hints what there's wrong with my desktop-comp ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlcc not coming up in Windows XP
I am trying to run MySQLcc(0.9.2) on Windows XP. When I try to bring it up I get an hourglass for a second, then nothing happens. Has anyone had similar issues or any ideas as to what could cause this? Thanks (mysql, query) Scott Pippin [EMAIL PROTECTED]
mysqlcc bug ?
I have noticed that mySQL Control Center (beta 092), will only return back 1000 rows whenever I doubleclick on a table that I know contains an amount greater than 1000 rows. I've checked all properties in mysqlcc and nothing makes a difference. When I select the table and then choose Return all Rows, same behaviour - 1000 rows outputted only. When I select Return Limit, and enter a very large number, I then get the all of the rows retrieved and displayed ... Is this a bug ? Thanks, Travis Weir Cognos Inc. Join us at Cognos' biggest event of the year Enterprise 2003, The Cognos Business Forum. Taking place in over 25 cities around the world, its an opportunity for Business and IT leaders to learn about strategies for driving performance. Visit http://www.cognos.com/enterprise03 for more details. This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.
Re: mysqlcc bug ?
Asfar as I know that is the default settings in the mysql server to be returned. So you will have to set the necessary parameter from the mysql command line client. Best regards Nils Valentin Tokyo/Japan 2003 7 16 22:32Weir Travis : I have noticed that mySQL Control Center (beta 092), will only return back 1000 rows whenever I doubleclick on a table that I know contains an amount greater than 1000 rows. I've checked all properties in mysqlcc and nothing makes a difference. When I select the table and then choose Return all Rows, same behaviour - 1000 rows outputted only. When I select Return Limit, and enter a very large number, I then get the all of the rows retrieved and displayed ... Is this a bug ? Thanks, Travis Weir Cognos Inc. Join us at Cognos' biggest event of the year Enterprise 2003, The Cognos Business Forum. Taking place in over 25 cities around the world, its an opportunity for Business and IT leaders to learn about strategies for driving performance. Visit http://www.cognos.com/enterprise03 for more details. This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you. -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems compiling mysqlcc
When compiling mysqlcc-0.9.2,I get: checking for libmysqlclient... checking for /usr/lib/mysql//libmysqlclient.a...yes checking for mysql_real_connect in -lmysqlclient...no configure:error:Could not find libmysqlclient in `/usr/lib/mysql/ /usr/lib/ ...etc. I did: ./configure --with-mysql-lib=/usr/lib/mysql \ --with-mysql-include=/usr/include/mysql \ --with-qt=/usr/lib/qt3 Previously,I had started mysqld and set a password for the mysql root user.What do is wrong here? Thank you. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error in mysqlcc
Hi there - I have a database and I am using mysqlcc to admin the mysql server. At anyrate - when I am connected and I am trying to create a new table, and I get the error: Could not load Field Types. Please select the location of the Syntax File in 'Options-General-Sql Editor' and re-open this dialog. Any ideas? I mean the file that is supposed to be there /home/user/syntax.txt is missing - so how do I create this file? .::d::. --- THEbeatingsWILLcontinueUNTILmoraleIMPROVES --- - 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
mysqlcc - release 0.8.10-beta - show create
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mysqlcc - release 0.8.10-beta - show create Description: If there are more than one database (database1, database2, database3) connected by MySQLCC, and you will start the function show create for one of the tables of database2, you get not an correct response, but an error-message: ERROR 1146: Table 'database1.tablename' doesen't exist. Same result after 'disconnect' database1. How-To-Repeat: start mysqlcc, connect to more than one database, let you show all tables of the second database, click on one of the listed tables, start the function show create Fix: Submitter-Id: [EMAIL PROTECTED] Originator:Michael Scheidt Organization: Moeller Werke GmbH Kupferhammer D-33649 Bielefeld PHONE 0049 521 44 77 132 FAX 0049 521 44 77 222 MySQL support: none Synopsis: bad function show create Severity: non-critical Priority: low Category: mysqlcc Class: sw-bug Release: mysqlcc-0.8.10-beta Environment: FUJITSU-SIEMENS, Windoz 2000 SP2 System: Linux dbssv1 2.4.18-4GB #1 Wed Mar 27 13:57:05 UTC 2002 i686 unknown (database-server) Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC:Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='-O2 -march=i486 -mcpu=i686 -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rwxr-xr-x1 root root 1394238 Mär 23 2002 /lib/libc.so.6 -rw-r--r--1 root root 25361424 Mär 23 2002 /usr/lib/libc.a -rw-r--r--1 root root 178 Mär 23 2002 /usr/lib/libc.so -rw-r--r--1 root root 869190 Mär 23 2002 /usr/lib/libc-client.a lrwxrwxrwx1 root root 20 Okt 7 14:54 /usr/lib/libc-client.so - libc-client.so.2001a -rwxr-xr-x1 root root 725296 Mär 23 2002 /usr/lib/libc-client.so.2001a Configure command: ./configure --disable-shared --with-mysqld-ldflags=-static --with-client-ldflags=-static --without-berkeley-db --without-innodb --enable-assembler --enable-large-files --infodir=/usr/share/info --libdir=/usr/lib --libexecdir=/usr/sbin --localstatedir=/var/lib/mysql --mandir=/usr/share/man --prefix=/usr --sysconfdir=/etc --with-mysqld-user=mysql --without-debug --datadir=/usr/share --includedir=/usr/include --with-extra-charsets=complex --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-libwrap - 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
MySQLcc list down?
Hi, I was wondering if anyone knows - is the MySQLcc list down? I signed up yesterday but never got a confirmation e-mail from them. - 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
MysqlCC
Hello, In MySQL Control Center 0.9.10 you cannot add an hotkey for cell edit (double click on cell to edit it's content). I think that adding a key for this is very important so the user will not need the mouse to edit cells. Sorin Sbarnea - 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
mysql + mysqlcc
i have a problem when i use mysqlcc connect server Linux 7.3 ( Client Windows98se ) show massage Error 1130 Host 192.168.0.11 not allowed connect this Mysql Server _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail - 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 + mysqlcc
You have to add a new user with hostip 192.168.0.11 With kind regards, Richard Pijnenburg Klik-on Internet Solutions -Original Message- From: Narin Cherdchoosat [mailto:[EMAIL PROTECTED] Sent: Sunday, March 02, 2003 3:38 PM To: [EMAIL PROTECTED] Subject: mysql + mysqlcc i have a problem when i use mysqlcc connect server Linux 7.3 ( Client Windows98se ) show massage Error 1130 Host 192.168.0.11 not allowed connect this Mysql Server _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail - 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
MySQLCC
Hello How can i translate MySQLCC on Bulgarian? - 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
mysqlcc client
Why would the mysqlcc client need to use such a new and unstable version of the qt libs. For god sake, Suse is only using 3.03 and this 'requires' 3.05. This is like a disease with GNOME and KDE developers lately. Why does everyone push the libraries to the brink all the time. It just makes things hard and creates development chaos. There is no need to be on the bleeding edge all the time and to through backward compatability out the window. Frankly, I don't know why it even needs the Qt libraries. What is wrong with the standard X libraries? Ruben -- __ Brooklyn Linux Solutions __ DRM is THEFT - We are the STAKEHOLDERS http://fairuse.nylxs.com http://www.mrbrklyn.com - Consulting http://www.inns.net -- Happy Clients http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and articles from around the net http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn 1-718-382-0585 - 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
How to install MySQLCC on W98
Hi, The MySQLCC's setup.exe program is calling MSIEXEC windows installator. I have no such program on my W98. Is it a problem only of my windows 98 or it is possible to use MySQLCC only on w2000 and newer? Is there any way how to install MySQL Control Center without MSIEXEC? Thanks Michal __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.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: How to install MySQLCC on W98
Since you are on Windows I will suggest take a look at SQLyog at http://www.webyog.com/sqlyog I prefer it over MySQLCC Karam --- Michal Seidl [EMAIL PROTECTED] wrote: Hi, The MySQLCC's setup.exe program is calling MSIEXEC windows installator. I have no such program on my W98. Is it a problem only of my windows 98 or it is possible to use MySQLCC only on w2000 and newer? Is there any way how to install MySQL Control Center without MSIEXEC? Thanks Michal __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.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 __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.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
Hungarian FONT problem in MySQLCC!
Hi All, Please help me. I can't use some hungarian characters (long accent mark and ) in the MySQL Control Center (version: 0.8.7-alpha, on op.sys.: Windows 2000 proffesional), because the application changes my fonts to ? (question mark) in the query, altough the MySQL server (ver.: 3.23.51) and its client can store/use this letters. How can I solve this problem? Thanks: Bela - 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
mysqlcc 0.8.7-alfa (win32) not supporting russian charset?
Hello when using mysqlcc and adding for russian symbols into database fields, it represents as ?? When using other client - all is o'k. the repeatable steps are: 1. open mysqlcc 2. open some table 3. enter in the field of type string some russian letters 4. uddate this record 5. see the ?? instead of russian letters --- regards, Dmitry - 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
How to enter data in MySQLCC
Please someone email me at [EMAIL PROTECTED] how to do this as well...I am lost on how to ad data to MYSQLCC - 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
How to enter data in MySQLCC
Please someone email me at [EMAIL PROTECTED] how to do this as well...I am lost on how to ad data to MYSQLCC - 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
How to enter data in MySQLCC
Please someone email me at [EMAIL PROTECTED] how to do this as well...I am lost on how to ad data to MYSQLCC - 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
How to enter data in MySQLCC
Please someone email me at [EMAIL PROTECTED] how to do this as well...I am lost on how to ad data to MYSQLCC
How to enter data in MySQLCC
Hi, I've installed MySQLCC as a client on Windows 2000, it connects via the net to a linux server running the mysql server and it's working ok to the point where I try to enter data into any cell of my tables other than one expecting a numerical value. I know MySQLCC is only in beta test mode but surely it should be able to accept data entry in non numerical cells? Thanks, Jeff - 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
