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: '[EMAIL PROTECTED]' (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
