SQL user

→ global: This section is about configuring global variables and settings in MySQL that define the general behavior of the database server.

→ table: This section describes operations with tables in MySQL, including creating, modifying the structure, and deleting tables, as well as managing data within them.

→ ab: This section discusses the use of the ab (Apache Benchmark) utility to test web server performance and assess its load capacity.

→ Root → Admin without passwords

Open the config.php file in the Apache console

This section shows how to open and edit the config.php file in the Apache console to configure connection and authentication settings in phpMyAdmin.

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config'; --> peame vahetada 'cookie'
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

MySQL –> table –> user

New User

CREATE DATABASE

Log in as a new user → JekGuz
Let’s check what this user has access to

Grant / Revoke permissions

Cinema (Kinoteatr)

A practical project is presented for creating a database for a cinema, including the development of tables for movies, genres, and screenings

A set of images illustrates the process of designing and creating a database for managing information about movies, genres, and screenings in a cinema.

We log in as user JekGuz and check whether the procedure works.

The screenshots demonstrate the execution and verification of procedures in the database under the JekGuz account.

INSERT (ZANR)

A series of images shows the process of adding new movie genres to the ZANR table using the SQL INSERT statement.

Add user Opilane / password 12345, who can execute procedures/functions and see only those tables that are referenced in the procedures.

It shows how to create the user Opilane with password 12345, grant permission to execute procedures, and restrict access to only the necessary tables.

Opilane is able to add and drop successfully!

Now — update procedure

ALTER filmtype

Own procedure

User Opilane now has access to all procedures.