I installed Xampp on my Ubuntu 22.04 box.
In its
my.cnf
, I set
[client]
password =mypassword
port =3306
socket =/opt/lampp/var/mysql/mysql.sock
I saved this and restarted MySQL.
When I try Ubuntu's mysql client:
$ mysql --host=localhost --port=3306 -u root -p -S /opt/lampp/var/mysql/mysql.sock
it asked for a password where I gave the configured password but it said
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
What do I need to make this work?
Asked by Gergely
(101 rep)
Oct 5, 2023, 11:30 AM
Last activity: Oct 9, 2023, 09:07 AM
Last activity: Oct 9, 2023, 09:07 AM