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 vote143 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
1 vote140 views1 answer
Altering the column name in MySQL to have a default value
SQL
8 votes134 views2 answers
Replace string value in sql
SQL
0 vote141 views1 answer
Sqlplus change user
SQL
17 votes143 views4 answers
Postgres list users
SQL
1 vote202 views1 answer
Column with prefix in sql
SQL
0 vote98 views1 answer
Select all domains of database firbird
SQL
1 vote137 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
2 votes165 views1 answer
Python sql
SQL
2 votes95 views1 answer
Sql float to int
SQL