Bug #52059 The user_objects table is never created
Submitted: 15 Mar 2010 10:13 Modified: 15 Apr 2010 10:28
Reporter: Aique Fernandez Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version:5.1 OS:Microsoft Windows (XP)
Assigned to: CPU Architecture:Any
Tags: user_objects

[15 Mar 2010 10:13] Aique Fernandez
Description:
I have the mysql database installed in the system. I have created a database, a user, inserted some data... all works in command line.

But when I try to connect to the database through the JDBC driver from a Java application I have this exception:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mysql.user_objects' doesn't exist

With the mysql administrator the user_objects table doesn't appear in the information schema.

I have run the mysql_install_db.pl script but I have the same result.

The driver and the database are in their latest versions available in the mysql web.

How to repeat:
When I try to connect to the database from a Java application through the JDBC driver.

Suggested fix:
Creating the user_objects table automatically while the database installation.
[15 Mar 2010 10:28] Sveta Smirnova
Thank you for the report.

> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mysql.user_objects'
> doesn't exist

Correct. And this table should not be created. This looks like bug somewhere in your application.

If you don't agree and still think this is MySQL bug provide repeatable test case: Java code you are using to connect to mysqld and command you use to invoke Java program.
[15 Apr 2010 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".