unable to change password
am 06.04.2003 13:49:24 von Hisako Shimizu--Apple-Mail-2-455604227
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
delsp=yes;
charset=US-ASCII;
format=flowed
Dear sir/madam
Please tolerate my poor English.
I had been using mysql for a while without any problems.
And one day Error occuered ,I could not access it anymore.
My password which I had been using has been declined and i have this
error "Access Denied "
even though I have never changed password, at least not I am aware of.
------------------------------------------------------------ ------------
-------
Welcome to Darwin!
[Hisako:~] hisako% /usr/local/mysql/bin/mysql -u root -p mysql
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password:
YES)
[Hisako:~] hisako% /usr/local/mysql/bin/mysql -u root -P mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.55-entropy.ch
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
------------------------------------------------------------ ------------
---------
I tried to reset password with code below after I removed startupitem
from library and left it at desltop,
then typed the following code after restarting computer.
but I failed.
I do not have any idea why I can not change password.
---------------------------------
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--------------------------------------------------------- -
below is information about mysqladmin.
------------------------------------------------------------ ------------
-----------------------------
[Hisako:/usr/local/mysql] hisako% sudo ./bin/mysqladmin variables
extended -status processlist
+---------------------------------
+----------------------------------------------------------- ------------
------------------------------------------------------------ ------------
------------+
| Variable_name | Value
|
+---------------------------------
+----------------------------------------------------------- ------------
------------------------------------------------------------ ------------
------------+
| back_log | 50
|
| basedir | /usr/local/mysql/
|
| binlog_cache_size | 32768
|
| character_set | latin1
|
| character_sets | latin1 dec8 dos german1 hp8 koi8_ru
latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian
koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON
|
| connect_timeout | 5
|
| datadir | /usr/local/mysql/data/
| delay_key_write | ON
|
| delayed_insert_limit | 100
|
| delayed_insert_timeout | 300
|
| delayed_queue_size | 1000
|
| flush | OFF
|
| flush_time | 0
(----omit a few lines-------)
| pid_file |
/usr/local/mysql/data/Hisako.local..pid
(----omit a few lines-------)
| socket | /tmp/mysql.sock
(----omit the rest-------)
------------------------------------------------------------ ------------
------
Please let me know what is happening to my mysql.
Thank you very much in advance.
Best Regards
--Apple-Mail-2-455604227--