Jeste, sad sam dodao APT 5.7 i okinuo apt-get update posle toga, i instalirao sam taj paket. I uspeo sam da napravim login-path za admin ali ne uspevam da koristim. To me jos od ranije muci.
root@server /home/tmp # mysql --login-path=admin
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
Sledeca je situacija.
Plesk valjda posle instalacije automatski promeni root u admin. Valjda neki security fazon. I sa root vise ne mogu da se ulogujem u mysql.
E sad... Recimo da mi je admin sifra coyotekg01!
Ako pokusam da se ulogujem sa
# mysql -uadmin -p
i ukucam coyotekg01!
dobijem ovu poruku
root@server /home/tmp # mysql -uadmin -p
Enter password:
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
Ako izvrsim komandu da vidim koji mi je password
root@server /home/tmp # /usr/local/psa/bin/admin --show-password
coyotekg01!
dobijem odgovor da je password taj koji i jeste...
dakle ako ga rucno ukucam imam ERROR 1045,
A ako ga upisem sa cat, onda se ulogujem bez problema...
root@server /home/tmp # mysql -uadmin -p`cat /etc/psa/.psa.shadow`
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 207300
Server version: 5.7.12 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
Sta ja tu pogresno razumem?