Hello,
I am new here. I havent found anything to my problem in this topic yet and am hoping somebody could help me to find the solution/topic at least ...
I installed xampp on a win10 computer ... after everything was configured to my needs (httpd.conf, my.ini, etc.) I used the "Console"-Button on the xampp-controlpanel (the xampp-console) to connect to the MySQL server and set up the root password ...
In a second step I tried to log on via the phpMyAdmin interface with the just set password which did not work; then I tried to connect via Oracle Workbench to the xampp configured and managed Server ... same result; I also tried to use mysqlsh.exe of a mysql server standalone installation on the same computer and tried to log in ... same result. All connection attempts are made over the loopback interface; therefore conection issues may not be the problem.
After some research I came to the possible result, that the encoding of the xampp-console is something different as UTF-8, and therefore the Passwords do not match.
My question now is how to change the encoding to that xampp-console during runtime (which AFAIK is not possible) to log in with the wrong encoding, and change the password with the correct encoding.
Or is there maybe a other way to change the passowrd to be able to log on as root.
Also good to know how to configure the xampp-console to a suitable encoding; ideally automatically to the encodings of the runing servers.
Thanks for your help.