ISPManager - Debian - phpmyadmin - ошибка при указании соединения для controluser в конфигурации


Материал из Wiki - Iphoster - 'the best ever support'

Перейти к: навигация, поиск

Самые выгодные сервера в рунете


ISPManager - Debian - phpmyadmin - ошибка при указании соединения для controluser в конфигурации

Ошибки вида

ошибка при указании соединения для controluser в конфигурации
Дополнительные возможности phpMyAdmin не настроены в полной мере, некоторые функции были отключены.
configuration storage and some extended features
The phpMyAdmin configuration storage  is not completely configured, some extended features have been deactivated

решаются через патч. Для Debian:

  # vi ~/.my.cnf
  [client]
 user = root
 password = mysql_root_pass_here
  # wget -c https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-debian.sh
  #  sh pma-debian.sh


Для CentOS:

  # vi ~/.my.cnf
  [client]
 user = root
 password = mysql_root_pass_here
  # https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-centos.sh
  #  sh pma-centos.sh



# sh pma-debian.sh
Phpmyadmin fixes for configuration storage and some  extended features
................
Let's do it
............
..........
.........
........
......
Generate password for PMA (pma.txt)
PMA Password = CkRoTPuRunxP6QGNpUWAKIhGDzUU5Efs
Download tables for our mysql server
--2016-04-05 06:03:36--  https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/create_tables.sql
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 185.31.19.133
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|185.31.19.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 11912 (12K) [text/plain]
Saving to: `create_tables.sql'
100%[ ===========================================================================================================>] 11,912      --.-K/s   in 0s
2016-04-05 06:03:38 (269 MB/s) - `create_tables.sql' saved [11912/11912]
Download via wget
--2016-04-05 06:03:38--  https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/create_tables.sql 
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 185.31.19.133
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|185.31.19.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 11912 (12K) [text/plain]
Saving to: `create_tables.sql.1'
100%  [=================================================================================== ========================>] 11,912      --.-K/s   in 0s
2016-04-05 06:03:40 (228 MB/s) - `create_tables.sql.1' saved [11912/11912]
Download via curl
 % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                Dload  Upload   Total   Spent    Left  Speed
100 11912  100 11912    0     0  82799      0 --:--:-- --:--:-- --:--:-- 93062
Delete temp files
Индекс цитирования