08/02/2022
Database is most important thing for a website which should be properly organised and secured.
See how can you make it more organised and secured .
1. Avoid creating tangled databases. One of the primary ways you’ll keep your databases organized is by naming them. Databases in the DreamHost system need to have unique names. Because of this, common names such as “blog,” “WordPress” or “wiki” aren’t available.To create unique names and to keep your databases organized, include the domain name and/or the subdirectory and subdomain in your database name.
For Example:
For a website named: justin.dreamhosters.com/myblog
Consider naming the associated database: “justin_dreamhosters_com_myblog.”
If you use this convention, then the database name will provide a clue about the website you’re looking for (and vice versa) when you need to refer to a less used database.
2. Setting specific user permissions for your database is one of the best ways to keep them secure. User permissions can be set to grant MySQL users specific permissions, allowing you to set flexible security measures.
Most user permissions options can be found in the control panel in Goodies -> MySQL Databases. Once there, you can change individual settings by clicking on a MySQL username in the “Users with Access” column. From here, you can set permissions on a per-user basis.
3. You probably hear how important backups are, and at Dreamhost, we agree! Our own MySQL servers are backed up daily and are maintained for five days. This provides an important safety net, however, we recommend keeping a copy of your own backups as well. A best practice is to backup your data offsite often enough to cover your needs.
