background image

20. phpMyAdmin

Äëÿ òîãî, ÷òîá àäìèíèñòðèðîâàòü MySQL ïðè ïîìîùè web èíòåðôåéñà,

ëó÷øå âñåãî ïîäõîäèò phpMyAdmin.

20.1. Óñòàíîâêà phpMyAdmin

Äëÿ åãî óñòàíîâêè íóæíî ñäåëàòü ñëåäóþùèå øàãè:

% cd /usr/ports/databases/phpmyadmin

% make config

Ïîñëå ýòîãî ïîÿâèòñÿ ýêðàí êîíôèãóðàöèè, íà êîòîðîì íóæíî âûáðàòü

îïöèè. Îáðàòèòå âíèìàíèå, ÷òî íóæíî óáðàòü îïöèþ PDF (ïîääåðæêà PDFLib)

è GD (íà íà÷àëüíîì ýòàïå âàì ýòî íå ïîíàäîáèòñÿ).

+--------------------------------------------------------------------+

|

Options for phpMyAdmin 2.11.4

|

| +----------------------------------------------------------------+ |

| |

[X] BZ2

bzip2 library support

| |

| |

[ ] GD

GD library support

| |

| |

[ ] MYSQLI

Improved MySQL support

| |

| |

[X] OPENSSL

OpenSSL support

| |

| |

[ ] PDF

PDFlib support (implies GD)

| |

| |

[X] ZLIB

ZLIB support

| |

| |

[X] MCRYPT

MCrypt library support

| |

| |

[X] MBSTRING Multi-byte character-set string support

| |

| |

| |

| |

| |

| |

| |

| |

| |

| |

| |

| |

| |

| |

| |

+-+----------------------------------------------------------------+-+

|

[ OK ]

Cancel

|

+--------------------------------------------------------------------+

Ïîñëå ýòîãî óñòàíîâèòå ïàêåò ïðè ïîìîùè
make install

Ïîñëå òîãî, êàê ïðîöåññ óñòàíîâêè çàâåðøèòüñÿ, âàì íåîáõîäèìî äîáà-

âèòü phpMyAdmin â êîíôèãóðàöèþ apache ñåðâåðà.

Îòêðîéòå ôàéë /usr/local/etc/apache/httpd.conf â ðåäàêòîðå, íàé-

äèòå â íåì ñòðî÷êó

### Section 3: Virtual Hosts

Îíà íàõîäèòñÿ â êîíöå ôàéëà.

Ïåðåä ýòîé ñòðî÷êîé äîáàâüòå ñòðî÷êè êîíôèãóðàöèè phpMyAdmin,

êàê è ïðåäëàãàë ýòîò ïàêåò ïîñëå èíñòàëÿöèè.

Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"

<Directory "/usr/local/www/phpMyAdmin/">

79