MySQL Database Setup – Complete Configuration
In this tutorial, I’ll guide you through configuring MySQL Server for Jira Data Center. Setting up a reliable database is a crucial step to ensure performance, scalability, and high availability in your clustered Jira setup.
📌 What You’ll Learn:
✅ Installing MySQL Server on Ubuntu
✅ Creating a dedicated Jira database
Update system
sudo apt update
Install MySQL Server
sudo apt install mysql-server
Login to MySQL and create Jira database
sudo mysql -u root -p
CREATE DATABASE jiradb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
CREATE USER 'jirauser'@'%' IDENTIFIED BY 'YourPassword';
GRANT ALL PRIVILEGES ON jiradb.* TO 'jirauser'@'%';
EXIT;
📌 Call to Action:
💬 If you found this helpful, LIKE, COMMENT, and SUBSCRIBE for more in-depth Jira Data Center tutorials!