mardi 23 décembre 2014

MySQL Socket exclusively



  • I've disabled TCP by using skip-networking in my /etc/my.cnf file

  • I've deleted all users (mysql.user) that have other Host than localhost


Now I went through the other tables in the mysql database and stumbled upon proxies_priv, which likely allows database connections over proxies. It still contains an iMac.local for the root user.


I know I already have skip-networking enabled, but would it hurt to delete the non-localhost Host entries from that table? Just want to be tidy with my setup.


I also noticed in the information_schema.USER_PRIVELEGES that there are still non-localhost entries bound there. What to do with that?


If there are any other measures to be taken ensure the database will be Socket-only, please share :)


Thanks





Aucun commentaire:

Enregistrer un commentaire