Tee halti config.php fail Apache konsoolis’
Seda on vaja —> et tuleb sisse logimise aken
Uue kasutaja loomine
CREATE USER 'martin'@'localhost' IDENTIFIED VIA mysql_native_password USING '***';GRANT USAGE ON *.* TO 'martin'@'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 'martin'@'localhost'; REVOKE GRANT OPTION ON *.* FROM 'martin'@'localhost'; GRANT SELECT, INSERT ON *.* TO 'martin'@'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 'martin'@'localhost'; REVOKE GRANT OPTION ON *.* FROM 'martin'@'localhost'; GRANT SELECT, UPDATE ON *.* TO 'martin'@'localhost' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;