in Software by (10.1k points)
0 like 0 dislike
40 views

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

1 Answer

0 like 0 dislike
by (10.1k 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.