Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.
by Mishal02 » 13. March 2020 11:03
MySQL said: Documentation
Cannot connect: invalid settings.
mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.
mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)
it says like this !!
This happened when I added a username and a password for the localhost access
provide me a solution for this !!
-
Mishal02
-
- Posts: 1
- Joined: 13. March 2020 10:58
- XAMPP version: 7.4.3
- Operating System: MacOS
by gtraxx » 23. March 2020 12:36
Hi
Change the password to pwdpwd by opening Terminal (Applications > Utilities > Terminal) and enter:
sudo /Applications/XAMPP/xamppfiles/xampp security
-
gtraxx
-
- Posts: 3
- Joined: 23. March 2020 12:30
- XAMPP version: 7.3.15
- Operating System: 10.13.6
by Nobbie » 23. March 2020 13:25
Dont do that pwdpwd thing.
Instead edit config.inc.php (from folder phpmyadmin) and apply the password for "root" and also for "pma", as you applied for these users for localhost. You will easily find the appropriate lines in config.inc.php (currently there are empty passwords).
-
Nobbie
-
- Posts: 13176
- Joined: 09. March 2008 13:04
Return to XAMPP for macOS
Who is online
Users browsing this forum: No registered users and 56 guests