To Solve this error, you have to update the
mysql.user table.
GRANT ALL PRIVILEGES ON [dbname].* to ‘[user]‘@’[hostname]‘
identified by ‘[password]‘
Check whether it updated the privileges.
mysql> select Host, User, Password from
user;
host is not allowed to connect to this MySQL Server
Jul 20th, 2007 by L J Arthur Neil
Posted in MySQL | Leave a Comment
Leave a Reply Cancel reply
-
Recent Posts
Categories
- Amazed at…. (3)
- C,FastCGI (2)
- Designer Tips (26)
- Found it useful (6)
- Fun-and-morals (79)
- installations (15)
- Java (14)
- Javascript (4)
- JBOSS (1)
- Lessons I have learnt (19)
- Misc (1)
- Most Expected (1)
- MySQL (14)
- Networking (1)
- Oracle – XE (1)
- Photos (1)
- Rails – Mac Leopard (9)
- Rails deployment–FCGI (1)
- Rails deployment–SCGI (1)
- Ruby on Rails (73)
- Scriptures (12)
- Struts 2 (2)
- Trips (1)
- Unix (3)
- Videos (26)
- Web apps (2)
- Weird Errors (34)
Recent Comments
- Peggy on [FB App] Facebook developer issues – solutions
- Ruby – Usage of SELF in modules and libraries | NeilSys on Difference between include and extend in Ruby
- LJ Arthur Neil on `require_frameworks’: no such file to load — openssl (RuntimeError) [Ruby on Rails]
- alifazman on `require_frameworks’: no such file to load — openssl (RuntimeError) [Ruby on Rails]
- Shravan on launchctl: CFURLWriteDataAndPropertiesToResource(/System/Library/LaunchDaemons/org.apache.httpd.plist) failed: -10
Archives
- February 2012 (1)
- January 2012 (7)
- December 2011 (3)
- November 2011 (11)
- October 2011 (9)
- September 2011 (22)
- August 2011 (1)
- March 2010 (1)
- February 2010 (3)
- October 2009 (2)
- September 2009 (3)
- August 2009 (6)
- July 2009 (8)
- June 2009 (3)
- May 2009 (1)
- April 2009 (9)
- March 2009 (3)
- February 2009 (5)
- January 2009 (9)
- December 2008 (10)
- November 2008 (15)
- October 2008 (5)
- September 2008 (20)
- August 2008 (13)
- July 2008 (20)
- June 2008 (12)
- May 2008 (2)
- April 2008 (2)
- March 2008 (2)
- February 2008 (1)
- January 2008 (2)
- December 2007 (9)
- November 2007 (8)
- October 2007 (6)
- September 2007 (3)
- August 2007 (3)
- July 2007 (13)
- June 2007 (8)
- May 2007 (6)
Tags