Изпечатай

[chesster]

Примерен код

Lost connection to MySQL server at 'reading initial communication packet', system error: 111

някой може ли да ми обясни тва как се оправя и какво е

[spec1]

Не си дал никаква информация, за сървъра:
  конфигурация,настройки
 поне   my.cnf

[chesster]

spec1 твоа е my.cnf

Примерен код

# Example MySQL config file for medium systems. # # This is for a system with little memory (32M - 64M) where MySQL plays # an important part, or systems up to 128M where MySQL is used together with # other programs (such as a web server) # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # In this file, you can use all long options that a program supports. # If you want to know which options a program supports, run the program # with the "--help" option. # The following options will be passed to all MySQL clients [client] #password   = your_password port      = 3306 socket      = /var/run/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port      = 3306 socket      = /var/run/mysql/mysql.sock skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M # Don't listen on a TCP/IP port at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction with mysqld must be made via Unix sockets or named pipes. # Note that using this option without enabling named pipes on Windows # (via the "enable-named-pipe" option) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging is required for replication log-bin=mysql-bin # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id   = 1 # Replication Slave (comment out master section to use this) # # To configure this host as a replication slave, you can choose between # two methods : # # 1) Use the CHANGE MASTER TO command (fully described in our manual) - #    the syntax is: # #    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>, #    MASTER_USER=<user>, MASTER_PASSWORD=<password>; # #    where you replace <host>, <user>, <password> by quoted strings and #    <port> by the master's port number (3306 by default). # #    Example: # #    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306, #    MASTER_USER='joe', MASTER_PASSWORD='secret'; # # OR # # 2) Set the variables below. However, in case you choose this method, then #    start replication for the first time (even unsuccessfully, for example #    if you mistyped the password in master-password and the slave fails to #    connect), the slave will create a master.info file, and any later #    change in this file to the variables' values below will be ignored and #    overridden by the content of the master.info file, unless you shutdown #    the slave server, delete master.info and restart the slaver server. #    For that reason, you may want to leave the lines below untouched #    (commented) and instead use CHANGE MASTER TO (see above) # # required unique id between 2 and 2^32 - 1 # (and different from the master) # defaults to 2 if master-host is set # but will not function as a slave if omitted #server-id       = 2 # # The replication master for this slave - required #master-host     =   <hostname> # # The username the slave will use for authentication when connecting # to the master - required #master-user     =   <username> # # The password the slave will authenticate with when connecting to # the master - required #master-password =   <password> # # The port the master is listening on. # optional - defaults to 3306 #master-port     =  <port> # # binary logging - not required for slaves, but recommended #log-bin=mysql-bin # Point the following paths to different dedicated disks #tmpdir      = /tmp/       #log-update    = /path-to-dedicated-directory/hostname # Uncomment the following if you are using BDB tables #bdb_cache_size = 4M #bdb_max_lock = 10000 # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:10M:autoextend #innodb_log_group_home_dir = /var/lib/mysql/ #innodb_log_arch_dir = /var/lib/mysql/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high #innodb_buffer_pool_size = 16M #innodb_additional_mem_pool_size = 2M # Set .._log_file_size to 25 % of buffer pool size #innodb_log_file_size = 5M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout

слагам за секи случай и httpd.conf

Примерен код

# # This is the main Apache HTTP server configuration file.  It contains the # configuration directives that give the server its instructions. # See <URL:http://httpd.apache.org/docs/2.2> for detailed information. # In particular, see # <URL:http://httpd.apache.org/docs/2.2/mod/directives.html> # for a discussion of each configuration directive. # # Do NOT simply read the instructions in here without understanding # what they do.  They're here only as hints or reminders.  If you are unsure # consult the online docs. You have been warned.   # # Configuration and logfile names: If the filenames you specify for many # of the server's control files begin with "/" (or "drive:/" for Win32), the # server will use that explicit path.  If the filenames do *not* begin # with "/", the value of ServerRoot is prepended -- so "/var/log/httpd/foo.log" # with ServerRoot set to "/usr" will be interpreted by the # server as "/usr//var/log/httpd/foo.log". # # ServerRoot: The top of the directory tree under which the server's # configuration, error, and log files are kept. # # Do not add a slash at the end of the directory path.  If you point # ServerRoot at a non-local disk, be sure to point the LockFile directive # at a local disk.  If you wish to share the same ServerRoot for multiple # httpd daemons, you will need to change at least LockFile and PidFile. # ServerRoot "/usr" # # Listen: Allows you to bind Apache to specific IP addresses and/or # ports, instead of the default. See also the <VirtualHost> # directive. # # Change this to Listen on specific IP addresses as shown below to # prevent Apache from glomming onto all bound IP addresses. # #Listen 12.34.56.78:80 Listen 80 # # Dynamic Shared Object (DSO) Support # # To be able to use the functionality of a module which was built as a DSO you # have to place corresponding `LoadModule' lines at this location so the # directives contained in it are actually available _before_ they are used. # Statically compiled modules (those listed by `httpd -l') do not need # to be loaded here. # # Example: # LoadModule foo_module modules/mod_foo.so # LoadModule authn_file_module lib/httpd/modules/mod_authn_file.so LoadModule authn_dbm_module lib/httpd/modules/mod_authn_dbm.so LoadModule authn_anon_module lib/httpd/modules/mod_authn_anon.so LoadModule authn_dbd_module lib/httpd/modules/mod_authn_dbd.so LoadModule authn_default_module lib/httpd/modules/mod_authn_default.so LoadModule authn_alias_module lib/httpd/modules/mod_authn_alias.so LoadModule authz_host_module lib/httpd/modules/mod_authz_host.so LoadModule authz_groupfile_module lib/httpd/modules/mod_authz_groupfile.so LoadModule authz_user_module lib/httpd/modules/mod_authz_user.so LoadModule authz_dbm_module lib/httpd/modules/mod_authz_dbm.so LoadModule authz_owner_module lib/httpd/modules/mod_authz_owner.so LoadModule authnz_ldap_module lib/httpd/modules/mod_authnz_ldap.so LoadModule authz_default_module lib/httpd/modules/mod_authz_default.so LoadModule auth_basic_module lib/httpd/modules/mod_auth_basic.so LoadModule auth_digest_module lib/httpd/modules/mod_auth_digest.so LoadModule file_cache_module lib/httpd/modules/mod_file_cache.so LoadModule cache_module lib/httpd/modules/mod_cache.so LoadModule disk_cache_module lib/httpd/modules/mod_disk_cache.so LoadModule mem_cache_module lib/httpd/modules/mod_mem_cache.so LoadModule dbd_module lib/httpd/modules/mod_dbd.so LoadModule dumpio_module lib/httpd/modules/mod_dumpio.so LoadModule ext_filter_module lib/httpd/modules/mod_ext_filter.so LoadModule include_module lib/httpd/modules/mod_include.so LoadModule filter_module lib/httpd/modules/mod_filter.so LoadModule deflate_module lib/httpd/modules/mod_deflate.so LoadModule ldap_module lib/httpd/modules/mod_ldap.so LoadModule log_config_module lib/httpd/modules/mod_log_config.so LoadModule log_forensic_module lib/httpd/modules/mod_log_forensic.so LoadModule logio_module lib/httpd/modules/mod_logio.so LoadModule env_module lib/httpd/modules/mod_env.so LoadModule mime_magic_module lib/httpd/modules/mod_mime_magic.so LoadModule cern_meta_module lib/httpd/modules/mod_cern_meta.so LoadModule expires_module lib/httpd/modules/mod_expires.so LoadModule headers_module lib/httpd/modules/mod_headers.so LoadModule ident_module lib/httpd/modules/mod_ident.so LoadModule usertrack_module lib/httpd/modules/mod_usertrack.so LoadModule unique_id_module lib/httpd/modules/mod_unique_id.so LoadModule setenvif_module lib/httpd/modules/mod_setenvif.so LoadModule version_module lib/httpd/modules/mod_version.so LoadModule proxy_module lib/httpd/modules/mod_proxy.so LoadModule proxy_connect_module lib/httpd/modules/mod_proxy_connect.so LoadModule proxy_ftp_module lib/httpd/modules/mod_proxy_ftp.so LoadModule proxy_http_module lib/httpd/modules/mod_proxy_http.so LoadModule proxy_ajp_module lib/httpd/modules/mod_proxy_ajp.so LoadModule proxy_balancer_module lib/httpd/modules/mod_proxy_balancer.so #LoadModule ssl_module lib/httpd/modules/mod_ssl.so LoadModule mime_module lib/httpd/modules/mod_mime.so LoadModule dav_module lib/httpd/modules/mod_dav.so LoadModule status_module lib/httpd/modules/mod_status.so LoadModule autoindex_module lib/httpd/modules/mod_autoindex.so LoadModule asis_module lib/httpd/modules/mod_asis.so LoadModule info_module lib/httpd/modules/mod_info.so LoadModule cgi_module lib/httpd/modules/mod_cgi.so LoadModule dav_fs_module lib/httpd/modules/mod_dav_fs.so LoadModule vhost_alias_module lib/httpd/modules/mod_vhost_alias.so LoadModule negotiation_module lib/httpd/modules/mod_negotiation.so LoadModule dir_module lib/httpd/modules/mod_dir.so LoadModule imagemap_module lib/httpd/modules/mod_imagemap.so LoadModule actions_module lib/httpd/modules/mod_actions.so LoadModule userdir_module lib/httpd/modules/mod_userdir.so LoadModule alias_module lib/httpd/modules/mod_alias.so LoadModule rewrite_module lib/httpd/modules/mod_rewrite.so <IfModule !mpm_netware_module> # # If you wish httpd to run as a different user or group, you must run # httpd as root initially and it will switch.   # # User/Group: The name (or #number) of the user/group to run httpd as. # It is usually good practice to create a dedicated user and group for # running httpd, as with most system services. # User apache Group apache </IfModule> # 'Main' server configuration # # The directives in this section set up the values used by the 'main' # server, which responds to any requests that aren't handled by a # <VirtualHost> definition.  These values also provide defaults for # any <VirtualHost> containers you may define later in the file. # # All of these directives may appear inside <VirtualHost> containers, # in which case these default settings will be overridden for the # virtual host being defined. # # # ServerAdmin: Your address, where problems with the server should be # e-mailed.  This address appears on some server-generated pages, such # as error documents.  e.g. [EMAIL=admin@your-domain.com]admin@your-domain.com[/EMAIL] # ServerAdmin [EMAIL=you@example.com]you@example.com[/EMAIL] # # ServerName gives the name and port that the server uses to identify itself. # This can often be determined automatically, but we recommend you specify # it explicitly to prevent problems during startup. # # If your host doesn't have a registered DNS name, enter its IP address here. # #ServerName http://www.example.com:80 # # DocumentRoot: The directory out of which you will serve your # documents. By default, all requests are taken from this directory, but # symbolic links and aliases may be used to point to other locations. # DocumentRoot "/srv/httpd/htdocs" # # Each directory to which Apache has access can be configured with respect # to which services and features are allowed and/or disabled in that # directory (and its subdirectories). # # First, we configure the "default" to be a very restrictive set of # features.   # <Directory />     Options FollowSymLinks     AllowOverride None     Order deny,allow     Deny from all </Directory> # # Note that from this point forward you must specifically allow # particular features to be enabled - so if something's not working as # you might expect, make sure that you have specifically enabled it # below. # # # This should be changed to whatever you set DocumentRoot to. # <Directory "/srv/httpd/htdocs">     #     # Possible values for the Options directive are "None", "All",     # or any combination of:     #   Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews     #     # Note that "MultiViews" must be named *explicitly* --- "Options All"     # doesn't give it to you.     #     # The Options directive is both complicated and important.  Please see     # http://httpd.apache.org/docs/2.2/mod/core.html#options     # for more information.     #     Options Indexes FollowSymLinks     #     # AllowOverride controls what directives may be placed in .htaccess files.     # It can be "All", "None", or any combination of the keywords:     #   Options FileInfo AuthConfig Limit     #     AllowOverride None     #     # Controls who can get stuff from this server.     #     Order allow,deny     Allow from all </Directory> # # DirectoryIndex: sets the file that Apache will serve if a directory # is requested. # <IfModule dir_module>     DirectoryIndex index.html index.php </IfModule> # # The following lines prevent .htaccess and .htpasswd files from being # viewed by Web clients. # <FilesMatch "^\.ht">     Order allow,deny     Deny from all     Satisfy All </FilesMatch> # # ErrorLog: The location of the error log file. # If you do not specify an ErrorLog directive within a <VirtualHost> # container, error messages relating to that virtual host will be # logged here.  If you *do* define an error logfile for a <VirtualHost> # container, that host's errors will be logged there and not here. # ErrorLog /var/log/httpd/error_log # # LogLevel: Control the number of messages logged to the error_log. # Possible values include: debug, info, notice, warn, error, crit, # alert, emerg. # LogLevel warn <IfModule log_config_module>     #     # The following directives define some format nicknames for use with     # a CustomLog directive (see below).     #     LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined     LogFormat "%h %l %u %t \"%r\" %>s %b" common     <IfModule logio_module>       # You need to enable mod_logio.c to use %I and %O       LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio     </IfModule>     #     # The location and format of the access logfile (Common Logfile Format).     # If you do not define any access logfiles within a <VirtualHost>     # container, they will be logged here.  Contrariwise, if you *do*     # define per-<VirtualHost> access logfiles, transactions will be     # logged therein and *not* in this file.     #     CustomLog /var/log/httpd/access_log common     #     # If you prefer a logfile with access, agent, and referer information     # (Combined Logfile Format) you can use the following directive.     #     #CustomLog /var/log/httpd/access_log combined </IfModule> <IfModule alias_module>     #     # Redirect: Allows you to tell clients about documents that used to     # exist in your server's namespace, but do not anymore. The client     # will make a new request for the document at its new location.     # Example:     # Redirect permanent /foo http://www.example.com/bar     #     # Alias: Maps web paths into filesystem paths and is used to     # access content that does not live under the DocumentRoot.     # Example:     # Alias /webpath /full/filesystem/path     #     # If you include a trailing / on /webpath then the server will     # require it to be present in the URL.  You will also likely     # need to provide a <Directory> section to allow access to     # the filesystem path.     #     # ScriptAlias: This controls which directories contain server scripts.     # ScriptAliases are essentially the same as Aliases, except that     # documents in the target directory are treated as applications and     # run by the server when requested rather than as documents sent to the     # client.  The same rules about trailing "/" apply to ScriptAlias     # directives as to Alias.     #     ScriptAlias /cgi-bin/ "/srv/httpd/cgi-bin/" </IfModule> <IfModule cgid_module>     #     # ScriptSock: On threaded servers, designate the path to the UNIX     # socket used to communicate with the CGI daemon of mod_cgid.     #     #Scriptsock /var/run/httpd/cgisock </IfModule> # # "/srv/httpd/cgi-bin" should be changed to whatever your ScriptAliased # CGI directory exists, if you have that configured. # <Directory "/srv/httpd/cgi-bin">     AllowOverride None     Options None     Order allow,deny     Allow from all </Directory> # # DefaultType: the default MIME type the server will use for a document # if it cannot otherwise determine one, such as from filename extensions. # If your server contains mostly text or HTML documents, "text/plain" is # a good value.  If most of your content is binary, such as applications # or images, you may want to use "application/octet-stream" instead to # keep browsers from trying to display binary files as though they are # text. # DefaultType text/plain <IfModule mime_module>     #     # TypesConfig points to the file containing the list of mappings from     # filename extension to MIME-type.     #     TypesConfig /etc/httpd/mime.types     #     # AddType allows you to add to or override the MIME configuration     # file specified in TypesConfig for specific file types.     #     #AddType application/x-gzip .tgz     #     # AddEncoding allows you to have certain browsers uncompress     # information on the fly. Note: Not all browsers support this.     #     #AddEncoding x-compress .Z     #AddEncoding x-gzip .gz .tgz     #     # If the AddEncoding directives above are commented-out, then you     # probably should define those extensions to indicate media types:     #     AddType application/x-compress .Z     AddType application/x-gzip .gz .tgz     #     # AddHandler allows you to map certain file extensions to "handlers":     # actions unrelated to filetype. These can be either built into the server     # or added with the Action directive (see below)     #     # To use CGI scripts outside of ScriptAliased directories:     # (You will also need to add "ExecCGI" to the "Options" directive.)     #     #AddHandler cgi-script .cgi     # For type maps (negotiated resources):     #AddHandler type-map var     #     # Filters allow you to process content before it is sent to the client.     #     # To parse .shtml files for server-side includes (SSI):     # (You will also need to add "Includes" to the "Options" directive.)     #     #AddType text/html .shtml     #AddOutputFilter INCLUDES .shtml </IfModule> # # The mod_mime_magic module allows the server to use various hints from the # contents of the file itself to determine its type.  The MIMEMagicFile # directive tells the module where the hint definitions are located. # #MIMEMagicFile /etc/httpd/magic # # Customizable error responses come in three flavors: # 1) plain text 2) local redirects 3) external redirects # # Some examples: #ErrorDocument 500 "The server made a boo boo." #ErrorDocument 404 /missing.html #ErrorDocument 404 "/cgi-bin/missing_handler.pl" #ErrorDocument 402 http://www.example.com/subscription_info.html # # # EnableMMAP and EnableSendfile: On systems that support it, # memory-mapping or the sendfile syscall is used to deliver # files.  This usually improves server performance, but must # be turned off when serving from networked-mounted # filesystems or if support for these functions is otherwise # broken on your system. # #EnableMMAP off #EnableSendfile off # Supplemental configuration # # The configuration files in the /etc/httpd/extra/ directory can be # included to add extra features or to modify the default configuration of # the server, or you may simply copy their contents here and change as # necessary. # Server-pool management (MPM specific) #Include /etc/httpd/extra/httpd-mpm.conf # Multi-language error messages #Include /etc/httpd/extra/httpd-multilang-errordoc.conf # Fancy directory listings #Include /etc/httpd/extra/httpd-autoindex.conf # Language settings #Include /etc/httpd/extra/httpd-languages.conf # User home directories #Include /etc/httpd/extra/httpd-userdir.conf # Real-time info on requests and configuration #Include /etc/httpd/extra/httpd-info.conf # Virtual hosts #Include /etc/httpd/extra/httpd-vhosts.conf # Local access to the Apache HTTP Server Manual #Include /etc/httpd/extra/httpd-manual.conf # Distributed authoring and versioning (WebDAV) #Include /etc/httpd/extra/httpd-dav.conf # Various default settings #Include /etc/httpd/extra/httpd-default.conf # Secure (SSL/TLS) connections #Include /etc/httpd/extra/httpd-ssl.conf # # Note: The following must must be present to support #       starting without SSL on platforms with no /dev/random equivalent #       but a statically compiled-in mod_ssl. # <IfModule ssl_module> SSLRandomSeed startup builtin SSLRandomSeed connect builtin </IfModule> # Uncomment the following line to enable PHP: # Include /etc/httpd/mod_php.conf # Uncomment the following lines to enable svn support: # #LoadModule dav_svn_module lib/httpd/modules/mod_dav_svn.so #LoadModule authz_svn_module lib/httpd/modules/mod_authz_svn.so

кажи ако трябват и други '>

[spec1]

Забрани отварянето на ТСР порт 3306 (сложи # пред port ...)
да остане само "socket ..."
  B php.ini трябва да е указан сокета:
  mysql.default_socket = ... (от my.cnf)
  Махни реда
  mysql.default_port = ...
и рестартирай сървъра.

[chesster]

същата работа ;( ;(

[bulg]

Ползвай google преди това - 48000 results.

[chesster]

ся с риск да ми кажете пак 4овека се oпива да ти помогне а ти го псуваш щи кажа че съм начинещ и щом пиша тука значи  тва дето има в google  немие помогнало

[bnight]

Цитат (chesster @ Авг. 24 2008,20:15)

ся с риск да ми кажете пак 4овека се oпива да ти помогне а ти го псуваш щи кажа че съм начинещ и щом пиша тука значи  тва дето има в google  немие помогнало

chesser предполагам че се опитваш да настройш phpmyadmin който ти връща тази грешка ? За целта ти трябва да редактираш конфигурационият файл на phpmyadmin-a мисля че се казваше config.inc.php моля те постни съдържанието на този файл който се намира в работната директория на phpmyadmin за да го редактираме и да сръботи. Поздрави.

[chesster]

заповядай '>

Примерен код

<?php /* $Id: config.inc.php,v 2.48 2004/12/28 12:48:27 nijel 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'] = ''; /**  * 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']      = 'new-password';          // 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]['AllowRoot']     = TRUE;        // whether to allow root login $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']            = '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]['AllowRoot']       = 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]['AllowRoot']       = 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']= 'TABLETABLE__-structure'; $cfg['Export']['sql_structure']             = TRUE; $cfg['Export']['sql_data']                  = TRUE; $cfg['Export']['sql_compat']                = 'NONE'; $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 warning, error and information messages (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',             'UNIX_TIMESTAMP',             '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.48 $'; ?>

[neter]

chesster, да се загледаме в три от редовете в конфигурационния файл на phpmyadmin

Цитат

$cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)? $cfg['Servers'][$i]['user']          = 'root';      // MySQL user $cfg['Servers'][$i]['password']      = 'new-password';          // MySQL password (only needed                                                    // with 'config' auth_type)

Както се вижда, зададено ти е автентикацията пред MySQL сървъра да се извършва чрез данните в този конфигурационен файл. Увери се, че MySQL потребителят (не системният) root е активен и че си въвел вярна парола на реда $cfg['Servers'][$i]['password'].
Едно предложение - задай auth_type на cookie. Тогава няма да има нужда данни за автентикация да седят в този файл '>

[bnight]

Цитат (chesster @ Авг. 25 2008,17:02)

заповядай '> Примерен код <?php /* $Id: config.inc.php,v 2.48 2004/12/28 12:48:27 nijel 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'] = ''; /**  * 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'] = 'asd93afaimseda'; /**  * 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']  = 'socket';       // 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']     = 'http';    // Authentication method (config, http or cookie based)? $cfg['Servers'][$i]['user']          = '';      // MySQL user $cfg['Servers'][$i]['password']      = '';          // 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]['AllowRoot']     = TRUE;        // whether to allow root login $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']            = '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]['AllowRoot']       = 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]['AllowRoot']       = 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']= 'TABLETABLE__-structure'; $cfg['Export']['sql_structure']             = TRUE; $cfg['Export']['sql_data']                  = TRUE; $cfg['Export']['sql_compat']                = 'NONE'; $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 warning, error and information messages (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',             'UNIX_TIMESTAMP',             '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.48 $'; ?>

Поправено с нужните промени.
Сменени са следните опции:

$cfg['blowfish_secret'] = 'asd93afaimseda';
$cfg['Servers'][$i]['connect_type']  = 'socket';
$cfg['Servers'][$i]['auth_type']     = 'http';
$cfg['Servers'][$i]['user']          = '';
$cfg['Servers'][$i]['password']      = '';

Моля да го пуснеш така конфига и да пробваш пак надявам се че си знаеш паролата за root-a на mysql-a. Поздрави.