phpMyAdmin MySQL proble,

[Dave Moore]

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')

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!.

2). Secondly, I noticed that phpMyAdmin on the host shows a 'Collation'
column with the value 'latin1_swedish_ci'. This column isn't present when
using phpMyAdmin on my local machine, even though the DB contents show be
identical. So what's that all about??.

Thanks for any comments,
Dave

[Rauch Christian]

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 [url]http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html[/url] 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

[Dave Moore]

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 [url]http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html[/url] 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

[Axel Schwenke]

"Dave Moore" <dave_m_moore@post2me.freeserve.co.uk> wrote:

> 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.

....

> but there are two problems:
>
> 1). Firstly, the MySQL PASSWORD() command give different results on the host
> than it does on my local machine.

> SELECT PASSWORD ('mypassword')
>
> 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!.

....

> 2). Secondly, I noticed that phpMyAdmin on the host shows a 'Collation'
> column with the value 'latin1_swedish_ci'. This column isn't present when
> using phpMyAdmin on my local machine, even though the DB contents show be
> identical. So what's that all about??.

As Christian said, you hoster uses a newer MySQL version than you. Both
features were introduced with MySQL 4.1. I suggest you upgrade your
development machine to the latest 4.1 version of MySQL.

Regarding PASSWORD(): the MySQL manual [1] strongly discourages from
using PASSWORD() for your own applications and recommends MD5() or
SHA1() for password hashing.

Regarding character sets and collations: this is great stuff if one
wants to build a multilingual website. For a unilingual application
it's enough to set the defaults for the used tables/databases to the
right values. I suggest reading the manual [2].


[1] [url]http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html[/url]
[2] [url]http://dev.mysql.com/doc/refman/5.0/en/charset.html[/url]


XL