Tee lahti config.php fail Apache konsoolis
Seda on vaja -> et tuleb sisse logimise aken
Uue kasutaja loomine
CREATE USER 'Illia'@'localhost' IDENTIFIED VIA mysql_native_password USING '***';GRANT USAGE ON *.* TO 'Illia'@'localhost' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
REVOKE ALL PRIVILEGES ON *.* FROM 'Illia'@'localhost'; REVOKE GRANT OPTION ON *.* FROM 'Illia'@'localhost'; GRANT SELECT, INSERT ON *.* TO 'Illia'@'localhost' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
Lisa kasutaja nimega parool -kala, kes saab retseptiraamatud vaadata ja uuendata andmeid(SELECT ja UPDATE)
REVOKE ALL PRIVILEGES ON *.* FROM 'Illia'@'localhost'; REVOKE GRANT OPTION ON *.* FROM 'Illia'@'localhost'; GRANT SELECT, UPDATE ON *.* TO 'Illia'@'localhost' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
