Sample Header Ad - 728x90

Problem accessing MySQL in Xampp

-1 votes
2 answers
90 views
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