[Warning] IP address '10.127.xxxx' could not be resolved: Temporary failure in name resolution [Warning] IP address '10.127.xxxx' could not be resolved: Temporary failure in name resolutio
> show grants for webadmin@'10.127.xxx.xxx'; +---------------------------------------------------+ | Grants for webadmin@10.127.xxx.xxx| +---------------------------------------------------+ | GRANT USAGE ON *.* TO 'webadmin'@'10.127.xxx.xxx' | +---------------------------------------------------+ 1 row in set (0.00 sec)而后面的就是訪問權(quán)限了，比如開發(fā)同學(xué)不知道哪個(gè)權(quán)限合適，說你給我所有的權(quán)限吧，于是DBA說好，就寫下了*.*,然后問題就來了。
> GRANT ALL PRIVILEGES ON *.* TO 'webadmin'@'10.127.xxx.xxx';使用show grants查看權(quán)限，發(fā)現(xiàn)原來的usage權(quán)限竟然沒了。
> show grants for webadmin@'10.127.xxx.xxx'; +------------------------------------------------------------+ | Grants for webadmin@10.127.xxx.xxx| +------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'webadmin'@'10.127.xxx.xxx' | +------------------------------------------------------------+
{main} Attempted reconnect 3 times. Giving up. {main} at com.mysql.jdbc.Connection.createNewIO(Connection.java:2781) {main} at com.mysql.jdbc.Connection.(Connection.java:1485) {main} at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) {main} at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
