SQL Database installation


  • After installing MySQL, you must launch the MySQL 8.4 Command Line Client tool, which can be found in the MySQL folder in the Windows Start Menu, and create a database named jetico_messenger using the command: create database jetico_messenger;. If the database is successfully created, the console will display the response: Query OK, 1 row affected (0.01 sec).


  • To check the list of databases, use the command: show databases;. The output should include the jetico_messenger database and may look like this:

       +--------------------+

       | Database           |

       +--------------------+

       | information_schema |

       | jetico_messenger   |

       | mysql              |

       | performance_schema |

       | sys                |

       +--------------------+

       5 rows in set (0.00 sec)