|
Устанавливаем PHPMyAdmin: # cd /usr/ports/databases/phpmyadmin # make install clean В опциях включаем:[X] MYSQLI Improved MySQL support # cd /usr/local/www/phpMyAdmin # cp config.sample.inc.php config.inc.php Правим: # ee config.inc.php $cfg['blowfish_secret'] = 'Password'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ $cfg['Servers'][$i]['controluser'] = 'mysqluser'; $cfg['Servers'][$i]['controlpass'] = 'password'; Редактируем:# ee /usr/local/etc/apache22/httpd.conf AllowOverride None Order deny,allow Deny from all
Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"
<Directory "/usr/local/www/phpMyAdmin/"> Options none AllowOverride Limit
Order Deny,Allow Deny from all Allow from 127.0.0.1 .example.com </Directory> Рестартуем Apache:
# apachectl restart Создадим суперпользователя для MySQL:
# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> GRANT ALL PRIVILEGES ON *.* TO mysqluser@localhost IDENTIFIED BY 'password' WITH GRANT OPTION; Query OK, 0 rows affected (0.08 sec)
mysql> quit Bye Заходим: http://domain.xxx/phpmyadmin
|