Author Archives: alfred

Update Ubuntu 10 to 12

Posted on by
Reply

1. Update the sources.list in /etc/apt/ with following source lists

deb http://old-releases.ubuntu.com/ubuntu/ maverick main restricted
deb http://old-releases.ubuntu.com/ubuntu/ maverick-updates main restricted
deb http://old-releases.ubuntu.com/ubuntu/ maverick universe
deb http://old-releases.ubuntu.com/ubuntu/ maverick-updates universe
deb http://old-releases.ubuntu.com/ubuntu/ maverick multiverse
deb http://old-releases.ubuntu.com/ubuntu/ maverick-updates multiverse
deb http://old-releases.ubuntu.com/ubuntu/ maverick-security main restricted
deb http://old-releases.ubuntu.com/ubuntu/ maverick-security universe
deb http://old-releases.ubuntu.com/ubuntu/ maverick-security multiverse

Warning: mysql_connect(): 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’)

Posted on by
Reply

1. generate mysql5 hash value of mysql password

2. execute SET PASSWORD FOR ‘username’ = ‘*aa1420f182e88b9e5f874f6fbe7459291e8f4601’ in phpmyadmin

References

1. http://www.insidepro.com/hashes.php

2. http://stackoverflow.com/questions/4807072/windows-7-php-mysql-connection-issues