Титла: Mysql error
Публикувано от: chesster в Aug 23, 2008, 17:36
Примерен код | Lost connection to MySQL server at 'reading initial communication packet', system error: 111 | някой може ли да ми обясни тва как се оправя и какво е
Титла: Mysql error
Публикувано от: spec1 в Aug 23, 2008, 20:28
Не си дал никаква информация, за сървъра: конфигурация,настройки поне my.cnf
Титла: Mysql error
Публикувано от: chesster в Aug 24, 2008, 02:51
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 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
|
кажи ако трябват и други 
Титла: Mysql error
Публикувано от: spec1 в Aug 24, 2008, 10:53
Забрани отварянето на ТСР порт 3306 (сложи # пред port ...) да остане само "socket ..." B php.ini трябва да е указан сокета: mysql.default_socket = ... (от my.cnf) Махни реда mysql.default_port = ... и рестартирай сървъра.
Титла: Mysql error
Публикувано от: chesster в Aug 24, 2008, 16:34
същата работа ;( ;(
Титла: Mysql error
Публикувано от: bulg в Aug 24, 2008, 18:20
Титла: Mysql error
Публикувано от: chesster в Aug 24, 2008, 19:15
ся с риск да ми кажете пак 4овека се oпива да ти помогне а ти го псуваш щи кажа че съм начинещ и щом пиша тука значи тва дето има в google немие помогнало
Титла: Mysql error
Публикувано от: bnight в Aug 25, 2008, 15:34
Цитат (chesster @ Авг. 24 2008,20:15) | ся с риск да ми кажете пак 4овека се oпива да ти помогне а ти го псуваш щи кажа че съм начинещ и щом пиша тука значи тва дето има в google немие помогнало |
chesser предполагам че се опитваш да настройш phpmyadmin който ти връща тази грешка ? За целта ти трябва да редактираш конфигурационият файл на phpmyadmin-a мисля че се казваше config.inc.php моля те постни съдържанието на този файл който се намира в работната директория на phpmyadmin за да го редактираме и да сръботи. Поздрави.
Титла: Mysql error
Публикувано от: chesster в Aug 25, 2008, 16: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'] = '';
/** * 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 $'; ?>
|
Титла: Mysql error
Публикувано от: neter в Aug 25, 2008, 21:41
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. Тогава няма да има нужда данни за автентикация да седят в този файл 
Титла: Mysql error
Публикувано от: bnight в Aug 26, 2008, 09:56
Цитат (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. Поздрави.
|