[SOLVED] mysqsl installation problem

zillur · 09-13-2016, 05:34 PM

Thank you very much. Yeah. I used the same password. But if I use a wrong password the error message remains same.

keefaz · 09-13-2016, 05:37 PM

Just for curiosity, is there any output with:

Code:

sudo grep 'temporary password' /var/log/mysqld.log

You could change the password at this step with mysql_secure_installation
(just enter y, then type password)

Code:

You already have a root password set, so you can safely answer 'n'.

Change the root password? [Y/n] y

zillur · 09-13-2016, 05:38 PM

Thank you very much.

Code:

[zillur@genomics bin]$ sudo grep 'temporary password' /var/log/mysqld.log
sudo: /var/db/sudo writable by non-owner (040777), should be mode 0700

We trust you have received the usual lecture from the local System
Administrator. It usually boils down to these three things:

    #1) Respect the privacy of others.
    #2) Think before you type.
    #3) With great power comes great responsibility.

[sudo] password for zillur: 
2016-08-31T23:18:24.748067Z 1 [Note] A temporary password is generated for root@localhost: Iol<eEmb1?<%

keefaz · 09-13-2016, 05:44 PM

You can try change the password with mysqladmin

Code:

sudo mysqladmin -u root -p'Iol<eEmb1?<%' password <your password here>

edit: upsss I didn't see the log date, I don't think it will work

zillur · 09-13-2016, 05:48 PM

Thank you very much. It works now.

Code:

[zillur@genomics bin]$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 16
Server version: 5.7.15-log MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Thanks again all of you for helping me from the beginning.

Best Regards
Zillur

keefaz · 09-13-2016, 05:50 PM

Nice, how did you change the password?