Sosat 1 Posted December 10, 2018 Share Posted December 10, 2018 Hello metin2dev, i have the following problem.. so when the server is offline and im staring the mysql-server (service mysql-server start) it is working fine but when server is ON "mysql not running? (check /var/db/mysql/server.xx.tld.pid)." server.xx.tld.pid: Spoiler 181210 16:15:53 mysqld_safe Logging to '/var/db/mysql/server.xx.tld.err'. 181210 16:15:53 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql Warning: World-writable config file '/var/db/mysql/my.cnf' is ignored Warning: World-writable config file '/var/db/mysql/my.cnf' is ignored 2018-12-10 16:15:54 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-12-10 16:15:54 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.42) starting as process 1633 ... 2018-12-10 16:15:54 1633 [Note] Plugin 'FEDERATED' is disabled. 2018-12-10 16:15:54 1633 [Note] InnoDB: Using atomics to ref count buffer pool pages 2018-12-10 16:15:54 1633 [Note] InnoDB: The InnoDB memory heap is disabled 2018-12-10 16:15:54 1633 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-12-10 16:15:54 1633 [Note] InnoDB: Memory barrier is not used 2018-12-10 16:15:54 1633 [Note] InnoDB: Compressed tables use zlib 1.2.11 2018-12-10 16:15:54 1633 [Note] InnoDB: Not using CPU crc32 instructions 2018-12-10 16:15:54 1633 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2018-12-10 16:15:54 1633 [Note] InnoDB: Completed initialization of buffer pool 2018-12-10 16:15:54 1633 [Note] InnoDB: Highest supported file format is Barracuda. 2018-12-10 16:15:54 1633 [Note] InnoDB: 128 rollback segment(s) are active. 2018-12-10 16:15:54 1633 [Note] InnoDB: Waiting for purge to start 2018-12-10 16:15:54 1633 [Note] InnoDB: 5.6.42 started; log sequence number 1600617 2018-12-10 16:15:54 1633 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work. 2018-12-10 16:15:54 1633 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work. 2018-12-10 16:15:54 1633 [Note] Server hostname (bind-address): '*'; port: 3306 2018-12-10 16:15:54 1633 [Note] IPv6 is available. 2018-12-10 16:15:54 1633 [Note] - '::' resolves to '::'; 2018-12-10 16:15:54 1633 [Note] Server socket created on IP: '::'. 2018-12-10 16:15:54 1633 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-12-10 16:15:54 1633 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-12-10 16:15:54 1633 [ERROR] Aborting 2018-12-10 16:15:54 1633 [Note] Binlog end 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'partition' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_METRICS' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_CMP' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'INNODB_TRX' 2018-12-10 16:15:54 1633 [Note] Shutting down plugin 'InnoDB' 2018-12-10 16:15:54 1633 [Note] InnoDB: FTS optimize thread exiting. 2018-12-10 16:15:54 1633 [Note] InnoDB: Starting shutdown... 2018-12-10 16:15:55 1633 [Note] InnoDB: Shutdown completed; log sequence number 1600627 2018-12-10 16:15:55 1633 [Note] Shutting down plugin 'BLACKHOLE' 2018-12-10 16:15:55 1633 [Note] Shutting down plugin 'ARCHIVE' 2018-12-10 16:15:55 1633 [Note] Shutting down plugin 'MRG_MYISAM' 2018-12-10 16:15:55 1633 [Note] Shutting down plugin 'MyISAM' 2018-12-10 16:15:55 1633 [Note] Shutting down plugin 'MEMORY' 2018-12-10 16:15:55 1633 [Note] Shutting down plugin 'CSV' 2018-12-10 16:15:55 1633 [Note] Shutting down plugin 'sha256_password' 2018-12-10 16:15:55 1633 [Note] Shutting down plugin 'mysql_old_password' 2018-12-10 16:15:55 1633 [Note] Shutting down plugin 'mysql_native_password' 2018-12-10 16:15:55 1633 [Note] Shutting down plugin 'binlog' 2018-12-10 16:15:55 1633 [Note] /usr/local/libexec/mysqld: Shutdown complete 181210 16:15:55 mysqld_safe mysqld from pid file /var/db/mysql/server.xx.tld.pid ended hope you unsterstand and sorry for my english! Thank you! Link to comment Share on other sites More sharing options...
Active Member Mind Rapist 188 Posted December 10, 2018 Active Member Share Posted December 10, 2018 1 hour ago, Sosat said: 2018-12-10 16:15:54 1633 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-12-10 16:15:54 1633 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-12-10 16:15:54 1633 [ERROR] Aborting There's your problem buddy, some other process is using your port. If you installed a new version of mysql-server make sure it is the only version of mysql in your system. If you installed mysqlXX-client make sure server and client are the same version and that it's the only version in your system. If none of these gets the job done, rename /var/db/mysql folder, deinstall every instance of mysql-server/client and then reinstall your desired version of server (and client if you wish), start the service, stop it, delete /var/db/mysql (newly created) and recover your old folder's name back to original. Then without starting the service again hit reboot and that should do it Best regards Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now