Posted by Dave Moore on 10/13/05 00:46

Thanks Rauch. That explains a lot.

"Rauch Christian" <info@rauch-webdesign.de> wrote in message
news:dijvjk$o7l$05$1@news.t-online.com...
> 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]