Re: Error: Unknown database 'root@localhost'
Robert Großkopf <[email protected]> Wed, 16 Feb 2011 14:14:41 +0100
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
Hello Stefan, I'm not a developer, but have read the text "Getting_started" > > I want to use the MySQL Connector to transfer data tables from an Open > Office Database to a MySQL Database. I have Open Office 3.2.1 and I > connected OO with a new MySQL Database as described in > http://wiki.services.openoffice.org/wiki/Database/Drivers/MySQL_Native/1.0#Getting_Started:_Connecting_to_MySQL I could not understand that people will connect as "root" to mysql. A bad idea for anybody who is interested in a save system. > > > During the process the connection test is successful. You have connected and can see the tables of the mysql-database? > > As sonn as I drag and drop a table from OO db to the MySQL db, I can > select the imput parameters but when I click finish I get the Error in > the subject. How can I make it work? I have tried it, with the assistant I cannot get any connection, but when I finish ist works - not only for one database but for all databases of mysql at the same time. When I drag and drop data I have to select a database first. Example: I have a table "holidays". OpenOffice assistant asks for the name and only writes "holidays". I will create the tabele in "test". So I have to change the name to "test.holidays". So mysql will save it in the database test. Good luck Robert