Система
Код: Выделить всё
#uname -v
FreeBSD 6.2-RELEASE #4: Sun Apr 13 20:08:23 PETST 2008Код: Выделить всё
#pkg_info | grep mysql
courier-authlib-mysql-0.58_2 MySQL support for the Courier authentication library
mysql-client-5.0.27 Multithreaded SQL database (client)
mysql-server-5.0.27 Multithreaded SQL database (server)
php5-mysql-5.1.6_3 The mysql shared extension for php
php5-mysqli-5.1.6_3 The mysqli shared extension for php
Код: Выделить всё
# Там где лежит копии my.cnf
# /etc/my.cnf
# /var/db/mysql/my.cnf
# /usr/local/etc/my.cnf
[client]
# Пароль для подключения к БД
#password = your_password
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
bind-address = 127.0.0.1
socket = /tmp/mysql.sock
skip-locking
# /etc/my.cnf
# /var/db/mysql/my.cnf
# /usr/local/etc/my.cnf
[client]
# Пароль для подключения к БД
#password = your_password
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
bind-address = 127.0.0.1
socket = /tmp/mysql.sock
skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
skip-networking
skip-innodb
skip-bdb
server-id = 1
log = /var/log/mysql.log
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 8M
sort_buffer_size = 8M
[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
interactive-timeout
Ставлю phpMyAdmin
Код: Выделить всё
#cd /usr/ports/databases/phpmyadmin/
#make config
[X] BZ2 bzip2 library support
[X] GD GD library support
[X] MYSQLI Improved MySQL support
[ ] 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
#make && make install && make clean
Код: Выделить всё
phpMyAdmin-2.9.0.2 has been installed into:
/usr/local/www/phpMyAdmin
Please edit config.inc.php to suit your needs.
To make phpMyAdmin available through your web site, I suggest
that you add something like the following to httpd.conf:
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>
#один локальный ип
#другой публичный чтобы из дома можно было ходить (ип не настоящий)
Код: Выделить всё
#ee /usr/local/etc/apache2/httpd.conf
Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"
<Directory "/usr/local/www/phpMyAdmin/">
Options none
AllowOverride Limit
Order Deny,Allow
Deny from all
Allow from 192.168.0.2
Allow from 86.22.248.229
#Allow from 127.0.0.1 .example.com
</Directory>
Код: Выделить всё
<?php
$i = 0;
$i++;
$cfg['Servers'][$i]['host'] = 'http://192.168.0.1';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'password'; // Пароль пользователя root
?>
Код: Выделить всё
/usr/local/sbin/apachectl configtest
Syntax OK
Апач рестарт
Код: Выделить всё
#/usr/local/etc/rc.d/apache2.sh restart
Performing sanity check on apache2 configuration:
Syntax OK
Stopping apache2.
Waiting for PIDS: 754.
Starting apache2.
Код: Выделить всё
#ee /etc/ipfw.work
#Открываем с глобала и Локала порт для работы с mysql 3306
${FwCMD} add allow tcp from 192.168.0.2 to ${IpOut} 3306 via ${LanOut}
${FwCMD} add allow tcp from 86.22.248.229 to ${IpOut} 3306 via ${LanOut}
Код: Выделить всё
shutdown -r now
))