MySQL database SSL connection using PHP

Question

I have a database setup non remote server.

What im trying to do is establish the connection using PHP.

All the settings on the server are OK as I tested it using MySQL workbench using following details: Hostname : xxx.xx.xx.xxx Port - blank so as defalut this is :3306

In advanced tab in workbench "Use SSL if available" is selected. Connection test is successful.

Although when Im trying to connect using simple mysq_connect('IP','user','pass') im getting the following errors: line 2 : $c = mysql_connect('IP','USER','PASS');

Warning: mysql_connect() [function.mysql-connect]: Premature end of data (mysqlnd_wireprotocol.c:553) in C:\wamp\www\sql\index.php on line

Warning: mysql_connect() [function.mysql-connect]: OK packet 1 bytes shorter than expected >in C:\wamp\www\sql\index.php on line 2

Warning: mysql_connect() [function.mysql-connect]: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file in C:\wamp\www\sql\index.php on line 2

Its been days now when Im trying to establish this connection. Please help!

Did you reset you password as instructed there at the bottom? — Brian Adkins
– Brian Adkins, Commented May 22, 2012 at 11:39
No, I didn't but why would it connect using MySQL workbench? — Dom
– Dom, Commented May 22, 2012 at 11:41
Dom, this error could cause even if there's a version incompaitibility b/w your mysql and PHP. Which version(s) you are in? — Rahul
– Rahul, Commented May 22, 2012 at 11:58

Lee Davis · Accepted Answer · 2012-05-22 11:41:51Z

1

try..

mysql_connect('IP','USER','PASS', false, MYSQL_CLIENT_SSL);

answered May 22, 2012 at 11:41

Lee Davis

4,7763 gold badges31 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dom Over a year ago

I tried that. Now I have the following error Warning: mysql_connect() [streams.crypto]: this stream does not support SSL/crypto in C:\wamp\www\sql\index.php on line 2

Lee Davis Over a year ago

Do you have the php_openssl extension up and running? php.net/manual/en/openssl.installation.php

Ja͢ck · Accepted Answer · 2012-05-22 11:41:54Z

0

Quick guide:

Open the server's my.cnf (usually in /etc)
Comment out the old-passwords = 1
Restart MySQL
Run mysql_fix_privilege_tables if necessary
Connect using the mysqlclient utility as root
use mysql
update user set password=password('new password') where user='the user'

Then try again

answered May 22, 2012 at 11:41

Ja͢ck

174k39 gold badges269 silver badges316 bronze badges

2 Comments

Dom Over a year ago

There is nothing in /etc apart from php5/php.ini

Ja͢ck Over a year ago

@Dom well, check the output of SELECT PASSWORD('test'); and make sure it's ehh ... long :) if not, you will have to look for the my.cnf

anjalis · Accepted Answer · 2012-05-22 11:44:45Z

0

here you are php manual mysql connect

see client flags

answered May 22, 2012 at 11:44

anjalis

3972 silver badges19 bronze badges

Collectives™ on Stack Overflow

MySQL database SSL connection using PHP

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related