Possible Solution: MySQL Error Number 1045 Access denied
I am brand new to MySQL and I don't do much work with databases in general, but I found a solution that worked to allow me to remotely access a DB on development testing server as root from the MySQL GUI tools.
I made the mistake of changing my database's root password. Fine. I'll use a password.
Note that I am also allowing everyone on my subnet to login as root using the password.
mysql> grant all on *.* to root@'192.168.168.%' IDENTIFIED BY "rootpassword";
Subject
Written By
Posted
December 29, 2004 08:39PM
December 22, 2009 04:23AM
February 07, 2005 10:11AM
September 06, 2007 11:06PM
September 30, 2007 02:35PM
February 28, 2007 11:03AM
September 23, 2006 05:45PM
November 07, 2007 11:41PM
February 07, 2006 06:09AM
February 28, 2007 11:05AM
November 30, 2008 11:32PM
February 10, 2009 10:49AM
November 03, 2009 07:36AM
September 16, 2005 04:54PM
December 31, 2006 03:51PM
February 10, 2007 08:02AM
November 13, 2005 11:05AM
December 23, 2005 06:15PM
February 16, 2006 09:07PM
February 28, 2007 11:27AM
February 20, 2008 06:17AM
September 20, 2007 07:50AM
November 11, 2005 01:19PM
December 13, 2005 02:42PM
December 15, 2005 12:56AM
February 17, 2007 11:07AM
September 03, 2007 02:40PM
September 07, 2007 10:42AM
Possible Solution: MySQL Error Number 1045 Access denied
March 28, 2008 08:45AM
February 13, 2009 04:29PM
September 11, 2009 08:24AM
September 19, 2009 08:54AM
December 16, 2009 03:44AM
December 22, 2009 04:21AM
December 22, 2009 01:49PM