Bii o ṣe le Muu Wiwọle Iwọle root si PhpMyAdmin

Ti o ba n gbero lori lilo phpmyadmin ni igbagbogbo lati ṣakoso awọn apoti isura data rẹ lori nẹtiwọọki (tabi buru, lori Intanẹẹti!), Iwọ ko fẹ lo akọọlẹ gbongbo. Eyi wulo nikan kii ṣe fun phpmyadmin ṣugbọn tun fun eyikeyi wiwo orisun wẹẹbu miiran.

Ninu /etc/phpmyadmin/config.inc.php , wa laini atẹle ki o rii daju pe itọsọna AllowRoot ti ṣeto si FALSE:

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

Ni Ubuntu/Debian, o nilo lati ṣafikun awọn ila meji wọnyi bi o ṣe han:

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

Fipamọ awọn ayipada ki o tun bẹrẹ Apache.

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

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

Lẹhinna tẹle awọn igbesẹ ti a ṣe ilana ninu awọn imọran ti o wa loke lati wa si oju-iwe wiwọle phpmyadmin ( https://phpmyadmin ) ati Gbiyanju lati buwolu wọle bi gbongbo:

Lẹhinna sopọ si ibi ipamọ data MySQL/MariaDB rẹ nipasẹ aṣẹ aṣẹ ati, ni lilo awọn iwe eri root, ṣẹda ọpọlọpọ awọn akọọlẹ bi o ṣe nilo lati wọle si ibi ipamọ data kọọkan kọọkan. Ni ọran yii a yoo ṣẹda akọọlẹ ti a npè ni jdoe pẹlu ọrọigbaniwọle 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)

Lẹhinna jẹ ki a buwolu wọle nipa lilo awọn iwe eri ti o wa loke. Bi o ti le rii, akọọlẹ yii ni iraye si ibi-ipamọ data nikan:

Oriire! O ti ni iraye si gbongbo si fifi sori ẹrọ rẹ phpmyadmin ati pe o le lo bayi lati ṣakoso awọn apoti isura data rẹ.

Mo gba ọ niyanju ni iyanju lati ṣafikun Layer ti aabo si fifi sori rẹ phpmyadmin pẹlu iṣeto HTTPS (ijẹrisi SSL) lati yago fun fifiranṣẹ orukọ olumulo ati ọrọ igbaniwọle ni ọna kika ọrọ pẹtẹlẹ lori nẹtiwọọki.