Problem Description

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

Solution

1. Check whether the Linux operating system has installedMySQL

   $ rpm -qa mysql
   mysql-4.1.7-4.RHEL4.1
   
   # 说明已经安装了 MySQL

   Copy after login

2. 
   

3. Check Status
   Detect MySQL running status:

   service mysqld status

   Copy after login

4. 
   

5. ## Start the service: You can use three methods to start MySQL:
   

##Method 1: Use the service command to start MySQL:

1. service mysqld start

   Copy after login

2. 
   

3. 
   

   ##Method 2: Use the mysqld script to start MySQL:

/etc/init.d/mysql start

Copy after login

5. 
   ##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

7. 
   

6. 
   ##Login

8. 
   Change password

mysqladmin -u root password
mysqladmin -u root password 'kaishi'

Copy after login
9. 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 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQ
L server

Copy after login

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

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 | | |
+-----------------------+------+-------------------------------------------+

You can see the above results. Only localhost has access permissions set.

1. 
   

2. ##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

3. 
   

4. 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
on any client machine. It is recommended. Set to % during development.

5. 
   

After modifying the permissions, you need to execute the following statement to take effect:

6. update user set host = '%' where user = 'sillycat';
   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!