MySQL (Windows) cannot connect after power failure

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

MySQL (Windows) cannot connect after power failure

Postby sdifiore » 28. June 2011 18:12

After a power failure, all seems to run smootly but the MySQL altough initializes do not connect.

Here's the message:
MySQL said:

Cannot connect: invalid settings.

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.


I tryied to desinstal everything, remove directoryes, registry index, everything, and re-install from scratch, but it didn't work...

Here the first log after the re-instalL:

110627 18:38:04 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
110627 18:38:04 InnoDB: Initializing buffer pool, size = 16.0M
110627 18:38:04 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
110627 18:38:04 InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
110627 18:38:04 InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
110627 18:38:04 InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
110627 18:38:04 InnoDB: 1.1.4 started; log sequence number 0
110627 18:38:05 [Note] Event Scheduler: Loaded 0 events
110627 18:38:05 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.8' socket: '' port: 3306 MySQL Community Server (GPL)
110627 18:43:19 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

110627 18:43:19 [Note] Event Scheduler: Purging the queue. 0 events
110627 18:43:19 InnoDB: Starting shutdown...
110627 18:43:19 InnoDB: Shutdown completed; log sequence number 1595675
110627 18:43:19 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete


Thanks

Sergio
User avatar
sdifiore
 
Posts: 4
Joined: 28. June 2011 17:57
Location: Brazil

Re: MySQL (Windows) cannot connect after power failure

Postby Sharley » 29. June 2011 03:00

@sdifiore
You have selected a misleading and incorrect Avatar.
You are an ApacheFriends User not an ApacheFriends Administrator so kindly reselect the correct User Avatar or be adventurous and create or use an alternative that reflects more about your own character- thanks.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: MySQL (Windows) cannot connect after power failure

Postby sdifiore » 29. June 2011 19:54

Well.... Unfortunatelly, you do, what people in you organization ask you to do, regardless of your previous knowledge in a specific item. So, if they ask me to act as admin than user, that's what I have to show, whetever my knowledge at the moment does not match so. Anyways, I'm a faster learner, that you can bet.

What I really need are ansswers, like the one of the webdav folder, wich worth trying....

Thanks!
User avatar
sdifiore
 
Posts: 4
Joined: 28. June 2011 17:57
Location: Brazil

Re: MySQL (Windows) cannot connect after power failure

Postby Altrea » 29. June 2011 23:47

What Sharley wants you to tell you is that the Avatar you "choose" is not for Administrators hosting XAMPP but for Administrators of this Board, of the Apachefriends Project.
And that is (independing of your knowledge or what your organisation tell you) not your position.
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: 8298
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 73 guests