Accessing MySQL
The HSQL Database Manager should never be used in the production instance because it's prone to data loss. The recommended database is either MySQL or PostgreSQL. Earlier in this book, we discussed how to create a database in MySQL to store JIRA's data and configure it during the setup phase. To access your database in order to run SQL queries, you can either use the MySQL console, which comes with the MySQL server, or you can use phpMyAdmin.
phpMyAdmin
The phpMyAdmin application can be downloaded from http://www.phpmyadmin.net/.
This is a great web-based tool to manage your MySQL database and it's usually accessed using http://localhost/phpmyadmin/. The exact URL can be different, depending on your installation.
Perform these following ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access