As long as you followed the directions and did nothing else after you installed and started MySQL, the mysqladmin command to set the initial password should have worked. I'm guessing you might have tried some other things first.
When in a total jam, you can startup mysqld without having it check access rights. You can then login as a guest and set the root password manual. You can kill the mysql process and start it backup up with out the grant tables.
mysqld --skip-grant-tables
But if you don't know how to set the password "manually" (you need to encrypt it), you should probably reinstall MySQL and see if you can set the root password. Download the install from the MySQL website. I've done about a dozen installs of MySQL on Macs over the past two years without a problem, so it does work.
On Apr 12, 2004, at 1:26 AM, Daniel Lahey wrote:
I have been trying for months to set up mysql on my Mac (Panther) with no success. I can't run mysqladmin as root. I get an access denied error message. If I try to use SHELL>mysqladmin -u root password 'password' I get access denied as either root or the regular user. I can't run mysql as root. 'access denied' I can't create databases. I can run mysql as the regular user and mess with the test db, and that's about all I can do. I've followed every instruction I could find online at the command line. I've tried CocoaMySQL. I have practically resorted to prayer.
Are there step-by-step instructions anywhere? I would be eternally grateful for any help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
