Moin,
vorgestern ging alles, als ich was eingefügt habe, was am Ende nicht ging, hab ich alles zurück gemacht in der Datenbank. Natürlich hab ich
auch getestet ob alles wieder ging. (Hat auch alles geklappt) Jetzt wollte ich einfach eine Map einfügen von mir, aber irgendwie möchte der Mysql Server nicht starten.
Was muss ich jetzt machen?
Code: admin.err
- 200701 17:57:19 mysqld_safe Logging to '/var/db/mysql/admin.err'.
- 200701 17:57:19 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
- 2020-07-01 17:57:19 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
- 2020-07-01 17:57:19 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.48) starting as process 898 ...
- 2020-07-01 17:57:19 898 [Note] Plugin 'FEDERATED' is disabled.
- 2020-07-01 17:57:19 898 [Note] InnoDB: Using atomics to ref count buffer pool pages
- 2020-07-01 17:57:19 898 [Note] InnoDB: The InnoDB memory heap is disabled
- 2020-07-01 17:57:19 898 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2020-07-01 17:57:19 898 [Note] InnoDB: Memory barrier is not used
- 2020-07-01 17:57:19 898 [Note] InnoDB: Compressed tables use zlib 1.2.11
- 2020-07-01 17:57:19 898 [Note] InnoDB: Using CPU crc32 instructions
- 2020-07-01 17:57:19 898 [Note] InnoDB: Initializing buffer pool, size = 128.0M
- 2020-07-01 17:57:20 898 [Note] InnoDB: Completed initialization of buffer pool
- 2020-07-01 17:57:20 898 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
- 2020-07-01 17:57:20 898 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
- 2020-07-01 17:57:20 898 [Note] InnoDB: Database physically writes the file full: wait...
- 2020-07-01 17:57:20 898 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
- 2020-07-01 17:57:20 898 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
- 2020-07-01 17:57:20 898 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
- 2020-07-01 17:57:20 898 [Warning] InnoDB: New log files created, LSN=45781
- 2020-07-01 17:57:20 898 [Note] InnoDB: Doublewrite buffer not found: creating new
- 2020-07-01 17:57:20 898 [Note] InnoDB: Doublewrite buffer created
- 2020-07-01 17:57:20 898 [Note] InnoDB: 128 rollback segment(s) are active.
- 2020-07-01 17:57:20 898 [Warning] InnoDB: Creating foreign key constraint system tables.
- 2020-07-01 17:57:20 898 [Note] InnoDB: Foreign key constraint system tables created
- 2020-07-01 17:57:20 898 [Note] InnoDB: Creating tablespace and datafile system tables.
- 2020-07-01 17:57:20 898 [Note] InnoDB: Tablespace and datafile system tables created.
- 2020-07-01 17:57:20 898 [Note] InnoDB: Waiting for purge to start
- 2020-07-01 17:57:20 898 [Note] InnoDB: 5.6.48 started; log sequence number 0
- /usr/local/libexec/mysqld: Error on delete of './auto.cnf' (Errcode: 2 - No such file or directory)
- 2020-07-01 17:57:20 898 [Warning] World-writable config file './auto.cnf' has been removed.
- 2020-07-01 17:57:20 898 [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: 8bb0f499-bbb3-11ea-b028-0800270ef579.
- 2020-07-01 17:57:20 898 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
- 2020-07-01 17:57:20 898 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
- 2020-07-01 17:57:20 898 [Note] Server hostname (bind-address): '*'; port: 3306
- 2020-07-01 17:57:20 898 [Note] IPv6 is available.
- 2020-07-01 17:57:20 898 [Note] - '::' resolves to '::';
- 2020-07-01 17:57:20 898 [Note] Server socket created on IP: '::'.
- 2020-07-01 17:57:20 898 [ERROR] Can't start server : Bind on unix socket: Address already in use
- 2020-07-01 17:57:20 898 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ?
- 2020-07-01 17:57:20 898 [ERROR] Aborting
- 2020-07-01 17:57:20 898 [Note] Binlog end
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'partition'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_FT_DELETED'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_METRICS'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_CMPMEM'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_CMP_RESET'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_CMP'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_LOCKS'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'INNODB_TRX'
- 2020-07-01 17:57:20 898 [Note] Shutting down plugin 'InnoDB'
- 2020-07-01 17:57:20 898 [Note] InnoDB: FTS optimize thread exiting.
- 2020-07-01 17:57:20 898 [Note] InnoDB: Starting shutdown...
- 2020-07-01 17:57:22 898 [Note] InnoDB: Shutdown completed; log sequence number 1600607
- 2020-07-01 17:57:22 898 [Note] Shutting down plugin 'BLACKHOLE'
- 2020-07-01 17:57:22 898 [Note] Shutting down plugin 'ARCHIVE'
- 2020-07-01 17:57:22 898 [Note] Shutting down plugin 'MRG_MYISAM'
- 2020-07-01 17:57:22 898 [Note] Shutting down plugin 'MyISAM'
- 2020-07-01 17:57:22 898 [Note] Shutting down plugin 'MEMORY'
- 2020-07-01 17:57:22 898 [Note] Shutting down plugin 'CSV'
- 2020-07-01 17:57:22 898 [Note] Shutting down plugin 'sha256_password'
- 2020-07-01 17:57:22 898 [Note] Shutting down plugin 'mysql_old_password'
- 2020-07-01 17:57:22 898 [Note] Shutting down plugin 'mysql_native_password'
- 2020-07-01 17:57:22 898 [Note] Shutting down plugin 'binlog'
- 2020-07-01 17:57:22 898 [Note] /usr/local/libexec/mysqld: Shutdown complete
- 200701 17:57:22 mysqld_safe mysqld from pid file /var/db/mysql/admin.pid ended