Ubuntu – MySql – unable to connect as root

MySQL

I have need to connect to mySql server 5.5 and create database using command line. Ideally it would be using a UI utility but I don't have it. Here is an issue:

alex@ubuntu:~$ sudo mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

However I definitely set password while I was installing MySql server.

What should I do to solve it?

Best Answer

Connect with sudo mysql -u root -p and it will prompt you for the password. The key here is the -p option. You can also provide the password as part of the command with the -p option, but that is considered a security risk, since the password will be stored in clear text in your commands history.

Related Solutions

Ubuntu – MySQL Access denied for user ‘root’@’localhost’

If you're running n localhost, just type the command below in terminal:

mysql -u root -p

If you're using an external server, enter the host IP (xxx.xxx.xxx.xxx) as well:

mysql -hxxx.xxx.xxx.xxx -uroot -p

You will be prompted for your password, enter it and you will be able to access your MySQL prompt.

You can also look at this answer on how to reset your MySQL password.

Ubuntu – ERROR 1698 (28000): Access denied for user ‘root’@’localhost’ at Ubuntu 18.04

I found a solution at here link, by following this solution I have solved my problem.

Short steps are:

sudo mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test';

Note: here test is a new password for the root user. Also, remember to run the command sudo service mysql restart after altering the user.

Best Answer

Related Solutions

Ubuntu – MySQL Access denied for user ‘root’@’localhost’

Ubuntu – ERROR 1698 (28000): Access denied for user ‘root’@’localhost’ at Ubuntu 18.04

Related Question