Bug 33403

Summary:	Can not directly connect to MySQL database
Product:	LibreOffice	Reporter:	Mindaugas Baranauskas <embar>
Component:	Database	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG	QA Contact:
Severity:	normal
Priority:	medium
Version:	3.3.0 RC4
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
i915 platform:		i915 features:

Description Mindaugas Baranauskas 2011-01-24 04:10:27 UTC

I can connect to SQLdata base with MySQL Query Browser v1.2.12,
but I fail to connect with the same Server IP, port, username and password. 

If I use correct username and password, I get error:
The connection to the data source "Xxxxx" could not be established.
SQL Status: 42000
Error code: 1044
Access denied for user 'usernamexx'@'%' to database 'xxxxx'

If I enter wrong password, I see:
The connection to the data source "Xxxxx" could not be established.
SQL Status: 28000
Error code: 1045
Access denied for user 'usernamexx'@'linux-72om.home' (using password: YES)

So It seems, that LibreOffice differently behaves with correct and incorrect password, but still can't access database.
Besides, I see that OpenOffice 3.0.3rc10 has no option to direct connection to MySQL (only through ODBC and JDBC), but LibreOffice has such option.

Comment 1 Mindaugas Baranauskas 2011-01-24 05:00:18 UTC

Excuse-me it works if I in field „data base name“ write real database name :)

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.