Linux Server dev/test environment build-process

1. MariaDB Yum Install/Initialize/grant remote permissions

　　

Yum Installation

Find the DB version you need on the MARIADB website based on the Linux system: https://downloads.mariadb.org/mariadb/repositories/#mirror =tuna

After the selection is complete, the following configuration is displayed at the bottom of the page:

#MariaDB 10.1 CentOS repository list-created 2016-06-22 03:05 UTC # http://downloads.mariadb.org/mariadb/ Repositories/[mariadb]name = Mariadbbaseurl = http://yum.mariadb.org/10.1/centos6-x86gpgkey=https:// Yum.mariadb.org/rpm-gpg-key-mariadbgpgcheck=1

Enter directory/etc/yum.repos.d/, create Mariadb.repo, copy the above contents

Execute the following command

sudo yum install mariadb-server mariadb-client

The implementation will download the installation package and detect dependencies, all the way y can

complete!

Initialization

Start mairadb:/etc/init.d/mysql start

Execute initialization tool: Mysql_secure_installation

The execution process will help you initialize the password, as well as some other initialization operations, borrowing the online operation flowchart

Granting Remote access Permissions

GRANTALL PRIVILEGES ON *.* TO ‘root(与本地用户不同)‘@‘%‘IDENTIFIED BY ‘此处填写远程访问密码(和本地登录密码可不同)‘ WITH GRANTOPTION;

Refresh enables permissions to take effect

flush privileges;

2. JDK Installation

Upload the JDK installation file to the server's custom directory, such as:/ROOT/JDK

If it is a tar package, execute the TAR-XZVF package name

Unzip the file to the current path

Vim/etc/profile (can also be configured under the. Profile under a new user directory)

Add at the end of the document

Export java_home=/root/jdk/jdk1.8.0_92
Export path= $JAVA _home/bin: $PATH

Then: Wq Save

Perform source/etc/profile to make configuration effective

Performs java-version validation success.

3. Tomcat Upload

RZ the tomcat package to the specified directory and tar decompression

execution./bin/start.sh; Tail–f./logs/catalina.out

Observe the startup results.

Ok! Linux Program Basic Environment configuration complete, if there is a problem, welcome to discuss.

---------------------2016-09-14-----------------------------------

Setting the MARIADB 10.1 database is not case sensitive ()

Modify /etc/my.cnf.d/server.cnf, add Lower_case_table_names=1 (1 for case insensitive, 0 sensitive----Linux environment) under [mysqld]

View the default boot status for all services in the current Linux system under each RunLevel

chkconfig–list (Double horizontal line)

Restart MySQL Service

Service MySQL Restart

View MySQL Service status

Service MySQL Status

MySQL Database password reset

1. Skip Password detection

Mysqld_safe–skip-grant-tables & (middle parallel bars)

2, Mysql–uroot–p

3. Use MySQL

4. Update user set Password=password (' You are going to reset to a password ') where user= ' root ';

5, flush privileges;

6, quit;

7. Service MySQL Restart

8, ok!

Linux Server dev/test environment build-process