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

20 votes150 views4 answers
How to find average in sql
SQL
12 votes108 views4 answers
Mysql get date difference in hours
SQL
1 vote114 views1 answer
Oracle sql listagg
SQL
3 votes125 views1 answer
Oracle detect invalid password
SQL
1 vote129 views1 answer
T-sql disable system versioning
SQL
3 votes115 views2 answers
Search text in all sql server stored procedure
SQL
28 votes110 views4 answers
Show tables mysql
SQL
6 votes143 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
11 votes120 views2 answers
Sql rank
SQL
3 votes188 views1 answer
Ssh check mysql version
SQL