Database mariadb server

[rsingh0706]

Overview Database (mariadb server)

Service name: Database Servers (mariadb server) Port: 3306 Usage description: Database servers are powerful machines or software systems designed to store, manage, and provide access to databases. They are crucial in handling large volumes of data, ensuring data integrity, security, and efficient retrieval. Here are some common uses and purposes of database servers: CLI:

 sudo apt update
 sudo apt install mariadb-server mariadb-client
 sudo systemctl start mariadb
 sudo systemctl enable mariadb
 sudo systemctl status mariadb                                                   
 sudo mysql_secure_installation
 1. Enter current password for root :- password root set
 2. Set root password :- r
 3. Remove anonymous users :- y
 4. Disallow root login remotely :- n
 5. Remove test database and access to it :- y
 6. Reload privilege tables now :- y
 sudo mysql -u root -p
 sudo mariadb  
 MariaDB [none]

User: Emily Garcia (Database Analyst) (read-only) Daniel Rodriguez (Database Administrator) (full access)

Path:

• config_files: /etc/mysql/conf.d/
• configuration directories: /etc/mysql/mariadb.conf.d/

  Security Considerations: (research on it):-

  university-collage (s.no, name, department) (1, rahul, devops) (2, shivam, code) (3, swetank, architect) CREATE DATABASE university; SHOW DATABASES; USE university; CREATE TABLE collage (serial_no INT, name VARCHAR(100), department VARCHAR (100) ); DESCRIBE collage; INSERT INTO collage (serial_no, name, department) VALUES ('3', 'swetank', 'archittect'); SELECT * FROM collage;