• notice
  • Congratulations on the launch of the Sought Tech site

Mysql unable to reboot the wrong WARLING: World-Writableconfigfile '/ etc / my.cnf'Ignore solution

Problem analysis

The command to close the database found that mysql could not be closed, prompting Warning: World-writable config file '/etc/my.cnf' is ignored , which probably means that the permissions are globally writable and can be written by any user.mysql is worried that this file will be maliciously modified by other users, so ignore this configuration file.So mysql cannot be closed.

Let’s take a look at the whole process

Restart MySQL

[root@ttlsa ~]# service mysqld stop
Warning: World-writable config file'/etc/my.cnf' is ignored
Warning: World-writable config file'/etc/my.cnf' is ignored
MySQL manager or server PID file could not be found![FAILED]

You can see that mysql can't stop

View the permissions of my.cnf

[root@ttlsa ~]# ls -l/etc/my.cnf
-rwxrwxrwx 1 root root 4878 Jul 30 11:31/etc/my.cnf

Permission 777, any user can change my.cnf, there is a big security risk.

Fix MySQL issues

[root@ttlsa ~]# chmod 644/etc/my.cnf

my.cnf is set to be readable and writable by users, but not writable by other users.

Close MySQL

[root@ttlsa ~]# service mysqld stop
Shutting down MySQL..[ OK ]

MySQL shut down successfully.The problem is simple

Summary

The above is the entire content of this article.I hope that the content of this article will be helpful to your study or work.If you have any questions, you can leave a message to communicate.

Tags

Technical otaku

Sought technology together

Related Topic

1 Comments

author

purchase lipitor generic & lt;a href="https://lipiws.top/"& gt;atorvastatin oral& lt;/a& gt; lipitor 10mg generic

Whpujo

2024-03-07

Leave a Reply

+