Avatar billede krohn Praktikant
20. december 2004 - 09:19 Der er 14 kommentarer og
1 løsning

php my admin

Jeh har nu i to dage prøvet at få phpmyadmin til at køre på min server, men jeg får denne fejl.:kan ikke indlæse udvidelsen mysqli,
check PHP-konfigurationen!
Dokumentation .. Hvis man så læser i dokumentationen får man dette: [1.20] I receive the error "cannot load MySQL extension, please check PHP Configuration".
To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension". This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.

Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar.

Da jeg ikke er så hård til dette her, hjælper det mig ikke så meget, men er der en software pakke jeg kan hente?
Eller er det i config filen jeg skal ændre noget, eller i windows?

Min server er sat op som følger..
Win 2003
IIS 6.0
php 5
Mysql 4.1
Avatar billede noob2003 Nybegynder
20. december 2004 - 09:59 #1
kik efter      ;extension=php_mysql.dll
den skal stå som extension=php_mysql.dll
Avatar billede noob2003 Nybegynder
20. december 2004 - 09:59 #2
i php.ini filen
Avatar billede krohn Praktikant
20. december 2004 - 10:19 #3
Jeg har fjernet ; i php.ini, jeg får også en fejl, som er hvis jeg læser migtil det rigtigt at min mysql ikke er enable i php?
Men jeg poster lige min php.ini
Avatar billede krohn Praktikant
20. december 2004 - 10:20 #4
[PHP]

;;;;;;;;;;;
; WARNING ;
;;;;;;;;;;;
; This is the default settings file for new PHP installations.
; By default, PHP installs itself with a configuration suitable for
; development purposes, and *NOT* for production purposes.
; For several security-oriented considerations that should be taken
; before going online with your site, please consult php.ini-recommended
; and http://php.net/manual/en/security.php.


;;;;;;;;;;;;;;;;;;;
; About php.ini  ;
;;;;;;;;;;;;;;;;;;;
; This file controls many aspects of PHP's behavior.  In order for PHP to
; read it, it must be named 'php.ini'.  PHP looks for it in the current
; working directory, in the path designated by the environment variable
; PHPRC, and in the path that was defined in compile time (in that order).
; Under Windows, the compile-time path is the Windows directory.  The
; path in which the php.ini file is looked for can be overridden using
; the -c argument in command line mode.
;
; The syntax of the file is extremely simple.  Whitespace and Lines
; beginning with a semicolon are silently ignored (as you probably guessed).
; Section headers (e.g. [Foo]) are also silently ignored, even though
; they might mean something in the future.
;
; Directives are specified using the following syntax:
; directive = value
; Directive names are *case sensitive* - foo=bar is different from FOO=bar.
;
; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI), one
; of the INI constants (On, Off, True, False, Yes, No and None) or an expression
; (e.g. E_ALL & ~E_NOTICE), or a quoted string ("foo").
;
; Expressions in the INI file are limited to bitwise operators and parentheses:
; |        bitwise OR
; &        bitwise AND
; ~        bitwise NOT
; !        boolean NOT
;
; Boolean flags can be turned on using the values 1, On, True or Yes.
; They can be turned off using the values 0, Off, False or No.
;
; An empty string can be denoted by simply not writing anything after the equal
; sign, or by using the None keyword:
;
;  foo =        ; sets foo to an empty string
;  foo = none    ; sets foo to an empty string
;  foo = "none"  ; sets foo to the string 'none'
;
; If you use constants in your value, and these constants belong to a
; dynamically loaded extension (either a PHP extension or a Zend extension),
; you may only use these constants *after* the line that loads the extension.
;
;
;;;;;;;;;;;;;;;;;;;
; About this file ;
;;;;;;;;;;;;;;;;;;;
; All the values in the php.ini-dist file correspond to the builtin
; defaults (that is, if no php.ini is used, or if you delete these lines,
; the builtin defaults will be identical).


;;;;;;;;;;;;;;;;;;;;
; Language Options ;
;;;;;;;;;;;;;;;;;;;;

; Enable the PHP scripting language engine under Apache.
engine = On

; Enable compatibility mode with Zend Engine 1 (PHP 4.x)
zend.ze1_compatibility_mode = Off

; Allow the <? tag.  Otherwise, only <?php and <script> tags are recognized.
; NOTE: Using short tags should be avoided when developing applications or
; libraries that are meant for redistribution, or deployment on PHP
; servers which are not under your control, because short tags may not
; be supported on the target server. For portable, redistributable code,
; be sure not to use short tags.
short_open_tag = On

; Allow ASP-style <% %> tags.
asp_tags = Off

; The number of significant digits displayed in floating point numbers.
precision    =  12

; Enforce year 2000 compliance (will cause problems with non-compliant browsers)
y2k_compliance = On

; Output buffering allows you to send header lines (including cookies) even
; after you send body content, at the price of slowing PHP's output layer a
; bit.  You can enable output buffering during runtime by calling the output
; buffering functions.  You can also enable output buffering for all files by
; setting this directive to On.  If you wish to limit the size of the buffer
; to a certain size - you can use a maximum number of bytes instead of 'On', as
; a value for this directive (e.g., output_buffering=4096).
output_buffering = Off

; You can redirect all of the output of your scripts to a function.  For
; example, if you set output_handler to "mb_output_handler", character
; encoding will be transparently converted to the specified encoding.
; Setting any output handler automatically turns on output buffering.
; Note: People who wrote portable scripts should not depend on this ini
;      directive. Instead, explicitly set the output handler using ob_start().
;      Using this ini directive may cause problems unless you know what script
;      is doing.
; Note: You cannot use both "mb_output_handler" with "ob_iconv_handler"
;      and you cannot use both "ob_gzhandler" and "zlib.output_compression".
; Note: output_handler must be empty if this is set 'On' !!!!
;      Instead you must use zlib.output_handler.
;output_handler =

; Transparent output compression using the zlib library
; Valid values for this option are 'off', 'on', or a specific buffer size
; to be used for compression (default is 4KB)
; Note: Resulting chunk size may vary due to nature of compression. PHP
;      outputs chunks that are few hundreds bytes each as a result of
;      compression. If you prefer a larger chunk size for better
;      performance, enable output_buffering in addition.
; Note: You need to use zlib.output_handler instead of the standard
;      output_handler, or otherwise the output will be corrupted.
zlib.output_compression = Off

; You cannot specify additional output handlers if zlib.output_compression
; is activated here. This setting does the same as output_handler but in
; a different order.
;zlib.output_handler =

; Implicit flush tells PHP to tell the output layer to flush itself
; automatically after every output block.  This is equivalent to calling the
; PHP function flush() after each and every call to print() or echo() and each
; and every HTML block.  Turning this option on has serious performance
; implications and is generally recommended for debugging purposes only.
implicit_flush = Off

; The unserialize callback function will be called (with the undefined class'
; name as parameter), if the unserializer finds an undefined class
; which should be instanciated.
; A warning appears if the specified function is not defined, or if the
; function doesn't include/implement the missing class.
; So only set this entry, if you really want to implement such a
; callback-function.
unserialize_callback_func=

; When floats & doubles are serialized store serialize_precision significant
; digits after the floating point. The default value ensures that when floats
; are decoded with unserialize, the data will remain the same.
serialize_precision = 100

; Whether to enable the ability to force arguments to be passed by reference
; at function call time.  This method is deprecated and is likely to be
; unsupported in future versions of PHP/Zend.  The encouraged method of
; specifying which arguments should be passed by reference is in the function
; declaration.  You're encouraged to try and turn this option Off and make
; sure your scripts work properly with it in order to ensure they will work
; with future versions of the language (you will receive a warning each time
; you use this feature, and the argument will be passed by value instead of by
; reference).
allow_call_time_pass_reference = On

;
; Safe Mode
;
safe_mode = Off

; By default, Safe Mode does a UID compare check when
; opening files. If you want to relax this to a GID compare,
; then turn on safe_mode_gid.
safe_mode_gid = Off

; When safe_mode is on, UID/GID checks are bypassed when
; including files from this directory and its subdirectories.
; (directory must also be in include_path or full path must
; be used when including)
safe_mode_include_dir =

; When safe_mode is on, only executables located in the safe_mode_exec_dir
; will be allowed to be executed via the exec family of functions.
safe_mode_exec_dir =

; Setting certain environment variables may be a potential security breach.
; This directive contains a comma-delimited list of prefixes.  In Safe Mode,
; the user may only alter environment variables whose names begin with the
; prefixes supplied here.  By default, users will only be able to set
; environment variables that begin with PHP_ (e.g. PHP_FOO=BAR).
;
; Note:  If this directive is empty, PHP will let the user modify ANY
; environment variable!
safe_mode_allowed_env_vars = PHP_

; This directive contains a comma-delimited list of environment variables that
; the end user won't be able to change using putenv().  These variables will be
; protected even if safe_mode_allowed_env_vars is set to allow to change them.
safe_mode_protected_env_vars = LD_LIBRARY_PATH

; open_basedir, if set, limits all file operations to the defined directory
; and below.  This directive makes most sense if used in a per-directory
; or per-virtualhost web server configuration file. This directive is
; *NOT* affected by whether Safe Mode is turned On or Off.
;open_basedir =

; This directive allows you to disable certain functions for security reasons.
; It receives a comma-delimited list of function names. This directive is
; *NOT* affected by whether Safe Mode is turned On or Off.
disable_functions =

; This directive allows you to disable certain classes for security reasons.
; It receives a comma-delimited list of class names. This directive is
; *NOT* affected by whether Safe Mode is turned On or Off.
disable_classes =

; Colors for Syntax Highlighting mode.  Anything that's acceptable in
; <font color="??????"> would work.
;highlight.string  = #DD0000
;highlight.comment = #FF9900
;highlight.keyword = #007700
;highlight.bg      = #FFFFFF
;highlight.default = #0000BB
;highlight.html    = #000000


;
; Misc
;
; Decides whether PHP may expose the fact that it is installed on the server
; (e.g. by adding its signature to the Web server header).  It is no security
; threat in any way, but it makes it possible to determine whether you use PHP
; on your server or not.
expose_php = On


;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

max_execution_time = 30    ; Maximum execution time of each script, in seconds
max_input_time = 60    ; Maximum amount of time each script may spend parsing request data
memory_limit = 8M      ; Maximum amount of memory a script may consume (8MB)


;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; Error handling and logging ;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

; error_reporting is a bit-field.  Or each number up to get desired error
; reporting level
; E_ALL            - All errors and warnings (doesn't include E_STRICT)
; E_ERROR          - fatal run-time errors
; E_WARNING        - run-time warnings (non-fatal errors)
; E_PARSE          - compile-time parse errors
; E_NOTICE          - run-time notices (these are warnings which often result
;                    from a bug in your code, but it's possible that it was
;                    intentional (e.g., using an uninitialized variable and
;                    relying on the fact it's automatically initialized to an
;                    empty string)
; E_STRICT            - run-time notices, enable to have PHP suggest changes
;                    to your code which will ensure the best interoperability
;                    and forward compatibility of your code
; E_CORE_ERROR      - fatal errors that occur during PHP's initial startup
; E_CORE_WARNING    - warnings (non-fatal errors) that occur during PHP's
;                    initial startup
; E_COMPILE_ERROR  - fatal compile-time errors
; E_COMPILE_WARNING - compile-time warnings (non-fatal errors)
; E_USER_ERROR      - user-generated error message
; E_USER_WARNING    - user-generated warning message
; E_USER_NOTICE    - user-generated notice message
;
; Examples:
;
;  - Show all errors, except for notices and coding standards warnings
;
;error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT
;
;  - Show all errors, except for notices
;
;error_reporting = E_ALL & ~E_NOTICE
;
;  - Show only errors
;
;error_reporting = E_COMPILE_ERROR|E_ERROR|E_CORE_ERROR
;
;  - Show all errors except for notices and coding standards warnings
;
error_reporting  =  E_ALL & ~E_NOTICE & ~E_STRICT

; Print out errors (as a part of the output).  For production web sites,
; you're strongly encouraged to turn this feature off, and use error logging
; instead (see below).  Keeping display_errors enabled on a production web site
; may reveal security information to end users, such as file paths on your Web
; server, your database schema or other information.
display_errors = On

; Even when display_errors is on, errors that occur during PHP's startup
; sequence are not displayed.  It's strongly recommended to keep
; display_startup_errors off, except for when debugging.
display_startup_errors = Off

; Log errors into a log file (server-specific log, stderr, or error_log (below))
; As stated above, you're strongly advised to use error logging in place of
; error displaying on production web sites.
log_errors = Off

; Set maximum length of log_errors. In error_log information about the source is
; added. The default is 1024 and 0 allows to not apply any maximum length at all.
log_errors_max_len = 1024

; Do not log repeated messages. Repeated errors must occur in same file on same
; line until ignore_repeated_source is set true.
ignore_repeated_errors = Off

; Ignore source of message when ignoring repeated messages. When this setting
; is On you will not log errors with repeated messages from different files or
; sourcelines.
ignore_repeated_source = Off

; If this parameter is set to Off, then memory leaks will not be shown (on
; stdout or in the log). This has only effect in a debug compile, and if
; error reporting includes E_WARNING in the allowed list
report_memleaks = On

; Store the last error/warning message in $php_errormsg (boolean).
track_errors = Off

; Disable the inclusion of HTML tags in error messages.
; Note: Never use this feature for production boxes.
;html_errors = Off

; If html_errors is set On PHP produces clickable error messages that direct
; to a page describing the error or function causing the error in detail.
; You can download a copy of the PHP manual from http://www.php.net/docs.php
; and change docref_root to the base URL of your local copy including the
; leading '/'. You must also specify the file extension being used including
; the dot.
; Note: Never use this feature for production boxes.
;docref_root = "/phpmanual/"
;docref_ext = .html

; String to output before an error message.
;error_prepend_string = "<font color=ff0000>"

; String to output after an error message.
;error_append_string = "</font>"

; Log errors to specified file.
;error_log = filename

; Log errors to syslog (Event Log on NT, not valid in Windows 95).
;error_log = syslog


;;;;;;;;;;;;;;;;;
; Data Handling ;
;;;;;;;;;;;;;;;;;
;
; Note - track_vars is ALWAYS enabled as of PHP 4.0.3

; The separator used in PHP generated URLs to separate arguments.
; Default is "&".
;arg_separator.output = "&amp;"

; List of separator(s) used by PHP to parse input URLs into variables.
; Default is "&".
; NOTE: Every character in this directive is considered as separator!
;arg_separator.input = ";&"

; This directive describes the order in which PHP registers GET, POST, Cookie,
; Environment and Built-in variables (G, P, C, E & S respectively, often
; referred to as EGPCS or GPC).  Registration is done from left to right, newer
; values override older values.
variables_order = "EGPCS"

; Whether or not to register the EGPCS variables as global variables.  You may
; want to turn this off if you don't want to clutter your scripts' global scope
; with user data.  This makes most sense when coupled with track_vars - in which
; case you can access all of the GPC variables through the $HTTP_*_VARS[],
; variables.
;
; You should do your best to write your scripts so that they do not require
; register_globals to be on;  Using form variables as globals can easily lead
; to possible security problems, if the code is not very well thought of.
register_globals = On

; Whether or not to register the old-style input arrays, HTTP_GET_VARS
; and friends.  If you're not using them, it's recommended to turn them off,
; for performance reasons.
register_long_arrays = On

; This directive tells PHP whether to declare the argv&argc variables (that
; would contain the GET information).  If you don't use these variables, you
; should turn it off for increased performance.
register_argc_argv = On

; Maximum size of POST data that PHP will accept.
post_max_size = 8M

; Magic quotes
;

; Magic quotes for incoming GET/POST/Cookie data.
magic_quotes_gpc = On

; Magic quotes for runtime-generated data, e.g. data from SQL, from exec(), etc.
magic_quotes_runtime = Off

; Use Sybase-style magic quotes (escape ' with '' instead of \').
magic_quotes_sybase = Off

; Automatically add files before or after any PHP document.
auto_prepend_file =
auto_append_file =

; As of 4.0b4, PHP always outputs a character encoding by default in
; the Content-type: header.  To disable sending of the charset, simply
; set it to be empty.
;
; PHP's built-in default is text/html
default_mimetype = "text/html"
;default_charset = "iso-8859-1"

; Always populate the $HTTP_RAW_POST_DATA variable.
;always_populate_raw_post_data = On


;;;;;;;;;;;;;;;;;;;;;;;;;
; Paths and Directories ;
;;;;;;;;;;;;;;;;;;;;;;;;;

; UNIX: "/path1:/path2"
;include_path = ".:/php/includes"
;
; Windows: "\path1;\path2"
;include_path = ".;c:\php\includes"

; The root of the PHP pages, used only if nonempty.
; if PHP was not compiled with FORCE_REDIRECT, you SHOULD set doc_root
; if you are running php as a CGI under any web server (other than IIS)
; see documentation for security issues.  The alternate is to use the
; cgi.force_redirect configuration below
doc_root =

; The directory under which PHP opens the script using /~username used only
; if nonempty.
user_dir =

; Directory in which the loadable extensions (modules) reside.
extension_dir = "./"

; Whether or not to enable the dl() function.  The dl() function does NOT work
; properly in multithreaded servers, such as IIS or Zeus, and is automatically
; disabled on them.
enable_dl = On

; cgi.force_redirect is necessary to provide security running PHP as a CGI under
; most web servers.  Left undefined, PHP turns this on by default.  You can
; turn it off here AT YOUR OWN RISK
; **You CAN safely turn this off for IIS, in fact, you MUST.**
cgi.force_redirect = 0

; if cgi.nph is enabled it will force cgi to always sent Status: 200 with
; every request.
; cgi.nph = 1

; if cgi.force_redirect is turned on, and you are not running under Apache or Netscape
; (iPlanet) web servers, you MAY need to set an environment variable name that PHP
; will look for to know it is OK to continue execution.  Setting this variable MAY
; cause security issues, KNOW WHAT YOU ARE DOING FIRST.
; cgi.redirect_status_env = ;

; FastCGI under IIS (on WINNT based OS) supports the ability to impersonate
; security tokens of the calling client.  This allows IIS to define the
; security context that the request runs under.  mod_fastcgi under Apache
; does not currently support this feature (03/17/2002)
; Set to 1 if running under IIS.  Default is zero.
; fastcgi.impersonate = 1;

; cgi.rfc2616_headers configuration option tells PHP what type of headers to
; use when sending HTTP response code. If it's set 0 PHP sends Status: header that
; is supported by Apache. When this option is set to 1 PHP will send
; RFC2616 compliant header.
; Default is zero.
;cgi.rfc2616_headers = 0


;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;

; Whether to allow HTTP file uploads.
file_uploads = On

; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
;upload_tmp_dir =

; Maximum allowed size for uploaded files.
upload_max_filesize = 2M


;;;;;;;;;;;;;;;;;;
; Fopen wrappers ;
;;;;;;;;;;;;;;;;;;

; Whether to allow the treatment of URLs (like http:// or ftp://) as files.
allow_url_fopen = On

; Define the anonymous ftp password (your email address)
;from="john@doe.com"

; Define the User-Agent string
; user_agent="PHP"

; Default timeout for socket based streams (seconds)
default_socket_timeout = 60

; If your scripts have to deal with files from Macintosh systems,
; or you are running on a Mac and need to deal with files from
; unix or win32 systems, setting this flag will cause PHP to
; automatically detect the EOL character in those files so that
; fgets() and file() will work regardless of the source of the file.
; auto_detect_line_endings = Off


;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
;
; If you wish to have an extension loaded automatically, use the following
; syntax:
;
;  extension=modulename.extension
;
; For example, on Windows:
;
;  extension=msql.dll
;
; ... or under UNIX:
;
;  extension=msql.so
;
; Note that it should be the name of the module only; no directory information
; needs to go here.  Specify the location of the extension with the
; extension_dir directive above.


;Windows Extensions
;Note that ODBC support is built in, so no dll is needed for it.
;

;extension=php_bz2.dll
;extension=php_cpdf.dll
;extension=php_curl.dll
;extension=php_dba.dll
;extension=php_dbase.dll
;extension=php_dbx.dll
;extension=php_exif.dll
;extension=php_fdf.dll
;extension=php_filepro.dll
;extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_ifx.dll
;extension=php_iisfunc.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_java.dll
;extension=php_ldap.dll
;extension=php_mbstring.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_mime_magic.dll
;extension=php_ming.dll
;extension=php_mssql.dll
;extension=php_msql.dll
extension=php_mysql.dll
;extension=php_oci8.dll
;extension=php_openssl.dll
;extension=php_oracle.dll
;extension=php_pdf.dll
;extension=php_pgsql.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
;extension=php_sockets.dll
;extension=php_sybase_ct.dll
;extension=php_tidy.dll
;extension=php_w32api.dll
;extension=php_xmlrpc.dll
;extension=php_xsl.dll
;extension=php_yaz.dll
;extension=php_zip.dll


;;;;;;;;;;;;;;;;;;;
; Module Settings ;
;;;;;;;;;;;;;;;;;;;

[Syslog]
; Whether or not to define the various syslog variables (e.g. $LOG_PID,
; $LOG_CRON, etc.).  Turning it off is a good idea performance-wise.  In
; runtime, you can define these variables by calling define_syslog_variables().
define_syslog_variables  = Off

[mail function]
; For Win32 only.
SMTP = localhost
smtp_port = 25

; For Win32 only.
;sendmail_from = me@example.com

; For Unix only.  You may supply arguments as well (default: "sendmail -t -i").
;sendmail_path =

; Force the addition of the specified parameters to be passed as extra parameters
; to the sendmail binary. These parameters will always replace the value of
; the 5th parameter to mail(), even in safe mode.
;mail.force_extra_parameters =

[SQL]
sql.safe_mode = Off

[ODBC]
;odbc.default_db    =  Not yet implemented
;odbc.default_user  =  Not yet implemented
;odbc.default_pw    =  Not yet implemented

; Allow or prevent persistent links.
odbc.allow_persistent = On

; Check that a connection is still valid before reuse.
odbc.check_persistent = On

; Maximum number of persistent links.  -1 means no limit.
odbc.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
odbc.max_links = -1

; Handling of LONG fields.  Returns number of bytes to variables.  0 means
; passthru.
odbc.defaultlrl = 4096

; Handling of binary data.  0 means passthru, 1 return as is, 2 convert to char.
; See the documentation on odbc_binmode and odbc_longreadlen for an explanation
; of uodbc.defaultlrl and uodbc.defaultbinmode
odbc.defaultbinmode = 1

[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
mysql.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
mysql.max_links = -1

; Default port number for mysql_connect().  If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
mysql.default_port =

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =

; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password =

; Maximum time (in secondes) for connect timeout. -1 means no limit
mysql.connect_timeout = 60

; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Errors will be displayed.
mysql.trace_mode = Off

[MySQLI]

; Maximum number of links.  -1 means no limit.
mysqli.max_links = -1

; Default port number for mysqli_connect().  If unset, mysqli_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
mysqli.default_port = 3306

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysqli.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysqli.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
mysqli.default_user =

; Default password for mysqli_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysqli.default_password")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
mysqli.default_password =

; Allow or prevent reconnect
mysqli.reconnect = Off

[mSQL]
; Allow or prevent persistent links.
msql.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
msql.max_persistent = -1

; Maximum number of links (persistent+non persistent).  -1 means no limit.
msql.max_links = -1

[PostgresSQL]
; Allow or prevent persistent links.
pgsql.allow_persistent = On

; Detect broken persistent links always with pg_pconnect().
; Auto reset feature requires a little overheads.
pgsql.auto_reset_persistent = Off

; Maximum number of persistent links.  -1 means no limit.
pgsql.max_persistent = -1

; Maximum number of links (persistent+non persistent).  -1 means no limit.
pgsql.max_links = -1

; Ignore PostgreSQL backends Notice message or not.
; Notice message logging require a little overheads.
pgsql.ignore_notice = 0

; Log PostgreSQL backends Noitce message or not.
; Unless pgsql.ignore_notice=0, module cannot log notice message.
pgsql.log_notice = 0

[Sybase]
; Allow or prevent persistent links.
sybase.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
sybase.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
sybase.max_links = -1

;sybase.interface_file = "/usr/sybase/interfaces"

; Minimum error severity to display.
sybase.min_error_severity = 10

; Minimum message severity to display.
sybase.min_message_severity = 10

; Compatability mode with old versions of PHP 3.0.
; If on, this will cause PHP to automatically assign types to results according
; to their Sybase type, instead of treating them all as strings.  This
; compatability mode will probably not stay around forever, so try applying
; whatever necessary changes to your code, and turn it off.
sybase.compatability_mode = Off

[Sybase-CT]
; Allow or prevent persistent links.
sybct.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
sybct.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
sybct.max_links = -1

; Minimum server message severity to display.
sybct.min_server_severity = 10

; Minimum client message severity to display.
sybct.min_client_severity = 10

[dbx]
; returned column names can be converted for compatibility reasons
; possible values for dbx.colnames_case are
; "unchanged" (default, if not set)
; "lowercase"
; "uppercase"
; the recommended default is either upper- or lowercase, but
; unchanged is currently set for backwards compatibility
dbx.colnames_case = "unchanged"

[bcmath]
; Number of decimal digits for all bcmath functions.
bcmath.scale = 0

[browscap]
;browscap = extra/browscap.ini

[Informix]
; Default host for ifx_connect() (doesn't apply in safe mode).
ifx.default_host =

; Default user for ifx_connect() (doesn't apply in safe mode).
ifx.default_user =

; Default password for ifx_connect() (doesn't apply in safe mode).
ifx.default_password =

; Allow or prevent persistent links.
ifx.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
ifx.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
ifx.max_links = -1

; If on, select statements return the contents of a text blob instead of its id.
ifx.textasvarchar = 0

; If on, select statements return the contents of a byte blob instead of its id.
ifx.byteasvarchar = 0

; Trailing blanks are stripped from fixed-length char columns.  May help the
; life of Informix SE users.
ifx.charasvarchar = 0

; If on, the contents of text and byte blobs are dumped to a file instead of
; keeping them in memory.
ifx.blobinfile = 0

; NULL's are returned as empty strings, unless this is set to 1.  In that case,
; NULL's are returned as string 'NULL'.
ifx.nullformat = 0

[Session]
; Handler used to store/retrieve data.
session.save_handler = files

; Argument passed to save_handler.  In the case of files, this is the path
; where data files are stored. Note: Windows users have to change this
; variable in order to use PHP's session functions.
;
; As of PHP 4.0.1, you can define the path as:
;
;    session.save_path = "N;/path"
;
; where N is an integer.  Instead of storing all the session files in
; /path, what this will do is use subdirectories N-levels deep, and
; store the session data in those directories.  This is useful if you
; or your OS have problems with lots of files in one directory, and is
; a more efficient layout for servers that handle lots of sessions.
;
; NOTE 1: PHP will not create this directory structure automatically.
;        You can use the script in the ext/session dir for that purpose.
; NOTE 2: See the section on garbage collection below if you choose to
;        use subdirectories for session storage
;
; The file storage module creates files using mode 600 by default.
; You can change that by using
;
;    session.save_path = "N;MODE;/path"
;
; where MODE is the octal representation of the mode. Note that this
; does not overwrite the process's umask.
;session.save_path = "/tmp"

; Whether to use cookies.
session.use_cookies = 1

; This option enables administrators to make their users invulnerable to
; attacks which involve passing session ids in URLs; defaults to 0.
; session.use_only_cookies = 1

; Name of the session (used as cookie name).
session.name = PHPSESSID

; Initialize session on request startup.
session.auto_start = 0

; Lifetime in seconds of cookie or, if 0, until browser is restarted.
session.cookie_lifetime = 0

; The path for which the cookie is valid.
session.cookie_path = /

; The domain for which the cookie is valid.
session.cookie_domain =

; Handler used to serialize data.  php is the standard serializer of PHP.
session.serialize_handler = php

; Define the probability that the 'garbage collection' process is started
; on every session initialization.
; The probability is calculated by using gc_probability/gc_divisor,
; e.g. 1/100 means there is a 1% chance that the GC process starts
; on each request.

session.gc_probability = 1
session.gc_divisor    = 100

; After this number of seconds, stored data will be seen as 'garbage' and
; cleaned up by the garbage collection process.
session.gc_maxlifetime = 1440

; NOTE: If you are using the subdirectory option for storing session files
;      (see session.save_path above), then garbage collection does *not*
;      happen automatically.  You will need to do your own garbage
;      collection through a shell script, cron entry, or some other method.
;      For example, the following script would is the equivalent of
;      setting session.gc_maxlifetime to 1440 (1440 seconds = 24 minutes):
;          cd /path/to/sessions; find -cmin +24 | xargs rm

; PHP 4.2 and less have an undocumented feature/bug that allows you to
; to initialize a session variable in the global scope, albeit register_globals
; is disabled.  PHP 4.3 and later will warn you, if this feature is used.
; You can disable the feature and the warning separately. At this time,
; the warning is only displayed, if bug_compat_42 is enabled.

session.bug_compat_42 = 1
session.bug_compat_warn = 1

; Check HTTP Referer to invalidate externally stored URLs containing ids.
; HTTP_REFERER has to contain this substring for the session to be
; considered as valid.
session.referer_check =

; How many bytes to read from the file.
session.entropy_length = 0

; Specified here to create the session id.
session.entropy_file =

;session.entropy_length = 16

;session.entropy_file = /dev/urandom

; Set to {nocache,private,public,} to determine HTTP caching aspects
; or leave this empty to avoid sending anti-caching headers.
session.cache_limiter = nocache

; Document expires after n minutes.
session.cache_expire = 180

; trans sid support is disabled by default.
; Use of trans sid may risk your users security.
; Use this option with caution.
; - User may send URL contains active session ID
;  to other person via. email/irc/etc.
; - URL that contains active session ID may be stored
;  in publically accessible computer.
; - User may access your site with the same session ID
;  always using URL stored in browser's history or bookmarks.
session.use_trans_sid = 0

; Select a hash function
; 0: MD5  (128 bits)
; 1: SHA-1 (160 bits)
session.hash_function = 0

; Define how many bits are stored in each character when converting
; the binary hash data to something readable.
;
; 4 bits: 0-9, a-f
; 5 bits: 0-9, a-v
; 6 bits: 0-9, a-z, A-Z, "-", ","
session.hash_bits_per_character = 4

; The URL rewriter will look for URLs in a defined set of HTML tags.
; form/fieldset are special; if you include them here, the rewriter will
; add a hidden <input> field with the info which is otherwise appended
; to URLs.  If you want XHTML conformity, remove the form entry.
; Note that all valid entries require a "=", even if no value follows.
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=,fieldset="

[MSSQL]
; Allow or prevent persistent links.
mssql.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
mssql.max_persistent = -1

; Maximum number of links (persistent+non persistent).  -1 means no limit.
mssql.max_links = -1

; Minimum error severity to display.
mssql.min_error_severity = 10

; Minimum message severity to display.
mssql.min_message_severity = 10

; Compatability mode with old versions of PHP 3.0.
mssql.compatability_mode = Off

; Connect timeout
;mssql.connect_timeout = 5

; Query timeout
;mssql.timeout = 60

; Valid range 0 - 2147483647.  Default = 4096.
;mssql.textlimit = 4096

; Valid range 0 - 2147483647.  Default = 4096.
;mssql.textsize = 4096

; Limits the number of records in each batch.  0 = all records in one batch.
;mssql.batchsize = 0

; Specify how datetime and datetim4 columns are returned
; On => Returns data converted to SQL server settings
; Off => Returns values as YYYY-MM-DD hh:mm:ss
;mssql.datetimeconvert = On

; Use NT authentication when connecting to the server
mssql.secure_connection = Off

; Specify max number of processes. Default = 25
;mssql.max_procs = 25

[Assertion]
; Assert(expr); active by default.
;assert.active = On

; Issue a PHP warning for each failed assertion.
;assert.warning = On

; Don't bail out by default.
;assert.bail = Off

; User-function to be called if an assertion fails.
;assert.callback = 0

; Eval the expression with current error_reporting().  Set to true if you want
; error_reporting(0) around the eval().
;assert.quiet_eval = 0

[Ingres II]
; Allow or prevent persistent links.
ingres.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
ingres.max_persistent = -1

; Maximum number of links, including persistents.  -1 means no limit.
ingres.max_links = -1

; Default database (format: [node_id::]dbname[/srv_class]).
ingres.default_database =

; Default user.
ingres.default_user =

; Default password.
ingres.default_password =

[Verisign Payflow Pro]
; Default Payflow Pro server.
pfpro.defaulthost = "test-payflow.verisign.com"

; Default port to connect to.
pfpro.defaultport = 443

; Default timeout in seconds.
pfpro.defaulttimeout = 30

; Default proxy IP address (if required).
;pfpro.proxyaddress =

; Default proxy port.
;pfpro.proxyport =

; Default proxy logon.
;pfpro.proxylogon =

; Default proxy password.
;pfpro.proxypassword =

[Sockets]
; Use the system read() function instead of the php_read() wrapper.
sockets.use_system_read = On

[com]
; path to a file containing GUIDs, IIDs or filenames of files with TypeLibs
;com.typelib_file =
; allow Distributed-COM calls
;com.allow_dcom = true
; autoregister constants of a components typlib on com_load()
;com.autoregister_typelib = true
; register constants casesensitive
;com.autoregister_casesensitive = false
; show warnings on duplicate constat registrations
;com.autoregister_verbose = true

[mbstring]
; language for internal character representation.
;mbstring.language = Japanese

; internal/script encoding.
; Some encoding cannot work as internal encoding.
; (e.g. SJIS, BIG5, ISO-2022-*)
;mbstring.internal_encoding = EUC-JP

; http input encoding.
;mbstring.http_input = auto

; http output encoding. mb_output_handler must be
; registered as output buffer to function
;mbstring.http_output = SJIS

; enable automatic encoding translation accoding to
; mbstring.internal_encoding setting. Input chars are
; converted to internal encoding by setting this to On.
; Note: Do _not_ use automatic encoding translation for
;      portable libs/applications.
;mbstring.encoding_translation = Off

; automatic encoding detection order.
; auto means
;mbstring.detect_order = auto

; substitute_character used when character cannot be converted
; one from another
;mbstring.substitute_character = none;

; overload(replace) single byte functions by mbstring functions.
; mail(), ereg(), etc are overloaded by mb_send_mail(), mb_ereg(),
; etc. Possible values are 0,1,2,4 or combination of them.
; For example, 7 for overload everything.
; 0: No overload
; 1: Overload mail() function
; 2: Overload str*() functions
; 4: Overload ereg*() functions
;mbstring.func_overload = 0

[FrontBase]
;fbsql.allow_persistent = On
;fbsql.autocommit = On
;fbsql.default_database =
;fbsql.default_database_password =
;fbsql.default_host =
;fbsql.default_password =
;fbsql.default_user = "_SYSTEM"
;fbsql.generate_warnings = Off
;fbsql.max_connections = 128
;fbsql.max_links = 128
;fbsql.max_persistent = -1
;fbsql.max_results = 128
;fbsql.batchSize = 1000

[exif]
; Exif UNICODE user comments are handled as UCS-2BE/UCS-2LE and JIS as JIS.
; With mbstring support this will automatically be converted into the encoding
; given by corresponding encode setting. When empty mbstring.internal_encoding
; is used. For the decode settings you can distinguish between motorola and
; intel byte order. A decode setting cannot be empty.
;exif.encode_unicode = ISO-8859-15
;exif.decode_unicode_motorola = UCS-2BE
;exif.decode_unicode_intel    = UCS-2LE
;exif.encode_jis =
;exif.decode_jis_motorola = JIS
;exif.decode_jis_intel    = JIS

[Tidy]
; The path to a default tidy configuration file to use when using tidy
;tidy.default_config = /usr/local/lib/php/default.tcfg

; Should tidy clean and repair output automatically?
; WARNING: Do not use this option if you are generating non-html content
; such as dynamic images
tidy.clean_output = Off

[soap]
; Enables or disables WSDL caching feature.
soap.wsdl_cache_enabled=1
; Sets the directory name where SOAP extension will put cache files.
soap.wsdl_cache_dir="/tmp"
; (time to live) Sets the number of second while cached file will be used
; instead of original one.
soap.wsdl_cache_ttl=86400

; Local Variables:
; tab-width: 4
; End:
Avatar billede noob2003 Nybegynder
20. december 2004 - 10:49 #5
Hmm ja det kan jeg godt se den er slået til, men jeg bruger kun 4.3.10
og den virker perfekt på ISS 6.0.

såå der kan jeg nok ikke hjælpe dig
Avatar billede krohn Praktikant
20. december 2004 - 11:33 #6
Jeg har da php-4.3.10-Win32 liggende, jeg prøver lige at smide den anden ud og lægge denne ind, hvilken mysql køre du med?
Avatar billede noob2003 Nybegynder
20. december 2004 - 11:45 #7
Mysql 4.1
Avatar billede noob2003 Nybegynder
20. december 2004 - 16:17 #8
Har du fået det til at virke ??
Avatar billede krohn Praktikant
20. december 2004 - 17:25 #9
Næ langtfra, men prøver lige igen
Avatar billede krohn Praktikant
20. december 2004 - 17:36 #10
Jeg har nu installeret 4.3.10 og får denne, med et test script http://test.6pm.dk/
Men ced ikke om min sql er enabel
Avatar billede krohn Praktikant
20. december 2004 - 17:54 #11
ced??? kan
Avatar billede noob2003 Nybegynder
20. december 2004 - 18:11 #12
Det er den :))
Avatar billede krohn Praktikant
20. december 2004 - 20:08 #13
Jeg er da kommet længere med php my admin end før nu siger den: phpMyAdmin forsøgte at forbinde til MySQL-serveren, og serveren afviste forbindelsen. Du bør tjekke host, brugernavn og kodeord i config.inc.php og sikre dig at de svarer til den information du har fået af administratoren af MySQL-serveren.

Og der er en rød fejl box med et fejl nummer 1251 og den siger: #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Avatar billede krohn Praktikant
20. december 2004 - 20:15 #14
Min config.inc.php ser såda her ud:
<?php
/* $Id: config.inc.php,v 2.41 2004/09/23 10:10:37 rabus Exp $ */
// vim: expandtab sw=4 ts=4 sts=4:

/**
* phpMyAdmin Configuration File
*
* All directives are explained in Documentation.html
*/


/**
* Sets the php error reporting - Please do not change this line!
*/
if (!isset($old_error_reporting)) {
    error_reporting(E_ALL);
    @ini_set('display_errors', '1');
}


/**
* Your phpMyAdmin url
*
* Complete the variable below with the full url ie
*    http://www.your_web.net/path_to_your_phpMyAdmin_directory/
*
* It must contain characters that are valid for a URL, and the path is
* case sensitive on some Web servers, for example Unix-based servers.
*
* In most cases you can leave this variable empty, as the correct value
* will be detected automatically. However, we recommend that you do
* test to see that the auto-detection code works in your system. A good
* test is to browse a table, then edit a row and save it.  There will be
* an error message if phpMyAdmin cannot auto-detect the correct value.
*
* If the auto-detection code does work properly, you can set to TRUE the
* $cfg['PmaAbsoluteUri_DisableWarning'] variable below.
*/
$cfg['PmaAbsoluteUri'] = 'http://php.6pm.dk';


/**
* Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
* You should use this if and ONLY if the PmaAbsoluteUri auto-detection
* works perfectly.
*/
$cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;

/**
* Disable the default warning that is displayed on the DB Details Structure page if
* any of the required Tables for the relationfeatures could not be found
*/
$cfg['PmaNoRelation_DisableWarning']  = FALSE;

/**
* The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
* at least one server configuration uses 'cookie' auth_type, enter here a
* passphrase that will be used by blowfish.
*/
$cfg['blowfish_secret'] = '';

/**
* Server(s) configuration
*/
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use $cfg['Servers'][0].
// You can disable a server config entry by setting host to ''.
$i++;
$cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type']  = 'tcp';      // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension']    = 'mysql';    // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress']      = FALSE;      // Use compressed protocol for the MySQL connection
                                                    // (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser']  = '';          // MySQL control user settings
                                                    // (this user must have read-only
$cfg['Servers'][$i]['controlpass']  = '';          // access to the "mysql/user"
                                                    // and "mysql/db" tables).
                                                    // The controluser is also
                                                    // used for all relational
                                                    // features (pmadb)
$cfg['Servers'][$i]['auth_type']    = 'config';    // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = 'root';      // MySQL user
$cfg['Servers'][$i]['password']      = 'xxxxxxxxxx';// MySQL password (only needed
                                                    // with 'config' auth_type)
$cfg['Servers'][$i]['only_db']      = '';          // 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['Servers'][$i]['verbose']      = '';          // Verbose name for this host - leave blank to show the hostname

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


$i++;
$cfg['Servers'][$i]['host']            = '';
$cfg['Servers'][$i]['port']            = '';
$cfg['Servers'][$i]['socket']          = '';
$cfg['Servers'][$i]['connect_type']    = 'tcp';
$cfg['Servers'][$i]['extension']      = 'mysql';
$cfg['Servers'][$i]['compress']        = FALSE;
$cfg['Servers'][$i]['controluser']    = '';
$cfg['Servers'][$i]['controlpass']    = '';
$cfg['Servers'][$i]['auth_type']      = 'config';
$cfg['Servers'][$i]['user']            = '';
$cfg['Servers'][$i]['password']        = 'xxxxxxxxxx';
$cfg['Servers'][$i]['only_db']        = '';
$cfg['Servers'][$i]['verbose']        = '';
$cfg['Servers'][$i]['pmadb']          = ''; // 'phpmyadmin' - see scripts/create_tables.sql
$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]['verbose_check']  = TRUE;
$cfg['Servers'][$i]['AllowDeny']['order']
                                      = '';
$cfg['Servers'][$i]['AllowDeny']['rules']
                                      = array();

$i++;
$cfg['Servers'][$i]['host']            = '';
$cfg['Servers'][$i]['port']            = '';
$cfg['Servers'][$i]['socket']          = '';
$cfg['Servers'][$i]['connect_type']    = 'tcp';
$cfg['Servers'][$i]['extension']      = 'mysql';
$cfg['Servers'][$i]['compress']        = FALSE;
$cfg['Servers'][$i]['controluser']    = '';
$cfg['Servers'][$i]['controlpass']    = '';
$cfg['Servers'][$i]['auth_type']      = 'config';
$cfg['Servers'][$i]['user']            = 'root';
$cfg['Servers'][$i]['password']        = '';
$cfg['Servers'][$i]['only_db']        = '';
$cfg['Servers'][$i]['verbose']        = '';
$cfg['Servers'][$i]['pmadb']          = ''; // 'phpmyadmin' - see scripts/create_tables.sql
$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]['verbose_check']  = TRUE;
$cfg['Servers'][$i]['AllowDeny']['order']
                                      = '';
$cfg['Servers'][$i]['AllowDeny']['rules']
                                      = array();

// If you have more than one server configured, you can set $cfg['ServerDefault']
// 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['ServerDefault'] *MUST* be
// set to that server.
$cfg['ServerDefault'] = 1;              // Default server (0 = no default server)
$cfg['Server']        = '';
unset($cfg['Servers'][0]);


/**
* Other core phpMyAdmin settings
*/
$cfg['OBGzip']                  = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto')
$cfg['PersistentConnections']  = FALSE;  // use persistent connections to MySQL database
$cfg['ExecTimeLimit']          = 300;    // maximum execution time in seconds (0 for no limit)
$cfg['SkipLockedTables']        = FALSE;  // mark used tables, make possible to show
                                          // locked tables (since MySQL 3.23.30)
$cfg['ShowSQL']                = TRUE;  // show SQL queries as run
$cfg['AllowUserDropDatabase']  = FALSE;  // show a 'Drop database' link to normal users
$cfg['Confirm']                = TRUE;  // confirm 'DROP TABLE' & 'DROP DATABASE'
$cfg['LoginCookieRecall']      = TRUE;  // recall previous login in cookie auth. mode or not
$cfg['LoginCookieValidity']    = 1800;  // validity of cookie login (in seconds)
$cfg['UseDbSearch']            = TRUE;  // whether to enable the "database search" feature
                                          // or not
$cfg['IgnoreMultiSubmitErrors'] = FALSE;  // if set to true, PMA continues computing multiple-statement queries
                                          // even if one of the queries failed
$cfg['VerboseMultiSubmit']      = 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['AllowArbitraryServer']    = FALSE;  // allow login to any user entered server in cookie based auth

// Left frame setup
$cfg['LeftFrameLight']        = TRUE;    // use a select-based menu and display only the
                                        // current tables in the left frame.
$cfg['LeftFrameTableSeparator']= '__';  // Which string will be used to generate table prefixes
                                        // to split/nest tables into multiple categories
$cfg['LeftFrameTableLevel']  = '1';    // How many sublevels should be displayed when splitting
                                        // up tables by the above Separator
$cfg['ShowTooltip']          = TRUE;    // display table comment as tooltip in left frame
$cfg['ShowTooltipAliasDB']    = FALSE;  // if ShowToolTip is enabled, this defines that table/db comments
$cfg['ShowTooltipAliasTB']    = FALSE;  // are shown (in the left menu and db_details_structure) instead of
                                        // table/db names. Setting ShowTooltipAliasTB to 'nested' will only
                                        // use the Aliases for nested descriptors, not the table itself.

$cfg['LeftDisplayLogo']      = TRUE;  // display logo at top of left frame
$cfg['LeftDisplayServers']    = FALSE;  // display server choice at top of left frame
$cfg['DisplayServersList']    = FALSE;  // server choice as links

// In the main frame, at startup...
$cfg['ShowStats']            = TRUE;  // allow to display statistics and space usage in
                                        // the pages about database details and table
                                        // properties
$cfg['ShowMysqlInfo']        = FALSE;  // whether to display the "MySQL runtime
$cfg['ShowMysqlVars']        = FALSE;  // information", "MySQL system variables", "PHP
$cfg['ShowPhpInfo']          = FALSE;  // information" and "change password" links for
$cfg['ShowChgPassword']      = FALSE;  // simple users or not
$cfg['SuggestDBName']        = TRUE;  // suggest a new DB name if possible (false = keep empty)

// In browse mode...
$cfg['ShowBlob']              = FALSE;  // display blob field contents
$cfg['NavigationBarIconic']  = TRUE;  // do not display text inside navigation bar buttons
$cfg['ShowAll']              = FALSE;  // allows to display all the rows
$cfg['MaxRows']              = 30;    // maximum number of rows to display
$cfg['Order']                = '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['ProtectBinary']        = 'blob'; // disallow editing of binary fields
                                        // valid values are:
                                        //  FALSE  allow editing
                                        //  'blob' allow editing except for BLOB fields
                                        //  'all'  disallow editing
$cfg['ShowFunctionFields']    = TRUE;  // Display the function fields in edit/insert mode
$cfg['CharEditing']          = 'input';
                                        // Which editor should be used for CHAR/VARCHAR fields:
                                        //  input - allows limiting of input length
                                        //  textarea - allows newlines in fields
$cfg['InsertRows']            = 2;      // How many rows can be inserted at one time

// For the export features...
$cfg['ZipDump']              = TRUE;  // Allow the use of zip/gzip/bzip
$cfg['GZipDump']              = TRUE;  // compression for
$cfg['BZipDump']              = TRUE;  // dump files
$cfg['CompressOnFly']        = 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['LightTabs']            = FALSE;  // use graphically less intense menu tabs
$cfg['PropertiesIconic']      = TRUE;  // Use icons instead of text for the table display of a database (TRUE|FALSE|'both')
$cfg['PropertiesNumColumns']  = 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['DefaultTabServer']      = '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['DefaultTabDatabase']    = 'db_details_structure.php';
                                  // Possible values:
                                  // 'db_details_structure.php' = tables list
                                  // 'db_details.php' = sql form
                                  // 'db_search.php' = search query
$cfg['DefaultTabTable']      = '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['Export']['format']                    = 'sql';  // sql/latex/excel/csv/xml/xls
$cfg['Export']['compression']              = 'none'; // none/zip/gzip/bzip2

$cfg['Export']['asfile']                    = FALSE;
$cfg['Export']['onserver']                  = FALSE;
$cfg['Export']['onserver_overwrite']        = FALSE;
$cfg['Export']['remember_file_template']    = TRUE;

$cfg['Export']['xls_columns']              = FALSE;
$cfg['Export']['xls_null']                  = 'NULL';

$cfg['Export']['csv_columns']              = FALSE;
$cfg['Export']['csv_null']                  = 'NULL';
$cfg['Export']['csv_separator']            = ';';
$cfg['Export']['csv_enclosed']              = '&quot;';
$cfg['Export']['csv_escaped']              = '\\';
$cfg['Export']['csv_terminated']            = 'AUTO';
$cfg['Export']['excel_columns']            = FALSE;
$cfg['Export']['excel_null']                = 'NULL';
$cfg['Export']['excel_edition']            = 'win'; // win/mac

$cfg['Export']['latex_structure']          = TRUE;
$cfg['Export']['latex_data']                = TRUE;
$cfg['Export']['latex_columns']            = TRUE;
$cfg['Export']['latex_relation']            = TRUE;
$cfg['Export']['latex_comments']            = TRUE;
$cfg['Export']['latex_mime']                = TRUE;
$cfg['Export']['latex_null']                = '\textit{NULL}';
$cfg['Export']['latex_caption']            = TRUE;
$cfg['Export']['latex_data_label']          = 'tab:__TABLE__-data';
$cfg['Export']['latex_structure_label']    = 'tab:__TABLE__-structure';

$cfg['Export']['sql_structure']            = TRUE;
$cfg['Export']['sql_data']                  = TRUE;
$cfg['Export']['sql_disable_fk']            = FALSE;
$cfg['Export']['sql_use_transaction']      = FALSE;
$cfg['Export']['sql_drop_database']        = FALSE;
$cfg['Export']['sql_drop_table']            = FALSE;
$cfg['Export']['sql_if_not_exists']        = FALSE;
$cfg['Export']['sql_auto_increment']        = TRUE;
$cfg['Export']['sql_backquotes']            = TRUE;
$cfg['Export']['sql_dates']                = FALSE;
$cfg['Export']['sql_relation']              = FALSE;
$cfg['Export']['sql_columns']              = FALSE;
$cfg['Export']['sql_delayed']              = FALSE;
$cfg['Export']['sql_ignore']                = FALSE;
$cfg['Export']['sql_hex_for_binary']        = TRUE;
$cfg['Export']['sql_type']                  = 'insert'; // insert/update/replace
$cfg['Export']['sql_extended']              = FALSE;
$cfg['Export']['sql_comments']              = FALSE;
$cfg['Export']['sql_mime']                  = FALSE;
$cfg['Export']['sql_header_comment']        = ''; // \n is replaced by new line

/**
* Link to the official MySQL documentation.
* Be sure to include no trailing slash on the path.
* See http://dev.mysql.com/doc/ for more information
* about MySQL manuals and their types.
*/
$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/mysql/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['MySQLManualType'] = 'searchable';


/**
* PDF options
*/
$cfg['PDFPageSizes']        = array('A3', 'A4', 'A5', 'letter', 'legal');
$cfg['PDFDefaultPageSize']  = 'A4';


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

// Force: always use this language - must be defined in
//        libraries/select_lang.lib.php
// $cfg['Lang']    = '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['AllowAnywhereRecoding'] or in language file
// (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
$cfg['DefaultCharset'] = '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['AllowAnywhereRecoding'] = 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['RecodingEngine'] = 'auto';

// Specify some parameters for iconv used in charset conversion. See iconv
// documentation for details:
// http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
$cfg['IconvExtraParams'] = '';

// 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['AvailableCharsets'] = 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
*
* The graphical settings are now located in themes/themename/layout.inc.php
*/

$cfg['LeftPointerEnable']  = TRUE;        // enable the left panel pointer
                                            // (used when LeftFrameLight is FALSE)
                                            // see also LeftPointerColor
                                            // in layout.inc.php

$cfg['BrowsePointerEnable'] = TRUE;        // enable the browse pointer
                                            // see also BrowsePointerColor
                                            // in layout.inc.php

$cfg['BrowseMarkerEnable'] = TRUE;        // enable the browse marker
                                            // see also BrowseMarkerColor
                                            // in layout.inc.php

$cfg['TextareaCols']        = 40;          // textarea size (columns) in edit mode
                                            // (this value will be emphasized (*2) for sql
                                            // query textareas and (*1.25) for query window)
$cfg['TextareaRows']        = 7;            // textarea size (rows) in edit mode
$cfg['LongtextDoubleTextarea'] = TRUE;      // double size of textarea size for longtext fields
$cfg['TextareaAutoSelect']  = TRUE;        // autoselect when clicking in the textarea of the querybox
$cfg['CharTextareaCols']    = 40;          // textarea size (columns) for CHAR/VARCHAR
$cfg['CharTextareaRows']    = 2;            // textarea size (rows) for CHAR/VARCHAR
$cfg['CtrlArrowsMoving']    = TRUE;        // Enable Ctrl+Arrows moving between fields when editing?
$cfg['LimitChars']          = 50;          // Max field data length in browse mode for all non-numeric fields
$cfg['ModifyDeleteAtLeft']  = TRUE;        // show edit/delete links on left side of browse
                                            // (or at the top with vertical browse)
$cfg['ModifyDeleteAtRight'] = FALSE;        // show edit/delete links on right side of browse
                                            // (or at the bottom with vertical browse)
$cfg['DefaultDisplay']      = 'horizontal'; // default display direction
                                            // (horizontal|vertical|horizontalflipped)
$cfg['DefaultPropDisplay']  = 'horizontal'; // default display direction for altering/
                                            // creating columns (tbl_properties)
                                            // (horizontal|vertical)

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

$cfg['QueryFrame']          = TRUE;        // displays a link or icon in the left frame to open the querybox, and activates the querybox when clicking on [Edit] on the results page.
$cfg['QueryFrameJS']        = 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['QueryWindowWidth']    = 550;          // Width of Query window
$cfg['QueryWindowHeight']  = 310;          // Height of Query window
$cfg['QueryHistoryDB']      = 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['QueryWindowDefTab']  = 'sql';        // which tab to display in the querywindow on startup
                                            // (sql|files|history|full)
$cfg['QueryHistoryMax']    = 25;          // When using DB-based query history, how many entries
                                            // should be kept?
$cfg['BrowseMIME']          = TRUE;        // Use MIME-Types (stored in column comments table) for
$cfg['MaxExactCount']      = 20000;        // When approximate count < this, PMA will get exact count for
                                            // table rows.
$cfg['WYSIWYG-PDF']        = TRUE;        // Utilize DHTML/JS capabilities to allow WYSIWYG editing of
                                            // the PDF page editor. Requires an IE6/Mozilla based browser.

$cfg['NaturalOrder']        = TRUE;        // Sort table and database in natural order


//-----------------------------------------------------------------------------
// custom-setup by mkkeck: 2004-05-04
//    some specials for new icons and scrollings
// FIXME:
// 2004-05-08 rabus: We need to rearrange these variables.

$cfg['ShowHttpHostTitle']  = TRUE;            // show HttpHost in browsers window title (true|false)?
$cfg['SetHttpHostTitle']    = '';              // if ShowHttpHostTitle=true, please set your host (server)
                                            // or an other string, wich should be shown in browsers window title.
                                            // If not set (or empty), the PMA will get your real Host-Adress.

$cfg['ErrorIconic']          = TRUE;    // show some icons for warnings, errors and informations (true|false)?
$cfg['MainPageIconic']      = TRUE;    // show icons in list on main page, on right panel top menu (server db table)  and on menu tabs (true|false)?
$cfg['ReplaceHelpImg']      = TRUE;    // show help button instead of strDocumentation (true|false)?

// theme manager
$cfg['ThemePath']          = './themes';    // using themes manager please set up here the path to 'themes'
                                            // else leave empty
$cfg['ThemeManager']        = TRUE;          // if you want to use selectable themes and if ThemesPath not empty
                                            // set it to true, else set it to false (default is false);
$cfg['ThemeDefault']        = 'original';        // set up default theme, if ThemePath not empty
                                            // you can set up here an valid path to themes or 'original' for
                                            // the original pma-theme

//-----------------------------------------------------------------------------


/**
* Default queries
* %d will be replaced by the database name.
* %t will be replaced by the table name.
* %f will be replaced by a list of field names.
* (%t and %f only applies to DefaultQueryTable)
*/
$cfg['DefaultQueryTable']    = 'SELECT * FROM %t WHERE 1';
$cfg['DefaultQueryDatabase'] = '';

/**
* SQL Query box settings
* These are the links display in all of the SQL Query boxes
*/
$cfg['SQLQuery']['Edit']      = TRUE;      // Edit link to change a query
$cfg['SQLQuery']['Explain']  = TRUE;      // EXPLAIN on SELECT queries
$cfg['SQLQuery']['ShowAsPHP'] = TRUE;      // Wrap a query in PHP
$cfg['SQLQuery']['Validate']  = FALSE;      // Validate a query (see $cfg['SQLValidator'] as well)
$cfg['SQLQuery']['Refresh']  = TRUE;      // Refresh the results page


/**
* Webserver upload/save/import directories
*/
$cfg['UploadDir']            = '';        // Directory for uploaded files that can be executed by
                                            // phpMyAdmin. For example './upload'. Leave empty for
                                            // no upload directory support
$cfg['SaveDir']              = '';        // Directory where phpMyAdmin can save exported data on
                                            // server. For example './save'. Leave empty for no save
                                            // directory support.
$cfg['docSQLDir']            = '';        // Directory for docSQL imports, phpMyAdmin can import
                                            // docSQL files from that directory. For example
                                            // './docSQL'. Leave empty for no docSQL import support.
$cfg['TempDir']              = '';        // Directory where phpMyAdmin can save temporary files.
                                            // This is needed for MS Excel export, see documentation
                                            // how to enable that.


/**
* Misc. settings
*/
$cfg['GD2Available']          = 'auto';    // Is GD >= 2 available? Set to yes/no/auto. 'auto'
                                            // does autodetection, which is a bit expensive for
                                            // php < 4.3.0, but it is the only safe vay how to
                                            // determine GD version.
/**
* SQL Parser Settings
*/
$cfg['SQP']['fmtType']      = 'html';      // Pretty-printing style to use on queries (html, text, none)
$cfg['SQP']['fmtInd']      = '1';          // Amount to indent each level (floats ok)
$cfg['SQP']['fmtIndUnit']  = 'em';        // Units for indenting each level (CSS Types - {em,px,pt})
// The graphical settings are now located in themes/themename/layout.inc.php

/**
* 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['SQLValidator']['use']      = FALSE;  // Make the SQL Validator available
$cfg['SQLValidator']['username'] = '';      // If you have a custom username, specify it here (defaults to anonymous)
$cfg['SQLValidator']['password'] = '';      // Password for username

/**
* Developers ONLY!
* To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
*/
$cfg['DBG']['enable'] = FALSE;              // Make the DBG stuff available
$cfg['DBG']['profile']['enable'] = FALSE;  // Produce profiling results of PHP
$cfg['DBG']['profile']['threshold'] = 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['ColumnTypes'] = 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'
);

// Attributes
$cfg['AttributeTypes'] = array(
  '',
  'BINARY',
  'UNSIGNED',
  'UNSIGNED ZEROFILL'
);

// Available functions
if ($cfg['ShowFunctionFields']) {
    $cfg['Functions'] = array(
      'ASCII',
      'CHAR',
      'SOUNDEX',
      'LCASE',
      'UCASE',
      'NOW',
      'PASSWORD',
      'MD5',
      'SHA1',
      '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['RestrictColumnTypes'] = 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['RestrictFunctions'] = array(
        'FUNC_CHAR'  => array(
            'ASCII',
            'CHAR',
            'SOUNDEX',
            'LCASE',
            'UCASE',
            'PASSWORD',
            'MD5',
            'SHA1',
            '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',
            'SHA1',
            'ENCRYPT',
            'RAND',
            'LAST_INSERT_ID',
            'COUNT',
            'AVG',
            'SUM'
        )
    );

    // Default functions for above defined groups
    $cfg['DefaultFunctions'] = array(
        'FUNC_CHAR'        => '',
        'FUNC_DATE'        => '',
        'FUNC_NUMBER'      => '',
        'first_timestamp'  => 'NOW'
    );


} // end if

// Search operators
$cfg['NumOperators'] = array(
  '=',
  '>',
  '>=',
  '<',
  '<=',
  '!=',
  'LIKE',
  'NOT LIKE'
);

$cfg['TextOperators'] = array(
  'LIKE',
  'LIKE %...%',
  'NOT LIKE',
  '=',
  '!=',
  'REGEXP',
  'NOT REGEXP'
);

$cfg['EnumOperators'] = array(
  '=',
  '!='
);

$cfg['NullOperators'] = array(
  'IS NULL',
  'IS NOT NULL'
);

$cfg['UnaryOperators'] = array(
  'IS NULL'    => 1,
  'IS NOT NULL' => 1
);

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

/**
* File Revision - do not change either!
*/
$cfg['FileRevision'] = '$Revision: 2.41 $';
?>
Avatar billede noob2003 Nybegynder
20. december 2004 - 21:01 #15
min version er 2.5.4 men det burde ikke gøre den store forskel
og her er den del jeg bruger fra $cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname
og ned.
Bemærk config er udskiftet med http
user og password er tom da man skriver det ind



$cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname
$cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type']  = 'tcp';      // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['controluser']  = '';          // MySQL control user settings
                                                    // (this user must have read-only
$cfg['Servers'][$i]['controlpass']  = '';          // access to the "mysql/user"
                                                    // and "mysql/db" tables)
$cfg['Servers'][$i]['auth_type']    = 'http';    // Authentication method (http, http or cookie based)?
$cfg['Servers'][$i]['user']          = '';      // MySQL user
$cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
                                                    // with 'http' auth_type)
$cfg['Servers'][$i]['only_db']      = '';          // If set to a db-name, only
                                                    // this db is displayed
                                                    // at left frame
                                                    // It may also be an array
                                                    // of db-names
$cfg['Servers'][$i]['verbose']      = '';          // Verbose name for this host - leave blank to show the hostname

$cfg['Servers'][$i]['pmadb']        = '';          // Database used for Relation, Bookmark and PDF Features
                                                    // - leave blank for no support
$cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table - leave blank for no bookmark support
$cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)
                                                    //  - leave blank for no relation-links support
$cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
                                                    //  - leave blank for no display fields support
$cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF
                                                    //  schema - leave blank for no PDF schema support
$cfg['Servers'][$i]['pdf_pages']    = '';          // table to describe pages of relationpdf
                                                    // - leave blank if you don't want to use this
$cfg['Servers'][$i]['column_comments']              // table to store columncomments
                                    = '';          // - leave blank if you don't want to use this
$cfg['Servers'][$i]['AllowDeny']['order']          // Host authentication order, leave blank to not use
                                    = '';
$cfg['Servers'][$i]['AllowDeny']['rules']          // Host authentication rules, leave blank for defaults
                                    = array();


$i++;
$cfg['Servers'][$i]['host']            = '';
$cfg['Servers'][$i]['port']            = '';
$cfg['Servers'][$i]['socket']          = '';
$cfg['Servers'][$i]['connect_type']    = 'tcp';
$cfg['Servers'][$i]['controluser']    = '';
$cfg['Servers'][$i]['controlpass']    = '';
$cfg['Servers'][$i]['auth_type']      = 'http';
$cfg['Servers'][$i]['user']            = '';
$cfg['Servers'][$i]['password']        = '';
$cfg['Servers'][$i]['only_db']        = '';
$cfg['Servers'][$i]['verbose']        = '';
$cfg['Servers'][$i]['pmadb']          = '';
$cfg['Servers'][$i]['bookmarktable']  = '';
$cfg['Servers'][$i]['relation']        = '';
$cfg['Servers'][$i]['table_info']      = '';
$cfg['Servers'][$i]['table_coords']    = '';
$cfg['Servers'][$i]['pdf_pages']      = '';
$cfg['Servers'][$i]['column_comments'] = '';
$cfg['Servers'][$i]['AllowDeny']['order']
                                      = '';
$cfg['Servers'][$i]['AllowDeny']['rules']
                                      = array();

$i++;
$cfg['Servers'][$i]['host']            = '';
$cfg['Servers'][$i]['port']            = '';
$cfg['Servers'][$i]['socket']          = '';
$cfg['Servers'][$i]['connect_type']    = 'tcp';
$cfg['Servers'][$i]['controluser']    = '';
$cfg['Servers'][$i]['controlpass']    = '';
$cfg['Servers'][$i]['auth_type']      = 'http';
$cfg['Servers'][$i]['user']            = '';
$cfg['Servers'][$i]['password']        = '';
$cfg['Servers'][$i]['only_db']        = '';
$cfg['Servers'][$i]['verbose']        = '';
$cfg['Servers'][$i]['pmadb']          = '';
$cfg['Servers'][$i]['bookmarktable']  = '';
$cfg['Servers'][$i]['relation']        = '';
$cfg['Servers'][$i]['table_info']      = '';
$cfg['Servers'][$i]['table_coords']    = '';
$cfg['Servers'][$i]['pdf_pages']      = '';
$cfg['Servers'][$i]['column_comments'] = '';
$cfg['Servers'][$i]['AllowDeny']['order']
                                      = '';
$cfg['Servers'][$i]['AllowDeny']['rules']
                                      = array();

// If you have more than one server httpured, you can set $cfg['ServerDefault']
// 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 httpured, $cfg['ServerDefault'] *MUST* be
// set to that server.
$cfg['ServerDefault'] = 1;              // Default server (0 = no default server)
$cfg['Server']        = '';
unset($cfg['Servers'][0]);


/**
* Other core phpMyAdmin settings
*/
$cfg['OBGzip']                = TRUE;  // use GZIP output buffering if possible
$cfg['PersistentConnections'] = FALSE;  // use persistent connections to MySQL database
$cfg['ExecTimeLimit']        = 300;    // maximum execution time in seconds (0 for no limit)
$cfg['SkipLockedTables']      = FALSE;  // mark used tables, make possible to show
                                        // locked tables (since MySQL 3.23.30)
$cfg['ShowSQL']              = TRUE;  // show SQL queries as run
$cfg['AllowUserDropDatabase'] = FALSE;  // show a 'Drop database' link to normal users
$cfg['Confirm']              = TRUE;  // confirm 'DROP TABLE' & 'DROP DATABASE'
$cfg['LoginCookieRecall']    = TRUE;  // recall previous login in cookie auth. mode or not
$cfg['UseDbSearch']          = TRUE;  // whether to enable the "database search" feature
                                        // or not

// Left frame setup
$cfg['LeftFrameLight']        = TRUE;  // use a select-based menu and display only the
                                        // current tables in the left frame.
$cfg['ShowTooltip']          = TRUE;  // display table comment as tooltip in left frame
$cfg['LeftDisplayLogo']      = TRUE;  // display logo at top of left frame

// In the main frame, at startup...
$cfg['ShowStats']            = TRUE;  // allow to display statistics and space usage in
                                        // the pages about database details and table
                                        // properties
$cfg['ShowMysqlInfo']        = FALSE;  // whether to display the "MySQL runtime
$cfg['ShowMysqlVars']        = FALSE;  // information", "MySQL system variables", "PHP
$cfg['ShowPhpInfo']          = FALSE;  // information" and "change password" links for
$cfg['ShowChgPassword']      = FALSE;  // simple users or not
$cfg['SuggestDBName']        = TRUE;  // suggest a new DB name if possible (false = keep empty)

// In browse mode...
$cfg['ShowBlob']              = FALSE;  // display blob field contents
$cfg['NavigationBarIconic']  = TRUE;  // do not display text inside navigation bar buttons
$cfg['ShowAll']              = FALSE;  // allows to display all the rows
$cfg['MaxRows']              = 30;    // maximum number of rows to display
$cfg['Order']                = '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['ProtectBinary']        = 'blob'; // disallow editing of binary fields
                                        // valid values are:
                                        //  FALSE  allow editing
                                        //  'blob' allow editing except for BLOB fields
                                        //  'all'  disallow editing
$cfg['ShowFunctionFields']    = TRUE;  // Display the function fields in edit/insert mode
$cfg['CharEditing']          = '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['ZipDump']              = TRUE;  // Allow the use of zip/gzip/bzip
$cfg['GZipDump']              = TRUE;  // compression for
$cfg['BZipDump']              = TRUE;  // dump files

// Default Tabs display settings
$cfg['DefaultTabDatabase']    = 'db_details_structure.php';
                                  // Possible values:
                                  // 'db_details_structure.php' = tables list
                                  // 'db_details.php' = sql form
                                  // 'db_search.php' = search query
$cfg['DefaultTabTable']      = 'tbl_properties_structure.php';
                                  // Possible values:
                                  // 'tbl_properties_structure.php' = fields list
                                  // 'tbl_properties.php' = sql form
                                  // 'tbl_select.php = select page (buggy!)
                                  // 'tbl_change.php = insert row page


/**
* 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['MySQLManualBase'] = '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['MySQLManualType'] = 'searchable';


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

// Force: always use this language - must be defined in
//        libraries/select_lang.lib.php
// $cfg['Lang']    = '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['AllowAnywhereRecoding'] or in language file
// (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
$cfg['DefaultCharset'] = '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['AllowAnywhereRecoding'] = 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['RecodingEngine'] = 'auto';

// 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['AvailableCharsets'] = 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-1257',
    'koi8-r',
    'big5',
    'gb2312',
    'utf-8',
    'utf-7',
    'x-user-defined',
    'euc-jp',
    'ks_c_5601-1987',
    'tis-620',
    'SHIFT_JIS'
);

// Loads language file
require('./libraries/select_lang.lib.php');


/**
* Customization & design
*/
$cfg['LeftWidth']          = 150;          // left frame width
$cfg['LeftBgColor']        = '#D0DCE0';    // background color for the left frame
$cfg['RightBgColor']        = '#F5F5F5';    // background color for the right frame
$cfg['RightBgImage']        = '';          // path to a background image for the right frame
                                            // (leave blank for no background image)
$cfg['LeftPointerColor']    = '#CCFFCC';    // color of the pointer in left frame
                                            // (blank for no pointer)
$cfg['Border']              = 0;            // border width on tables
$cfg['ThBgcolor']          = '#D3DCE3';    // table header row colour
$cfg['BgcolorOne']          = '#CCCCCC';    // table data row colour
$cfg['BgcolorTwo']          = '#DDDDDD';    // table data row colour, alternate
$cfg['BrowsePointerColor']  = '#CCFFCC';    // color of the pointer in browse mode
                                            // (blank for no pointer)
$cfg['BrowseMarkerColor']  = '#FFCC99';    // color of the marker (visually marks row
                                            // by clicking on it) in browse mode
                                            // (blank for no marker)
$cfg['TextareaCols']        = 40;          // textarea size (columns) in edit mode
                                            // (this value will be emphasized (*2) for sql
                                            // query textareas)
$cfg['TextareaRows']        = 7;            // textarea size (rows) in edit mode
$cfg['TextareaAutoSelect']  = TRUE;        // autoselect when clicking in the textarea of the querybox
$cfg['CharTextareaCols']    = 40;          // textarea size (columns) for CHAR/VARCHAR
$cfg['CharTextareaRows']    = 2;            // textarea size (rows) for CHAR/VARCHAR
$cfg['LimitChars']          = 50;          // max field data length in browse mode
$cfg['ModifyDeleteAtLeft']  = TRUE;        // show edit/delete links on left side of browse
                                            // (or at the top with vertical browse)
$cfg['ModifyDeleteAtRight'] = FALSE;        // show edit/delete links on right side of browse
                                            // (or at the bottom with vertical browse)
$cfg['DefaultDisplay']      = 'horizontal'; // default display direction (horizontal|vertical)
$cfg['RepeatCells']        = 100;          // repeat header names every X cells? (0 = deactivate)


/**
* SQL Query box settings
* These are the links display in all of the SQL Query boxes
*/
$cfg['SQLQuery']['Edit']      = TRUE;      // Edit link to change a query
$cfg['SQLQuery']['Explain']  = TRUE;      // EXPLAIN on SELECT queries
$cfg['SQLQuery']['ShowAsPHP'] = TRUE;      // Wrap a query in PHP
$cfg['SQLQuery']['Validate']  = FALSE;      // Validate a query (see $cfg['SQLValidator'] as well)


/**
* web-server upload directory
*/
$cfg['UploadDir']            = '';        // for example, './upload/'; you must end it with
                                            // a slash, and you leave it empty for no upload
                                            // directory


/**
* SQL Parser Settings
*/
$cfg['SQP']['enable']      = TRUE;        // Totally turn off the SQL Parser (not recommended)
$cfg['SQP']['fmtType']      = 'html';      // Pretty-printing style to use on queries (html, text, none)
$cfg['SQP']['fmtInd']      = '1';          // Amount to indent each level (floats ok)
$cfg['SQP']['fmtIndUnit']  = 'em';        // Units for indenting each level (CSS Types - {em,px,pt})
$cfg['SQP']['fmtColor']    = array(        // Syntax colouring data
    'comment'            => '#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_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['SQLValidator']['use']      = FALSE;  // Make the SQL Validator available
$cfg['SQLValidator']['username'] = '';      // If you have a custom username, specify it here (defaults to anonymous)
$cfg['SQLValidator']['password'] = '';      // Password for username


/**
* MySQL settings
*/
// Column types;
// varchar, tinyint, text and date are listed first, based on estimated popularity
$cfg['ColumnTypes'] = 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['AttributeTypes'] = array(
  '',
  'BINARY',
  'UNSIGNED',
  'UNSIGNED ZEROFILL'
);

// Available functions
if ($cfg['ShowFunctionFields']) {
    $cfg['Functions'] = 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'
    );
} // end if


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

/**
* File Revision - do not change either!
*/
$cfg['FileRevision'] = '$Revision: 1.151 $';
?>
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Vi tilbyder markedets bedste kurser inden for webudvikling

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester