Problem Description

This article explains the inability to access the MySQL problem on cloud server ECS Linux General troubleshooting steps.

Solution

Check whether the Linux operating system has installedMySQL
```
$ rpm -qa mysql
mysql-4.1.7-4.RHEL4.1

# 说明已经安装了 MySQL
```
Copy after login
Check Status
Detect MySQL running status:
```
service mysqld status
```
Copy after login
## Start the service: You can use three methods to start MySQL:

```
service mysqld start
```
Copy after login
##Method 2: Use the mysqld script to start MySQL:

/etc/init.d/mysql start

Copy after login

##Method 3: Use the safe_mysqld utility to start the MySQL service. This method can use relevant parameters:
```
safe_mysqld& //使用&表示将safe_mysqld放在后台执行。
```
Copy after login

##Login
Change password

mysqladmin -u root password
mysqladmin -u root password &#39;kaishi&#39;

Copy after login

The "password" here is the new password we want to set. The system will prompt us to enter the old password (if MySQL has just been installed, the default password is empty)

If the local machine can log in, but the client of other machines Login error. For example:

ERROR 1130 (00000): Host &#39;xxx.xxx.xxx.xxx&#39; is not allowed to connect to this MySQ
L server

Copy after login

First check the iptables settings and confirm that port 3306 is open:

iptables -A INPUT -p tcp -m tcp --sport 3306 -j ACCEPT
iptables -A OUTPUT -p tcp -m tcp --dport 3306 -j ACCEPT
service iptables save

Copy after login

If it is still inaccessible, it may be a permission issue with MySQL. You can troubleshoot through the following steps:

mysql -h localhost -u root -pkaishi
show databases;
use mysql;
select Host, User, Password from user;
+-----------------------+------+-------------------------------------------+
| Host | User | Password |
+-----------------------+------+-------------------------------------------+
| localhost | root | *18F54215F48E644FC4E0F05EC2D39F88D7244B1A |
| localhost.localdomain | root | |
| localhost.localdomain | | |
| localhost | | |
+-----------------------+------+-------------------------------------------+

Copy after login

##Enter MySQL and create a new user user:
Format: grant permission on database name. table name user @Login hostident
if
ied by "user password".

grant select,update,insert,delete on easyview.* to sillycat@192.168.10.103 identified by "kaishi";

Copy after login

To view the results, execute:
```
use mysql;
select host,user,password from user;
```
Copy after login
You can see that the user user just created is already in the user table. The host field indicates the logged-in host. Its value can be IP or host name. Changing the value of the host field to % means that you can log in to the mysql server as user

update user set host = &#39;%&#39; where user = &#39;sillycat&#39;;
flush privileges;

Copy after login

The above is the detailed content of Basic steps to troubleshoot MySQL inaccessibility under Linux. For more information, please follow other related articles on the PHP Chinese website!