By Roel Guldemond on

Xmas-holidays in the netherlands: My son (15) and I (49) are dedicated to get drupal on our eMac (OS 10.3.9).

Since our, 8 weeks ago, posted forum topic "how first start Drupal on eMac 10.3?", we’ve been reading again and again Maczealot's article "Installing Drupal on Tiger" at http://maczealots.com/tutorials/drupal/#step1

Who can help with following?
A/m Maczealot's article reads:
"Now that MySQL is running, we'll change the root password of MySQL so that Drupal (and you) can access it later. Use this command (where yourpasswordhere is replaced by your chosen password):
/usr/local/mysql/bin/mysqladmin -u root password yourpasswordhere"

In Terminal (1.4.6 (v100.1.8)) we enter the line:
eMac:~ roel$ /usr/local/mysql/bin/mysqladmin -u root password ***
Terminal is replying with:
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

At this point we do not see how we can get access.
We’ve been been redoing the MySQL several times, went through the MySQL-manual.pdf, but we don’t see where we go wrong.
Can you help or advice? Dear reader! Thank you for your attention uptill here!
Best regards Roel en Stan Guldemond, Ossendrecht, Netherlands

Comments

mdixoncm@drupal.org’s picture

mdixoncm@drupal.org commented

Try :

/usr/local/mysql/bin/mysqladmin -u root

If a password is needed for your root user you will be prompted to enter it (I am not sure what the default password will be - probably just blank).

You can now change the password with something like

update mysql.user set Password=PASSWORD('PUT YOUR PASSWORD HERE') where User='root' and Hostname='localhost';

flush privileges;

It might be an idea to try the GUI tools, these will allow you to do all the stuff that you normally do from the command line but with pretty pictures :) - much nicer and more productive.

like books? check out booktribes.com