Jump to content


Photo

Installing MySQL


  • Please log in to reply
6 replies to this topic

#1 robmiller

robmiller
  • Members
  • Pip
  • Newbie
  • 3 posts

Posted 12 August 2003 - 10:18 AM

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

#2 robmiller

robmiller
  • Members
  • Pip
  • Newbie
  • 3 posts

Posted 13 August 2003 - 08:38 PM

bump




still no luck, any ideas?

#3 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 13 August 2003 - 08:45 PM

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.
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#4 robmiller

robmiller
  • Members
  • Pip
  • Newbie
  • 3 posts

Posted 13 August 2003 - 09:16 PM

I\'ve checked many times and my password is correct.

I tried logging in as root, and it still doesn\'t work.


:erk:

#5 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 13 August 2003 - 09:32 PM

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.
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#6 sandeep

sandeep
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 14 August 2003 - 08:16 AM

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

#7 im1hunt

im1hunt
  • Members
  • Pip
  • Newbie
  • 2 posts

Posted 14 August 2003 - 08:33 AM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users