asked in Software by (8.9k points)
0 like 0 dislike
36 views

How I can to create user and give him all privileges via MySQL console client MySQL monitor?

1 Answer

0 like 0 dislike
answered by (8.9k points)

Console:

mysql -u root -p

SQL queries:

CREATE USER 'username'@'host' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'host' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Your answer

Try to answer the question as detailed as possible.
Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.

Related questions

0 like 0 dislike
1 answer 42 views
0 like 0 dislike
1 answer 31 views
0 like 0 dislike
1 answer 32 views
0 like 0 dislike
1 answer 44 views
0 like 0 dislike
1 answer 42 views
0 like 0 dislike
1 answer 32 views
0 like 0 dislike
1 answer 20 views
0 like 0 dislike
1 answer 22 views
...