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

-1 vote229 views1 answer
Difference berween database and data base management system
SQL
0 vote168 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote178 views1 answer
Sql sum if
SQL
-1 vote192 views2 answers
Sql query examples
SQL
1 vote192 views4 answers
Get week day from date in sql
SQL
4 votes238 views3 answers
Postgres drop all tables
SQL
1 vote201 views2 answers
Mysql extract number from string
SQL
8 votes188 views3 answers
SQL column name
SQL
1 vote176 views1 answer
Drop function
SQL
2 votes183 views1 answer
Select * from table where name like
SQL