Ativando o Modo Designer do phpMyAdmin

Question

Ativando o Modo Designer do phpMyAdmin

#1 resposta do (1 votos)
#2 resposta do (1 votos)

1

Eu tenho tentado por horas ativar o modo de designer do phpMyAdmin em um servidor dedicado do CentOS cPanel sem sorte ... aqui estão os passos que eu segui, talvez eu esteja perdendo alguma coisa?

Eu criei o usuário pma e concedi permissão adequada à tabela phpmyadmin :

GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY '?????';
GRANT SELECT (
    Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
    Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
    File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
    Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
    Execute_priv, Repl_slave_priv, Repl_client_priv
    ) ON mysql.user TO 'pma'@'localhost';
GRANT SELECT ON mysql.db TO 'pma'@'localhost';
GRANT SELECT ON mysql.host TO 'pma'@'localhost';
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
    ON mysql.tables_priv TO 'pma'@'localhost';

Eu modifiquei config.inc.php para definir os nomes de usuários e tabelas:

...
/* User used to manipulate with storage */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '?????';

/* Storage database and tables */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
...

Alguma idéia do que eu poderia estar perdendo?

Obrigado!

ATUALIZAÇÃO: Após abrir um ticket com minha empresa de hospedagem / phpMyAdmin, percebi que não deixei claro que eu corri o create_tables.sql em /usr/local/cpanel/base/3rdparty/phpMyAdmin/scripts

mysql centos

por Mikey1980 02.08.2011 / 17:48

2 respostas

1

Para qualquer pessoa que visite aqui procurando respostas, isso não responde a essa pergunta, mas ajuda outras pessoas.

você provavelmente seguiu um tutorial e definiu o arquivo de configuração de acordo, mas a consulta que você encontrou estava desatualizada para o mysql abaixo de 4.1.2.

Esta é a consulta que você deve usar para o mysql acima de 5:

    -- --------------------------------------------------------
-- SQL Commands to set up the pmadb as described in Documentation.html.
-- 
-- This file is meant for use with MySQL 5 and above!
-- 
-- This script expects the user pma to already be existing. If we would put a
-- line here to create him too many users might just use this script and end
-- up with having the same password for the controluser.
--                                                     
-- This user "pma" must be defined in config.inc.php (controluser/controlpass)                         
--                                                  
-- Please don't forget to set up the tablenames in config.inc.php                                 
-- 

-- --------------------------------------------------------

-- 
-- Database : 'phpmyadmin'
-- 
CREATE DATABASE IF NOT EXISTS 'phpmyadmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
USE phpmyadmin;

-- --------------------------------------------------------

-- 
-- Privileges
-- 
-- (activate this statement if necessary)
-- GRANT SELECT, INSERT, DELETE, UPDATE ON 'phpmyadmin'.* TO
--    'pma'@localhost;

-- --------------------------------------------------------

-- 
-- Table structure for table 'pma_bookmark'
-- 

CREATE TABLE IF NOT EXISTS 'pma_bookmark' (
  'id' int(11) NOT NULL auto_increment,
  'dbase' varchar(255) NOT NULL default '',
  'user' varchar(255) NOT NULL default '',
  'label' varchar(255) COLLATE utf8_general_ci NOT NULL default '',
  'query' text NOT NULL,
  PRIMARY KEY  ('id')
)
  ENGINE=MyISAM COMMENT='Bookmarks'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- 
-- Table structure for table 'pma_column_info'
-- 

CREATE TABLE IF NOT EXISTS 'pma_column_info' (
  'id' int(5) unsigned NOT NULL auto_increment,
  'db_name' varchar(64) NOT NULL default '',
  'table_name' varchar(64) NOT NULL default '',
  'column_name' varchar(64) NOT NULL default '',
  'comment' varchar(255) COLLATE utf8_general_ci NOT NULL default '',
  'mimetype' varchar(255) COLLATE utf8_general_ci NOT NULL default '',
  'transformation' varchar(255) NOT NULL default '',
  'transformation_options' varchar(255) NOT NULL default '',
  PRIMARY KEY  ('id'),
  UNIQUE KEY 'db_name' ('db_name','table_name','column_name')
)
  ENGINE=MyISAM COMMENT='Column information for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- 
-- Table structure for table 'pma_history'
-- 

CREATE TABLE IF NOT EXISTS 'pma_history' (
  'id' bigint(20) unsigned NOT NULL auto_increment,
  'username' varchar(64) NOT NULL default '',
  'db' varchar(64) NOT NULL default '',
  'table' varchar(64) NOT NULL default '',
  'timevalue' timestamp NOT NULL,
  'sqlquery' text NOT NULL,
  PRIMARY KEY  ('id'),
  KEY 'username' ('username','db','table','timevalue')
)
  ENGINE=MyISAM COMMENT='SQL history for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- 
-- Table structure for table 'pma_pdf_pages'
-- 

CREATE TABLE IF NOT EXISTS 'pma_pdf_pages' (
  'db_name' varchar(64) NOT NULL default '',
  'page_nr' int(10) unsigned NOT NULL auto_increment,
  'page_descr' varchar(50) COLLATE utf8_general_ci NOT NULL default '',
  PRIMARY KEY  ('page_nr'),
  KEY 'db_name' ('db_name')
)
  ENGINE=MyISAM COMMENT='PDF relation pages for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

--
-- Table structure for table 'pma_recent'
--

CREATE TABLE IF NOT EXISTS 'pma_recent' (
  'username' varchar(64) NOT NULL,
  'tables' text NOT NULL,
  PRIMARY KEY ('username')
)
  ENGINE=MyISAM COMMENT='Recently accessed tables'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

--
-- Table structure for table 'pma_table_uiprefs'
--

CREATE TABLE IF NOT EXISTS 'pma_table_uiprefs' (
  'username' varchar(64) NOT NULL,
  'db_name' varchar(64) NOT NULL,
  'table_name' varchar(64) NOT NULL,
  'prefs' text NOT NULL,
  'last_update' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY ('username','db_name','table_name')
)
  ENGINE=MyISAM COMMENT='Tables'' UI preferences'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- 
-- Table structure for table 'pma_relation'
-- 

CREATE TABLE IF NOT EXISTS 'pma_relation' (
  'master_db' varchar(64) NOT NULL default '',
  'master_table' varchar(64) NOT NULL default '',
  'master_field' varchar(64) NOT NULL default '',
  'foreign_db' varchar(64) NOT NULL default '',
  'foreign_table' varchar(64) NOT NULL default '',
  'foreign_field' varchar(64) NOT NULL default '',
  PRIMARY KEY  ('master_db','master_table','master_field'),
  KEY 'foreign_field' ('foreign_db','foreign_table')
)
  ENGINE=MyISAM COMMENT='Relation table'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- 
-- Table structure for table 'pma_table_coords'
-- 

CREATE TABLE IF NOT EXISTS 'pma_table_coords' (
  'db_name' varchar(64) NOT NULL default '',
  'table_name' varchar(64) NOT NULL default '',
  'pdf_page_number' int(11) NOT NULL default '0',
  'x' float unsigned NOT NULL default '0',
  'y' float unsigned NOT NULL default '0',
  PRIMARY KEY  ('db_name','table_name','pdf_page_number')
)
  ENGINE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- 
-- Table structure for table 'pma_table_info'
-- 

CREATE TABLE IF NOT EXISTS 'pma_table_info' (
  'db_name' varchar(64) NOT NULL default '',
  'table_name' varchar(64) NOT NULL default '',
  'display_field' varchar(64) NOT NULL default '',
  PRIMARY KEY  ('db_name','table_name')
)
  ENGINE=MyISAM COMMENT='Table information for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- 
-- Table structure for table 'pma_designer_coords'
-- 

CREATE TABLE IF NOT EXISTS 'pma_designer_coords' (
  'db_name' varchar(64) NOT NULL default '',
  'table_name' varchar(64) NOT NULL default '',
  'x' INT,
  'y' INT,
  'v' TINYINT,
  'h' TINYINT,
  PRIMARY KEY ('db_name','table_name')
)
  ENGINE=MyISAM COMMENT='Table coordinates for Designer'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

-- 
-- Table structure for table 'pma_tracking'
-- 

CREATE TABLE IF NOT EXISTS 'pma_tracking' (
  'db_name' varchar(64) NOT NULL,
  'table_name' varchar(64) NOT NULL,
  'version' int(10) unsigned NOT NULL,
  'date_created' datetime NOT NULL,
  'date_updated' datetime NOT NULL,
  'schema_snapshot' text NOT NULL,
  'schema_sql' text,
  'data_sql' longtext,
  'tracking' set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') default NULL,
  'tracking_active' int(1) unsigned NOT NULL default '1',
  PRIMARY KEY  ('db_name','table_name','version')
)
  ENGINE=MyISAM ROW_FORMAT=COMPACT COMMENT='Database changes tracking for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

-- --------------------------------------------------------

--
-- Table structure for table 'pma_userconfig'
--

CREATE TABLE IF NOT EXISTS 'pma_userconfig' (
  'username' varchar(64) NOT NULL,
  'timevalue' timestamp NOT NULL,
  'config_data' text NOT NULL,
  PRIMARY KEY  ('username')
)
  ENGINE=MyISAM COMMENT='User preferences storage for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

por 02.01.2013 / 12:02

Tags mysql centos

ZFS no FreeBSD: atualize de 7.x para 8.2? Controlador de Domínio, Servidor DNS e OpenDNS - Usuário do Bloco 1?

score 1 · Accepted Answer

Eu fiz isso na semana passada (em uma caixa do Windows, mas ainda assim o phpMyAdmin) e havia um aviso dizendo que você deveria sair do phpMyAdmin e logar novamente para o arquivo de configuração ser relido - que parecia fazer o truque para mim.

Se o pior acontecer, você pode tentar usar o Apache - eu tive que fazer isso algumas vezes antes para pegar as alterações de configuração do phpMyAdmin, mas reconhecidamente era um servidor com problemas de saúde.