Help, I'm Brand New To This, And I'm A Retarded I'm Having Problems On The Install

[zzbolt]

I've downloaded the latest version of OS Commerce, I've unzipped the catalog file and uploaded to my local root folder on my web host. I've set up a blank mysql data base on it, and I've started the install via my website. But when i try to do the database import, i keep getting the same error message from OS commerce Client does not support authentication protocol requested by server; consider upgrading MySQL client Any ideas? or suggestions? Like I said, I am completely new to this. I've never really used PHP or mysql's before. Some one hold my hand and help.

[zzbolt]

I've downloaded the latest version of OS Commerce, I've unzipped the catalog file and uploaded to my local root folder on my web host. I've set up a blank mysql data base on it, and I've started the install via my website. But when i try to do the database import, i keep getting the same error message from OS commerce Client does not support authentication protocol requested by server; consider upgrading MySQL client Any ideas? or suggestions? Like I said, I am completely new to this. I've never really used PHP or mysql's before. Some one hold my hand and help.

 

 

Just one thing i forgot to add, I'm using mysql 5 i can also use 4.1 if that makes any difference

[Bloged]

Just one thing i forgot to add, I'm using mysql 5 i can also use 4.1 if that makes any difference

 

Do this only if you know what you are doing!

 

If you are able to run this SQL query try if it helps:

SET PASSWORD FOR user@localhost = OLD_PASSWORD('<password>');

* change <password> with your password :blush:

 

Grtz,

 

Arjan Gelderblom

[zzbolt]

Do this only if you know what you are doing!

 

If you are able to run this SQL query try if it helps:

SET PASSWORD FOR user@localhost = OLD_PASSWORD('<password>');

* change <password> with your password :blush:

 

Grtz,

 

Arjan Gelderblom

 

 

what does this query do exactly?

[zzbolt]

what does this query do exactly?

 

 

I tried it, and i got this as an error "#1044 - Access denied for user '<my user name>'@'%' to database 'mysql'

[Historian]

Just a thought zzbolt, maybe it would be better to do things the other way round!

 

If the shop is really important, then might it be an idea to change to a host that offers osCommerce support. OsCommerce was installed on my server with just one click and it all worked. I then had one or two problems when I copied all the files to my own computer (inside Wamp), but with some help they were solved.

 

The advantage of doing things that way round, is that you know that the important files on the remote server are running correctly.

 

I'm not sure I'm retarded, but I am a new user!

[zzbolt]

Just a thought zzbolt, maybe it would be better to do things the other way round!

 

If the shop is really important, then might it be an idea to change to a host that offers osCommerce support. OsCommerce was installed on my server with just one click and it all worked. I then had one or two problems when I copied all the files to my own computer (inside Wamp), but with some help they were solved.

 

The advantage of doing things that way round, is that you know that the important files on the remote server are running correctly.

 

I'm not sure I'm retarded, but I am a new user!

 

 

What web host are you using?

[Historian]

What web host are you using?

 

I'm not sure advertising is allowed, but as you asked, it's Blackfoot on http://www.blackfoot.co.uk/

That's fine if you are in the UK. If you in a different country then obviously you will need a local company.

[Bloged]

I tried it, and i got this as an error "#1044 - Access denied for user '<my user name>'@'%' to database 'mysql'

 

This query tries to change the password of your mysql username to the password you choose for <password>!

 

But you could try one of these three solutions given!

 

Grtz,

 

Arjan Gelderblom