MySQL Forums
Forum List  »  Install & Repo

After install, how to retrieve the root temporary password
Posted by: Jean-Louis Matéo
Date: July 25, 2017 07:58AM


I installed MySQL 5.7.19 (yum install) on my RHEL 6 server.
I followed the instructions from this page:

At step 4 - Checking the temporary password "shell> sudo grep 'temporary password' /var/log/mysqld.log", i'm blocked as there's no line saying that there's a temporary password.

Here is the log after having installed and run MySQL server (port 3306 has well arised)

[root@lyon log]# view mysqld.log
2017-07-25T13:19:55.307408Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-07-25T13:19:55.307458Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-07-25T13:19:55.307474Z 0 [Note] InnoDB: Uses event mutexes
2017-07-25T13:19:55.307489Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2017-07-25T13:19:55.307500Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-07-25T13:19:55.307511Z 0 [Note] InnoDB: Using Linux native AIO
2017-07-25T13:19:55.308082Z 0 [Note] InnoDB: Number of pools: 1
2017-07-25T13:19:55.308298Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-07-25T13:19:55.311736Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-07-25T13:19:55.327422Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-07-25T13:19:55.331679Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-07-25T13:19:55.345930Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-07-25T13:19:55.365360Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-07-25T13:19:55.365696Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-07-25T13:19:55.435456Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-07-25T13:19:55.439160Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-07-25T13:19:55.439199Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-07-25T13:19:55.441703Z 0 [Note] InnoDB: Waiting for purge to start
2017-07-25T13:19:55.492148Z 0 [Note] InnoDB: 5.7.19 started; log sequence number 2535993
2017-07-25T13:19:55.494851Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-07-25T13:19:55.495496Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-07-25T13:19:55.498214Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170725 15:19:55
2017-07-25T13:19:55.506356Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2017-07-25T13:19:55.506769Z 0 [Warning] CA certificate ca.pem is self signed.
2017-07-25T13:19:55.510063Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2017-07-25T13:19:55.510945Z 0 [Note] IPv6 is available.
2017-07-25T13:19:55.511011Z 0 [Note] - '::' resolves to '::';
2017-07-25T13:19:55.511069Z 0 [Note] Server socket created on IP: '::'.
2017-07-25T13:19:55.533511Z 0 [Note] Event Scheduler: Loaded 0 events
2017-07-25T13:19:55.533959Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.19' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
2017-07-25T13:19:55.534013Z 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-07-25T13:19:55.534022Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-07-25T13:19:55.559179Z 0 [Note] End of list of non-natively partitioned tables
2017-07-25T13:19:55.804357Z 3 [Note] Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)

so i thought that root user came without any password and i tried to enter mysql or mysqladmin (mysql -uroot) and i still got the message:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Please, could tell me what's wrong ?
Any idea on where should I look at ?

Jean-Louis Matéo

Options: ReplyQuote

Written By
After install, how to retrieve the root temporary password
July 25, 2017 07:58AM

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.