I have a database created on MySQL workbench that runs on my company server and I connected it to Base using this connector here MySQL Connector for OpenOffice.org | Apache OpenOffice Extensions .
I have several users (6 for now, but i plan on adding some more) and i didn’t have any problem whatsoever.
Today i tried removing the password from every user login autentication but it didn’t work. In the mysql workbench i removed the password (and i see the warning “no password” so i think it worked just fine) and in the base .obd file i unchecked the option “password required”.
When i try to acces the database it asks me for the password, I just press OK since there is no password to insert but then i get the error “Impossible creating the link to the “augeo” data source. User and password are mandatory” (i ruffly translated it from italian, sorry).
I already tried modifying the content.xml file as it’s said in this discussion here To reset password to default type but it didnt’ work, it still gives me the same error as before, the only difference is that now it doen’t even ask me for the user login, it just gives me the error .
I tried changing the connection, without the connector and with the direct connection but i still have the same error.
Do you have any solution for this?