Tables were created previously on a different PC using LibreBase and MySQL, and the “.odb” file was copied from the previous PC. The Connector is working. Username and Password were verified via MySQL install.
Hello,
Have tried SBDC, JDBC and ODBC connectors and cannot exactly duplicate the the error with “error 42000”. However I can duplicate the “Unknown database” and it specifies the name being tried (which is obviously incorrect). This error appears in many posts such as:
ERROR 1049 (42000): Unknown database
Getting an existing AOO DB to Connect to MySQL.
and there are others all of which seem to indicate an incorrect DB name.
The name could also have changed when exporting/importing the MySQL data. Use MySQL Workbench or similar to verify your DB.
How do I find the correct name?
Thanks. Will try SQL workbench.
Make sure you use MySQL Workbench and NOT SQL Workbench/J. They are NOT the same.