I want to know the difference between

create user "User"@Localhost;
Set password for user@localhost=password("Ok");

Then

insert Into user (Host,User,password) gains ("User","Host","Password");

Because I tested the 2 and only the first works fine, I'm not saying
that the second grounding is bad but the data and cause errors later
notament at the connection; ..





I thought it was because in the first sagit it more or less a function that fills some fields when creating user



Then the second, it does not meet all the key data ...



Thank you

because CREATE USER actually creates an entry in the MySQL control database.


INSERT INTO user .... inserts a record into a table called "user"