mysql授权
mysql无密码授权
1 mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; 2 ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement 3 mysql> flush privileges; 4 Query OK, 0 rows affected (0.11 sec) 5 6 mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; 7 Query OK, 0 rows affected, 1 warning (0.02 sec) 8 9 mysql> flush privileges; 10 Query OK, 0 rows affected (0.00 sec)
