Grouper on TIER packaging server CentOS and MySQL

grouper#>mkdir /root/software
grouper#>cd /root/software
grouper#>yum -y install mlocate
grouper#>updatedb
grouper#>yum install java-1.8.0-openjdk.x86_64
grouper#>yum install java-1.8.0-openjdk-devel.x86_64
grouper#>yum install dos2unix
grouper#>wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.11-1.el7.x86_64.rpm-bundle.tar
grouper#>tar xvf mysql-5.7.11-1.el7.x86_64.rpm-bundle.tar 
grouper#>mv mysql-community-server-minimal-5.7.11-1.el7.x86_64.rpm temp-mysql-community-server-minimal-5.7.11-1.el7.x86_64.rpm
grouper#>yum install mysql-community-{server,client,common,libs}-*
grouper#>systemctl enable mysqld.service
grouper#>systemctl start mysqld
grouper#>yum install telnet
grouper#>telnet localhost 3306
grouper#>systemctl stop mysqld
grouper#>sudo -u mysql mysqld --skip-grant-tables &
mysql> use mysql;
mysql> update user set authentication_string=password('XXXXXXX') where user='root'
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 1
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> 
grouper#>yum install emacs
grouper#>yum install java-1.8.0-openjdk-devel.x86_64

character-set-server=utf8
collation-server = utf8_bin
init-connect='SET NAMES utf8'
init_connect='SET collation_connection = utf8_bin'
skip-character-set-client-handshake

grouper#>ps -ef | grep mysql
grouper#>kill -KILL XXXXX
grouper#>systemctl start mysqld
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'XXXXXXXXXX';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
mysql> create database grouper;
mysql> create user 'grouper'@'localhost' identified by 'XXXXXXXXXXX';
mysql> grant all on grouper.* to 'grouper'@'localhost' identified by 'XXXXXXXXXXX';
mysql> flush privileges;

grouper#>useradd grouper
grouper#>su - grouper
[grouper@grouper ~]$ mkdir /home/grouper/2.3.0
[grouper@grouper ~]$ cd /home/grouper/2.3.0/
[grouper@grouper 2.3.0]$ wget http://software.internet2.edu/grouper/release/2.3.0/grouperInstaller.jar
[grouper@grouper 2.3.0]$ java -jar grouperInstaller.jar 
hit <enter> a bunch to get the defaults
Do you want to use the default and included hsqldb database (t|f)? [t]: f
Enter the database URL [jdbc:hsqldb:hsql://localhost:9001/grouper]: jdbc:mysql://localhost:3306/grouper
Database user [sa]: grouper
Database password (note, you aren't setting the pass here, you are using an existing pass, this will be echoed back) [<blank>]: XXXXXXX
Do you want to init the database (delete all existing grouper tables, add new ones) (t|f)? t
Enter the GrouperSystem password: XXXXXXXXXXXX
Do you want to start the Grouper loader (daemons)?
  (note, if it is already running, you need to stop it now, check ps -ef | grep gsh | grep loader) (t|f)? [f]: y
 
Installation success!
Go here for the Grouper UI (change hostname if on different host): http://localhost:8080/grouper/
This is the Grouper WS URL (change hostname if on different host): http://localhost:8080/grouper-ws/