Fix MySQL Error on Ubuntu

Lanalen — Thu, 14 Jan 2021 15:03:35 +0000

I installed mysql on ubuntu and tried to access mysql.

mysql -u root -p

But I got the following error.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

So I restarted mysql.

Sudo service mysql restart

Then I tried to access mysql again, but faced with a new error.

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

By googling, I read that this error appears because of the type of the password.
So I changed it.
Firstly, I got into mysql with sudo commend.

Sudo mysql -u root

Then I checked the type of the password.

SELECT User, plugin FROM mysql.user;

The password type of user 'root' was 'auth_socket'.
I changed this to 'mysql_native_password'.

UPDATE mysql.user SET plugin='mysql_native_password' WHERE User='root';

flush privileges;

And then I tried to access mysql.

mysql -u root -p

It worked well.

What I learnt today: Function

Lanalen — Mon, 19 Oct 2020 16:00:01 +0000

function myFunction() {
    console.log("hi");
}

const a = function() {console.log("hi")};

const a = new Function("x", "y", "return x + y");

also possible without new keyword

const a = Fuction("x", "y", "return x + y");

What is it? To call a function before declaring it.

myFunction();

function myFunction() {
    console.log("hi");
}

function myFunction(name) {
     console.log("Hi", name);
}

myFunction("Lena");

name is a parameter.
"Lena" is an argument.

What is meant by "self-invoking"? You don't need to call the function.
How to use? Put a function inside parentheses.

(function () {
     console.log("hi");
})();