hey everyone, ive been trying to set up my Macs to use PHP and MySQL for the last week, and ive been stuck for the last 3 days. here is my setup:
Mac OSX 10.2, Apache 2.X, PHP. everything is set up, except for MySQL.
here is where i am at so far:
downloaded and installed MySQL Package.
1. Download the package mysql-3.23.52-jaguar.pkg.tar.gz to your desktop. Unpack it and then double-click on the .pkg file to install it.
2. Open a terminal window and type in the following commands (without the double quotes):
3. "cd /usr/local/mysql"
4. "sudo ./scripts/mysql_install_db", enter administrator password when asked
5. "sudo chown -R mysql /usr/local/mysql/*"
6. "sudo ./bin/safe_mysqld --user=mysql &"
7. "/usr/local/bin/mysql test"
great, worked fine, then i exited to set password with:
mysqladmin -u root password new_password_here
thats when i get the following message everytime i try to do anything (create database, set passwords, etc.):
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
now, i know that there is no password set up, i want to set one up. any type of command i throw at it (root or otherwise) gives me the error.
what can i do????
thanks for everyones help!!!!!!!