title: "error connecting to database" wordpress error when adding new db and site to multi-site vps
body: <p>For some context I am running multiple sites on a single VPS through Nginx, they are all WordPress sites.
  The issue I am having is when I made a new site today and went to create a new Mysql DB for it and assigned a user using:</p>
  <p><code>GRANT ALL ON dbNew.* TO admin @'localhost' IDENTIFIED BY 'newPassword';</code></p>
  <p>It broke the DB connections of all my other WP sites.</p>
  <p>The only solution to restore the connections of all the other sites was to run the above command for a known working site that restored all other site's connections.</p>
  <p><code>GRANT ALL ON dbOld.* TO admin @'localhost' IDENTIFIED BY 'oldPassword';</code></p>
  <p>After extensive google searching, I've tried all recommended approaches including running in safe mode and turning MySQL on and off, flushing, etc.</p>
  <p>I feel like I'm am missing something obvious here or there is some other error, I've followed the same process in the past without any issues, currently hosting 5 WordPress sites on this VPS and there are no hardware limitations.</p>
  <p>Any help would be appreciated.</p>