Jump to content

как настроить и установить phpMyAdmin для множества сайтов?


Recommended Posts

Под одним логином для доступа в phpmyadmin создаем разные БД для каждого сайта.
Ничего особого настраивать и устанавливать не надо, если пользуетесь более-менее нормальным хостингом.

Link to post
Share on other sites
1 час назад, Eserador сказал:

Под одним логином для доступа в phpmyadmin создаем разные БД для каждого сайта.
Ничего особого настраивать и устанавливать не надо, если пользуетесь более-менее нормальным хостингом.

Можно и под разными логинами, так безопаснее и правильнее. Тогда при входе через phpmyamin останется только указывать разные пары логин-пароль для разных сайтов, и все.

Link to post
Share on other sites
57 минут назад, fans сказал:

Можно и под разными логинами, так безопаснее и правильнее. Тогда при входе через phpmyamin останется только указывать разные пары логин-пароль для разных сайтов, и все.

Ну да, так однозначно лучше и правильнее)) Но, как я понял (возможно, не правильно), что ТСа интересовал вариант с одним логином))

Link to post
Share on other sites
10 минут назад, Eserador сказал:

Ну да, так однозначно лучше и правильнее)) Но, как я понял (возможно, не правильно), что ТСа интересовал вариант с одним логином))

Через скрипт делаем аналог "adm/pass" как при смене почтовых логинов гугл/яндекс.

Link to post
Share on other sites

Устанавливаете скрипт phpMyAdmin в произвольную папку (в рамках одного аккаунта), далее настраиваете алиас:
если у вас Apache, то смотрите в сторону директив Alias, AliasMatch; на Nginx также есть директива alias.
Перезапускаете Apache/Nginx и все заработает) Про синтаксис и примеры - загуглите.

Есть вариант проще: в www директории делаете символическую ссылку (например, pma), которая ведет к phpMyAdmin

Link to post
Share on other sites

Самый простой и правильный способ - без алиасов и символических ссылок. Устанавливайте прямо в www/pma (речь об отдельном сайте, а не об урле /pma).

Link to post
Share on other sites

С phpMyAdmin это не связано. Для этого вам нужно Web-сервер настраивать. А в phpMyAdmin вы просто создаете для каждого сайта (которому это необходимо) отдельного пользователя и базу данных (с одинаковыми именами), как выше уже писали.

Link to post
Share on other sites

sudo pecl install mcrypt-1.0.1
[sudo] пароль для php:

Warning: Invalid argument supplied for foreach() in Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Notice: Undefined index: honorsbaseinstall in Role.php on line 173
PHP Notice:  Undefined index: honorsbaseinstall in /usr/share/php/PEAR/Installer/Role.php on line 173

Notice: Undefined index: honorsbaseinstall in Role.php on line 173
PHP Notice:  Undefined index: honorsbaseinstall in /usr/share/php/PEAR/Installer/Role.php on line 173

Notice: Undefined index: honorsbaseinstall in Role.php on line 173
PHP Notice:  Undefined index: honorsbaseinstall in /usr/share/php/PEAR/Installer/Role.php on line 173

Notice: Undefined index: honorsbaseinstall in Role.php on line 173
PHP Notice:  Undefined index: honorsbaseinstall in /usr/share/php/PEAR/Installer/Role.php on line 173

Notice: Undefined index: honorsbaseinstall in Role.php on line 173
PHP Notice:  Undefined index: honorsbaseinstall in /usr/share/php/PEAR/Installer/Role.php on line 173

Notice: Undefined index: honorsbaseinstall in Role.php on line 173
PHP Notice:  Undefined index: honorsbaseinstall in /usr/share/php/PEAR/Installer/Role.php on line 173

Notice: Undefined index: honorsbaseinstall in Role.php on line 173
PHP Notice:  Undefined index: honorsbaseinstall in /usr/share/php/PEAR/Installer/Role.php on line 173

Notice: Undefined index: honorsbaseinstall in Role.php on line 173
PHP Notice:  Undefined index: honorsbaseinstall in /usr/share/php/PEAR/Installer/Role.php on line 173

Notice: Undefined index: honorsbaseinstall in Role.php on line 173
PHP Notice:  Undefined index: honorsbaseinstall in /usr/share/php/PEAR/Installer/Role.php on line 173

Notice: Undefined index: honorsbaseinstall in Role.php on line 173
PHP Notice:  Undefined index: honorsbaseinstall in /usr/share/php/PEAR/Installer/Role.php on line 173

Notice: Undefined index: installable in Role.php on line 139
PHP Notice:  Undefined index: installable in /usr/share/php/PEAR/Installer/Role.php on line 139

Notice: Undefined index: installable in Role.php on line 139
PHP Notice:  Undefined index: installable in /usr/share/php/PEAR/Installer/Role.php on line 139

Notice: Undefined index: installable in Role.php on line 139
PHP Notice:  Undefined index: installable in /usr/share/php/PEAR/Installer/Role.php on line 139

Notice: Undefined index: installable in Role.php on line 139
PHP Notice:  Undefined index: installable in /usr/share/php/PEAR/Installer/Role.php on line 139

Notice: Undefined index: installable in Role.php on line 139
PHP Notice:  Undefined index: installable in /usr/share/php/PEAR/Installer/Role.php on line 139

Notice: Undefined index: installable in Role.php on line 139
PHP Notice:  Undefined index: installable in /usr/share/php/PEAR/Installer/Role.php on line 139

Notice: Undefined index: installable in Role.php on line 139
PHP Notice:  Undefined index: installable in /usr/share/php/PEAR/Installer/Role.php on line 139

Notice: Undefined index: installable in Role.php on line 139
PHP Notice:  Undefined index: installable in /usr/share/php/PEAR/Installer/Role.php on line 139

Notice: Undefined index: installable in Role.php on line 139
PHP Notice:  Undefined index: installable in /usr/share/php/PEAR/Installer/Role.php on line 139

Notice: Undefined index: installable in Role.php on line 139
PHP Notice:  Undefined index: installable in /usr/share/php/PEAR/Installer/Role.php on line 139

Notice: Undefined index: phpfile in Role.php on line 204
PHP Notice:  Undefined index: phpfile in /usr/share/php/PEAR/Installer/Role.php on line 204

Notice: Undefined index: phpfile in Role.php on line 204
PHP Notice:  Undefined index: phpfile in /usr/share/php/PEAR/Installer/Role.php on line 204

Notice: Undefined index: phpfile in Role.php on line 204
PHP Notice:  Undefined index: phpfile in /usr/share/php/PEAR/Installer/Role.php on line 204

Notice: Undefined index: phpfile in Role.php on line 204
PHP Notice:  Undefined index: phpfile in /usr/share/php/PEAR/Installer/Role.php on line 204

Notice: Undefined index: phpfile in Role.php on line 204
PHP Notice:  Undefined index: phpfile in /usr/share/php/PEAR/Installer/Role.php on line 204

Notice: Undefined index: phpfile in Role.php on line 204
PHP Notice:  Undefined index: phpfile in /usr/share/php/PEAR/Installer/Role.php on line 204

Notice: Undefined index: phpfile in Role.php on line 204
PHP Notice:  Undefined index: phpfile in /usr/share/php/PEAR/Installer/Role.php on line 204

Notice: Undefined index: phpfile in Role.php on line 204
PHP Notice:  Undefined index: phpfile in /usr/share/php/PEAR/Installer/Role.php on line 204

Notice: Undefined index: phpfile in Role.php on line 204
PHP Notice:  Undefined index: phpfile in /usr/share/php/PEAR/Installer/Role.php on line 204

Notice: Undefined index: phpfile in Role.php on line 204
PHP Notice:  Undefined index: phpfile in /usr/share/php/PEAR/Installer/Role.php on line 204

Notice: Undefined index: config_vars in Role.php on line 46
PHP Notice:  Undefined index: config_vars in /usr/share/php/PEAR/Installer/Role.php on line 46

Notice: Undefined index: config_vars in Role.php on line 46
PHP Notice:  Undefined index: config_vars in /usr/share/php/PEAR/Installer/Role.php on line 46

Notice: Undefined index: config_vars in Role.php on line 46
PHP Notice:  Undefined index: config_vars in /usr/share/php/PEAR/Installer/Role.php on line 46

Notice: Undefined index: config_vars in Role.php on line 46
PHP Notice:  Undefined index: config_vars in /usr/share/php/PEAR/Installer/Role.php on line 46

Notice: Undefined index: config_vars in Role.php on line 46
PHP Notice:  Undefined index: config_vars in /usr/share/php/PEAR/Installer/Role.php on line 46

Notice: Undefined index: config_vars in Role.php on line 46
PHP Notice:  Undefined index: config_vars in /usr/share/php/PEAR/Installer/Role.php on line 46

Notice: Undefined index: config_vars in Role.php on line 46
PHP Notice:  Undefined index: config_vars in /usr/share/php/PEAR/Installer/Role.php on line 46

Notice: Undefined index: config_vars in Role.php on line 46
PHP Notice:  Undefined index: config_vars in /usr/share/php/PEAR/Installer/Role.php on line 46

Notice: Undefined index: config_vars in Role.php on line 46
PHP Notice:  Undefined index: config_vars in /usr/share/php/PEAR/Installer/Role.php on line 46

Notice: Undefined index: config_vars in Role.php on line 46
PHP Notice:  Undefined index: config_vars in /usr/share/php/PEAR/Installer/Role.php on line 46

Warning: Invalid argument supplied for foreach() in PEAR/Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in PEAR/Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in PEAR/Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in PEAR/Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in PEAR/Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in PEAR/Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in PEAR/Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in PEAR/Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in PEAR/Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in PEAR/Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249

Warning: Invalid argument supplied for foreach() in PEAR/Command.php on line 249
PHP Warning:  Invalid argument supplied for foreach() in /usr/share/php/PEAR/Command.php on line 249
XML Extension not found

Link to post
Share on other sites

попробовал вордпресс загрузить
пишет
Ошибка установки соединения с базой данных


define( 'DB_NAME', 'root' );

/** Имя пользователя MySQL */
define( 'DB_USER', 'word' );

/** Пароль к базе данных MySQL */
define( 'DB_PASSWORD', '55555' );

/** Имя сервера MySQL */
define( 'DB_HOST', 'localhost' );

/** Кодировка базы данных для создания таблиц. */
define( 'DB_CHARSET', 'utf8' );

/** Схема сопоставления. Не меняйте, если не уверены. */
define( 'DB_COLLATE', '' );

Link to post
Share on other sites

Что-то все пишут про сложные способы установки, а я всегда делал через apt-get install phpmyadmin. И никаких плясок с бубнами и настройками, все сразу работает по адресу ip-сервера/phpmyadmin

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...