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 vote108 views1 answer
Generate sequence number in sql server
SQL
0 vote131 views2 answers
Clauses in mysql
SQL
0 vote110 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
14 votes113 views2 answers
Oracle export trigger ddl
SQL
8 votes94 views1 answer
Unique vs primary key
SQL
0 vote100 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote116 views2 answers
Sql regex vowel
SQL
0 vote143 views1 answer
Sql multiple into
SQL
0 vote66 views1 answer
Flask_sqlalchemy install
SQL
8 votes109 views1 answer
Sql remove leading spaces
SQL