Posted by Rauch Christian on 10/13/05 00:36

Dave Moore schrieb:
> Hi All,
> I'm putting a website together using PHP and a MySQL database. I've been
> using phpMyAdmin as it makes updating the DB nice and easy. For development,
> I've been using Apache, MySQL and PHP installed on my local machine but now
> I'm having problems porting to my hoster's server.
>
> To transfer the database contents, I've exported the structure and data of
> my local DB to a .sql file and uploaded this to my hosted DB using
> phpMyAdmin on the host. This seems to work, but there are two problems:
>
> 1). Firstly, the MySQL PASSWORD() command give different results on the host
> than it does on my local machine. For example, using phpMyAdmin on my local
> machine, typing:
>
> SELECT PASSWORD ('mypassword')
Your hoster has a newer MySQL version than you have. If you want to use
your scripts, replace PASSWORD through OLD_PASSWORD.

See http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html for
more information.
>
> gives a 16 byte number as my books suggest. However, running the same
> command on the server gives a 41 bytes code!!!. Consequently, all my login
> functionality does not work!.
>
Leaving 2 for the others due to lack of knowledge ;)
>
> Thanks for any comments,
> Dave
>
hth,
rauch

[Back to original message]