Access Denied to user root localhost while using mysql

Question

Hi, I am new t linux and this the first time for me working with mysql. So I've been following this tutorial to set up mySQL on my machine. These are the following commands I've used so far:

sudo apt-get update
sudo apt-get install mysql-server-5.5
sudo apt-get install mysql-client-5.5
sudo apt-get install mysql-common
sudo apt-get install glade
sudo apt-get install ntp

After this, when I try and run this:

me@ubuntu:~/Desktop/iPDC-v1.3.1/DBServer-1.1$ mysql -uroot -proot <"Db.sql"

I get this error.

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

What am I doing wrong here?

Answer 1

For MySQL versions < 5.7:

the default root password should be nothing so just tap enter after:

mysql -u root

You should obviously change your root password after installation

To set a new password do:

mysqladmin -u root password [newpassword]

This should be enough to set you up for the DB Operations

For versions that came after 5.7:

So when you initialize the server, 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.

This generates a temporary password. Use this command to show:

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

Now change the root password, Use:

shell> mysql -uroot -p 

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