You said that you changed the password to the password you wanted, but in all the examples you are trying to access the server without a password. Try using the -p flag so it prompts you for your password, then type in whatever you set the password to be.
-----Original Message----- From: katherine bjork [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 3:02 PM To: mysql Subject: mysql install---help please Tried for the second time to install mysql on my mac and again a problem during the install related to the password. 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
