mariovaldez.net

MV.net forums
It is currently 14 Jul 2016, 00:50

All times are UTC - 7 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 15 posts ] 
Author Message
 Post subject: Error connecting to DB
PostPosted: 15 Jan 2005, 14:16 
Hio ther great program you written!
I try to connect trough ssh but get the following error:

SQL Error: client does not support authentication protocol requested by server; consider upgrading MySQL client.

I run MySQL 4.1.8 what could i do to make it connect?

Tnx for your help!


Report this post
Top
  
Reply with quote  
PostPosted: 16 Jan 2005, 14:05 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
Repute:

> Hio ther great program you written!
> I try to connect trough ssh but get
> the following error: SQL Error: client
> does not support authentication protocol
> requested by server; consider upgrading
> MySQL client. I run MySQL 4.1.8 what
> could i do to make it connect?

Hi. I think there was a change in the authentication hashing since MySQL 4.1.1. I thought the ZEOSlib (which is used by OSCPMWin for DB connectivity) was compatible with it. We still don't upgrade to the latest ZEOSlib because it is still in beta.

There is a workaround described in the MySQL documentation (http://dev.mysql.com/doc/mysql/en/Old_client.html):
Quote:
Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:

mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');




Regards,

Mario A. Valdez-Ramirez.


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: 18 Jan 2005, 03:30 
Ok thanx but i cant manage it to do this with putty via root login would you please make a description of how to manage changing this.

Your the best!


Report this post
Top
  
Reply with quote  
 Post subject:
PostPosted: 20 Jan 2005, 07:21 

Joined: 15 Jan 2005, 15:09
Posts: 2
Mario? please help me!

Thnx


Report this post
Top
 Profile  
Reply with quote  
PostPosted: 20 Jan 2005, 14:54 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
Repute:

> ...i cant manage it to do this with putty via root
> login would you please make a description of
> how to manage changing this.

Hi. Is that server your own server (under your full control) or it is from a hosting service?

If it is your own server, you can login and then invoke the mysql client by typing:
Code:
mysql --user root --password


Then you will be asked to enter the root password (of the MySQL root user, not the system root user).

To check what are the accounts for MySQL you can type this:
Code:
use mysql;


That will select the "mysql" database. Then you enter the following SQL query.

Code:
select host,user,password from user;


There you can see the passwords as hashes and the hosts allowed for each user. For example, I get an output like this:

Code:
+------+------------------------+------------------+
| user | host                   | password         |
+------+------------------------+------------------+
| root | localhost              | a174b1193efdd17c |
| root | 192.168.0.%            | a174b1193efdd17c |
| root | wintermute             | a174b1193efdd17c |
+------+------------------------+------------------+


That result shows that my "root" account has three allowed hosts to connect from: localhost, wintermute (the proper hostname) and from any computer in my LAN (the 192.168.0 network).

Then you can change the user password type by typing:

Code:
set password for 'root'@'localhost'=old_password('mynewpass');


You will need to do that for every host.

Of course this would be more simple if you already have a web interface like phpmyadmin, where you can simply use your web browser with a graphical interface to execute the SQL instructions. :wink:


If you have more questions, comments or suggestions, please post to this forum. :)


Regards,

Mario A. Valdez-Ramirez.


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: 21 Jan 2005, 10:57 

Joined: 15 Jan 2005, 15:09
Posts: 2
Thnx your the best it's working now!!!!


Report this post
Top
 Profile  
Reply with quote  
PostPosted: 11 Mar 2005, 14:00 
Hi,

I have installed oscpmwin (many times), but I still get the same error message: error while connecting to database (vakondweb@www.ongyogyitas.hu).
SQL error:can't connect to mysql server on www.ongyogyitas.hu (10060).

Do you have any idea ?
Thank you in advance:Laszlo


Report this post
Top
  
Reply with quote  
PostPosted: 11 Mar 2005, 14:01 
Hi,

I have installed oscpmwin (many times), but I still get the same error message: error while connecting to database (vakondweb@www.ongyogyitas.hu).
SQL error:can't connect to mysql server on www.ongyogyitas.hu (10060).

Do you have any idea ?
Thank you in advance:Laszlo


Report this post
Top
  
Reply with quote  
PostPosted: 11 Mar 2005, 14:03 
Hi,

I have installed oscpmwin (many times), but I still get the same error message: error while connecting to database (vakondweb@www.mysite.hu).
SQL error:can't connect to mysql server on www .mysite.hu (10060).

Do you have any idea ?
Thank you in advance:Laszlo


Report this post
Top
  
Reply with quote  
 Post subject: Connection problems...
PostPosted: 12 Mar 2005, 07:28 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
Vakond:

> I have installed oscpmwin (many times),
> but I still get the same error message:
> error while connecting to database
> (vakondweb@www.mysite.hu).
> SQL error:can't connect to mysql server
> on www .mysite.hu (10060).

Hi. The most common cause is that the MySQL server is not accepting connection in the server. Please check the following posting with several suggestions regarding connection problems:

http://www.mariovaldez.net/webapps/forums/viewtopic.php?t=94

If you still have question, please post in the forums or contact me by email.

Regards,

Mario A. Valdez-Ramirez.


Report this post
Top
 Profile  
Reply with quote  
PostPosted: 19 Aug 2005, 03:24 
Repute wrote:
Hio ther great program you written!
I try to connect trough ssh but get the following error:

SQL Error: client does not support authentication protocol requested by server; consider upgrading MySQL client.

I run MySQL 4.1.8 what could i do to make it connect?

Tnx for your help!


Report this post
Top
  
Reply with quote  
 Post subject: just a thanks
PostPosted: 19 Nov 2005, 10:16 
just a thanks for posting - this sent me in the right direction now i am up and running!


Report this post
Top
  
Reply with quote  
PostPosted: 21 Dec 2005, 17:49 
thank you... I fix it


Report this post
Top
  
Reply with quote  
PostPosted: 29 Apr 2006, 12:16 

Joined: 29 Apr 2006, 12:04
Posts: 2
Repute wrote:
I'm trying to connect to the MySQL server and this error comes up:

SQL Error: client does not support authentication protocol requested by server; consider upgrading MySQL client.


The MySQL server is on a hosting service and I DON'T have access to the sql server. The MySQL is in the U.S. and I'm in China. The hosting service is using MySQL 4.1.16.

How can I connect to my store in this situation?

Thanks!


Report this post
Top
 Profile  
Reply with quote  
PostPosted: 04 May 2006, 23:49 

Joined: 29 Apr 2006, 12:04
Posts: 2
paulsmith wrote:
Repute wrote:
I'm trying to connect to the MySQL server and this error comes up:

SQL Error: client does not support authentication protocol requested by server; consider upgrading MySQL client.


The MySQL server is on a hosting service and I DON'T have access to the sql server. The MySQL is in the U.S. and I'm in China. The hosting service is using MySQL 4.1.16.


Hello everyone again!

Does anyone know a workaround to this? It's a big problem when one can't control their MySQL server or program it. This looks like a great tool and should help a lot in keeping a store running.

What can I do at this point?

Thanks


Report this post
Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 15 posts ] 

All times are UTC - 7 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group