Home  >  Article  >  Database  >  How to install mysql database and configure Java project in linux

How to install mysql database and configure Java project in linux

王林
王林forward
2023-05-30 18:55:061285browse

1. Install the mysql database

①Download and unzip it and upload it to the /opt/soft directory (the soft directory is created by yourself)

How to install mysql database and configure Java project in linux

②Extract: tar -xvf mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar

How to install mysql database and configure Java project in linux

## ③Clear the database that comes with linux

1. Check if there is an old version of the database:

rpm -qa | grep mysql

How to install mysql database and configure Java project in linux##rpm -qa | grep mariadb

How to install mysql database and configure Java project in linux 2. Uninstall the existing database: (Uninstalling will also uninstall the dependent packages of this package)

yum -y remove mariadb-libs.x86_64

## ④Install the mysql community edition service package: How to install mysql database and configure Java project in linux

rpm -ivh mysql-community-server-5.7.27-1.el7.x86_64.rpm

Found that 5 dependency packages are needed, so install the dependency package first (needed dependency) How to install mysql database and configure Java project in linux

1. Install the perl dependency package:

yum -y install perl (27 packages with perl are installed here, including 3 dependent packages)

2. Install the dependent package of mysql-community-client:

rpm -ivf mysql -community-client-5.7.27-1.el7.x86_64.rpm

Found that this package depends on: mysql-community-libs, so install mysql-community- first libs package. How to install mysql database and configure Java project in linux

Install the mysql-community-libs library package:

rpm -ivf mysql-community-libs-5.7.27-1.el7.x86_64.rpm

3. Then install mysql-community-cient-5.7.27-1.el7.x86_64.rpmHow to install mysql database and configure Java project in linux

4. Install mysql-community-common Dependency package: How to install mysql database and configure Java project in linux

rpm -ivf mysql-community-common-5.7.27-1.el7.x86_64.rpm

⑤Install the mysql community edition server package again:

rpm -ivh mysql-community-server-5.7.27-1.el7.x86_64.rpm

⑥Verify whether mysql is installed successfully (no error at startup indicates successful installation) How to install mysql database and configure Java project in linux

Start the mysql service: systemctl start mysqld.service

How to install mysql database and configure Java project in linux2. Find the temporary password and modify it

① Find the file that stores the temporary password:

find / -name mysql*log

② View the temporary password: How to install mysql database and configure Java project in linux

more /var/ log/mysql.log | grep temp

(Password is c_xmovu7jjcw)How to install mysql database and configure Java project in linux

③Enter mysql -u root -p and temporary password to log in and enter the mysql database Environment

④In the environment of mysql database: How to install mysql database and configure Java project in linux

1. Set the mysql password policy:

mysql>set global validate_password_policy= 0;

2. Set the length of mysql password: How to install mysql database and configure Java project in linux

mysql>set global validate_password_length=4;

3. Set password:

mysql>set password=password('123456');

4. Exit: quit; Or ctrl zHow to install mysql database and configure Java project in linux

3. View and create remote connection users

① Check whether the user can connect remotely:

1. Log in: mysql -u root -p; enter the password to log in (123456)

How to install mysql database and configure Java project in linuxHow to install mysql database and configure Java project in linux

2. Enter: use mysql;

How to install mysql database and configure Java project in linux

3. View: select host,user,authentication_string from user;

How to install mysql database and configure Java project in linux

②Create remote user

1. Create user: create user 'myroot'@'%' identified by '123456';

How to install mysql database and configure Java project in linux

2. Grant all privileges on *.* to 'myroot'@'%';

How to install mysql database and configure Java project in linux

## 3. Refresh: flush privileges;

How to install mysql database and configure Java project in linux

4. Use the navicat tool to log in remotely

①Close the firewall: systemctl stop firewalld.service

②Connect

How to install mysql database and configure Java project in linux

③Connect successfully

How to install mysql database and configure Java project in linux

##5. Configure java project

The project includes: program package (.war) data package (.sql)

①Upload the .war and program package to the wbapps directory under tomcat (in /opt/soft/apach-tomcat -8.5.47 directory)

# ② Import the .sql data package into navicat (after connecting, left-click, and then click to run the sql file) How to install mysql database and configure Java project in linux

③Start the tomcat service: (To be started in the bin directory under the apache-tomcat-8.5.47 directory) How to install mysql database and configure Java project in linux

sh startup.sh

④Modify the file connecting the project to the database so that the project can connect to the database How to install mysql database and configure Java project in linux

Default path: (Automatically decompress the project after uploading, refresh it first)

/opt/sotp /apache-tomcat-8.5.47/webapps/test/web-inf/classes

Modification:How to install mysql database and configure Java project in linux

1. Database service ip address: (Change into the ip address of linux)

2. Database name:                                                                                                                                    . 4. Password of the remote connection user: (Password of user myroot)

5. Save

⑥ Turn off the firewall:

systemctl stop firewalld.service

⑦Open the web page: enter 192.168.1.181:8080/test How to install mysql database and configure Java project in linux

⑧Enter user name and password to test login

How to install mysql database and configure Java project in linux ⑨Login

The above is the detailed content of How to install mysql database and configure Java project in linux. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:yisu.com. If there is any infringement, please contact admin@php.cn delete