Phpmyadmin Designer

[HelioHost]

Heliohost users on the Johnny server can now use Designer Mode in PhpMyAdmin to create relationships.

1. To get started, log in to your Johnny account by visiting http://johnny.helioh...PhpMyAdmin.html
   
2. Next select a database in the left navigation column.
   
3. In the top right corner you'll see a new tab entitled "Designer."
   
4. The tables in the database will be displayed as boxes that you can drag around the screen.
   

For a more detailed tutorial on how to use designer mode check out http://www.yourwebskills.com/dbphpmyadminrelationships.php You can also read up about foreign keys, and how they're used at https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-foreign-keys.html Using a graphical user interface such as this is by far the easiest and most intuitive way to create relationships within your databases.

 

Please don't hesitate to let us know if you're having any trouble with the new features of PhpMyAdmin. For now Designer Mode is only enabled on Johnny, but if it doesn't cause any issues or break anything we will enable this new feature on Stevie as well. If you have any suggestions on what we should upgrade next we'd love to hear from you. Thanks for being part of the Heliohost community.