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: Base (show other bugs)
Version:
(earliest affected)
3.3.0 RC4
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-01-24 04:10 UTC by opensuse.lietuviu.kalba
Modified: 2011-01-24 05:00 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description opensuse.lietuviu.kalba 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 opensuse.lietuviu.kalba 2011-01-24 05:00:18 UTC 
Excuse-me it works if I in field „data base name“ write real database name :)