changeweb / Unifiedtransform

A school management Software
https://changeweb.github.io/Unifiedtransform/
GNU General Public License v3.0
2.81k stars 1.23k forks source link

mysql: [Warning] World-writable config file '/etc/mysql/my.cnf' is ignored. #371

Open alizesformation opened 1 year ago

alizesformation commented 1 year ago

Hello,

I followed some README.md steps to install UnifiedTransform but I'm stucked at the step 5 :

  1. Run docker exec -it db sh. Inside the shell, run:

:/# mysql -u root -p Mysql Root password: your_mysql_root_password in the docker-compose.yml file. Then run following commands:

mysql> SHOW DATABASES; mysql> GRANT ALL ON unifiedtransform.* TO 'unifiedtransform'@'%' IDENTIFIED BY 'secret'; mysql> FLUSH PRIVILEGES; mysql> EXIT;

When I run "mysql -u root -p" inside the shell, I have this message as return :

mysql: [Warning] World-writable config file '/etc/mysql/my.cnf' is ignored. Enter password:

It's impossible to type a password.

I don't know how to fix it.

Mkexplorer commented 9 months ago

The warning indicates that the MySQL configuration file, 'my.cnf,' has overly permissive permissions, which could pose a security risk. You should restrict the file's permissions to prevent unauthorized access. Consider using the following command:

" chmod 644 /etc/mysql/my.cnf "

This command sets the file permissions to read and write for the owner and read-only for others, enhancing security.