Create mysql user

Mysql add user with all privileges

# First Login mysql shell..
sudo mysql -u root -p 
CREATE USER 'username'@'localhost' IDENTIFIED BY 'P4ssW0rd';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';
FLUSH PRIVILEGES;

Create mysql user

CREATE USER 'newuser'@'%' IDENTIFIED BY 'user_password';
GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'%';
SHOW GRANTS FOR 'newuser'@'%';
FLUSH PRIVILEGES;

Similar codes

3 votes245 views2 answers
Brew restart mysql
SQL
0 vote194 views1 answer
Mysql join column order By and group By
SQL
21 votes190 views6 answers
Docker run mysql
SQL
4 votes201 views2 answers
Float postgres
SQL
4 votes199 views2 answers
Mysql delete user if exists
SQL
0 vote188 views1 answer
Order by with where clause in mysql
SQL
5 votes233 views3 answers
Sql server utc to local
SQL
0 vote176 views1 answer
Find usage of table in sql server
SQL
5 votes209 views1 answer
Oracle asynchronous query
SQL
1 vote251 views1 answer
Top 10 rows in mysql
SQL