Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

The MySQL database you named testdatabase is different than the "database" that LibreOffice base is asking you to create. It is asking you to create a .odb file that will act as a front end to your MySQL database. The .odb file can have any name you want.

It sounds as though you did create an .odb file and the connector works but are still having connection problems. The connection properties for a MySQL database that is on the same computer and that is accessible using the MySQL root user are: Database name "testdatabase" (without the quotes, and case sensitive), Server localhost, User name root. You will be prompted for the root password when you attempt to use the database.

From your description the problem may be that you used testdatabase for MySQL and TestDatabase for LO base.

The MySQL database you named testdatabase is different than the "database" that LibreOffice base is asking you to create. It is asking you to create a .odb file that will act as a front end to your MySQL database. The .odb file can have any name you want.

It sounds as though you did create an .odb file and the connector works but are still having connection problems. The connection properties for a MySQL database that is on the same computer and that is accessible using the MySQL root user are: Database name "testdatabase" (without the quotes, and case sensitive), Server localhost, User name root. You will be prompted for the root password when you attempt to use the database.

From your description the problem may be that you used the name testdatabase for MySQL and TestDatabase for LO base.

The MySQL database you named testdatabase is different than the "database" that LibreOffice base is asking you to create. It is asking you to create a .odb file that will act as a front end to your MySQL database. The .odb file can have any name you want.

It sounds as though you did create an .odb file and the connector works but are still having connection problems. The connection properties for a MySQL database that is on the same computer and that is accessible using the MySQL root user are: Database name "testdatabase" (without the quotes, and case sensitive), Server localhost, User name root. You will be prompted for the root password when you attempt to use the database.

From your description the one problem may be that you used the name testdatabase for MySQL and TestDatabase for LO base.