Otu esi ewepu mgbọrọgwụ nbanye nweta PhpMyAdmin

Ọ bụrụ na ị na-eme atụmatụ iji phpmyadmin mgbe niile iji jikwaa ọdụ data gị na netwọkụ (ma ọ bụ njọ, na ịntanetị!), Ịchọghị iji akaụntụ mgbọrọgwụ. Nke a bara uru ọ bụghị naanị maka phpmyadmin kamakwa maka interface ọ bụla dabere na webụ.

Na /etc/phpmyadmin/config.inc.php, chọọ ahịrị na-esonụ wee hụ na iwu AllowRoot ka edobere na FALSE:

$cfg['Servers'][$i]['AllowRoot'] = FALSE;

Na Ubuntu/Debian, ịkwesịrị ịgbakwunye ahịrị abụọ a dị ka egosiri:

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['AllowRoot'] = false;

Chekwa mgbanwe wee malite Apache.

------------- On CentOS/RHEL Systems -------------
# systemctl restart httpd.service

------------- On Debian/Ubuntu Systems -------------
# systemctl restart apache2.service

Soro usoro ndị akọwapụtara na ndụmọdụ ndị a dị n'elu iji banye na ibe nbanye phpmyadmin (https:///phpmyadmin) wee gbalịa ịbanye dị ka mgbọrọgwụ:

Mgbe ahụ jikọọ na MySQL/MariaDB nchekwa data site na iwu ozugbo na, na-eji nzere mgbọrọgwụ, mepụta ọtụtụ akaụntụ dịka ọ dị mkpa iji nweta otu nchekwa data ọ bụla. N'okwu a, anyị ga-emepụta akaụntụ aha ya bụ jdoe nwere paswọọdụ jdoespassword:

# mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 24
Server version: 10.1.14-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> CREATE USER 'jdoe'@'localhost' IDENTIFIED BY 'jdoespassword';
Query OK, 0 rows affected (0.04 sec)

MariaDB [(none)]> GRANT ALL PRIVILEGES ON gestion.* to 'jdoe'@'localhost';
Query OK, 0 rows affected (0.00 sec)

Mgbe ahụ, ka anyị jiri nzere ndị dị n'elu banye. Dịka ị na-ahụ, akaụntụ a nwere naanị otu nchekwa data:

Ekele! Ị nwere nkwarụ ohere ịnweta mgbọrọgwụ phpmyadmin gị ma nwee ike iji ya ugbu a iji jikwaa ọdụ data gị.

Ana m akwado gị ka ị gbakwunye nchekwa nchekwa phpmyadmin gị yana HTTPS ntọala (akwụkwọ SSL) iji zere izipu aha njirimara na paswọọdụ n'ụdị ederede doro anya na netwọkụ.