/SQL/Mysql grant all privileges on *.* to 'root'@' ' identified by

Mysql grant all privileges on . to 'root'@' ' identified by

Mysql grant all privileges on . to 'root'@' ' identified by

mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'PASSWORD';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

1

Source: stackoverflow.com

Mysql>grant all privileges on . to root@localhost identified by 'password' with grant option;

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

0

Source: stackoverflow.com

Similar codes

0 vote148 views1 answer
Oracle execute package dblink
SQL
18 votes102 views2 answers
How to get all the tables displayed in oracle
SQL
32 votes145 views6 answers
How to change column name in sql
SQL
0 vote130 views1 answer
Mysql autoincrement valor inicial
SQL
50 votes198 views6 answers
Sql duplicate rows
SQL
5 votes159 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
0 vote134 views1 answer
Opensuse status MySQL
SQL
0 vote143 views1 answer
Mysql root permission denied lost
SQL
0 vote132 views4 answers
First max salary in sql
SQL
0 vote150 views1 answer
Test database for sql
SQL

Share