cannot log in to mysql server mysqli_real_connect():

Problems with the Windows version of XAMPP, questions, comments, and anything related.

cannot log in to mysql server mysqli_real_connect():

Postby Ptah » 28. January 2019 21:56

I am using windows 10 and xamp v3.2.2. I set a password in config.inc.php and I get the following error message:
"cannot log in to mysql server mysqli_real_connect():)HY000/1045):Access denied for user 'root@localhost' (using password: yes).

if I remove the password, I can log in to phpmyadmin with no errors. I would like to set a password. Where do I set or reset the password in mysql. Is there an easy way to correct this issue.

Also how do I insert an image or images
Ptah
 
Posts: 8
Joined: 03. April 2015 16:19
Operating System: win 7 64 bit

Re: cannot log in to mysql server mysqli_real_connect():

Postby Altrea » 28. January 2019 21:59

WHat do you do exactly to set the password?
Do you just edit phpmyadmins config.inc.php?

What are your reasons to set a password? In most cases this is not needed.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: cannot log in to mysql server mysqli_real_connect():

Postby Ptah » 28. January 2019 22:02

I just edit phpmyadmin config.inc.php. Regarding a password, I really do need one. how do I fix this problem. Thanks
Last edited by Ptah on 28. January 2019 22:22, edited 1 time in total.
Ptah
 
Posts: 8
Joined: 03. April 2015 16:19
Operating System: win 7 64 bit

Re: cannot log in to mysql server mysqli_real_connect():

Postby Altrea » 28. January 2019 22:19

The phpmyadmin application in xampp is by default only accessible from localhost, so only people operating on this specific system and script are able to login.
Is that not security enough in your environment?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: cannot log in to mysql server mysqli_real_connect():

Postby Ptah » 28. January 2019 22:26

I had a password set before, but I had to uninstall my old xampp and installed a new one. I had a bit of trouble with apache, mysql, filezilla services which I fixed and got phpmyadmin to work.

I am just more comfortable in setting a password, if it is possible and easy to fix. thanks
Ptah
 
Posts: 8
Joined: 03. April 2015 16:19
Operating System: win 7 64 bit

Re: cannot log in to mysql server mysqli_real_connect():

Postby Altrea » 28. January 2019 22:28

Login with phpmyadmin and set your password for user root there first.
After that you need to change the password variable in phpmyadmins config.inc.php file.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 119 guests