Now that you’re connected, double-click on the schema you wish to explore, select Tables and then click on the References tab to view your schema diagram (complete with pretty animations). jdbc:mysql://localhost:3306/habariĬlick Connect, and your connection should be established! The schema can be omitted if you don’t want to specify one by default. After installing it locally, I therefore used the following. I thought I’d take a poke around the schema used by the Habari open source project. The URL will take the format: jdbc:mysql://:/ To enter this information manually, set Database Type to MySQL, select MySQL from the Driver (JDBC) dropdown, and enter your Database URL and username/password. the server name (usually just localhost) and port number that your database runs on (usually 3306 for MySQL).There’s not really much to it all you need is: You can either follow the built-in connection wizard to establish your connection, or enter it manually. To connect to your database, choose Database > Create Database Connection. On the left, select MySQL, and in the User Specified tab of the Driver File Paths form, click the Browse icon and choose the jar file that we extracted earlier. Then launch DBVisualizer and select Driver Manager from the Tools menu. Download the MySQL JDBC driver, and unzip the archive to a folder of your choice (there’ll be a jar file in there somewhere, which is what we’re after). That’s it!ĭBVisualizer doesn’t come with a MySQL driver out of the box, but adding one is easy. Whether you’re running Windows, Mac, Linux or a general Unix platform, you have the choice of a wizard-style installer or just unpacking a compressed archive to the folder of your choice. Installing DBVisualizer is as simple as it gets. The version at the time of writing is 5.1.1. DBVisualizer Free performs all of the visualization coolness, but contains limited features (such as only being able to perform one SQL query at a time–possibly enough to make you want to upgrade to a personal license if you get addicted to the other stuff). There are a few versions of DBVisualizer. If you don’t know, you’re probably using MyISAM. You can still create a schema diagram if you’re using MyISAM, but it won’t reflect any foreign key constraints, as these are ignored by MyISAM.
0 Comments
Leave a Reply. |