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 vote316 views1 answer
Sql group by sum with condition
SQL
1 vote309 views1 answer
Mariadb alter user host
SQL
2 votes326 views2 answers
Sql query to list all tables in a database sql server
SQL
2 votes312 views1 answer
Update with join sql server
SQL
0 vote328 views1 answer
Nvl2 syntax
SQL
1 vote326 views1 answer
Pl sql create table from another table
SQL
4 votes349 views1 answer
Mysql delete last row
SQL
1 vote347 views1 answer
Db.Database.SqlQuery
SQL
0 vote300 views1 answer
Postgresql if else endif
SQL
0 vote294 views1 answer
Date diff sql
SQL