View All Products
Compute
Storage
Databases
Networking
Developer Tools
Delivery
Security
Services
Industries
Pricing
Community
Engage With Us
Community ▶ Questions ▶ Mysql started malfuctioning after update...
Log in to Ask a Question

Mysql started malfuctioning after update...

development

Not sure why… Ubuntu, fully updated. doesn't seem like php is getting along with mysql anymore. SSH tunneling with HeidiSQL stopped working too.

Ubuntu (Latest 64 bit (4.9.15-x86_64-linode81))

2017-06-01T00:08:19.429519Z 15 [Note] Aborted connection 15 to db: 'dbname' user: 'myuser' host: 'localhost' (Got an error reading communication packets)

2017-06-01T00:09:05.285527Z 14 [Note] Aborted connection 14 to db: 'dbname' user: 'myuser' host: 'localhost' (Got an error reading communication packets)

2017-06-01T00:09:05.285680Z 13 [Note] Aborted connection 13 to db: 'dbname' user: 'myuser' host: 'localhost' (Got an error reading communication packets)

2017-06-01T00:10:57.277929Z 16 [Note] Aborted connection 16 to db: 'dbname' user: 'myuser' host: 'localhost' (Got an error reading communication packets)

2 Replies

I tracked down the problem. It was the recent security update.

This… $primaryDbServer = '127.0.0.1:3306';

Now gets interpreted as '127.0.0.1:3306:3306';

So, now you have to just use "127.0.0.1" or "localhost"… You can't specify the port number in php anymore?

Sounds like a problem with the application you are using. PHP supports specifying a port number through both mysqli and PDO.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Log in to Reply
Community Code of Conduct