Error upgrading to SVN 2974
-
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 TABLEfog
.groupMembers
(
gmID
int(11) NOT NULL auto_increment,
gmHostID
int(11) NOT NULL,
gmGroupID
int(11) NOT NULL,
PRIMARY KEY (gmID
),
KEYnew_index
(gmHostID
),
KEYnew_index1
(gmGroupID
)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMICThe error list is very long and I have only pasted the first paragraphs.
How can I fix this?
-
Feed this error into any search engine and you’ll get a multitude of explanations on how to fix this, e.g.:
[url]http://www.phpro.org/articles/Database-Connection-Failed-Mysqlnd-Cannot-Connect-To-MySQL.html[/url]