I typed in
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
and changed 'new-password' to the password I wanted.
Got the --> on the next line but nothing else so I assumed it worked.
When I try to do anything such as check to see if mysql and php are happy I get
Warning: mysql_connect() [function.mysql-connect]: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) in /Library/WebServer/Documents/mysql_up2.php on line 5
Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) in /Library/WebServer/Documents/mysql_up2.php on line 9
Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /Library/WebServer/Documents/mysql_up2.php on line 9
Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
When I go back and try /usr/local/mysql/bin/mysqladmin -u root password 'new-password' again I get
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
Also tried
/usr/local/mysql/bin/mysqladmin -u root -h $hostname password 'new-password'
but was denied.
How the heck do I give myself access to mysql?
Please don't point me to the mysql.org page...been there I do not understand the "grants et al". Need plain english as in explicit instruction on what to do. BTW version is 4 on mac osx running apache 1.3 with php 4.3
Katherine
