I have an Ubuntu webserver which once used a local database, but we migrated it and now the database is stored remotely on a separate server accessed from many different places. The webserver runs code in PHP and in Python and connects to the remote database using PHP's built-in MySQL support and using Python MySQLdb module.
I'm not longer using the local database on the webserver, and want to remove any unnecessary MySQL server stuff from the webserver because at the moment I have a mysqld process sitting there using 2.8% of my memory and 0.3% of my CPU for no good purpose. I've run
sudo apt-get remove mysql-server sudo apt-get autoremove sudo apt-get autoclean
but I'm still able to access the database stored on the web server by typing
mysql -u root -p and the mysqld process is still using resources.
I'm pretty timid about fiddling around to try and fix the problem because I don't know which
mysql- packages, if any, are depended upon by PHP or MySQLd to connect to the database on the remote database server.
What do I need to do to get rid of the database hosted on the webserver and get rid of the resource-munching mysqld process without breaking the webserver's ability to connect to the remote database?