Shulou(Shulou.com)06/01 Report--

The purpose of this article is to share with you how to deal with the problems encountered in publishing war under linux. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

The display of linux startup mysql is also different due to the different startup mode.

Start ps-ef through. / mysqld_safe & launch grep mysql and the following information will be displayed

Root 15537 1 0 11:16? 00:00:00 / bin/sh. / mysqld_safe

/ usr/local/mysql/bin/mysqld-basedir=/usr/local/mysql-datadir=/usr/local/mysql/data-plugin-dir=/usr/local/mysql/lib/plugin-user=mysql-log-error=/usr/local/mysql/data/bogon.err-pid-file=/usr/local/mysql/data/bogon.pid-socket=/usr/local/mysql/mysql.sock-port=3306

And through. / mysqld-- user==root

Forced login via root will only show

Root 4998 10 13:12? 00:00:00. / mysqld-- user=root

The linux attached to the service network is forced to be started in the second way. If you can't start it with the first one, it will hang up automatically after a while.

Even if it starts in the second way, it cannot be plugged into the database. The following error occurred

Java.sql.SQLException: null, message from server: "Host 'xxx' is not allowed to connect to this MySQL server"

To investigate the reasons, start with the following:

First of all, let's see if the configuration file of the database is configured correctly.

If correct, continue to troubleshoot the mysql database in the database on the server to find the user table and check the host to find that there are two host in it are the same, but there is no root, so the above error will be reported. Just delete one of the host. But the service must be restarted.

Thank you for reading! This is the end of the article on "how to deal with the problems encountered in publishing war under linux". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.