reset password
Author Message
EASATRYAN
Posts: 14
Posted 20:19 Sep 10, 2017 |

I'm having trouble getting on MYSQL Server again, I think it may be I'm putting a wrong password. Any help is appreciated. Thank you.

EASATRYAN
Posts: 14
Posted 20:21 Sep 10, 2017 |

I believe I installed XAMP and was using that but cant find that on my computer.

astrong2
Posts: 25
Posted 20:26 Sep 10, 2017 |

I had the same problem using Windows 10. At the bottom right on the taskbar I clicked on the mysql icon and selected the option to connect to the server. Hopefully this helps!

EASATRYAN
Posts: 14
Posted 20:36 Sep 10, 2017 |

Thanks for quick response, but no MySQL Icon shows up I'm downloading XAMPP again hopefully it works out. Just spent over an hour trying to research online, the tutorials and cant get a handle on it. Frustrated.

EASATRYAN
Posts: 14
Posted 20:50 Sep 10, 2017 |
2015-11-10 15:26:56 10fc InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown
2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete
2017-09-10 20:49:35 2438 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2017-09-10 20:49:35 9272 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
2017-09-10 20:49:35 9272 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-09-10 20:49:35 9272 [Note] InnoDB: The InnoDB memory heap is disabled
2017-09-10 20:49:35 9272 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-09-10 20:49:35 9272 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-09-10 20:49:35 9272 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-09-10 20:49:35 9272 [Note] InnoDB: Using generic crc32 instructions
2017-09-10 20:49:35 9272 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-09-10 20:49:35 9272 [Note] InnoDB: Completed initialization of buffer pool
2017-09-10 20:49:35 9272 [Note] InnoDB: Highest supported file format is Barracuda.
2017-09-10 20:49:35 9272 [Note] InnoDB: 128 rollback segment(s) are active.
2017-09-10 20:49:35 9272 [Note] InnoDB: Waiting for purge to start
2017-09-10 20:49:35 9272 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1835037
2017-09-10 20:49:35 8616 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-09-10 20:49:35 9272 [Note] Plugin 'FEEDBACK' is disabled.
2017-09-10 20:49:35 9272 [Note] Server socket created on IP: '::'.
2017-09-10 20:49:35 9272 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2017-09-10 20:49:35 9272 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-09-10 20:49:35 9272 [ERROR] Aborting
 
THIS IS THE ERROR LOG ON XAMPP
EASATRYAN
Posts: 14
Posted 20:56 Sep 10, 2017 |

PROBLEM SOLVED, THE SQL SERVER WAS RUNNING, SO I USED RUN, SERVICES.MSC AND STOPPED THE SERVER. AND WITH XAMPP I WAS ABLE TO OPEN COMMAND AND LOGIN USING -u root -p (no password) THANK YOU!!!