Thread: [Squirrel-sql-users] MySQL Plugin create database
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Pablo N. M. <pn...@ca...> - 2008-11-13 12:34:33
|
Hello. First of all thanks for nice software I'm really impressed with the job done so far. But... (Yes, unluckily there's a "but") I'm having some problems trying to use the functionalities of MySQL Plugin. I'm using Version 2.6.8 installed using the .jar installer on a Linux box with Java 1.6 update 10 (the last stable version till now) as MySQL jdbc conector I'm using mysql-connector-java-5.1.7-bin.jar (Last version too) When I try to use the menu to 'Create Database' I get a dialog window asking for the name. So far it's ok. Then, I write a name and accept.. The result is not the expected, the database is not created. But I noticed that now there's a new item called 'USERS' where al the DB users are listed. I logged in MySQL ad root btw, so I'm sure I have all grants and rights to perform the action. And another weird behaviour is what happens if I clic on any user I get this error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: There is no such grant defined for user 'example@localhost' on host '%' Or this one: java.sql.SQLException: String 'longname@localhost' is too long for user name (should be no longer than 16) So I can't neither manage MySQL users. Is there something broken in the plugin with this version of Squirrel? Is there any workaround to make things work as expected? Thanks in Advance. -- Greetings. Pablo Nieto (Systems Administrator) |
From: Robert M. <rob...@gm...> - 2008-11-13 23:51:19
|
On Thu, Nov 13, 2008 at 7:10 AM, Pablo Nieto Martinez <pn...@ca...> wrote: > > When I try to use the menu to 'Create Database' I get a dialog window > asking for the name. So far it's ok. Then, I write a name and accept.. > > The result is not the expected, the database is not created. But I The "Create Database" action has a bug. The code that it relies on was commented out a while back. Not sure why we haven't come across that until now. Please file a bug report. > noticed that now there's a new item called 'USERS' where al the DB users > are listed. > I logged in MySQL ad root btw, so I'm sure I have all grants and rights > to perform the action. > And another weird behaviour is what happens if I clic on any user I get > this error: > > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: There is no > such grant defined for user 'example@localhost' on host '%' The users displayed come from this query: select concat(user, '@', host) from mysql.user When you click on a user it is attempting to execute this query: show grants for <user> But, the algorithm for stripping the username of the '@...' suffix is not quite right. Another bug. Please report that one as well. Thanks! Rob |
From: Mr.Goose <ed...@ga...> - 2009-07-22 03:19:41
|
I agree with the O/P. It is a nice bit of kit. But I note that although 8 months have passed since the first post in this thread, and the version is now 3.0.2, it seems we still cannot create a database in MySQL. This is a fairly major problem for us because we need to be able to create databases. Is this likely to be fixed any time soon? Or is there a relatively simple work-around, without having to resort to a command-line, or PHPMyAdmin? ------------------------------------ Hello. First of all thanks for nice software I'm really impressed with the job done so far. But... (Yes, unluckily there's a "but") I'm having some problems trying to use the functionalities of MySQL Plugin. I'm using Version 2.6.8 installed using the .jar installer on a Linux box with Java 1.6 update 10 (the last stable version till now) as MySQL jdbc conector I'm using mysql-connector-java-5.1.7-bin.jar (Last version too) When I try to use the menu to 'Create Database' I get a dialog window asking for the name. So far it's ok. Then, I write a name and accept.. The result is not the expected, the database is not created. But I noticed that now there's a new item called 'USERS' where al the DB users are listed. -- View this message in context: http://www.nabble.com/MySQL-Plugin-create-database-tp20479964p24599424.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
From: Gerd W. <ger...@t-...> - 2009-07-30 01:00:24
|
Mr.Goose wrote: > I agree with the O/P. It is a nice bit of kit. But I note that although 8 > months have passed since the first post in this thread, and the version is > now 3.0.2, it seems we still cannot create a database in MySQL. This is a > fairly major problem for us because we need to be able to create databases. > > Is this likely to be fixed any time soon? Or is there a relatively simple > work-around, without having to resort to a command-line, or PHPMyAdmin? > > ------------------------------------ > > Hello. First of all thanks for nice software I'm really impressed with > the job done so far. Thank you very much. > When I try to use the menu to 'Create Database' I get a dialog window > asking for the name. So far it's ok. Then, I write a name and accept.. > > The result is not the expected, the database is not created. But I > noticed that now there's a new item called 'USERS' where al the DB users > are listed. Is now fixed in CVS and will be available in coming snapshots/releases. A workaround is to execute "create data <new db Name>" in the SQL-Editor. Gerd |