MySQL Forums
Forum List  »  Install & Repo

Cannot start mysqld after fresh install
Posted by: Dale Schmitz
Date: March 04, 2016 03:22PM

Hopefully I haven't started a thread here that's already in existence. I've done some looking but I can't find a topic that reflects mine.

I'm fairly new to MySQL, having used it but never installed it.

I've just installed MySQL 5.7.11 on a RHEL6 desktop system, and while the installation seems to have gone well, I can't start the server. I've looked at permissions for everything (that I can think of) and all seems well in that department. Other searches around the Internet for the same thing don't seem to apply or are significantly (enough) different.

I'm posting the results of my startup log (/var/log/mysqld.log) in the hopes someone can see something right off.

Thanks for any advice you can give:

2016-03-04T21:11:24.170687Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-03-04T21:11:24.638778Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-03-04T21:11:24.643741Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.11) starting as process 4557 ...
2016-03-04T21:11:24.663850Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-03-04T21:11:24.663914Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-03-04T21:11:24.663929Z 0 [Note] InnoDB: Uses event mutexes
2016-03-04T21:11:24.663941Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2016-03-04T21:11:24.663955Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-04T21:11:24.663967Z 0 [Note] InnoDB: Using Linux native AIO
2016-03-04T21:11:24.664542Z 0 [Note] InnoDB: Number of pools: 1
2016-03-04T21:11:24.664853Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-04T21:11:24.701339Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-03-04T21:11:24.753790Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-03-04T21:11:24.766059Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2016-03-04T21:11:24.782346Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-04T21:11:24.867473Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-03-04T21:11:24.867720Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-03-04T21:11:25.209974Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2016-03-04T21:11:25.211885Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-03-04T21:11:25.211933Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-03-04T21:11:25.215402Z 0 [Note] InnoDB: Waiting for purge to start
2016-03-04T21:11:25.265732Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 1210188
2016-03-04T21:11:25.267754Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-03-04T21:11:25.268947Z 0 [Warning] System table 'plugin' is expected to be transactional.
2016-03-04T21:11:25.272120Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-03-04T21:11:25.272307Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2016-03-04T21:11:25.272705Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-04T21:11:25.273018Z 0 [Note] IPv6 is available.
2016-03-04T21:11:25.273045Z 0 [Note] - '::' resolves to '::';
2016-03-04T21:11:25.273064Z 0 [Note] Server socket created on IP: '::'.
2016-03-04T21:11:25.273764Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2016-03-04T21:11:25.273960Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160304 15:11:25
2016-03-04T21:11:25.319440Z 0 [Warning] Failed to open optimizer cost constant tables

2016-03-04T21:11:25.320223Z 0 [ERROR] Fatal error: mysql.user table is damaged. Please run mysql_upgrade.
2016-03-04T21:11:25.320388Z 0 [ERROR] Aborting

2016-03-04T21:11:25.320415Z 0 [Note] Binlog end
2016-03-04T21:11:25.320519Z 0 [Note] Shutting down plugin 'ngram'
2016-03-04T21:11:25.320539Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-03-04T21:11:25.320551Z 0 [Note] Shutting down plugin 'partition'
2016-03-04T21:11:25.320591Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-03-04T21:11:25.320606Z 0 [Note] Shutting down plugin 'MyISAM'
2016-03-04T21:11:25.320628Z 0 [Note] Shutting down plugin 'CSV'
2016-03-04T21:11:25.320643Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-03-04T21:11:25.320655Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-03-04T21:11:25.320666Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-03-04T21:11:25.320677Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-03-04T21:11:25.320703Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-03-04T21:11:25.320714Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-03-04T21:11:25.320725Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-03-04T21:11:25.320736Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-03-04T21:11:25.320748Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-03-04T21:11:25.320758Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-03-04T21:11:25.320769Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-03-04T21:11:25.320780Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-03-04T21:11:25.320791Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-03-04T21:11:25.320802Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-03-04T21:11:25.320813Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-03-04T21:11:25.320824Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-03-04T21:11:25.320835Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-03-04T21:11:25.320846Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-03-04T21:11:25.320857Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-03-04T21:11:25.320868Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-03-04T21:11:25.320879Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-03-04T21:11:25.320890Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-03-04T21:11:25.320901Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-03-04T21:11:25.320912Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-03-04T21:11:25.320923Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-03-04T21:11:25.320934Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-03-04T21:11:25.320944Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-03-04T21:11:25.320955Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-03-04T21:11:25.320967Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-03-04T21:11:25.320978Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-03-04T21:11:25.320988Z 0 [Note] Shutting down plugin 'InnoDB'
2016-03-04T21:11:25.321128Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-03-04T21:11:25.321303Z 0 [Note] InnoDB: Starting shutdown...
2016-03-04T21:11:25.422089Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2016-03-04T21:11:25.422468Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160304 15:11:25
2016-03-04T21:11:27.117339Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1210207
2016-03-04T21:11:27.121913Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-03-04T21:11:27.121966Z 0 [Note] Shutting down plugin 'MEMORY'
2016-03-04T21:11:27.121986Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-03-04T21:11:27.122157Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-03-04T21:11:27.122171Z 0 [Note] Shutting down plugin 'sha256_password'
2016-03-04T21:11:27.122181Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-03-04T21:11:27.122191Z 0 [Note] Shutting down plugin 'keyring_file'
2016-03-04T21:11:27.122466Z 0 [Note] Shutting down plugin 'binlog'
2016-03-04T21:11:27.129191Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2016-03-04T21:11:27.186212Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.