MySQL Plugin create database

[Pablo Nieto Martinez]

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)


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[manningr]

On Thu, Nov 13, 2008 at 7:10 AM, Pablo Nieto Martinez
<pniemar@...> 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

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Mr.Goose]

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.

[Gerd Wagner-3]

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

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users