Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : mysql not starting in ampps



Threaded Mode | Print  

 mysql not starting in ampps, i have installed ammps but mysql doesn't start (3 Replies, Read 10430 times)
nitinjn191
Group: Member
Post Group: Newbie
Posts: 1
Status:
i have installed ammps but mysql doesn't start when clicking on start mysql in control center  ... it showing error in error log file that i shared below..

2016-02-24 11:22:23 7304 [Warning] You need to use --log-bin to make --binlog-format work.
2016-02-24 11:22:23 7304 [Note] Plugin 'FEDERATED' is disabled.
2016-02-24 11:22:23 7304 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-02-24 11:22:23 7304 [Note] InnoDB: The InnoDB memory heap is disabled
2016-02-24 11:22:23 7304 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-02-24 11:22:23 7304 [Note] InnoDB: Memory barrier is not used
2016-02-24 11:22:23 7304 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-02-24 11:22:23 7304 [Note] InnoDB: Not using CPU crc32 instructions
2016-02-24 11:22:23 7304 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-02-24 11:22:23 7304 [Note] InnoDB: Completed initialization of buffer pool
2016-02-24 11:22:23 7304 [Note] InnoDB: The first specified data file .\ibdata1 did not exist: a new database to be created!
2016-02-24 11:22:23 7304 [Note] InnoDB: Setting file .\ibdata1 size to 12 MB
2016-02-24 11:22:23 7304 [Note] InnoDB: Database physically writes the file full: wait...
2016-02-24 11:22:23 7304 [Note] InnoDB: Setting log file .\ib_logfile101 size to 48 MB
2016-02-24 11:22:24 7304 [Note] InnoDB: Setting log file .\ib_logfile1 size to 48 MB
2016-02-24 11:22:27 7304 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
2016-02-24 11:22:27 7304 [Warning] InnoDB: New log files created, LSN=45781
2016-02-24 11:22:27 7304 [Note] InnoDB: Doublewrite buffer not found: creating new
2016-02-24 11:22:27 7304 [Note] InnoDB: Doublewrite buffer created
2016-02-24 11:22:27 7304 [Note] InnoDB: 128 rollback segment(s) are active.
2016-02-24 11:22:27 7304 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-02-24 11:22:27 7304 [Note] InnoDB: Foreign key constraint system tables created
2016-02-24 11:22:27 7304 [Note] InnoDB: Creating tablespace and datafile system tables.
2016-02-24 11:22:27 7304 [Note] InnoDB: Tablespace and datafile system tables created.
2016-02-24 11:22:27 7304 [Note] InnoDB: Waiting for purge to start
2016-02-24 11:22:27 7304 [Note] InnoDB: 5.6.28 started; log sequence number 0
2016-02-24 11:22:27 7304 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: c92fe459-daba-11e5-9fd3-00ffac1ace32.
2016-02-24 11:22:27 7304 [Note] Server hostname (bind-address): '*'; port: 3306
2016-02-24 11:22:27 7304 [Note] IPv6 is available.
2016-02-24 11:22:27 7304 [Note]  - '::' resolves to '::';
2016-02-24 11:22:27 7304 [Note] Server socket created on IP: '::'.
2016-02-24 11:22:27 7304 [ERROR] Can't start server: Bind on TCP/IP port: No error
2016-02-24 11:22:27 7304 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-02-24 11:22:27 7304 [ERROR] Aborting

2016-02-24 11:22:27 7304 [Note] Binlog end
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'partition'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_METRICS'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_CMP'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'INNODB_TRX'
2016-02-24 11:22:27 7304 [Note] Shutting down plugin 'InnoDB'
2016-02-24 11:22:27 7304 [Note] InnoDB: FTS optimize thread exiting.
2016-02-24 11:22:27 7304 [Note] InnoDB: Starting shutdown...
2016-02-24 11:22:29 7304 [Note] InnoDB: Shutdown completed; log sequence number 1600607
2016-02-24 11:22:29 7304 [Note] Shutting down plugin 'BLACKHOLE'
2016-02-24 11:22:29 7304 [Note] Shutting down plugin 'ARCHIVE'
2016-02-24 11:22:29 7304 [Note] Shutting down plugin 'MRG_MYISAM'
2016-02-24 11:22:29 7304 [Note] Shutting down plugin 'MyISAM'
2016-02-24 11:22:29 7304 [Note] Shutting down plugin 'MEMORY'
2016-02-24 11:22:29 7304 [Note] Shutting down plugin 'CSV'
2016-02-24 11:22:29 7304 [Note] Shutting down plugin 'sha256_password'
2016-02-24 11:22:29 7304 [Note] Shutting down plugin 'mysql_old_password'
2016-02-24 11:22:29 7304 [Note] Shutting down plugin 'mysql_native_password'
2016-02-24 11:22:29 7304 [Note] Shutting down plugin 'binlog'
2016-02-24 11:22:29 7304 [Note] mysql\bin\mysqld.exe: Shutdown complete

please help regarding this
IP: --   

mysql not starting in ampps
aguila
Group: Member
Post Group: Newbie
Posts: 1
Status:
I have the same problem. Any idea?
IP: --   

mysql not starting in ampps
SammyWest
Group: Member
Post Group: Newbie
Posts: 1
Status:
Looks like the port in question is being blocked by another program. you may need a port scanning software to see if that port is indeed active, and if it is active, it might actually in fact be mysql running in the first place. Also there is a configuration file that you can manually change the port from as well if needed.

As far as the services that may use that program, you can always check online what potential programs use that port if you don't have access to a scanner.
IP: --   

mysql not starting in ampps
Rishi_P
Group: Member
Post Group: Elite Member
Posts: 317
Status:
Hi,

>>2016-02-24 11:22:27 7304 [ERROR] Can't start server: Bind on TCP/IP port: No error
2016-02-24 11:22:27 7304 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-02-24 11:22:27 7304 [ERROR] Aborting

This means your port is block because another version of MySQL is running in the background.

Try this:

If you are using windows then open command prompt and run following command.

TASKKILL /F /IM mysqld.exe (Run 2-3 times)

And if you are using Linux or MAC OS then open Terminal and run following command.

sudo killall mysqld (Run 2-3 times)
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 29, 2024, 10:51 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.019