robmiller Posted August 12, 2003 Share Posted August 12, 2003 I\'ve installed MySQL 4.0.14 on Windows XP. I\'m running the Xitami webserver with PHP installed. However, there\'s a problem. Whenever I try to connect to the database, with PHPMyAdmin or with a database manager, or through a PHP script, it gives me this error: #1045 - Access denied for user: \'rob@localhost\' (Using password: YES) Any ideas guys? It\'s probably a noob mistake, but I\'m new to MySQL. Thanks everyone, Rob Quote Link to comment Share on other sites More sharing options...
robmiller Posted August 13, 2003 Author Share Posted August 13, 2003 bump still no luck, any ideas? Quote Link to comment Share on other sites More sharing options...
effigy Posted August 13, 2003 Share Posted August 13, 2003 either your password is incorrect, or that user does not have permissions to access the specified database. for the former, check your spelling and case; for the latter, login into the command interface via root and run a grant statement. Quote Link to comment Share on other sites More sharing options...
robmiller Posted August 13, 2003 Author Share Posted August 13, 2003 I\'ve checked many times and my password is correct. I tried logging in as root, and it still doesn\'t work. :erk: Quote Link to comment Share on other sites More sharing options...
effigy Posted August 13, 2003 Share Posted August 13, 2003 have you tried via the web or the command line? are you absolutley sure what your root password is? you may want to get the instructions from mysql.com of how to reset it to be sure. try using a blank password -- i believe that is the default. the only other thing i can think of is file permissions, however i am not sure how these are handled in windows. Quote Link to comment Share on other sites More sharing options...
sandeep Posted August 14, 2003 Share Posted August 14, 2003 I tried to set the MySQL privilieges but when i type mysql_install_db in c:mysqlscripts it can\'t be executed and said its not a executable command inside the Command Prompt I am using Windows XP Professional please help Thank you Quote Link to comment Share on other sites More sharing options...
im1hunt Posted August 14, 2003 Share Posted August 14, 2003 Hi rob, when you are connecting, are you using an IP address or are you using localhost, when you are running it locally localhost works best. Just thought Id mention that cos when I set up phpmyadmin I had that same error message you are getting, then I changed the IP address to localhost and it went away. Just a thought Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.