Restart JIRA with MySQL DB; UNIX commands

ps -ef | grep jira

kill any running processes.

 

As app user:

 

Start database with /usr/local/mysql/bin and run ./mysqld

 

to stop database;

 

cd /usr/local/mysql/supporting-files/  and ./mysql.server stop

 

 

 

 

    export JAVA_HOME=/apname/src/jdk1.8.0_211/

​

    export PATH=$JAVA_HOME/bin:$PATH

 

 

cd /usr/local/mysql/

              

[app@ITSP14 bin]$ ./mysql -u root -p

 

password:<password>

 Below needs to be set for MySQL8

mysql>    SELECT @@global.time_zone;

​

mysql>   SET GLOBAL time_zone = '+00:00';

              

               After setting it up, Don't restart MySQL, Just restart JIRA

              

               Restart JIRA as jira user.

              

               ./config.sh is used to configure jira

 

 

As root run ->chown -R jira:jira /appname/apps/atlassian/

 

Reindex after logging to JIRA under Systems and Advanced options-->