Automatic installation doens't work in some cases

Releem / mysqlconfigurer

Releem is a simple MySQL tuning tool to improve database performance and reduce servers costs.

https://releem.com

GNU General Public License v3.0

258 stars 28 forks source link

Automatic installation doens't work in some cases #166

Closed drupaladmin closed 4 months ago

drupaladmin commented 1 year ago

-If the root password for MySQL contains an ' (apostrophe) the automatic setup script will fail because it encloses the password in apostrophes. Using the advanced manual setup is then needed. -If the admin of the server has enabled skip-name-resolve then a connection to localhost will fail because the root user won't be allowed from a hostname. The IP loopback address 127.0.0.1 must be used instead. Again using the advanced manual setup is needed.

kochetovd commented 5 months ago

MySQL is allowed special characters: ‘ ~ ! @ # $ % ^ & * ( ) _ - + = { } [ ] / < > , . ; ? ' : | (space) Changed to double quotes in the agent setup command for the RELEEM_MYSQL_ROOT_PASSWORD variable, since single quotes are allowed for use in the password.
When the agent is installed, a socket connection is made to the root user. Therefore, the skip-name-resolve setting does not affect the installation script.