|
Tuesday 21 December 2004 2:59:55 pm
Thanks for the tip, I fixed the problem this way:
I used the tip from this thread:
http://ez.no/community/forum/install_configuration/kernel_50_on_solaris_mysql_4_1_7_ez_3_4_3
--
Open your MySQL configuration file, locate the [mysqld] section and add "old_passwords" on a new line. Restart your MySQL server.
Now open a MySQL console and execute the following to reset the password to the "old" method:
-- The only problem is finding the nonexisting my.cnf file. Google helped me find the answer, I had to make a new file called my.cnf placed in /etc/
I added old_password to a "typical global conf file":
(From http://dev.mysql.com/doc/mysql/en/Option_files.html )
[client]
port=3306
socket=/tmp/mysql.sock
[mysqld]
port=3306
socket=/tmp/mysql.sock
key_buffer_size=16M
max_allowed_packet=8M
old_password
[mysqldump]
quick
After this I updated mysql:
USE mysql;
UPDATE user SET Password = PASSWORD('<your password>') WHERE User = '<your username>';
Just to be sure I restarted the machine, and like magic, it worked:)
Best regards
Jonas B Holten
(looking forward to a christmas testing Exponential)
--
Jonas B Holten
|