1. Install the mysql database
①Download and unzip it and upload it to the /opt/soft directory (the soft directory is created by yourself)
②Extract: tar -xvf mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar
## ③Clear the database that comes with linux1. Check if there is an old version of the database: rpm -qa | grep mysql##rpm -qa | grep mariadb
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:
rpm -ivh mysql-community-server-5.7.27-1.el7.x86_64.rpmFound that 5 dependency packages are needed, so install the dependency package first (needed dependency)
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.rpmFound that this package depends on: mysql-community-libs, so install mysql-community- first libs package.
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.rpm
4. Install mysql-community-common Dependency package:
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)
Start the mysql service: systemctl start mysqld.service2. Find the temporary password and modify it
① Find the file that stores the temporary password:
find / -name mysql*log② View the temporary password:
more /var/ log/mysql.log | grep temp(Password is c_xmovu7jjcw)
③Enter mysql -u root -p and temporary password to log in and enter the mysql database Environment④In the environment of mysql database:
1. Set the mysql password policy: mysql>set global validate_password_policy= 0;
2. Set the length of mysql password:
mysql>set global validate_password_length=4;3. Set password: mysql>set password=password('123456');4. Exit: quit; Or ctrl z
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)2. Enter: use mysql;
3. View: select host,user,authentication_string from user;
②Create remote user
1. Create user: create user 'myroot'@'%' identified by '123456';
2. Grant all privileges on *.* to 'myroot'@'%';
## 3. Refresh: flush privileges;4. Use the navicat tool to log in remotely
①Close the firewall: systemctl stop firewalld.service②Connect ③Connect successfully ##5. Configure java projectThe 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)
③Start the tomcat service: (To be started in the bin directory under the apache-tomcat-8.5.47 directory)
sh startup.sh④Modify the file connecting the project to the database so that the project can connect to the database
Default path: (Automatically decompress the project after uploading, refresh it first) /opt/sotp /apache-tomcat-8.5.47/webapps/test/web-inf/classesModification:
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
⑧Enter user name and password to test login
⑨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!