CENTOS7 configuration javaweb---mysql installation and configuration, garbled solution

Thanks for the installation of JDK and Tomcat. Let's update the useful today.

1. Instead of shutting down the firewall, add port 80 to the firewall's open port.

Firewall-cmd--zone=public--add-port=/tcp--permanent

The success is a success.

2. User authorization Issue---this article concludes that

Install MySQL

The first step is to download the Linux version of MySQL.

Address

Click to download

Upload to Linux server with FTP tool after download. I created a new directory and uploaded the software to this directory.

Now get ready to install ...

Find your catalogue first.

Yes, before installing MySQL to remove mariadb related things, otherwise it will not be installed successfully!

Command

rpm-qa| grep mariadb is used to view wooden and related packages

I have a related product here. Then I execute

rpm-e [file name]--nodeps to delete this package

He gave a hint that I didn't install it, so let's just forget it. I'm going to unzip MySQL first.

tar -xvf [filename]-C [New Path] Extract to a folder

You can see that there are a total of several RPM files, and we only need to install 4 to meet the basic requirements.

There's a little episode here? : I later found that I needed to remove mariadb-libs, so I put this step behind the understanding of the pressure MySQL.

Delete Maraidb-libs here,

yum list mariadb-libs        is used to list files that have been installed yum remove mariadb-libs         used to delete

Finally let you choose y/n, you choose Y can. And then delete the success

After the episode, the official installation begins.

Note here that the installation sequence must be correct.

common-"libs-" client-"server

It's ready to start after installation.

But you need to know your login password to get to the road.

Cat grep password Gets the first password that the system generates for you. 

Log in to your MySQL with this password. Change Password after login successful.

Set password = password (' new password ');

View System encoding

It's not going to work, or it's garbled.

So we're going to modify the MY.CNF configuration file

Exit the MySQL command line first

Then execute the command.

VI /ETC/MY.CNF

Add the following:

Note that the variables you set are all corresponding to the action. For example: [mysqld] 、、、、 [client] 、、、 [MySQL]

Results:

To this, the coding problem is resolved.

============================================

Create a user.

First Red Line: User name (used as login)

A second red line: password

The third red line: the database name (for example, test.* represents permissions to the entire database.) * * represents permissions to the entire database server)

Fourth Red Line: User name

However: there was a problem with my project startup.

There is no way to create a user. Change all the localhost to%, the other unchanged. Test success!

==============================

Also: Check the boot process for Tomcat on the Linux server:

The MySQL command line executes the SAL script

First Red line: User name

Second Red Line: database name

Third Red Line: SQL file path

Fourth red Line: SQL file name

Let's just talk about this a lot.

CENTOS7 configuration javaweb---mysql installation and configuration, garbled solution