I am upgrading to SVN 2974 (old SVN is a week or two old). When upgrading the database scheme in GUI I got this error:
Install / Update Failed!
[SIZE=5][B]The following errors occured[/B][/SIZE]
[B]Update ID:[/B] 1 - 0
[B]Database Error:[/B]
mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(‘your_existing_password’). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file, Message: Check that database is running
[B]Database SQL:[/B]
CREATE DATABASE fog
[B]Update ID:[/B] 1 - 1
[B]Database Error:[/B]
mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(‘your_existing_password’). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file, Message: Check that database is running
[B]Database SQL:[/B]
CREATE TABLE fog
.groupMembers
(
gmID
int(11) NOT NULL auto_increment,
gmHostID
int(11) NOT NULL,
gmGroupID
int(11) NOT NULL,
PRIMARY KEY (gmID
),
KEY new_index
(gmHostID
),
KEY new_index1
(gmGroupID
)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
The error list is very long and I have only pasted the first paragraphs.
How can I fix this?