Kein Mysql Verbindung

In diesem Bereich sind Themen vom Themenersteller als erledigt zu markieren, wenn die Frage beantwortet oder das Problem gelöst wurde. Das Thema wird daraufhin automatisch geschlossen.
Klicke hierzu auf "Thema bearbeiten > Als erledigt markieren".
  • Hey wieso kriege ich mysql nicht gestartet? Folgendes steht in den .err dateien:
    180611 19:46:31 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
    2018-06-11 19:46:31 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2018-06-11 19:46:31 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.27) starting as process 873 ...
    2018-06-11 19:46:31 873 [Note] Plugin 'FEDERATED' is disabled.
    2018-06-11 19:46:31 873 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2018-06-11 19:46:31 873 [Note] InnoDB: The InnoDB memory heap is disabled
    2018-06-11 19:46:31 873 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2018-06-11 19:46:31 873 [Note] InnoDB: Memory barrier is not used
    2018-06-11 19:46:31 873 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2018-06-11 19:46:31 873 [Note] InnoDB: Not using CPU crc32 instructions
    2018-06-11 19:46:31 873 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2018-06-11 19:46:31 873 [Note] InnoDB: Completed initialization of buffer pool
    2018-06-11 19:46:31 873 [Note] InnoDB: Highest supported file format is Barracuda.
    2018-06-11 19:46:31 873 [Note] InnoDB: 128 rollback segment(s) are active.
    2018-06-11 19:46:31 873 [Note] InnoDB: Waiting for purge to start
    2018-06-11 19:46:31 873 [Note] InnoDB: 5.6.27 started; log sequence number 1625987
    /usr/local/libexec/mysqld: Error on delete of './auto.cnf' (Errcode: 2 - No such file or directory)
    2018-06-11 19:46:31 873 [Warning] World-writable config file './auto.cnf' has been removed.


    2018-06-11 19:46:31 873 [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: 6045b19f-6d9f-11e8-a85a-08002752514b.
    2018-06-11 19:46:31 873 [Note] Server hostname (bind-address): '*'; port: 3306
    2018-06-11 19:46:31 873 [Note] IPv6 is available.
    2018-06-11 19:46:31 873 [Note] - '::' resolves to '::';
    2018-06-11 19:46:31 873 [Note] Server socket created on IP: '::'.
    2018-06-11 19:46:31 873 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
    2018-06-11 19:46:31 873 [ERROR] Do you already have another mysqld server running on port: 3306 ?
    2018-06-11 19:46:31 873 [ERROR] Aborting


    2018-06-11 19:46:31 873 [Note] Binlog end
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'partition'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'ARCHIVE'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_METRICS'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_CMP'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_LOCKS'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'INNODB_TRX'
    2018-06-11 19:46:31 873 [Note] Shutting down plugin 'InnoDB'
    2018-06-11 19:46:31 873 [Note] InnoDB: FTS optimize thread exiting.
    2018-06-11 19:46:31 873 [Note] InnoDB: Starting shutdown...
    2018-06-11 19:46:33 873 [Note] InnoDB: Shutdown completed; log sequence number 1625997
    2018-06-11 19:46:33 873 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2018-06-11 19:46:33 873 [Note] Shutting down plugin 'BLACKHOLE'
    2018-06-11 19:46:33 873 [Note] Shutting down plugin 'MEMORY'
    2018-06-11 19:46:33 873 [Note] Shutting down plugin 'MRG_MYISAM'
    2018-06-11 19:46:33 873 [Note] Shutting down plugin 'MyISAM'
    2018-06-11 19:46:33 873 [Note] Shutting down plugin 'CSV'
    2018-06-11 19:46:33 873 [Note] Shutting down plugin 'sha256_password'
    2018-06-11 19:46:33 873 [Note] Shutting down plugin 'mysql_old_password'
    2018-06-11 19:46:33 873 [Note] Shutting down plugin 'mysql_native_password'
    2018-06-11 19:46:33 873 [Note] Shutting down plugin 'binlog'
    2018-06-11 19:46:33 873 [Note] /usr/local/libexec/mysqld: Shutdown complete


    180611 19:46:33 mysqld_safe mysqld from pid file /var/db/mysql/rext.test.server.pid ended




    Eventuell weiß ja jemand ne lösung :) besten dank!

  • Dieses Thema enthält 2 weitere Beiträge, die nur für registrierte Benutzer sichtbar sind, bitte registrieren Sie sich oder melden Sie sich an um diese lesen zu können.