Base and MySQL: getting started

answered 2012-05-29 22:54:35 +0200

Jay Lozier
41 ● 1 ● 1

When you open Base you get the "Database Wizard" and you have three options:

1. Create a new database (Creates a new odb database)
2. Open an existing database file (Opens an existing odb database)
3. Connect to an existing database (Will show a default connection)

Select "Connect to an existing database" and if you have the MySQL connector installed you select MySQL from the connectors, click Next

Select "Connect directly", click Next

At the next Dialog box select "Server/Port" enter in Database Name for your database (for example "Work" if you have database named "Work"), the Server (the url for the server or if on your computer "localhost"), the port defaults to 3306 and unless you changed the port, the port number is correct. Click on Next.

On the next Dialog box enter the user name (if localhost try root or your user name). Click "Password required" if you need to enter a password. To verify the username & password click test connection and enter your password. If all is correct you should get a message: "The connection was tested successfully" Click OK then Click Next.

On the next Dialog box you can either accept the defaults of change them then Click Finish. You should now see your MySQL database in Base.