Brtdku

I was able to solve this problem by executing this statement

sudo dpkg-reconfigure mysql-server-5.5

Which will change the root password.

You have to reset the password! steps for mac osx(tested and working) and ubuntu

Stop MySQL using

sudo service mysql stop

or

$ sudo /usr/local/mysql/support-files/mysql.server stop

Start it in safe mode:

$ sudo mysqld_safe --skip-grant-tables --skip-networking

(above line is the whole command)

This will be an ongoing command until the process is finished so open another shell/terminal window, log in without a password:

$ mysql -u root



mysql> UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';

As per @IberoMedia's comment, for newer versions of MySQL, the field is called authentication_string:

mysql> UPDATE mysql.user SET authentication_string =PASSWORD('password') WHERE User='root';

Start MySQL using:

sudo service mysql start

or

sudo /usr/local/mysql/support-files/mysql.server start

your new password is 'password'.

if the problem still exists try to force changing the pass

/etc/init.d/mysql stop



mysqld_safe --skip-grant-tables &



mysql -u root

Setup new MySQL root user password

use mysql;

update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';

flush privileges;

quit;

Stop MySQL Server:

/etc/init.d/mysql stop

Start MySQL server and test it:

mysql -u root -p

At the initial start up of the server the following happens, given that the data directory of the server is empty:

• The server is initialized.


• SSL certificate and key files are generated in the data directory.


• The validate_password plugin is installed and enabled.


• The superuser account 'root'@'localhost' is created. The password for the superuser is set and stored in the error log file.

To reveal it, use the following command:

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

Change the root password as soon as possible by logging in with the generated temporary password and set a custom password for the superuser account:

shell> mysql -uroot -p 



mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass5!'; 

I know this an old Question but i feel this might help someone. I was recently faced with the same problem but in my case, i remember my password quite alright but it kept on giving me the same error. I tried so many solutions but still none helped then i tried this

mysql -u root -p 

after which it asks you for a pass word like this

Enter password: 

and then i typed in the password i used. That's all

It happens when your password is missing.

Steps to change password when you have forgotten:

1. 
   

   Stop MySQL Server (on Linux):

   
   
   

   sudo systemctl stop mysql
   
   

   
   


2. 
   

   Start the database without loading the grant tables or enabling networking:

   
   
   

   sudo mysqld_safe --skip-grant-tables --skip-networking &
   
   

   
   
   

   The ampersand at the end of this command will make this process run in the
   
   background so you can continue to use your terminal and run #mysql -u root, it will not ask for password.

   
   
   

   If you get error like as below:

   
   
   

   2018-02-12T08:57:39.826071Z mysqld_safe Directory '/var/run/mysqld' for UNIX
   
   socket file don't exists.
   mysql -u root
   ERROR 2002 (HY000): Can't connect to local MySQL server through socket
   
   '/var/run/mysqld/mysqld.sock' (2)
   [1]+ Exit 1

   
   


3. 
   

   Make MySQL service directory.

   
   
   

   sudo mkdir /var/run/mysqld
   
   

   
   
   

   Give MySQL user permission to write to the service directory.

   
   
   

   sudo chown mysql: /var/run/mysqld
   
   

   
   



4. Run the same command in step 2 to run mysql in background.



5. 
   

   Run mysql -u root you will get mysql console without entering password.

   
   
   

   Run these commands

   
   
   

   FLUSH PRIVILEGES;
   
   

   
   
   

   For MySQL 5.7.6 and newer

   
   
   

   ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
   
   

   
   
   

   For MySQL 5.7.5 and older

   
   
   

   SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');
   
   

   
   
   

   If the ALTER USER command doesn't work use:

   
   
   

   UPDATE mysql.user SET authentication_string = PASSWORD('new_password')     WHERE User = 'root' AND Host = 'localhost';
   
   

   
   

Now exit

6. 
   

   To stop instance started manually

   
   
   

   sudo kill `cat /var/run/mysqld/mysqld.pid`
   
   

   
   


7. 
   

   Restart mysql

   
   
   

   sudo systemctl start mysql
   
   

   
   

Am using Ubuntu-16.04 : installed mysql - 5.7.
I Had the same issue : Login denied for root user.

Tried the below steps:

1. dpkg --get-selections | grep mysql (to get the version of mysql).




2. dpkg-reconfigure mysql-server-5.7




3. mysql -u root -p

Without -p that doesn't prompt you to ask password. Once you are in, you can create a user with a password by following steps :

CREATE USER 'your_new_username'@'your-hostname' IDENTIFIED BY 'your-password';



GRANT ALL PRIVILEGES ON *.* to 'your_new_username'@'your-hostname' WITH GRANT OPTION;

Exit from the root and login from the you gave above.

mysql -u <your_new_username> -p

For some reason still just typing mysql does not work. AT ALL. I suggest to make it a habit to use mysql -u <name> -p.

I came across this very annoying problem and found many answers that did not work. The best solution I came across was to completely uninstall mysql and re-install it. On re-install you set a root password and this fixed the problem.

sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-core-5.5 mysql-client-core-5.5

sudo rm -rf /etc/mysql /var/lib/mysql

sudo apt-get autoremove

sudo apt-get autoclean

I found this code elsewhere so I take no credit for it. But it works.
To install mysql after uninstalling it I think digital ocean has a good tutorial on it. Checkout my gist for this.

https://gist.github.com/JamesDaniel/c02ef210c17c1dec82fc973cac484096

Please read the official documentation: Mysql: How to Reset the Root Password

If you have access to terminal:

MySQL 5.7.6 and later:

$ mysql

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

MySQL 5.7.5 and earlier:

$ mysql

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');

I am using mysql-5.7.12-osx10.11-x86_64.dmg in Mac OSX

The installation process automatically sets up a temporary password for root user. You should save the password. The password can not be recovered.

Follow the instruction

1. Go to cd /usr/local/mysql/bin/
   


2. Enter the temporary password (which would look something like, "tsO07JF1=>3")


3. You should get mysql> prompt.


4. Run, SET PASSWORD FOR 'root'@'localhost' = PASSWORD('{YOUR_PASSWORD}'); If you wish to set your password: "root" then the command would be, SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root');
   


5. Run ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
   


6. Run exit
   


7. Run ./mysql -u root -p
   


8. Type your password. In my case I would type, "root" (without quote)


9. That's all.

For convenience, you should add "/usr/local/mysql/bin" to your PATH

Now from anywhere you can type ./mysql -u root -p and then type the password and you will get mysql> prompt.

Hope it helps.

The answer may sound silly, but after wasting hours of time, this is how I got it to work

mysql -u root -p

I got the error message

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Even though I was typing the correct password(the temporary password you get when you first install mysql)

I got it right when I typed in the password when the password prompt was blinking

if the problem still exists try to force changing the pass

Stop MySQL Server (on Linux):

/etc/init.d/mysql stop

Stop MySQL Server (on Mac OS X):

mysql.server stop

Start mysqld_safe daemon with --skip-grant-tables

mysqld_safe --skip-grant-tables &

mysql -u root

Setup new MySQL root user password

use mysql;

update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';

flush privileges;

quit;

Stop MySQL Server (on Linux):

/etc/init.d/mysql stop

Stop MySQL Server (on Mac OS X):

mysql.server stop

Start MySQL server service and test to login by root:

mysql -u root -p

Just one line and it solved my issue.

sudo dpkg-reconfigure mysql-server-5.5

In Ubuntu 16.04 (MySQL version 5.7.13) I was able to resolve the problem with the steps below:

1. Follow the instructions from the in section B.5.3.2.2 Resetting the Root Password: Unix and Unix-Like Systems
   MySQL 5.7 reference manual



2. 
   

   When I tried #sudo mysqld_safe --init-file=/home/me/mysql-init & it failed. The error was in /var/log/mysql/error.log

   
   
   

   2016-08-10T11:41:20.421946Z 0 [Note] Execution of init_file '/home/me/mysql/mysql-init' started.
   2016-08-10T11:41:20.422070Z 0 [ERROR] /usr/sbin/mysqld: File '/home/me/mysql/mysql-init' not found (Errcode: 13 - Permission denied)
   2016-08-10T11:41:20.422096Z 0 [ERROR] Aborting

   
   

The file permission of mysql-init was not the problem, need to edit apparmor permission

3. 
   

   Edit by #sudo vi /etc/apparmor.d/usr.sbin.mysqld

   
   
   

   ....
   
     /var/log/mysql/ r,
   
     /var/log/mysql/** rw,
   
   
   
   
   
   # Allow user init file
   
     /home/pranab/mysql/* r,
   
   
   
     # Site-specific additions and overrides. See local/README for details.
   
     #include <local/usr.sbin.mysqld>
   
   }
   
   

   
   



4. Do #sudo /etc/init.d/apparmor reload




5. Start mysqld_safe again try step 2 above. Check /var/log/mysql/error.log make sure there is no error and the mysqld is successfully started



6. 
   

   Run #mysql -u root -p

   
   
   

   Enter password:

   
   

Enter the password that you specified in mysql-init. You should be able to log in as root now.

7. Shutdown mysqld_safe by #sudo mysqladmin -u root -p shutdown




8. Start mysqld normal way by #sudo systemctl start mysql

BY default password will be null, so you have to change password by doing below steps.

connect to mysql

root# mysql

Use mysql

mysql> update user set password=PASSWORD('root') where User='root';
Finally, reload the privileges:

mysql> flush privileges;
mysql> quit

In recent MySQL versions there is no password in mysql.user table.

So you need to execute ALTER USER. Put this one line command into the file.

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

And execute it as init file (as root or mysql user)

mysqld_safe --init-file=/home/me/mysql-init &

MySQL server need to be stopped to start mysqld_safe.

Also, there may be a problem with apparmor permissions to load this init file. Read more here
https://blogs.oracle.com/jsmyth/entry/apparmor_and_mysql

If you haven't set password yet, then run mysql -uroot, it works for me.

On Mac, If you have a problem in logging in with the first password you were given in installation, maybe you can just simply kill the mysql process and then try.

So:
1- run the following command to find the PID of mysql:

ps -aef | grep mysql | grep -v grep

2- kill the process:

kill -15 [process id] 

Then you can login with the initial password using this command:

mysql -uroot -p

Which ask you to enter your password. Just enter the initial password.