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-->

Start MySQL DB on Linux;

 Start MySQL :

• cd to the bin directory and run the mysqld program.

Stop MySQL :

• cd to the bin directory(/home/vijay/mysql-8.0.20-linux-glibc2.12-i686) and run service mysqld stop

Check where mysql is installed on LINUX:

• whereis mysql

> whereis mysql > cd /usr/local/mysql > ls > cd bin > ls > ./mysqld start & > pwd > cd .. > cd support-files/ > ./mysql.server start &