How to login to mysql server in Fedora 23/24

Hi All;


Today i will show how to login to mysql server in Fedora 23 or 24 as after installing of the mysql-community-server in Fedora 23/24 you will get following error .


[anuj@anuj ~]$ mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

 



Solution of the problem:


Run the following command .

grep 'A temporary password is generated for root@localhost' /var/log/mysqld.log |tail -1

You will the password like bellow .

[root@anu]# grep 'A temporary password is generated for root@localhost' /var/log/mysqld.log |tail -1
 
2016-06-15T17:00:24.787059Z 1 [Note] A temporary password is generated for root@localhost: VTWK#Ee/5tKK
 

 


Use the password to login . And issue resolve .