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

0 vote136 views1 answer
Sql cross apply vs join
SQL
1 vote150 views3 answers
What is union in sql
SQL
2 votes163 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote188 views1 answer
Prisma transaction
SQL
0 vote122 views1 answer
Java spring boot connect to sql server
SQL
1 vote154 views2 answers
Datetrunc hour snowflake
SQL
1 vote157 views1 answer
Sql dcl
SQL
0 vote145 views2 answers
Sql last updated
SQL
3 votes147 views1 answer
Créer une table sql
SQL
0 vote164 views4 answers
Open mysql port bitnami tomact
SQL