mysql 1045 using password_mysql ERROR 1045 (28000): (using password: YES)问题解决

限制ip连接范围了，只限制本地连接了,增加用户匹配所有ip连接

查看用户：

mysql> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;

+--------------------------------------+

| query |

+--------------------------------------+

| User: 'em'@'%'; |

| User: 'emadmin'@'%'; |

| User: 'root'@'%'; |

| User: 'feelsme'@'localhost'; |

| User: 'hotpopdigital'@'127.0.0.1'; |

| User: 'hotpopdigitalCN'@'127.0.0.1'; |

| User: 'im'@'127.0.0.1'; |

| User: 'mobitrackspro'@'127.0.0.1'; |

| User: 'womanway'@'127.0.0.1'; |

| User: 'wordpress'@'127.0.0.1'; |

| User: 'root'@'::1'; |

| User: 'cleverpanda'@'localhost'; |

| User: 'em'@'localhost'; |

| User: 'entermedia'@'localhost'; |

| User: 'gototravel'@'localhost'; |

| User: 'hotpopdigital'@'localhost'; |

| User: 'hotpopdigitalCN'@'localhost'; |

| User: 'im'@'localhost'; |

| User: 'joe'@'localhost'; |

| User: 'joeliang'@'localhost'; |

| User: 'mobitrackspro'@'localhost'; |

| User: 'root'@'localhost'; |

| User: 'toptopcoupon'@'localhost'; |

| User: 'womanway'@'localhost'; |

| User: 'wordpress'@'localhost'; |

| User: 'xclick'@'localhost'; |

+--------------------------------------+

增加用户

执行sql:

CREATE USER 'feelsme'@'%' IDENTIFIED BY 'yourpassword';

grant all privileges on *.* to 'feelsme'@'%' with grant option;

flush privileges;

再查看用户:

mysql> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;

+--------------------------------------+

| query |

+--------------------------------------+

| User: 'em'@'%'; |

| User: 'emadmin'@'%'; |

| User: 'feelsme'@'%'; |

| User: 'root'@'%'; |

| User: 'feelsme'@'localhost'; |

| User: 'hotpopdigital'@'127.0.0.1'; |

| User: 'hotpopdigitalCN'@'127.0.0.1'; |

| User: 'im'@'127.0.0.1'; |

| User: 'mobitrackspro'@'127.0.0.1'; |

| User: 'womanway'@'127.0.0.1'; |

| User: 'wordpress'@'127.0.0.1'; |

| User: 'root'@'::1'; |

| User: 'cleverpanda'@'localhost'; |

| User: 'em'@'localhost'; |

| User: 'entermedia'@'localhost'; |

| User: 'gototravel'@'localhost'; |

| User: 'hotpopdigital'@'localhost'; |

| User: 'hotpopdigitalCN'@'localhost'; |

| User: 'im'@'localhost'; |

| User: 'joe'@'localhost'; |

| User: 'joeliang'@'localhost'; |

| User: 'mobitrackspro'@'localhost'; |

| User: 'root'@'localhost'; |

| User: 'toptopcoupon'@'localhost'; |

| User: 'womanway'@'localhost'; |

| User: 'wordpress'@'localhost'; |

| User: 'xclick'@'localhost'; |

+--------------------------------------+

发现有

User: 'feelsme'@'%'; 表明添加成功