hello Drupal community,
this is my very first post, am trying to install Drupal on my mac machine (i.e., locally, not on a web server..) have later than minimum required versions of Apache, PHP, & MySQL..
of course am running into probs with db... oh brother.. db always a problem.... I should have known....;-)
first, a comment: I think something is not too clear: when it asks for uid/pswd for db it's not clear whether you're supposed to create new uid/pswd for the particular drupal db, or are you supposed to type in uid/pswd you have already for MySQL server? (people often say "db uid/pswd", when in fact it's uid/pswd to conn. to the server, not to a particular db... correct me if I'm wrong.. at any rate b/c of the questions below figured out it's uid/pswd for the server...) maybe instr should just ask for uid/pswd you use to conn. to the server.. I think that would be a bit clearer...
after entering db info, am getting this msg:
Failed to connect to your database server. The server reports the following message: SQLSTATE  Access denied for user 'root'@'localhost' (using password: YES).
Is the database server running? -- of course, I just created the db for drupal ;-)
Does the database exist, and have you entered the correct database name? -- yes
Have you entered the correct username and password? -- yes, more than once (root & pswd, which I use to conn. to MySQL server..)
Have you entered the correct database hostname? -- yes (& logged out and in of MySQL server, my newly-created db for Drupal is there...)
(one note on hostname: for some reason, to conn. to MySQL from PHP have to put '127.0.0.1' instead of 'localhost'; I don't know why (from JSP 'localhost' works fine..))
so I tried both 127.0.0.1 and localhost, neither one works.. (but am assuming the correct one is 127.0.0.1, since get less errors when use this one instead of 'localhost'...;-)
if the port is 3306, do I have to put it in? I tried with and without filling that in...
where do I go from here??
Tried everything numerous times before posting this.... I'm not a newbie when it comes to local servers, have been using MySQL on local machine for years, have installed & configured Tomcat on numerous machines (windows & mac); (PHP env came installed with my mac...;-)
there must be something in MySQL stuff I'm still missing.. can't figure out what it is... :-(
would very much appreciate help/suggestions...