Week 6 Blog

DBMSs and Programming Languages

Databases and programming languages are what makes websites so special. We used HTML a little last week and it was very primitive. Most websites now are connected to databases in order to retrieve and store information. Programming allows features like usernames/passwords, security, and most visual aspects. Web servers are responsible for loading the index/home page, access the database to retrieve data, and sends the information to the client. Programming languages allow the website to be able to communicate to the web server.

Understanding the Database Management Systems (DBMs) Architecture

There’s a lot to DBMs, but most of it’s easy to understand. Let’s start with the clients. There’s the database administrator, web server, and anyone that is trusted. Anytime the database needs maintenance performed it needs to be done by the database administrator. Servicing the database outside of the company’s local area network can cause security issues because if you can access it outside, then somebody else can. The web server allows the web page to construct dynamic web pages by accessing the database once a web client requests the page. Database servers don’t need to be directly connected to internet. Developers can just access the database through the web server.

MySQL Configuration

The database management system we talked about this lesson was MySQL., which is specifically a relational database.  Relational database structures information to other comparative information. MySQL is highly modifiable. The main configure file is the my.cnf file. I mentioned earlier about remote access to the database server. To you can turn off that feature with the main configuration file. Once that’s done, you’ll create a root password and administrator account in MySQL. If the MySQL server package isn’t downloaded, then type sudo dnf -y install mysql-server into the terminal. This will also install MySQL users and groups. Set up passwords for the users and allow certain permissions for certain groups as a security protocol. An average Joe shouldn’t be able to make huge changes to the database. Here is how you drop the users: mysql> drop user ''@localhost;. If you need to exit MySQL enter in this command mysql> exit;.