Question

3

MySql - unable to connect as root

rated 0 times [ 3] [ 0] / answers: 1 / hits: 2316 / 3 Years ago, wed, october 6, 2021, 1:23:45

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?

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

terose

Add To Favorites

Follow

Total Points: 185

Total Questions: 125

Total Answers: 131

Location: Venezuela

Member since Mon, Dec 13, 2021

2 Years ago

terose questions

1 VBoxClient: error while loading shared libraries: libXt.so.6:

Thu, Aug 26, 21, 05:47, 3 Years ago

1 How to turn off light on Logitech G502 mouse?

Sun, Jan 9, 22, 17:24, 2 Years ago

1 File permission numerical value of "rws"

Thu, Feb 10, 22, 17:13, 2 Years ago

1 How do I install and configure the latest version of `solaar` to manage my Logitech wireless mouse or keyboard on Linux Ubuntu?

Mon, Nov 7, 22, 03:34, 2 Years ago

1 No sound (After I removed Pulseaudio)

Sun, Jul 25, 21, 22:51, 3 Years ago

View All

answered 3 Years ago musining · Accepted 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.