First, you should not need to use sudo or the root account for anything you do with MySQL except maybe installing it.
Second, I would always specify the account name when you are trying to log into MySQL.
For instance, try this:
mysqladmin -u root password
or
mysql -u root -p
to login as a client.
That is, if you have an account setup in MySQL called root. The example you gave in your email is think working because I'm pretty sure it's trying to execute as a guest since no account is specified.
I don't use any graphical interfaces to start and stop MySQL on OSX, but I know some people who have and have had problems. I've talked a few of them through removing the graphical tools and telling them how to start things from the command line.
Feel free to email on or off line for further troubleshooting.
On Jan 22, 2004, at 9:17 PM, Dietrich Speer wrote:
I am having a problem with accessing the mysql database in a new MySQL installation on OS X Panther.
This installation came with the original OS, and some configuration was done
right after installation. I have previously installed MySQL on Linux and Win
and have never encountered this problem.
After being unable to log into MySQL at all, I decided to reset the MySQL
root password. I did everything according to the book (several of them):
- kill mysqld by killing <host>.pid - restarting mysqld --skip-grant-tables - reset password for root by using MySQL client - Flush Privileges - restart mysqld the normal way.
Over the past 2 days I have done this many many times. In between the steps
I always check the processes to confirm that the previous step took.
With the grant tables skipped I am able to access the mysql db just fine.
After flushing privileges and restarting without skipping I cannot connect
to the mysql db with either of the usr/pwd combinations I just created.
I have tried back and forth - with a my.cnf file in /etc and without. With
the client password set in that file and without.
I am doing everything with the root password in OS X enabled but logged in
as a non-root user. Where It's needed I am using sudo. Is this where the
problem is? the password for OS X root and MySQL are different, and the
MySQL password does not contain any reserved letters.
It strikes me that, after going through all of this, and as a non root user,
the graphical MySQL Manager refuses to stop the database without giving me
an error message.
# mysqladmin -u password <password> has not worked in any scenario, whatever
I do.
I am getting really sick of this and have exhausted my ideas after going
through several manuals.
Can somebody please help!
Thanks!
Dietrich
--
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]
