How to get access to Mysql in Ubuntu?

Question

I installed Mysql server following the guide.

In terminal: mysql -u root

and receiving error:

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

What I am doing wrong?

Additionally, I cannot sudo apt install mysql-workbench (it is not found in repository)

Mathlight · Accepted Answer · 2019-12-29T15:14:09.327

1

Try sudo mysql -u root -p.

I believe it's some kind of security feature or something like that (not entirely sure). But with su/sudo rights, you can connect to the socket. The -p option will ask for password input

Added after a comment about symbols in the password:

My assumption is that the encoding of these characters isn't correct (ASCII connection, and non-ASCII charaters). Try connection with the following command, as stated in this SO answer by Martin Taleski

sudo mysql --default-character-set=utf8 -u root -p

You can set this as a default in the /etc/mysql/my.cnf file.

[mysql]
default-character-set=utf8

edited Dec 29 '19 at 15:14

answered Dec 29 '19 at 12:46

Mathlight

6,436
17
62
107

same: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) – andrew17 Dec 29 '19 at 12:47
Did you setup a password during the setup? If thadd (I believe) – Mathlight Dec 29 '19 at 12:48
thanks much, it works now. BUT, why so hard? I have to do that every time?... – andrew17 Dec 29 '19 at 15:07
and what could you say about installing workbench?:) – andrew17 Dec 29 '19 at 15:07
@andrew17, you can change it in the my.cnf file, so that you don't have to define it every time. – Mathlight Dec 29 '19 at 15:15
@andrew17 did you do a `sudo apt update` before trying to install the package? Which ubuntu version are you on? – Mathlight Dec 29 '19 at 15:19
@andrew17, it seems like you have to manually download the file, and then install it. See [this answer](https://stackoverflow.com/a/57553970) for more details – Mathlight Dec 29 '19 at 16:09

How to get access to Mysql in Ubuntu?

1 Answers1