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]
# 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
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…
