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 vote236 views1 answer
Sql oracle update multiple rows
SQL
1 vote189 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote276 views1 answer
Sqlite woth cmake
SQL
0 vote166 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote193 views1 answer
View to table sql
SQL
3 votes182 views1 answer
Postgres add not null to existing column
SQL
0 vote157 views1 answer
Faire une recherche par liste de mot clé sql
SQL
4 votes173 views3 answers
Postgres set default value
SQL
2 votes197 views3 answers
Application.properties spring boot mysql
SQL
3 votes170 views2 answers
Oracle sql drop sequence
SQL