# Cannot get it started on CentOS 7 **URL:** \ **Category:** Percona Server for MySQL 5.7\ **Created:** [September 17, 2017, 7:02pm UTC](https://forums.percona.com/t/cannot-get-it-started-on-centos-7/5866 "2017-09-17T19:02:49Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![gmillikan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gmillikan/32/38_2.png) [@gmillikan](https://forums.percona.com/u/gmillikan)\ **Post date:** [September 17, 2017, 7:02pm UTC](https://forums.percona.com/t/cannot-get-it-started-on-centos-7/5866/1 "2017-09-17T19:02:49Z")
After years w/vanilla MySQL we’re working to jump to Percona. So we did vanilla install. Starting it up but it errors out… But wait, there’s a process running! Oh good! Oh but wait, I can’t login (see last red circle). How do I log in? Static hostname: localhost.localdomain Icon name: computer-vm Chassis: vm Machine ID: c82455519f5b4eac85de2ea3c39ab8c8 Boot ID: 8accfd28cf7344ca98ef2a05fb7f40d9 Virtualization: vmware Operating System: CentOS Linux 7 (Core) CPE OS Name: cpe:/o:centos:centos:7 Kernel: Linux 3.10.0-693.2.2.el7.x86\_64 Architecture: x86-64[/INDENT] ![photoid=49629](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/2/2d35b1bbd2b30177de294fb81c23586aa374b54e.png) ---
**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\ **Post date:** [September 18, 2017, 11:01pm UTC](https://forums.percona.com/t/cannot-get-it-started-on-centos-7/5866/2 "2017-09-18T23:01:09Z")
Need to have the following: - Percona Server version installed (rpm -qa|grep -i percona) - full mysql error log since the upgrade and where PS did not start. ---
**Author:** ![gmillikan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gmillikan/32/38_2.png) [@gmillikan](https://forums.percona.com/u/gmillikan)\ **Post date:** [September 24, 2017, 10:31pm UTC](https://forums.percona.com/t/cannot-get-it-started-on-centos-7/5866/3 "2017-09-24T22:31:21Z")
```auto # rpm -qa | grep -i percona Percona-Server-client-57-5.7.19-17.1.el7.x86_64 Percona-Server-server-57-5.7.19-17.1.el7.x86_64 Percona-Server-shared-compat-57-5.7.19-17.1.el7.x86_64 Percona-Server-shared-57-5.7.19-17.1.el7.x86_64 percona-release-0.1-4.noarch ``` ```auto # cat /var/log/mysqld.log | more 2017-09-17T21:11:22.931848Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-09-17T21:11:32.007488Z 0 [Warning] InnoDB: New log files created, LSN=45790 2017-09-17T21:11:33.021294Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-09-17T21:11:33.144867Z 0 [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: c832ca29-9bec-11e7-bd62-000c29a5f040. 2017-09-17T21:11:33.147081Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2017-09-17T21:11:33.746547Z 0 [Warning] CA certificate ca.pem is self signed. 2017-09-17T21:11:34.025940Z 1 [Note] A temporary password is generated for root@localhost: ghF1K.fvYJCp 2017-09-17T21:11:42.060654Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-09-17T21:11:42.064374Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.19-17) starting as process 11578 ... 2017-09-17T21:11:42.073968Z 0 [Note] InnoDB: PUNCH HOLE support available 2017-09-17T21:11:42.074063Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-09-17T21:11:42.074072Z 0 [Note] InnoDB: Uses event mutexes 2017-09-17T21:11:42.074078Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-09-17T21:11:42.074084Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2017-09-17T21:11:42.074090Z 0 [Note] InnoDB: Using Linux native AIO 2017-09-17T21:11:42.074939Z 0 [Note] InnoDB: Number of pools: 1 2017-09-17T21:11:42.075307Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2017-09-17T21:11:42.081079Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2017-09-17T21:11:42.094141Z 0 [Note] InnoDB: Completed initialization of buffer pool 2017-09-17T21:11:42.101707Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-09-17T21:11:42.115863Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite 2017-09-17T21:11:42.117462Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2017-09-17T21:11:42.242189Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 3932160 bytes 2017-09-17T21:11:42.254716Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-09-17T21:11:42.255040Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-09-17T21:11:43.153597Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-09-17T21:11:43.156165Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2017-09-17T21:11:43.156210Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2017-09-17T21:11:43.159258Z 0 [Note] InnoDB: Waiting for purge to start 2017-09-17T21:11:43.209836Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.19-17 started; log sequence number 2544743 2017-09-17T21:11:43.210555Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2017-09-17T21:11:43.211401Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-09-17T21:11:43.215746Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170917 21:11:43 2017-09-17T21:11:43.229544Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2017-09-17T21:11:43.229582Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2017-09-17T21:11:43.233372Z 0 [Warning] CA certificate ca.pem is self signed. 2017-09-17T21:11:43.233693Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2017-09-17T21:11:43.235849Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2017-09-17T21:11:43.236198Z 0 [Note] IPv6 is available. 2017-09-17T21:11:43.236254Z 0 [Note] - '::' resolves to '::'; 2017-09-17T21:11:43.236369Z 0 [Note] Server socket created on IP: '::'. 2017-09-17T21:11:43.259093Z 0 [Note] Event Scheduler: Loaded 0 events 2017-09-17T21:11:43.260066Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.19-17' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona Server (GPL), Release 17, Revision e19a6b7b73f 2017-09-17T21:11:43.260099Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check . 2017-09-17T21:11:43.260105Z 0 [Note] Beginning of list of non-natively partitioned tables 2017-09-17T21:11:43.285140Z 0 [Note] End of list of non-natively partitioned tables 2017-09-17T21:12:06.309173Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2017-09-17T21:12:10.457617Z 4 [Note] Access denied for user 'root'@'localhost' (using password: YES) 2017-09-17T21:12:16.120394Z 5 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2017-09-17T21:12:16.808896Z 6 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2017-09-17T21:15:05.232418Z 0 [Note] Giving 0 client threads a chance to die gracefully 2017-09-17T21:15:05.232539Z 0 [Note] Shutting down slave threads 2017-09-17T21:15:05.232584Z 0 [Note] Forcefully disconnecting 0 remaining clients 2017-09-17T21:15:05.232612Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2017-09-17T21:15:05.232803Z 0 [Note] Binlog end 2017-09-17T21:15:05.234920Z 0 [Note] Shutting down plugin 'validate_password' 2017-09-17T21:15:05.235052Z 0 [Note] Shutting down plugin 'ngram' 2017-09-17T21:15:05.235063Z 0 [Note] Shutting down plugin 'ARCHIVE' 2017-09-17T21:15:05.235069Z 0 [Note] Shutting down plugin 'partition' 2017-09-17T21:15:05.235073Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2017-09-17T21:15:05.235089Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2017-09-17T21:15:05.235159Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2017-09-17T21:15:05.235172Z 0 [Note] Shutting down plugin 'CSV' 2017-09-17T21:15:05.235182Z 0 [Note] Shutting down plugin 'MyISAM' 2017-09-17T21:15:05.235215Z 0 [Note] Shutting down plugin 'MEMORY' 2017-09-17T21:15:05.235233Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2017-09-17T21:15:05.235885Z 0 [Note] InnoDB: FTS optimize thread exiting. 2017-09-17T21:15:05.236370Z 0 [Note] InnoDB: Starting shutdown... 2017-09-17T21:15:05.337035Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2017-09-17T21:15:05.338400Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170917 21:15:05 2017-09-17T21:15:06.337940Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2017-09-17T21:15:07.852938Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2544771 2017-09-17T21:15:07.855878Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2017-09-17T21:15:07.855899Z 0 [Note] Shutting down plugin 'sha256_password' 2017-09-17T21:15:07.855904Z 0 [Note] Shutting down plugin 'mysql_native_password' 2017-09-17T21:15:07.856522Z 0 [Note] Shutting down plugin 'binlog' 2017-09-17T21:15:07.859126Z 0 [Note] /usr/sbin/mysqld: Shutdown complete ``` ---
**Author:** ![gmillikan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gmillikan/32/38_2.png) [@gmillikan](https://forums.percona.com/u/gmillikan)\ **Post date:** [September 24, 2017, 10:33pm UTC](https://forums.percona.com/t/cannot-get-it-started-on-centos-7/5866/4 "2017-09-24T22:33:38Z")
Going to uninstall and try again unless you have other thoughts? ---
**Author:** ![gmillikan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gmillikan/32/38_2.png) [@gmillikan](https://forums.percona.com/u/gmillikan)\ **Post date:** [September 26, 2017, 9:06pm UTC](https://forums.percona.com/t/cannot-get-it-started-on-centos-7/5866/5 "2017-09-26T21:06:51Z")
Ping! Any thoughts? ---
**Author:** ![gmillikan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gmillikan/32/38_2.png) [@gmillikan](https://forums.percona.com/u/gmillikan)\ **Post date:** [September 26, 2017, 9:16pm UTC](https://forums.percona.com/t/cannot-get-it-started-on-centos-7/5866/6 "2017-09-26T21:16:43Z")
BTW, called the tech support line, got a really nice guy in Philippines but don’t have support contract, yet… Hoping these boards proved L1-type tech support… Plan to purchase support contract if these boards help with the basics… ---
**Author:** ![gmillikan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gmillikan/32/38_2.png) [@gmillikan](https://forums.percona.com/u/gmillikan)\ **Post date:** [September 27, 2017, 11:00pm UTC](https://forums.percona.com/t/cannot-get-it-started-on-centos-7/5866/7 "2017-09-27T23:00:19Z")
Hello? Mic check… ---
**Author:** ![gmillikan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gmillikan/32/38_2.png) [@gmillikan](https://forums.percona.com/u/gmillikan)\ **Post date:** [September 28, 2017, 9:08pm UTC](https://forums.percona.com/t/cannot-get-it-started-on-centos-7/5866/8 "2017-09-28T21:08:39Z")
Bummed this forums aren’t more active… ---
**Author:** ![gmillikan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gmillikan/32/38_2.png) [@gmillikan](https://forums.percona.com/u/gmillikan)\ **Post date:** [September 28, 2017, 9:41pm UTC](https://forums.percona.com/t/cannot-get-it-started-on-centos-7/5866/9 "2017-09-28T21:41:22Z")
Removed everything, reinstalled, works fine. ---
**Author:** ![gmillikan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/gmillikan/32/38_2.png) [@gmillikan](https://forums.percona.com/u/gmillikan)\ **Post date:** [September 28, 2017, 9:42pm UTC](https://forums.percona.com/t/cannot-get-it-started-on-centos-7/5866/10 "2017-09-28T21:42:25Z")
BTW, default password is here: [url][https://www.percona.com/blog/2016/05/18/where-is-the-mysql-5-7-root-password/[/url]](https://www.percona.com/blog/2016/05/18/where-is-the-mysql-5-7-root-password/%5B/url%5D)