|
Create a new MySQL connection
|
Previous Top Next |
Simply righclick in your Folders section of your MyLook Navigation window and click on New module, then click MySQL Console.
Optionally you may rename your connection to a more friendly name by pressing F2 while having the root folder selected or by clicking in the name.
You can now right click the root folder in your Folder pane and click on Properties, this will open the properties/configuration window for the connection where you can setup your normal MySQL parameters. For more details see Connection Overview
Your MySQL server might be setup without the show databases command for security or it might be setup showing you thousands of databases. For this reason MyCon allows you to specifically choose or customize your database listing. By default MyCon will show all the databases available (as provided by the MySQL server). If you wish to change this default behaviour then select the Databases tab (after you have tested your connection). If your MySQL is setup to return no database listing or if you don't have sufficient security privileges on the MySQL server to see the databases, you will have a "Manual" just below the "Databases" column, in which case you should add your databases comma delimited in the provided edit dialog. If however your server returns a listing you may select specific databases you wish to be listed under your Databases Folder . If you don't select any database explicitly, it is implied that MyCon should list all databases in your Folders view. For more information, please see Database Overview