SQLyog #1 | Setting up

 SQLyog

• One of the tools that will be used for development.
• It is a database manager used to get access.
• Download > here < .

• Open Xampp and run Apache and MySQL.
• The default port is 3306.
• Add database and table, as usual, to start using.

Adding New Database

• From the database menu tab, choose 'Create Database'.
• Add database name.

Adding New Table

• From the table menu tab, choose 'Create Table'.
• Or, right-click on your database name (on the left nav bar) > table > 'Create Table'.

• Fill in the column name, and other columns. Don't forget to set PK (Primary Key).

• Click Save.

Done!