#1045 Cannot log in to the MySQL server

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

#1045 Cannot log in to the MySQL server

Postby kundan » 04. October 2013 13:04

Hello Friends,

I know this might be asked many times but I was not able to find solution kindly request you to help me as I am trying to install wordpress but XAMPP myphpadmin username root is not working

Sorry and thanks,
Kundan
kundan
 
Posts: 7
Joined: 04. October 2013 13:02
Operating System: OS

Re: #1045 Cannot log in to the MySQL server

Postby Altrea » 04. October 2013 13:13

Hi Kundan,

which answer do you expect from your request?
We don't have really much information about how you have installed XAMPP and which actions you have done since then.
"not working" is a really bad error report. Do you get any messages or entries in your log files?
You even haven't filled out your operating system field in your profile correct.

The only answer i can give you with that base of information is: By default the username is root and the password is not set, so it's empty.
If you have changed this, you should know to what value you have set the password.

best wishes,
Altrea
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: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: #1045 Cannot log in to the MySQL server

Postby kundan » 04. October 2013 13:32

Hi Altrea,

I am extremely sorry.

After installing this is the first time I am trying to login in localhost/phpmyadmin with username root and password nothing and I am getting error Cannot log in to the MySQL server.
Hope it can help you to understand the current situation.

Best regards,
Kundan
kundan
 
Posts: 7
Joined: 04. October 2013 13:02
Operating System: OS

Re: #1045 Cannot log in to the MySQL server

Postby Altrea » 04. October 2013 13:37

After installing XAMPP the first time you should not get any login form, because the default login method is set to config.
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: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: #1045 Cannot log in to the MySQL server

Postby kundan » 04. October 2013 13:39

I am trying to install wordpress on Xampp and following below steps
http://www.wikihow.com/Install-Wordpress-on-XAMPP
kundan
 
Posts: 7
Joined: 04. October 2013 13:02
Operating System: OS

Re: #1045 Cannot log in to the MySQL server

Postby Altrea » 04. October 2013 14:00

After a fresh install of XAMPP http://localhost/phpmyadmin/ should not give you a login window but log you in automatically.
So the question is: Why do you get a login window.

If you start the control panel, which log messages do you get in its log window?
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: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: #1045 Cannot log in to the MySQL server

Postby kundan » 04. October 2013 15:55

Hi kindly share your email address so can send you screenshot
kundan
 
Posts: 7
Joined: 04. October 2013 13:02
Operating System: OS

Re: #1045 Cannot log in to the MySQL server

Postby kundan » 04. October 2013 16:27

20:54:11 [mysql] You need to uninstall/disable/reconfigure the blocking application
20:54:11 [mysql] or reconfigure MySQL to listen on a different port
20:54:11 [filezilla] XAMPP FileZilla FTP Server is already running on port 21
20:54:11 [filezilla] XAMPP FileZilla FTP Server is already running on port 14147
20:54:11 [mercury] XAMPP Mercury is already running
20:54:11 [mercury] Ports in use: 25, 79, 105, 106, 110, 143, 2224
20:54:11 [main] Starting Check-Timer
20:54:11 [main] Control Panel Ready


These are the erros
kundan
 
Posts: 7
Joined: 04. October 2013 13:02
Operating System: OS

Re: #1045 Cannot log in to the MySQL server

Postby Altrea » 04. October 2013 17:21

We need ALL line of the control panel, not just this little excerpt.
You can simply copy them out of your \xampp\xampp-control.log 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: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: #1045 Cannot log in to the MySQL server

Postby kundan » 04. October 2013 17:26

Thanks for replying.

Pls check the revised control panel message
21:55:58 [main] Enabling autostart for module "Tomcat"
21:55:58 [main] Starting Check-Timer
21:55:58 [main] Control Panel Ready
21:55:58 [Apache] Autostart aborted: Apache is already running
21:55:58 [mysql] Autostart aborted: MySQL is already running
21:55:58 [filezilla] Autostart aborted: FileZilla is already running
21:55:58 [mercury] Autostart aborted: Mercury is already running
21:55:58 [Tomcat] Autostart aborted: Tomcat is already running
kundan
 
Posts: 7
Joined: 04. October 2013 13:02
Operating System: OS

Re: #1045 Cannot log in to the MySQL server

Postby Altrea » 04. October 2013 17:38

That few lines are not enough information.
Are you not willing or not able to present the full content of the log?

The log window is a text field. You can either select all messages with CTRL+A (after you have onced clicked on the textfield) and after that copy it to your clipboard with CTRL+C (and paste it here with CTRL+V)
or you can (after you have quit the control panel) copy it's content from the \xampp\xampp-control.log file.

WIthout this information nobody here will be able to help you.

The first line of the log is something like " [main] Initializing Control Panel" and after that all lines you get.
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: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: #1045 Cannot log in to the MySQL server

Postby kundan » 04. October 2013 20:08

15:36:55 [main] Initializing Control Panel
15:36:55 [main] Windows Version: 64-bit
15:36:55 [main] XAMPP Version: 1.8.1
15:36:55 [main] Control Panel Version: 3.1.0 3.1.0 [ Compiled: September 20th 2012 ]
15:36:55 [main] You are not running with administrator rights! This will work for
15:36:55 [main] most application stuff but whenever you do something with services
15:36:55 [main] there will be a security dialogue or things will break! So think
15:36:55 [main] about running this application with administrator rights!
15:36:55 [main] XAMPP Installation Directory: "d:\kundan\projects\xampp\"
15:36:55 [main] Checking for prerequisites
15:36:55 [main] All prerequisites found
15:36:55 [main] Initializing Modules
15:36:55 [Apache] Apache Service detected with wrong path
15:36:55 [Apache] Change XAMPP Apache settings or
15:36:55 [Apache] Uninstall/disable the other service manually first
15:36:55 [Apache] Found Path: ERROR: Not Able To Open Service Manager
15:36:55 [Apache] Expected Path: "d:\kundan\projects\xampp\apache\bin\httpd.exe" -k runservice
15:36:55 [Apache] Problem detected!
15:36:55 [Apache] Port 80 in use by "httpd.exe"!
15:36:55 [Apache] Apache WILL NOT start without the configured ports free!
15:36:55 [Apache] You need to uninstall/disable/reconfigure the blocking application
15:36:55 [Apache] or reconfigure Apache to listen on a different port
15:36:55 [Apache] Problem detected!
15:36:55 [Apache] Port 443 in use by "httpd.exe"!
15:36:55 [Apache] Apache WILL NOT start without the configured ports free!
15:36:55 [Apache] You need to uninstall/disable/reconfigure the blocking application
15:36:55 [Apache] or reconfigure Apache to listen on a different port
15:36:55 [mysql] MySQL Service detected with wrong path
15:36:55 [mysql] Change XAMPP MySQL settings or
15:36:55 [mysql] Uninstall/disable the other service manually first
15:36:55 [mysql] Found Path: ERROR: Not Able To Open Service Manager
15:36:55 [mysql] Expected Path: d:\kundan\projects\xampp\mysql\bin\mysqld.exe --defaults-file=d:\kundan\projects\xampp\mysql\bin\my.ini mysql
15:36:55 [mysql] Problem detected!
15:36:55 [mysql] Port 3306 in use by "mysqld.exe"!
15:36:55 [mysql] MySQL WILL NOT start without the configured ports free!
15:36:55 [mysql] You need to uninstall/disable/reconfigure the blocking application
15:36:55 [mysql] or reconfigure MySQL to listen on a different port
15:36:55 [main] Starting Check-Timer
15:36:55 [main] Control Panel Ready
22:57:49 [main] Deinitializing Modules
22:57:49 [main] Deinitializing Control Panel
kundan
 
Posts: 7
Joined: 04. October 2013 13:02
Operating System: OS

Re: #1045 Cannot log in to the MySQL server

Postby Altrea » 04. October 2013 20:22

Okay, so the first thing you should do is start your control panel with elevated administrator rights (rightclick the control-panel exe and choose "run as Administrator")
That way your control panel should be able to identify the services already running on the needed ports.

My guess: There is already a different Apache and MySQL started. That would explain why you get the login form and why you cannot log in there.
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: 11926
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: Nobbie and 130 guests