grant all on theme.* to 'root'@'192.168.1.21 identified by '123456';
grant select,update,insert,delete on theme.* to 'root'@'192.168.1.21 identified by '123456';
flush privileges;
phpmyadmin 暴力连接
----------------------------------------------
phpmyadmin下的config.inc.php配置改为:
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'dfdfdgs';