Using MySQL ver. 5.5.55 in a production env

Forum Moderators: open

Message Too Old, No Replies

Using MySQL ver. 5.5.55 in a production env

abrodski

11:19 am on Jul 16, 2017 (gmt 0)

Hello!

Is it still OK to use this older version of MySQL on a production web server (LAMP on Ubuntu 14.04)? It's a low traffic volume business website. Loads fast enough. So far, no serious issues (like being hacked or something). Also we use older version of PhpMyAdmin (ver. 4.0), so my question also regarding this too.

topr8

7:03 pm on Aug 15, 2017 (gmt 0)

well RedHat 6.x ships with MySQL 5.1
and a lot of websites today are served by RedHat 5.x or 6.x (or CentOS which is effectively the same)
the main thing to note is with MySQL is to write efficient and secure queries and to lock down the db permissions of users [a whole big topic in itself]

as it happens there is a general move away from MySQL in the open sourse movement - to MariaDB ... which was forked off MySQL a while ago, it currently is effectively the same, but as time goes on that will change.

i've no idea about phpMyAdmin as i've never used it, however best practice with phpMyAdmin is to serve it from a non standard port and to restrict access to that port to your ip address or whoever needs to access it - are you doing this?