Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Plesk seems to need --no-defaults with MySQL #5

Open
LukeHandle opened this issue Jun 8, 2020 · 1 comment
Open

Plesk seems to need --no-defaults with MySQL #5

LukeHandle opened this issue Jun 8, 2020 · 1 comment

Comments

@LukeHandle
Copy link
Contributor

Might be a recent change somewhere, but it appears the --no-defaults is now needed on the MySQL lines:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin -Dpsa
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql --no-defaults -u admin -Dpsa
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2790
Server version: 5.5.65-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [psa]>
@dsgnr
Copy link
Owner

dsgnr commented Jun 16, 2020

I'm unable to replicate this with 18.0.27;

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin -Dpsa
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 360
Server version: 5.5.65-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [psa]>

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql --no-defaults -u admin -Dpsa
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 359
Server version: 5.5.65-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [psa]>

I will test other versions to double check.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants