phpMyAdmin

Szaisztok

A következõkben kérném a segítségeteket.
Adva van egy suse 9.1 rendszer fut rajta apache és phpmyadmin.
Minden nagyon jó müködik csak a phpmyadmin nem tudom normálisan beálítani,hogy kérjen usert ést passt. Iletve ha átálítom ezt a sort

$cfg[$i]     = ‘config’; http re

és ha  Privilégiumokban adok pass a root nak akkor feldob egy bejelentkezési ablakot,amibe be tudok jelenkezni,de én ugy szeretném mint pl itt http://phpmyadmin.srv.hu/ egy ilyen megoldás lenne számomra a jó megoldás.
Tehát ha valaki tudna nekem ebbe segíteni azt nagyon megköszöném.

Elõre is köszönöm a seegítséget  😀
[align=right][snapback]88389[/snapback][/align]

$cfg[$i] = ‘config’; cookie -ra
és
$cfg = ‘True’;

Ui.
Ha sikerült belépned illeszd ide a configod, mert nekem bejön ugyan amit kívántál, de a
belépés nem mûxik!
Már nincs több ötletem.

Itt a configom

= 4.3.0)
$cfg[$i] = ”; // MySQL control user settings
// (this user must have read-only
$cfg[$i] = ”; // access to the „mysql/user”
// and „mysql/db” tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg[$i] = ‘config’; cookie // Authentication method (config, http or cookie based)?
$cfg[$i] = ‘root’; // MySQL user
$cfg[$i] = ”; // MySQL password (only needed
// with ‘config’ auth_type)
$cfg[$i] = ”; // If set to a db-name, only
// this db is displayed in left frame
// It may also be an array of db-names, where sorting order is relevant.
$cfg[$i] = ”; // Verbose name for this host – leave blank to show the hostname

$cfg[$i] = ”; // Database used for Relation, Bookmark and PDF Features
// (see scripts/create_tables.sql)
// – leave blank for no support
// DEFAULT: ‘phpmyadmin’
$cfg[$i] = ”; // Bookmark table
// – leave blank for no bookmark support
// DEFAULT: ‘pma_bookmark’
$cfg[$i] = ”; // table to describe the relation between links (see doc)
// – leave blank for no relation-links support
// DEFAULT: ‘pma_relation’
$cfg[$i] = ”; // table to describe the display fields
// – leave blank for no display fields support
// DEFAULT: ‘pma_table_info’
$cfg[$i] = ”; // table to describe the tables position for the PDF schema
// – leave blank for no PDF schema support
// DEFAULT: ‘pma_table_coords’
$cfg[$i] = ”; // table to describe pages of relationpdf
// – leave blank if you don’t want to use this
// DEFAULT: ‘pma_pdf_pages’
$cfg[$i] = ”; // table to store column information
// – leave blank for no column comments/mime types
// DEFAULT: ‘pma_column_info’
$cfg[$i] = ”; // table to store SQL history
// – leave blank for no SQL query history
// DEFAULT: ‘pma_history’
$cfg[$i] = TRUE; // set to FALSE if you know that your pma_* tables
// are up to date. This prevents compatibility
// checks and thereby increases performance.
$cfg[$i] // Host authentication order, leave blank to not use
= ”;
$cfg[$i] // Host authentication rules, leave blank for defaults
= array();

$i++;
$cfg[$i] = ”;
$cfg[$i] = ”;
$cfg[$i] = ”;
$cfg[$i] = ‘tcp’;
$cfg[$i] = FALSE;
$cfg[$i] = ”;
$cfg[$i] = ”;
$cfg[$i] = ‘http’;
$cfg[$i] = ‘root’;
$cfg[$i] = ”;
$cfg[$i] = ”;
$cfg[$i] = ”;
$cfg[$i] = ”; // ‘phpmyadmin’ – see scripts/create_tables.sql
$cfg[$i] = ”; // ‘pma_bookmark’
$cfg[$i] = ”; // ‘pma_relation’
$cfg[$i] = ”; // ‘pma_table_info’
$cfg[$i] = ”; // ‘pma_table_coords’
$cfg[$i] = ”; // ‘pma_pdf_pages’
$cfg[$i] = ”; // ‘pma_column_info’
$cfg[$i] = ”; // ‘pma_history’
$cfg[$i] = TRUE;
$cfg[$i]
= ”;
$cfg[$i]
= array();

$i++;
$cfg[$i] = ”;
$cfg[$i] = ”;
$cfg[$i] = ”;
$cfg[$i] = ‘tcp’;
$cfg[$i] = FALSE;
$cfg[$i] = ”;
$cfg[$i] = ”;
$cfg[$i] = ‘http’;
$cfg[$i] = ‘root’;
$cfg[$i] = ”;
$cfg[$i] = ”;
$cfg[$i] = ”;
$cfg[$i] = ”; // ‘phpmyadmin’ – see scripts/create_tables.sql
$cfg[$i] = ”; // ‘pma_bookmark’
$cfg[$i] = ”; // ‘pma_relation’
$cfg[$i] = ”; // ‘pma_table_info’
$cfg[$i] = ”; // ‘pma_table_coords’
$cfg[$i] = ”; // ‘pma_pdf_pages’
$cfg[$i] = ”; // ‘pma_column_info’
$cfg[$i] = ”; // ‘pma_history’
$cfg[$i] = TRUE;
$cfg[$i]
= ”;
$cfg[$i]
= array();

// If you have more than one server configured, you can set $cfg
// to any one of them to autoconnect to that server when phpMyAdmin is started,
// or set it to 0 to be given a list of servers without logging in
// If you have only one server configured, $cfg *MUST* be
// set to that server.
$cfg = 1; // Default server (0 = no default server)
$cfg = ”;
unset($cfg[0]);

/**
* Other core phpMyAdmin settings
*/
$cfg = ‘auto’; // use GZIP output buffering if possible (TRUE|FALSE|’auto’)
$cfg = FALSE; // use persistent connections to MySQL database
$cfg = 300; // maximum execution time in seconds (0 for no limit)
$cfg = FALSE; // mark used tables, make possible to show
// locked tables (since MySQL 3.23.30)
$cfg = TRUE; // show SQL queries as run
$cfg = FALSE; // show a ‘Drop database’ link to normal users
$cfg = TRUE; // confirm ‘DROP TABLE’ & ‘DROP DATABASE’
$cfg = TRUE; // recall previous login in cookie auth. mode or not
$cfg = TRUE; // whether to enable the „database search” feature
// or not
$cfg = FALSE; // if set to true, PMA continues computing multiple-statement queries
// even if one of the queries failed
$cfg = TRUE; // if set to true, PMA will show the affected rows of EACH statement on
// multiple-statement queries. See the read_dump.php file for hardcoded
// defaults on how many queries a statement may contain!
$cfg = FALSE; // allow login to any user entered server in cookie based auth

// Left frame setup
$cfg = TRUE; // use a select-based menu and display only the
// current tables in the left frame.
$cfg= ‘__’; // Which string will be used to generate table prefixes
// to split tables into multiple categories
$cfg = ‘1’; // How many sublevels should be displayed when splitting
// up tables by the above Separator
$cfg = TRUE; // display table comment as tooltip in left frame
$cfg = FALSE; // if ShowToolTip is enabled, this defines that table/db comments
$cfg = FALSE; // are shown (in the left menu and db_details_structure) instead of
// table/db names

$cfg = TRUE; // display logo at top of left frame
$cfg = FALSE; // display server choice at top of left frame

// In the main frame, at startup…
$cfg = TRUE; // allow to display statistics and space usage in
// the pages about database details and table
// properties
$cfg = FALSE; // whether to display the „MySQL runtime
$cfg = FALSE; // information”, „MySQL system variables”, „PHP
$cfg = FALSE; // information” and „change password” links for
$cfg = FALSE; // simple users or not
$cfg = TRUE; // suggest a new DB name if possible (false = keep empty)

// In browse mode…
$cfg = FALSE; // display blob field contents
$cfg = TRUE; // do not display text inside navigation bar buttons
$cfg = FALSE; // allows to display all the rows
$cfg = 30; // maximum number of rows to display
$cfg = ‘ASC’; // default for ‘ORDER BY’ clause (valid
// values are ‘ASC’, ‘DESC’ or ‘SMART’ -ie
// descending order for fields of type
// TIME, DATE, DATETIME & TIMESTAMP,
// ascending order else-)

// In edit mode…
$cfg = ‘blob’; // disallow editing of binary fields
// valid values are:
// FALSE allow editing
// ‘blob’ allow editing except for BLOB fields
// ‘all’ disallow editing
$cfg = TRUE; // Display the function fields in edit/insert mode
$cfg = ‘input’;
// Which editor should be used for CHAR/VARCHAR fields:
// input – allows limiting of input length
// textarea – allows newlines in fields

// For the export features…
$cfg = TRUE; // Allow the use of zip/gzip/bzip
$cfg = TRUE; // compression for
$cfg = TRUE; // dump files
$cfg = TRUE; // Will compress gzip/bzip2 exports on
// fly without need for much memory.
// If you encounter problems with
// created gzip/bzip2 files disable
// this feature.

// Tabs display settings
$cfg = FALSE; // use graphically less intense menu tabs
$cfg = TRUE; // Use icons instead of text for the table display of a database (TRUE|FALSE|’both’)
$cfg = 1; // How many columns should be used for table display of a database?
// (a value larger than 1 results in some information being hidden)

$cfg = ‘main.php’;
// Possible values:
// ‘main.php’ = the welcome page
// (recommended for multiuser setups)
// ‘server_databases.php’ = list of databases
// ‘server_status.php’ = runtime information
// ‘server_variables.php’ = MySQL server variables
// ‘server_privileges.php’ = user management
// ‘server_processlist.php’ = process list
$cfg = ‘db_details_structure.php’;
// Possible values:
// ‘db_details_structure.php’ = tables list
// ‘db_details.php’ = sql form
// ‘db_search.php’ = search query
$cfg = ‘tbl_properties_structure.php’;
// Possible values:
// ‘tbl_properties_structure.php’ = fields list
// ‘tbl_properties.php’ = sql form
// ‘tbl_select.php = select page
// ‘tbl_change.php = insert row page

/**
* Export defaults
*/

$cfg = ‘sql’; // sql/latex/excel/csv/xml
$cfg = ‘none’; // none/zip/gzip/bzip2

$cfg = FALSE;
$cfg = FALSE;
$cfg = FALSE;
$cfg = TRUE;

$cfg = FALSE;
$cfg = ‘NULL’;
$cfg = ‘;’;
$cfg = ‘”‘;
$cfg = ‘\’;
$cfg = ‘AUTO’;
$cfg = FALSE;
$cfg = ‘NULL’;
$cfg = ‘win’; // win/mac

$cfg = TRUE;
$cfg = TRUE;
$cfg = TRUE;
$cfg = TRUE;
$cfg = TRUE;
$cfg = TRUE;
$cfg = ‘textit{NULL}’;
$cfg = TRUE;
$cfg = ‘tab:__TABLE__-data’;
$cfg = ‘tab:__TABLE__-structure’;

$cfg = TRUE;
$cfg = TRUE;
$cfg = FALSE;
$cfg = FALSE;
$cfg = TRUE;
$cfg = TRUE;
$cfg = FALSE;
$cfg = FALSE;
$cfg = FALSE;
$cfg = FALSE;
$cfg = ‘insert’; // insert/update/replace
$cfg = FALSE;
$cfg = FALSE;
$cfg = FALSE;

/**
* Link to the official MySQL documentation.
* Be sure to include no trailing slash on the path.
* See http://www.mysql.com/documentation/index.html for more information
* about MySQL manuals and their types.
*/
$cfg = ‘http://www.mysql.com/doc/en’;

/**
* Type of MySQL documentation:
* old – old style used in phpMyAdmin 2.3.0 and sooner
* searchable – „Searchable, with user comments”
* chapters – „HTML, one page per chapter”
* big – „HTML, all on one page”
* none – do not show documentation links
*/
$cfg = ‘searchable’;

/**
* PDF options
*/
$cfg = array(‘A3’, ‘A4’, ‘A5’, ‘letter’, ‘legal’);
$cfg = ‘A4’;

/**
* Language and charset conversion settings
*/
// Default language to use, if not browser-defined or user-defined
$cfg = ‘en-iso-8859-1’;

// Force: always use this language – must be defined in
// libraries/select_lang.lib.php
// $cfg = ‘en-iso-8859-1’;

// Default charset to use for recoding of MySQL queries, does not take
// any effect when charsets recoding is switched off by
// $cfg or in language file
// (see $cfg to possible choices, you can add your own)
$cfg = ‘iso-8859-1’;

// Allow charset recoding of MySQL queries, must be also enabled in language
// file to make harder using other language files than unicode.
// Default value is FALSE to avoid problems on servers without the iconv
// extension and where dl() is not supported
$cfg = FALSE;

// You can select here which functions will be used for charset conversion.
// Possible values are:
// auto – automatically use available one (first is tested iconv, then
// recode)
// iconv – use iconv or libiconv functions
// recode – use recode_string function
$cfg = ‘auto’;

// Specify some parameters for iconv used in charset conversion. See iconv
// documentation for details:
// http://www.gnu.org/software/libiconv/docum…onv_open.3.html
$cfg = ”;

// Available charsets for MySQL conversion. currently contains all which could
// be found in lang/* files and few more.
// Charsets will be shown in same order as here listed, so if you frequently
// use some of these move them to the top.
$cfg = array(
‘iso-8859-1’,
‘iso-8859-2’,
‘iso-8859-3’,
‘iso-8859-4’,
‘iso-8859-5’,
‘iso-8859-6’,
‘iso-8859-7’,
‘iso-8859-8’,
‘iso-8859-9’,
‘iso-8859-10’,
‘iso-8859-11’,
‘iso-8859-12’,
‘iso-8859-13’,
‘iso-8859-14’,
‘iso-8859-15’,
‘windows-1250’,
‘windows-1251’,
‘windows-1252’,
‘windows-1256’,
‘windows-1257’,
‘koi8-r’,
‘big5’,
‘gb2312’,
‘utf-8’,
‘utf-7’,
‘x-user-defined’,
‘euc-jp’,
‘ks_c_5601-1987’,
’tis-620′,
‘SHIFT_JIS’
);

/**
* Customization & design
*/
$cfg = 150; // left frame width
$cfg = ‘#D0DCE0’; // background color for the left frame
$cfg = ‘#F5F5F5’; // background color for the right frame
$cfg = ”; // path to a background image for the right frame
// (leave blank for no background image)
$cfg = ‘#CCFFCC’; // color of the pointer in left frame
// (blank for no pointer)
$cfg = 0; // border width on tables
$cfg = ‘#D3DCE3’; // table header row colour
$cfg = ‘#CCCCCC’; // table data row colour
$cfg = ‘#DDDDDD’; // table data row colour, alternate
$cfg = ‘#CCFFCC’; // color of the pointer in browse mode
// (blank for no pointer)
$cfg = ‘#FFCC99’; // color of the marker (visually marks row
// by clicking on it) in browse mode
// (blank for no marker)
$cfg = 40; // textarea size (columns) in edit mode
// (this value will be emphasized (*2) for sql
// query textareas and (*1.25) for query window)
$cfg = 7; // textarea size (rows) in edit mode
$cfg = TRUE; // double size of textarea size for longtext fields
$cfg = TRUE; // autoselect when clicking in the textarea of the querybox
$cfg = 40; // textarea size (columns) for CHAR/VARCHAR
$cfg = 2; // textarea size (rows) for CHAR/VARCHAR
$cfg = TRUE; // Enable Ctrl+Arrows moving between fields when editing?
$cfg = 50; // Max field data length in browse mode for all non-numeric fields
$cfg = TRUE; // show edit/delete links on left side of browse
// (or at the top with vertical browse)
$cfg = FALSE; // show edit/delete links on right side of browse
// (or at the bottom with vertical browse)
$cfg = ‘horizontal’; // default display direction
// (horizontal|vertical|horizontalflipped)
$cfg = ‘horizontal’; // default display direction for altering/
// creating columns (tbl_properties)
// (horizontal|vertical)

$cfg = ‘css’; // table-header rotation via faking or css? (css|fake)
// NOTE: CSS only works in IE browsers!
$cfg = TRUE; // shows stored relation-comments in ‘browse’ mode.
$cfg= TRUE; // shows stored relation-comments in ‘table property’ mode.
$cfg = 100; // repeat header names every X cells? (0 = deactivate)

$cfg = TRUE; // displays a new frame where a link to a querybox is always displayed.
$cfg = TRUE; // whether to use JavaScript functions for opening a new window for SQL commands.
// if set to ‘false’, the target of the querybox is always the right frame.
$cfg = FALSE; // display JS debugging link (DEVELOPERS only)
$cfg = 550; // Width of Query window
$cfg = 310; // Height of Query window
$cfg = FALSE; // Set to TRUE if you want DB-based query history.
// If FALSE, this utilizes JS-routines to display
// query history (lost by window close)
$cfg = ‘sql’; // which tab to display in the querywindow on startup
// (sql|files|history|full)
$cfg = 25; // When using DB-based query history, how many entries
// should be kept?
$cfg = TRUE; // Use MIME-Types (stored in column comments table) for
$cfg = 20000; // When approximate count = 2 available? Set to yes/no/auto. ‘auto’
// does autodetection, which is a bit expensive for
// php ‘#808000’,
‘comment_mysql’ => ”,
‘comment_ansi’ => ”,
‘comment_c’ => ”,
‘digit’ => ”,
‘digit_hex’ => ‘teal’,
‘digit_integer’ => ‘teal’,
‘digit_float’ => ‘aqua’,
‘punct’ => ‘fuchsia’,
‘alpha’ => ”,
‘alpha_columnType’ => ‘#FF9900’,
‘alpha_columnAttrib’ => ‘#0000FF’,
‘alpha_reservedWord’ => ‘#990099’,
‘alpha_functionName’ => ‘#FF0000’,
‘alpha_identifier’ => ‘black’,
‘alpha_charset’ => ‘#6495ed’,
‘alpha_variable’ => ‘#800000’,
‘quote’ => ‘#008000’,
‘quote_double’ => ”,
‘quote_single’ => ”,
‘quote_backtick’ => ”
);

/**
* If you wish to use the SQL Validator service, you should be
* aware of the following:
* All SQL statements are stored anonymously for statistical purposes.
* Mimer SQL Validator, Copyright 2002 Upright Database Technology.
* All rights reserved.
*/
$cfg = FALSE; // Make the SQL Validator available
$cfg = ”; // If you have a custom username, specify it here (defaults to anonymous)
$cfg = ”; // Password for username

/**
* Developers ONLY!
* To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
*/
$cfg = FALSE; // Make the DBG stuff available
$cfg = FALSE; // Produce profiling results of PHP
$cfg = 0.5; // Threshold of long running code to display
// Anything below the threshold is not displayed

/**
* MySQL settings
*/
// Column types;
// varchar, tinyint, text and date are listed first, based on estimated popularity
$cfg = array(
‘VARCHAR’,
‘TINYINT’,
‘TEXT’,
‘DATE’,
‘SMALLINT’,
‘MEDIUMINT’,
‘INT’,
‘BIGINT’,
‘FLOAT’,
‘DOUBLE’,
‘DECIMAL’,
‘DATETIME’,
‘TIMESTAMP’,
‘TIME’,
‘YEAR’,
‘CHAR’,
‘TINYBLOB’,
‘TINYTEXT’,
‘BLOB’,
‘MEDIUMBLOB’,
‘MEDIUMTEXT’,
‘LONGBLOB’,
‘LONGTEXT’,
‘ENUM’,
‘SET’
);

// Atributes
$cfg = array(
”,
‘BINARY’,
‘UNSIGNED’,
‘UNSIGNED ZEROFILL’
);

// Available functions
if ($cfg) {
$cfg = array(
‘ASCII’,
‘CHAR’,
‘SOUNDEX’,
‘LCASE’,
‘UCASE’,
‘NOW’,
‘PASSWORD’,
‘MD5’,
‘ENCRYPT’,
‘RAND’,
‘LAST_INSERT_ID’,
‘COUNT’,
‘AVG’,
‘SUM’,
‘CURDATE’,
‘CURTIME’,
‘FROM_DAYS’,
‘FROM_UNIXTIME’,
‘PERIOD_ADD’,
‘PERIOD_DIFF’,
‘TO_DAYS’,
‘UNIX_TIMESTAMP’,
‘USER’,
‘WEEKDAY’,
‘CONCAT’
);

// Which column types will be mapped to which Group?
$cfg = array(
‘VARCHAR’ => ‘FUNC_CHAR’,
‘TINYINT’ => ‘FUNC_NUMBER’,
‘TEXT’ => ‘FUNC_CHAR’,
‘DATE’ => ‘FUNC_DATE’,
‘SMALLINT’ => ‘FUNC_NUMBER’,
‘MEDIUMINT’ => ‘FUNC_NUMBER’,
‘INT’ => ‘FUNC_NUMBER’,
‘BIGINT’ => ‘FUNC_NUMBER’,
‘FLOAT’ => ‘FUNC_NUMBER’,
‘DOUBLE’ => ‘FUNC_NUMBER’,
‘DECIMAL’ => ‘FUNC_NUMBER’,
‘DATETIME’ => ‘FUNC_DATE’,
‘TIMESTAMP’ => ‘FUNC_DATE’,
‘TIME’ => ‘FUNC_DATE’,
‘YEAR’ => ‘FUNC_DATE’,
‘CHAR’ => ‘FUNC_CHAR’,
‘TINYBLOB’ => ‘FUNC_CHAR’,
‘TINYTEXT’ => ‘FUNC_CHAR’,
‘BLOB’ => ‘FUNC_CHAR’,
‘MEDIUMBLOB’ => ‘FUNC_CHAR’,
‘MEDIUMTEXT’ => ‘FUNC_CHAR’,
‘LONGBLOB’ => ‘FUNC_CHAR’,
‘LONGTEXT’ => ‘FUNC_CHAR’,
‘ENUM’ => ”,
‘SET’ => ”
);

// Map above defined groups to any function
$cfg = array(
‘FUNC_CHAR’ => array(
‘ASCII’,
‘CHAR’,
‘SOUNDEX’,
‘LCASE’,
‘UCASE’,
‘PASSWORD’,
‘MD5’,
‘ENCRYPT’,
‘LAST_INSERT_ID’,
‘USER’,
‘CONCAT’
),

‘FUNC_DATE’ => array(
‘NOW’,
‘CURDATE’,
‘CURTIME’,
‘FROM_DAYS’,
‘FROM_UNIXTIME’,
‘PERIOD_ADD’,
‘PERIOD_DIFF’,
‘TO_DAYS’,
‘UNIX_TIMESTAMP’,
‘WEEKDAY’
),

‘FUNC_NUMBER’ => array(
‘ASCII’,
‘CHAR’,
‘MD5’,
‘ENCRYPT’,
‘RAND’,
‘LAST_INSERT_ID’,
‘COUNT’,
‘AVG’,
‘SUM’
)
);

// Default functions for above defined groups
$cfg = array(
‘FUNC_CHAR’ => ”,
‘FUNC_DATE’ => ”,
‘FUNC_NUMBER’ => ”,
‘first_timestamp’ => ‘NOW’
);

} // end if

/**
* Unset magic_quotes_runtime – do not change!
*/
set_magic_quotes_runtime(0);

/**
* File Revision – do not change either!
*/
$cfg = ‘$Revision: 2.5.2.1 $’;
?>

Bocsika de nagyon béna voltam nem vettem észre hogy mit is írsz pontosan
😀

De most már értem azt hiszem
[align=right][snapback]88435[/snapback][/align]

A ‘config’ helyére írd a cookie -t