Bug 33403 - Can not directly connect to MySQL database
Summary: Can not directly connect to MySQL database
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Database (show other bugs)
Version: 3.3.0 RC4
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-01-24 04:10 UTC by Mindaugas Baranauskas
Modified: 2011-01-24 05:00 UTC (History)
0 users

See Also:
i915 platform:
i915 features:

Attachments

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.