Re: unable to change password

Hisako Shimizu writes:
>
> Dear sir
>
> I had access denied and tried code below after I removed startupitem
> from library and left it at desktop.
> Originally I tried to remove mysql from library from startupitem but I
> was shown I don't have privilege to do that.
>
> What can I do to get back access to mysql?
> Thank you very much in advance.

Hi!

This list is dedicated to bug reports with repeatable test cases.

This is not case with your message, which is a case of the forgotten
password.

For problems like those, write to mysql@lists.mysql.com

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

unable to change password

--Apple-Mail-4-555327271
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
delsp=yes;
charset=US-ASCII;
format=flowed


Dear sir

I had access denied and tried code below after I removed startupitem
from library and left it at desktop.
Originally I tried to remove mysql from library from startupitem but I
was shown I don't have privilege to do that.

---------------------------------
START------------------------------------------------------- ------

Last login: Sat Apr 5 04:08:11 on console
Welcome to Darwin!
[Hisako:~] hisako% cd /usr/local/mysql
[Hisako:/usr/local/mysql] hisako% sudo echo
Password:

[Hisako:/usr/local/mysql] hisako% sudo ./bin/safe_mysqld --user=mysql
--skip-grant-tables &
[1] 337
[Hisako:/usr/local/mysql] hisako% Starting mysqld daemon with databases
from /usr/local/mysql/data
../bin/mysqladmin -u root password 'hisako'
../bin/mysqladmin: unable to change password; error: 'You must have
privileges to update tables in the mysql database to be able to change
passwords for others'
[Hisako:/usr/local/mysql] hisako% sudo ./bin/mysqladmin -u root shutdown
030405 04:11:08 mysqld ended

[1] + Done sudo ./bin/safe_mysqld
--user=mysql --skip-grant-tables
[Hisako:/usr/local/mysql] hisako% sudo ./bin/safe_mysqld --user=mysql &
[1] 365
[Hisako:/usr/local/mysql] hisako% Starting mysqld daemon with databases
from /usr/local/mysql/data

----------------------------------
END--------------------------------------------------------- -

And then I run code below after putting back startupitem to library and
restarting computer.

[Hisako:~] hisako% cd /usr/local/mysql/bin
[Hisako:local/mysql/bin] hisako% sudo ./mysqladmin -u root shutdown
Password:
../mysqladmin: shutdown failed; error: 'Access denied for user:
'@localhost' (Using password: NO)'

also run the code below to check mysqladmin.

Hisako:~] hisako% cd /usr/local/mysql
[Hisako:/usr/local/mysql] hisako% sudo ./bin/mysqladmin version
mysqladmin
Password:
../bin/mysqladmin Ver 8.23 Distrib 3.23.55, for apple-darwin6.3 on
powerpc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 3.23.55-entropy.ch
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 hour 38 min 23 sec

Threads: 1 Questions: 2 Slow queries: 0 Opens: 5 Flush tables: 1
Open tables: 0 Queries per second avg: 0.000
../bin/mysqladmin: Unknown command: 'mysqladmin'

What can I do to get back access to mysql?
Thank you very much in advance.

--Apple-Mail-4-555327271--