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 vote216 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote212 views1 answer
Sql mod even odd
SQL
4 votes306 views6 answers
Laravel jwt
SQL
0 vote233 views2 answers
Sql update multiple tables
SQL
0 vote241 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote230 views1 answer
Pl/pgsql declare variable
SQL
1 vote216 views1 answer
Postgres cast as currency format
SQL
0 vote318 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
4 votes203 views3 answers
How to describe a table in sqlite3
SQL
3 votes200 views5 answers
Sql select
SQL