| Imran Chaudhry 2006-01-26, 4:56 pm |
| > My web hosting server runs PHP 4.4 and MySQL 4.1. But
> PHP 4.4 doesn't fully support MySQL 4.1. and i have
> problems restoring a utf8 encoded database dumped from
> a MySQL 4.0 server to the new 4.1 server. Do i have
> any chance to get it working in this setup or should i
> persuade the hosting provider to either upgrade to PHP
> 5 so i can use Connection Character Sets and
> Collations in PHP or downgrade to MySQL 4.0?
Lionel,
Please give us more specific information about the nature of the
problem you are having (eg error messages, codes, log file output).
The password hashing algorithm changed in MySQL 4.1 which is possibly
the cause of your problems with PHP client apps.
Try updating the password for your MySQL database account as follows:
SET PASSWORD FOR 'some_user'@'some_ho
st' =3D OLD_PASSWORD('newpwd
');
Now use these credentials to make a connection at parse some simple
table data. It should work.
Regards,
Im
--
http://www.ImranChaudhry.info
MySQL Database Management & Design Services
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|