mysql> delete from mysql.user where user='';
Query OK, 2 rows affected (0.01 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypasswd' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
您可能感兴趣的文章:
mysql 5.6.17 绿色版(免安装)安装配置教程win2008 R2 WEB环境配置之MYSQL 5.6.22安装版安装配置方法MySQL绿色版(zip解压版)的安装图文教程(mysql-5.6.22-win32.zip)RHEL6.5编译安装MySQL5.6.26教程MySQL 5.6.13 解压版(zip版)安装配置方法分享CentOS下MySQL最新版本5.6.13源码安装过程Linux下安装mysql-5.6.4 的图文教程Windows版Mysql5.6.11的安装与配置教程mysql 5.7.13 winx64安装配置方法图文教程Centos6.5 编译安装mysql 5.6.16 详细教程