mysql not allow [Solved]

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

mysql not allow [Solved]

Postby adempius » 24. July 2012 10:45

hi boy..
i have this problem..
first problem im italian :D
and..

Image

Image

help me.. i have created localhost..with xampp..but must problem with mysql





please help me..
xaamp I installed on my windows 7 but I have a problem with the page view phpmyadmin
adempius
 
Posts: 6
Joined: 24. July 2012 10:42
Operating System: windows 7

Re: mysql not allow

Postby JonB » 24. July 2012 16:25

First thing to check:

Open the file \xampp\mysql\data\mysql_error.log with a text editor.

Paste the recent contents into a reply. What the error messages say may help us fix your problem

Thanks
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: mysql not allow

Postby adempius » 24. July 2012 16:32

Code: Select all
120724 14:28:12 [Note] Plugin 'FEDERATED' is disabled.
120724 14:28:12 InnoDB: The InnoDB memory heap is disabled
120724 14:28:12 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120724 14:28:12 InnoDB: Compressed tables use zlib 1.2.3
120724 14:28:12 InnoDB: Initializing buffer pool, size = 16.0M
120724 14:28:12 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!
120724 14:28:12  InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
120724 14:28:12  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...
120724 14:28:12  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
120724 14:28:12  InnoDB: Waiting for the background threads to start
120724 14:28:13 InnoDB: 1.1.8 started; log sequence number 0
120724 14:28:13 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120724 14:28:13 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120724 14:28:13 [Note] Server socket created on IP: '0.0.0.0'.
120724 14:28:13 [Note] Event Scheduler: Loaded 0 events
120724 14:28:13 [Note] C:\xampp\mysql\bin\mysqld: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)
120724 14:32:35 [Note] C:\xampp\mysql\bin\mysqld: Normal shutdown

120724 14:32:35 [Note] Event Scheduler: Purging the queue. 0 events
120724 14:32:35  InnoDB: Starting shutdown...
120724 14:32:35  InnoDB: Shutdown completed; log sequence number 1595675
120724 14:32:35 [Note] C:\xampp\mysql\bin\mysqld: Shutdown complete

120724 14:32:36 [Note] Plugin 'FEDERATED' is disabled.
120724 14:32:36 InnoDB: The InnoDB memory heap is disabled
120724 14:32:36 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120724 14:32:36 InnoDB: Compressed tables use zlib 1.2.3
120724 14:32:36 InnoDB: Initializing buffer pool, size = 16.0M
120724 14:32:36 InnoDB: Completed initialization of buffer pool
120724 14:32:36 InnoDB: highest supported file format is Barracuda.
120724 14:32:36  InnoDB: Waiting for the background threads to start
120724 14:32:37 InnoDB: 1.1.8 started; log sequence number 1595675
120724 14:32:37 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120724 14:32:37 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120724 14:32:37 [Note] Server socket created on IP: '0.0.0.0'.
120724 14:32:37 [Note] Event Scheduler: Loaded 0 events
120724 14:32:37 [Note] C:\xampp\mysql\bin\mysqld: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)
120724 14:34:05 [Note] C:\xampp\mysql\bin\mysqld: Normal shutdown

120724 14:34:05 [Note] Event Scheduler: Purging the queue. 0 events
120724 14:34:05  InnoDB: Starting shutdown...
120724 14:34:05  InnoDB: Shutdown completed; log sequence number 1595675
120724 14:34:05 [Note] C:\xampp\mysql\bin\mysqld: Shutdown complete

120724 14:34:08 [Note] Plugin 'FEDERATED' is disabled.
120724 14:34:08 InnoDB: The InnoDB memory heap is disabled
120724 14:34:08 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120724 14:34:08 InnoDB: Compressed tables use zlib 1.2.3
120724 14:34:08 InnoDB: Initializing buffer pool, size = 16.0M
120724 14:34:08 InnoDB: Completed initialization of buffer pool
120724 14:34:08 InnoDB: highest supported file format is Barracuda.
120724 14:34:08  InnoDB: Waiting for the background threads to start
120724 14:34:09 InnoDB: 1.1.8 started; log sequence number 1595675
120724 14:34:09 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120724 14:34:09 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120724 14:34:09 [Note] Server socket created on IP: '0.0.0.0'.
120724 14:34:09 [Note] Event Scheduler: Loaded 0 events
120724 14:34:09 [Note] C:\xampp\mysql\bin\mysqld: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)
120724 14:41:40 [Note] C:\xampp\mysql\bin\mysqld: Normal shutdown

120724 14:41:40 [Note] Event Scheduler: Purging the queue. 0 events
120724 14:41:40  InnoDB: Starting shutdown...
120724 14:41:40  InnoDB: Shutdown completed; log sequence number 1595675
120724 14:41:40 [Note] C:\xampp\mysql\bin\mysqld: Shutdown complete

120724 14:41:52 [Note] Plugin 'FEDERATED' is disabled.
120724 14:41:52 InnoDB: The InnoDB memory heap is disabled
120724 14:41:52 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120724 14:41:52 InnoDB: Compressed tables use zlib 1.2.3
120724 14:41:52 InnoDB: Initializing buffer pool, size = 16.0M
120724 14:41:52 InnoDB: Completed initialization of buffer pool
120724 14:41:52 InnoDB: highest supported file format is Barracuda.
120724 14:41:52  InnoDB: Waiting for the background threads to start
120724 14:41:53 InnoDB: 1.1.8 started; log sequence number 1595675
120724 14:41:53 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120724 14:41:53 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120724 14:41:53 [Note] Server socket created on IP: '0.0.0.0'.
120724 14:41:54 [Note] Event Scheduler: Loaded 0 events
120724 14:41:54 [Note] C:\xampp\mysql\bin\mysqld: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)
120724 14:49:51 [Note] C:\xampp\mysql\bin\mysqld: Normal shutdown

120724 14:49:51 [Note] Event Scheduler: Purging the queue. 0 events
120724 14:49:51  InnoDB: Starting shutdown...
120724 14:49:51  InnoDB: Shutdown completed; log sequence number 1595675
120724 14:49:51 [Note] C:\xampp\mysql\bin\mysqld: Shutdown complete

120724 14:51:55 [Note] Plugin 'FEDERATED' is disabled.
120724 14:51:55 InnoDB: The InnoDB memory heap is disabled
120724 14:51:55 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120724 14:51:55 InnoDB: Compressed tables use zlib 1.2.3
120724 14:51:55 InnoDB: Initializing buffer pool, size = 16.0M
120724 14:51:55 InnoDB: Completed initialization of buffer pool
120724 14:51:55 InnoDB: highest supported file format is Barracuda.
120724 14:51:55  InnoDB: Waiting for the background threads to start
120724 14:51:56 InnoDB: 1.1.8 started; log sequence number 1595675
120724 14:51:56 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120724 14:51:56 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120724 14:51:56 [Note] Server socket created on IP: '0.0.0.0'.
120724 14:51:56 [Note] Event Scheduler: Loaded 0 events
120724 14:51:56 [Note] C:\xampp\mysql\bin\mysqld: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)
120724 16:28:04 [Note] C:\xampp\mysql\bin\mysqld: Normal shutdown

120724 16:28:04 [Note] Event Scheduler: Purging the queue. 0 events
120724 16:28:04  InnoDB: Starting shutdown...
120724 16:28:04  InnoDB: Shutdown completed; log sequence number 1595675
120724 16:28:04 [Note] C:\xampp\mysql\bin\mysqld: Shutdown complete

120724 16:38:47 [Note] Plugin 'FEDERATED' is disabled.
120724 16:38:47 InnoDB: The InnoDB memory heap is disabled
120724 16:38:47 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120724 16:38:47 InnoDB: Compressed tables use zlib 1.2.3
120724 16:38:47 InnoDB: Initializing buffer pool, size = 16.0M
120724 16:38:47 InnoDB: Completed initialization of buffer pool
120724 16:38:47 InnoDB: highest supported file format is Barracuda.
120724 16:38:47  InnoDB: Waiting for the background threads to start
120724 16:38:48 InnoDB: 1.1.8 started; log sequence number 1595675
120724 16:38:48 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120724 16:38:48 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120724 16:38:48 [Note] Server socket created on IP: '0.0.0.0'.
120724 16:38:49 [Note] Event Scheduler: Loaded 0 events
120724 16:38:49 [Note] C:\xampp\mysql\bin\mysqld: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)
120724 16:53:49 [Note] C:\xampp\mysql\bin\mysqld: Normal shutdown

120724 16:53:49 [Note] Event Scheduler: Purging the queue. 0 events
120724 16:53:49  InnoDB: Starting shutdown...
120724 16:53:49  InnoDB: Shutdown completed; log sequence number 1595675
120724 16:53:49 [Note] C:\xampp\mysql\bin\mysqld: Shutdown complete

120724 16:53:51 [Note] Plugin 'FEDERATED' is disabled.
120724 16:53:51 InnoDB: The InnoDB memory heap is disabled
120724 16:53:51 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120724 16:53:51 InnoDB: Compressed tables use zlib 1.2.3
120724 16:53:51 InnoDB: Initializing buffer pool, size = 16.0M
120724 16:53:51 InnoDB: Completed initialization of buffer pool
120724 16:53:51 InnoDB: highest supported file format is Barracuda.
120724 16:53:51  InnoDB: Waiting for the background threads to start
120724 16:53:52 InnoDB: 1.1.8 started; log sequence number 1595675
120724 16:53:52 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120724 16:53:52 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120724 16:53:52 [Note] Server socket created on IP: '0.0.0.0'.
120724 16:53:52 [Note] Event Scheduler: Loaded 0 events
120724 16:53:52 [Note] C:\xampp\mysql\bin\mysqld: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)
120724 16:56:56 [Note] C:\xampp\mysql\bin\mysqld: Normal shutdown

120724 16:56:56 [Note] Event Scheduler: Purging the queue. 0 events
120724 16:56:56  InnoDB: Starting shutdown...
120724 16:56:56  InnoDB: Shutdown completed; log sequence number 1595675
120724 16:56:56 [Note] C:\xampp\mysql\bin\mysqld: Shutdown complete

120724 16:58:47 [Note] Plugin 'FEDERATED' is disabled.
120724 16:58:47 InnoDB: The InnoDB memory heap is disabled
120724 16:58:47 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120724 16:58:47 InnoDB: Compressed tables use zlib 1.2.3
120724 16:58:47 InnoDB: Initializing buffer pool, size = 16.0M
120724 16:58:47 InnoDB: Completed initialization of buffer pool
120724 16:58:47 InnoDB: highest supported file format is Barracuda.
120724 16:58:47  InnoDB: Waiting for the background threads to start
120724 16:58:48 InnoDB: 1.1.8 started; log sequence number 1595675
120724 16:58:48 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120724 16:58:48 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120724 16:58:48 [Note] Server socket created on IP: '0.0.0.0'.
120724 16:58:48 [Note] Event Scheduler: Loaded 0 events
120724 16:58:48 [Note] C:\xampp\mysql\bin\mysqld: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)
120724 16:58:51 [Note] C:\xampp\mysql\bin\mysqld: Normal shutdown

120724 16:58:51 [Note] Event Scheduler: Purging the queue. 0 events
120724 16:58:51  InnoDB: Starting shutdown...
120724 16:58:51  InnoDB: Shutdown completed; log sequence number 1595675
120724 16:58:51 [Note] C:\xampp\mysql\bin\mysqld: Shutdown complete



i install xampp 1.7.7 or 1.8.0 ..successfully but.. :roll:
adempius
 
Posts: 6
Joined: 24. July 2012 10:42
Operating System: windows 7

Re: mysql not allow

Postby hackattack142 » 24. July 2012 22:25

You might also try opening your "/xampp/mysql/bin/my.ini" file, and finding this line:
Code: Select all
#bind-address="127.0.0.1"
, remove the "#" in front of it, save the file, and restart MySQL. When you visit the phpMyAdmin page http://localhost/phpmyadmin make sure you manually refresh the page in your browser so you do not get a cached error page.
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 701
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: mysql not allow

Postby adempius » 24. July 2012 23:17

ok .. i try

thanks
adempius
 
Posts: 6
Joined: 24. July 2012 10:42
Operating System: windows 7

Re: mysql not allow

Postby adempius » 25. July 2012 23:48

ok done
adempius
 
Posts: 6
Joined: 24. July 2012 10:42
Operating System: windows 7

Re: mysql not allow

Postby JonB » 25. July 2012 23:53

Does that mean it is working??? if so that is good news! :D

Good Luck with XAMPP
Buona fortuna con il progetto

8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: mysql not allow

Postby adempius » 26. July 2012 16:57

i have another error..mmm i try :(
when i digit localhost..on browser
Database connection error (2): Could not connect to MySQL.
adempius
 
Posts: 6
Joined: 24. July 2012 10:42
Operating System: windows 7

Re: mysql not allow

Postby adempius » 26. July 2012 17:36

resolved!!!!
file host of windows7 corrupted ..
f..k yeah
adempius
 
Posts: 6
Joined: 24. July 2012 10:42
Operating System: windows 7

Re: mysql not allow

Postby JonB » 26. July 2012 20:25

Glad you got it working

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 149 guests