archive-nl.com » NL » Z » ZONINSTITUUT.NL

Total: 197

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".

  • Hier komt de website van zoninstituut nl Ga direct naar uw Hosting Manager

    Original URL path: http://www.zoninstituut.nl/ (2015-12-05)
    Open archived version from archive


  • Login Portal van zoninstituut.nl
    Login Portal zoninstituut nl 1 Hosting Manager 2 Webmail 3 phpMyAdmin MySQL

    Original URL path: http://www.zoninstituut.nl/scripts/ (2015-12-05)
    Open archived version from archive

  • phpMyAdmin
    Estonian Suomi Finnish Français French Galego Galician Hindi Hrvatski Croatian Magyar Hungarian Bahasa Indonesia Indonesian Italiano Italian Japanese Lietuvi Lithuanian Norsk Norwegian Nederlands Dutch Polski Polish Português Portuguese Português Brazilian portuguese Român Romanian Russian Sinhala Slovenčina Slovak Slovenščina Slovenian Serbian

    Original URL path: http://www.zoninstituut.nl/phpmyadmin/ (2015-12-05)
    Open archived version from archive

  • phpMyAdmin
    Español Spanish Eesti Estonian Suomi Finnish Français French Galego Galician Hindi Hrvatski Croatian Magyar Hungarian Bahasa Indonesia Indonesian Italiano Italian Japanese Lietuvi Lithuanian Norsk Norwegian Nederlands Dutch Polski Polish Português Portuguese Português Brazilian portuguese Român Romanian Russian Sinhala Slovenčina Slovak

    Original URL path: http://www.zoninstituut.nl/phpmyadmin/url.php?url=http%3A%2F%2Fwww.phpmyadmin.net%2F&lang=en&collation_connection=utf8_general_ci&token=a674af7825a526afa870f55cb94b20dc (2015-12-05)
    Open archived version from archive

  • phpMyAdmin 3.4.11.1 - Documentation
    to display a link to wrap a query in PHP code in any SQL Query box cfg SQLQuery Validate boolean Whether to display a link to validate a query in any SQL Query box See also cfg SQLValidator cfg SQLQuery Refresh boolean Whether to display a link to refresh a query in any SQL Query box cfg UploadDir string The name of the directory where SQL files have been uploaded by other means than phpMyAdmin for example ftp Those files are available under a drop down box when you click the database or table name then the Import tab If you want different directory for each user u will be replaced with username Please note that the file names must have the suffix sql or sql bz2 or sql gz if support for compressed formats is enabled This feature is useful when your file is too big to be uploaded via HTTP or when file uploads are disabled in PHP Please note that if PHP is running in safe mode this directory must be owned by the same user as the owner of the phpMyAdmin scripts See also FAQ 1 16 for alternatives cfg SaveDir string The name of the directory where dumps can be saved If you want different directory for each user u will be replaced with username Please note that the directory must exist and has to be writable for the user running webserver Please note that if PHP is running in safe mode this directory must be owned by the same user as the owner of the phpMyAdmin scripts cfg TempDir string The name of the directory where temporary files can be stored This is needed to work around limitations of open basedir for uploaded files see FAQ 1 11 If the directory where phpMyAdmin is installed is subject to an open basedir restriction you need to create a temporary directory in some directory accessible by the web server However for security reasons this directory should be outside the tree published by webserver If you cannot avoid having this directory published by webserver place at least an empty index html file there so that directory listing is not possible This directory should have as strict permissions as possible as the only user required to access this directory is the one who runs the webserver If you have root privileges simply make this user owner of this directory and make it accessible only by it chown www data www data tmp chmod 700 tmp If you cannot change owner of the directory you can achieve a similar setup using ACL chmod 700 tmp setfacl m g www data rwx tmp setfacl d m g www data rwx tmp If neither of above works for you you can still make the directory chmod 777 but it might impose risk of other users on system reading and writing data in this directory cfg Export array In this array are defined default parameters for export names of items are similar to texts seen on export page so you can easily identify what they mean cfg Export method string Defines how the export form is displayed when it loads Valid values are quick to display the minimum number of options to configure custom to display every available option to configure custom no form same as custom but does not display the option of using quick export cfg Import array In this array are defined default parameters for import names of items are similar to texts seen on import page so you can easily identify what they mean cfg RepeatCells integer Repeat the headers every X cells or 0 to deactivate cfg EditInWindow boolean cfg QueryWindowWidth integer cfg QueryWindowHeight integer cfg QueryHistoryDB boolean cfg QueryWindowDefTab string cfg QueryHistoryMax integer All those variables affect the query window feature A SQL link or icon is always displayed on the left panel If JavaScript is enabled in your browser a click on this opens a distinct query window which is a direct interface to enter SQL queries Otherwise the right panel changes to display a query box The size of this query window can be customized with cfg QueryWindowWidth and cfg QueryWindowHeight both integers for the size in pixels Note that normally those parameters will be modified in layout inc php for the theme you are using If cfg EditInWindow is set to true a click on Edit from the results page in the Showing Rows section opens the query window and puts the current query inside it If set to false clicking on the link puts the SQL query in the right panel s query box The usage of the JavaScript query window is recommended if you have a JavaScript enabled browser Basic functions are used to exchange quite a few variables so most 4th generation browsers should be capable to use that feature It currently is only tested with Internet Explorer 6 and Mozilla 1 x If cfg QueryHistoryDB is set to TRUE all your Queries are logged to a table which has to be created by you see cfg Servers i history If set to FALSE all your queries will be appended to the form but only as long as your window is opened they remain saved When using the JavaScript based query window it will always get updated when you click on a new table db to browse and will focus if you click on Edit SQL after using a query You can suppress updating the query window by checking the box Do not overwrite this query from outside the window below the query textarea Then you can browse tables databases in the background without losing the contents of the textarea so this is especially useful when composing a query with tables you first have to look in The checkbox will get automatically checked whenever you change the contents of the textarea Please uncheck the button whenever you definitely want the query window to get updated even though you have made alterations If cfg QueryHistoryDB is set to TRUE you can specify the amount of saved history items using cfg QueryHistoryMax The query window also has a custom tabbed look to group the features Using the variable cfg QueryWindowDefTab you can specify the default tab to be used when opening the query window It can be set to either sql files history or full cfg BrowseMIME boolean Enable MIME transformations cfg MaxExactCount integer For InnoDB tables determines for how large tables phpMyAdmin should get the exact row count using SELECT COUNT If the approximate row count as returned by SHOW TABLE STATUS is smaller than this value SELECT COUNT will be used otherwise the approximate count will be used cfg MaxExactCountViews integer For VIEWs since obtaining the exact count could have an impact on performance this value is the maximum to be displayed using a SELECT COUNT LIMIT The default value of 0 bypasses any row counting cfg NaturalOrder boolean Sorts database and table names according to natural order for example t1 t2 t10 Currently implemented in the left panel Light mode and in Database view for the table list cfg InitialSlidersState string If set to closed the visual sliders are initially in a closed state A value of open does the reverse To completely disable all visual sliders use disabled cfg UserprefsDisallow array Contains names of configuration options keys in cfg array that users can t set through user preferences For possible values refer to libraries config user preferences forms php cfg UserprefsDeveloperTab boolean Activates in the user preferences a tab containing options for developers of phpMyAdmin cfg TitleTable string cfg TitleDatabase string cfg TitleServer string cfg TitleDefault string Allows you to specify window s title bar You can use format string expansion cfg ErrorIconic boolean Uses icons for warnings errors and informations cfg MainPageIconic boolean Uses icons on main page in lists and menu tabs cfg ReplaceHelpImg boolean Shows a help button instead of the Documentation message cfg ThemePath string If theme manager is active use this as the path of the subdirectory containing all the themes cfg ThemeManager boolean Enables user selectable themes See FAQ 2 7 cfg ThemeDefault string The default theme a subdirectory under cfg ThemePath cfg ThemePerServer boolean Whether to allow different theme for each server cfg DefaultQueryTable string cfg DefaultQueryDatabase string Default queries that will be displayed in query boxes when user didn t specify any You can use standard format string expansion cfg SQP fmtType string html none The main use of the new SQL Parser is to pretty print SQL queries By default we use HTML to format the query but you can disable this by setting this variable to none cfg SQP fmtInd float cfg SQP fmtIndUnit string em px pt ex For the pretty printing of SQL queries under some cases the part of a query inside a bracket is indented By changing cfg SQP fmtInd you can change the amount of this indent Related in purpose is cfg SQP fmtIndUnit which specifies the units of the indent amount that you specified This is used via stylesheets cfg SQP fmtColor array of string tuples This array is used to define the colours for each type of element of the pretty printed SQL queries The tuple format is class HTML colour code empty string If you specify an empty string for the color of a class it is ignored in creating the stylesheet You should not alter the class names only the colour strings Class name key comment Applies to all comment sub classes comment mysql Comments as n comment ansi Comments as n comment c Comments as digit Applies to all digit sub classes digit hex Hexadecimal numbers digit integer Integer numbers digit float Floating point numbers punct Applies to all punctuation sub classes punct bracket open round Opening brackets punct bracket close round Closing brackets punct listsep List item Separator punct qualifier Table Column Qualifier punct queryend End of query marker alpha Applies to all alphabetic classes alpha columnType Identifiers matching a column type alpha columnAttrib Identifiers matching a database table column attribute alpha functionName Identifiers matching a MySQL function name alpha reservedWord Identifiers matching any other reserved word alpha variable Identifiers matching a SQL variable foo alpha identifier All other identifiers quote Applies to all quotation mark classes quote double Double quotes quote single Single quotes quote backtick Backtick quotes cfg SQLValidator boolean cfg SQLValidator use boolean phpMyAdmin now supports use of the Mimer SQL Validator service as originally published on Slashdot For help in setting up your system to use the service see the FAQ 6 14 cfg SQLValidator username string cfg SQLValidator password string The SOAP service allows you to log in with anonymous and any password so we use those by default Instead if you have an account with them you can put your login details here and it will be used in place of the anonymous login cfg DBG DEVELOPERS ONLY cfg DBG sql boolean DEVELOPERS ONLY Enable logging queries and execution times to be displayed in the bottom of main page right frame cfg ColumnTypes array All possible types of a MySQL column In most cases you don t need to edit this cfg AttributeTypes array Possible attributes for columns In most cases you don t need to edit this cfg Functions array A list of functions MySQL supports In most cases you don t need to edit this cfg RestrictColumnTypes array Mapping of column types to meta types used for preferring displayed functions In most cases you don t need to edit this cfg RestrictFunctions array Functions preferred for column meta types as defined in cfg RestrictColumnTypes In most cases you don t need to edit this cfg DefaultFunctions array Functions selected by default when inserting changing row Functions are defined for meta types from cfg RestrictColumnTypes and for first timestamp which is used for first timestamp column in table cfg NumOperators array Operators available for search operations on numeric and date columns cfg TextOperators array Operators available for search operations on character columns Note that we put LIKE by default instead of LIKE to avoid unintended performance problems in case of huge tables cfg EnumOperators array Operators available for search operations on ENUM columns cfg NullOperators array Additional operators available for search operations when the column can be null Transformations Introduction Usage File structure 1 Introduction To enable transformations you have to setup the column info table and the proper directives Please see the Configuration section on how to do so You can apply different transformations to the contents of each column The transformation will take the content of each column and transform it with certain rules defined in the selected transformation Say you have a column filename which contains a filename Normally you would see in phpMyAdmin only this filename Using transformations you can transform that filename into a HTML link so you can click inside of the phpMyAdmin structure on the column s link and will see the file displayed in a new browser window Using transformation options you can also specify strings to append prepend to a string or the format you want the output stored in For a general overview of all available transformations and their options you can consult your www your host com your install dir transformation overview php installation For a tutorial on how to effectively use transformations see our Link section on the official phpMyAdmin homepage 2 Usage Go to your tbl structure php page i e reached through clicking on the Structure link for a table There click on Change or change icon and there you will see three new fields at the end of the line They are called MIME type Browser transformation and Transformation options The field MIME type is a drop down field Select the MIME type that corresponds to the column s contents Please note that transformations are inactive as long as no MIME type is selected The field Browser transformation is a drop down field You can choose from a hopefully growing amount of pre defined transformations See below for information on how to build your own transformation There are global transformations and mimetype bound transformations Global transformations can be used for any mimetype They will take the mimetype if necessary into regard Mimetype bound transformations usually only operate on a certain mimetype There are transformations which operate on the main mimetype like image which will most likely take the subtype into regard and those who only operate on a specific subtype like image jpeg You can use transformations on mimetypes for which the function was not defined for There is no security check for you selected the right transformation so take care of what the output will be like The field Transformation options is a free type textfield You have to enter transform function specific options here Usually the transforms can operate with default options but it is generally a good idea to look up the overview to see which options are necessary Much like the ENUM SET Fields you have to split up several options using the format a b c NOTE THE MISSING BLANKS This is because internally the options will be parsed as an array leaving the first value the first element in the array and so forth If you want to specify a MIME character set you can define it in the transformation options You have to put that outside of the pre defined options of the specific mime transform as the last value of the set Use the format charset XXX If you use a transform for which you can specify 2 options and you want to append a character set enter first parameter second parameter charset us ascii You can however use the defaults for the parameters charset us ascii 3 File structure All mimetypes and their transformations are defined through single files in the directory libraries transformations They are stored in files to ease up customization and easy adding of new transformations Because the user cannot enter own mimetypes it is kept sure that transformations always work It makes no sense to apply a transformation to a mimetype the transform function doesn t know to handle One can however use empty mime types and global transformations which should work for many mimetypes You can also use transforms on a different mimetype than what they where built for but pay attention to option usage as well as what the transformation does to your column There is a basic file called global inc php This function can be included by any other transform function and provides some basic functions There are 5 possible file names A mimetype subtype transform mimetype subtype transform inc php Please not that mimetype and subtype are separated via which shall not be contained in their names The transform function filename may contain only characters which cause no problems in the file system as well as the PHP function naming convention The transform function will the be called PMA transform mimetype subtype transform Example text html formatted inc php PMA transform text html formatted A mimetype w o subtype transform mimetype transform inc php Please note that there are no single characters The transform function filename may contain only characters which cause no problems in the file system as well as the PHP function naming convention The transform function will the be called PMA transform mimetype transform Example text formatted inc php PMA transform text formatted A mimetype subtype without specific transform function mimetype subtype inc php Please note that there are no characters in the filename Do not use special characters in the filename causing problems with the file system No transformation function is defined in the file itself Example text plain inc php No function A mimetype w o subtype without specific transform function mimetype inc php Please note that there are no characters in the filename Do not use special characters in the filename causing problems with the file system No transformation function is defined in the file itself Example text inc php No function A global transform function with no specific mimetype global transform inc php The transform function will the be called PMA transform global transform Example global formatted PMA transform global formatted So generally use to split up mimetype and subtype and to provide a transform function All filenames containing no in themselves are not shown as valid transform functions in the dropdown Please see the libraries transformations TEMPLATE file for adding your own transform function See the libraries transformations TEMPLATE MIMETYPE for adding a mimetype without a transform function To create a new transform function please see libraries transformations template generator sh To create a new empty mimetype please see libraries transformations template generator mimetype sh A transform function always gets passed three variables buffer Contains the text inside of the column This is the text you want to transform options Contains any user passed options to a transform function as an array meta Contains an object with information about your column The data is drawn from the output of the mysql fetch field function This means all object properties described on the manual page are available in this variable and can be used to transform a column accordingly to unsigned zerofill not null properties The meta mimetype variable contains the original MIME type of the column i e text plain image jpeg etc Additionally you should also provide additional function to provide information about the transformation to the user This function should have same name as transformation function just with appended info suffix This function accepts no parameters and returns array with information about the transformation Currently following keys can be used info Long description of the transformation FAQ Frequently Asked Questions Server Configuration Known limitations ISPs multi user installations Browsers or client OS Using phpMyAdmin phpMyAdmin project Security Synchronization Please have a look at our Link section on the official phpMyAdmin homepage for in depth coverage of phpMyAdmin s features and or interface Server 1 1 My server is crashing each time a specific action is required or phpMyAdmin sends a blank page or a page full of cryptic characters to my browser what can I do Try to set the cfg OBGzip directive to FALSE in your config inc php file and the zlib output compression directive to Off in your php configuration file 1 2 My Apache server crashes when using phpMyAdmin You should first try the latest versions of Apache and possibly MySQL See also the FAQ 1 1 entry about PHP bugs with output buffering If your server keeps crashing please ask for help in the various Apache support groups 1 3 withdrawn 1 4 Using phpMyAdmin on IIS I m displayed the error message The specified CGI application misbehaved by not returning a complete set of HTTP headers You just forgot to read the install txt file from the php distribution Have a look at the last message in this bug report from the official PHP bug database 1 5 Using phpMyAdmin on IIS I m facing crashes and or many error messages with the HTTP This is a known problem with the PHP ISAPI filter it s not so stable Please use instead the cookie authentication mode 1 6 I can t use phpMyAdmin on PWS nothing is displayed This seems to be a PWS bug Filippo Simoncini found a workaround at this time there is no better fix remove or comment the DOCTYPE declarations 2 lines from the scripts libraries header inc php libraries header printview inc php index php navigation php and libraries common lib php 1 7 How can I GZip or Bzip a dump or a CSV export It does not seem to work These features are based on the gzencode and bzcompress PHP functions to be more independent of the platform Unix Windows Safe Mode or not and so on So you must have Zlib Bzip2 support with zlib and with bz2 1 8 I cannot insert a text file in a table and I get an error about safe mode being in effect Your uploaded file is saved by PHP in the upload dir as defined in php ini by the variable upload tmp dir usually the system default is tmp We recommend the following setup for Apache servers running in safe mode to enable uploads of files while being reasonably secure create a separate directory for uploads mkdir tmp php give ownership to the Apache server s user group chown apache apache tmp php give proper permission chmod 600 tmp php put upload tmp dir tmp php in php ini restart Apache 1 9 withdrawn 1 10 I m having troubles when uploading files with phpMyAdmin running on a secure server My browser is Internet Explorer and I m using the Apache server As suggested by Rob M in the phpWizard forum add this line to your httpd conf SetEnvIf User Agent MSIE nokeepalive ssl unclean shutdown It seems to clear up many problems between Internet Explorer and SSL 1 11 I get an open basedir restriction while uploading a file from the query box Since version 2 2 4 phpMyAdmin supports servers with open basedir restrictions However you need to create temporary directory and configure it as cfg TempDir The uploaded files will be moved there and after execution of your SQL commands removed 1 12 I have lost my MySQL root password what can I do The MySQL manual explains how to reset the permissions 1 13 withdrawn 1 14 withdrawn 1 15 I have problems with mysql user column names In previous MySQL versions the User and Password columns were named user and password Please modify your column names to align with current standards 1 16 I cannot upload big dump files memory HTTP or timeout problems Starting with version 2 7 0 the import engine has been re written and these problems should not occur If possible upgrade your phpMyAdmin to the latest version to take advantage of the new import features The first things to check or ask your host provider to check are the values of upload max filesize memory limit and post max size in the php ini configuration file All of these three settings limit the maximum size of data that can be submitted and handled by PHP One user also said that post max size and memory limit need to be larger than upload max filesize There exist several workarounds if your upload is too big or your hosting provider is unwilling to change the settings Look at the cfg UploadDir feature This allows one to upload a file to the server via scp ftp or your favorite file transfer method PhpMyAdmin is then able to import the files from the temporary directory More information is available in the Configuration section of this document Using a utility such as BigDump to split the files before uploading We cannot support this or any third party applications but are aware of users having success with it If you have shell command line access use MySQL to import the files directly You can do this by issuing the source command from within MySQL source filename sql 1 17 Which MySQL versions does phpMyAdmin support Since phpMyAdmin 3 0 x only MySQL 5 0 1 and newer are supported For older MySQL versions you need to use the latest 2 x branch phpMyAdmin can connect to your MySQL server using PHP s classic MySQL extension as well as the improved MySQL extension MySQLi that is available in php 5 0 The latter one should be used unless you have a good reason not to do so When compiling PHP we strongly recommend that you manually link the MySQL extension of your choice to a MySQL client library of at least the same minor version since the one that is bundled with some PHP distributions is rather old and might cause problems see FAQ 1 17a MariaDB is also supported versions 5 1 and 5 2 were tested 1 17a I cannot connect to the MySQL server It always returns the error message Client does not support authentication protocol requested by server consider upgrading MySQL client You tried to access MySQL with an old MySQL client library The version of your MySQL client library can be checked in your phpinfo output In general it should have at least the same minor version as your server as mentioned in FAQ 1 17 This problem is generally caused by using MySQL version 4 1 or newer MySQL changed the authentication hash and your PHP is trying to use the old method The proper solution is to use the mysqli extension with the proper client library to match your MySQL installation Your chosen extension is specified in cfg Servers i extension More information and several workarounds are located in the MySQL Documentation 1 18 withdrawn 1 19 I can t run the display relations feature because the script seems not to know the font face I m using The FPDF library we re using for this feature requires some special files to use font faces Please refers to the FPDF manual to build these files 1 20 I receive the error cannot load MySQL extension please check PHP Configuration To connect to a MySQL server PHP needs a set of MySQL functions called MySQL extension This extension may be part of the PHP distribution compiled in otherwise it needs to be loaded dynamically Its name is probably mysql so or php mysql dll phpMyAdmin tried to load the extension but failed Usually the problem is solved by installing a software package called PHP MySQL or something similar 1 21 I am running the CGI version of PHP under Unix and I cannot log in using cookie auth In php ini set mysql max links higher than 1 1 22 I don t see the Location of text file field so I cannot upload This is most likely because in php ini your file uploads parameter is not set to on 1 23 I m running MySQL on a Win32 machine Each time I create a new table the table and column names are changed to lowercase This happens because the MySQL directive lower case table names defaults to 1 ON in the Win32 version of MySQL You can change this behavior by simply changing the directive to 0 OFF Just edit your my ini file that should be located in your Windows directory and add the following line to the group mysqld set variable lower case table names 0 Next save the file and restart the MySQL service You can always check the value of this directive using the query SHOW VARIABLES LIKE lower case table names 1 24 withdrawn 1 25 I am running Apache with mod gzip 1 3 26 1a on Windows XP and I get problems such as undefined variables when I run a SQL query A tip from Jose Fandos put a comment on the following two lines in httpd conf like this mod gzip item include file php mod gzip item include mime application x httpd php as this version of mod gzip on Apache Windows has problems handling PHP scripts Of course you have to restart Apache 1 26 I just installed phpMyAdmin in my document root of IIS but I get the error No input file specified when trying to run phpMyAdmin This is a permission problem Right click on the phpmyadmin folder and choose properties Under the tab Security click on Add and select the user IUSR machine from the list Now set his permissions and it should work 1 27 I get empty page when I want to view huge page eg db structure php with plenty of tables This is a PHP bug that occur when GZIP output buffering is enabled If you turn off it by cfg OBGzip false in config inc php it should work This bug will be fixed in PHP 5 0 0 1 28 My MySQL server sometimes refuses queries and returns the message Errorcode 13 What does this mean This can happen due to a MySQL bug when having database table names with upper case characters although lower case table names is set to 1 To fix this turn off this directive convert all database and table names to lower case and turn it on again Alternatively there s a bug fix available starting with MySQL 3 23 56 4 0 11 gamma 1 29 When I create a table or modify a column I get an error and the columns are duplicated It is possible to configure Apache in such a way that PHP has problems interpreting php files The problems occur when two different and conflicting set of directives are used SetOutputFilter PHP SetInputFilter PHP and AddType application x httpd php php In the case we saw one set of directives was in etc httpd conf httpd conf while the other set was in etc httpd conf addon modules php conf The recommended way is with AddType so just comment out the first set of lines and restart Apache SetOutputFilter PHP SetInputFilter PHP 1 30 I get the error navigation php Missing hash This problem is known to happen when the server is running Turck MMCache but upgrading MMCache to version 2 3 21 solves the problem 1 31 Does phpMyAdmin support php5 Yes Since release 3 0 only PHP 5 2 and newer For older PHP versions 2 9 branch is still maintained 1 32 Can I use HTTP authentication with IIS Yes This procedure was tested with phpMyAdmin 2 6 1 PHP 4 3 9 in ISAPI mode under IIS 5 1 In your php ini file set cgi rfc2616 headers 0 In Web Site Properties File Directory Security Anonymous Access dialog box check the Anonymous access checkbox and uncheck any other checkboxes i e uncheck Basic authentication Integrated Windows authentication and Digest if it s enabled Click OK In Custom Errors select the range of 401 1 through 401 5 and click the Set to Default button 1 33 Is there a problem with the mysqli extension when running PHP 5 0 4 on 64 bit systems Yes This problem affects phpMyAdmin Call to undefined function pma reloadnavigation so upgrade your PHP to the next version 1 34 Can I access directly to database or table pages Yes Out of the box you can use URL s like http server phpMyAdmin index php server X db database table table target script For server you use the server number which refers to the order of the server paragraph in config inc php Table and script parts are optional If you want http server phpMyAdmin database table script URL s you need to do some configuration Following lines apply only for Apache web server First make sure that you have enabled some features within global configuration You need Options FollowSymLinks and AllowOverride FileInfo enabled for directory where phpMyAdmin is installed and you need mod rewrite to be enabled Then you just need to create following htaccess file in root folder of phpMyAdmin installation don t forget to change directory name inside of it RewriteEngine On RewriteBase path to phpMyAdmin RewriteRule a zA Z0 9 a zA Z0 9 a z php index php db 1 table 2 target 3 R RewriteRule a zA Z0 9 a z php index php db 1 target 2 R RewriteRule a zA Z0 9 a zA Z0 9 index php db 1 table 2 R RewriteRule a zA Z0 9 index php db 1 R 1 35 Can I use HTTP authentication with Apache CGI Yes However you need to pass authentication variable to CGI using following rewrite rule RewriteEngine On RewriteRule E REMOTE USER HTTP Authorization L 1 36 I get an error 500 Internal Server Error There can be many explanations to this and a look at your server s error log file might give a clue 1 37 I run phpMyAdmin on cluster of different machines and password encryption in cookie auth doesn t work If your cluster consist of different architectures PHP code used for encryption decryption won t work correct This is caused by use of pack unpack functions in code Only solution is to use mcrypt extension which works fine in this case 1 38 Can I use phpMyAdmin on a server on which Suhosin is enabled Yes but the default configuration values of Suhosin are known to cause problems with some operations for example editing a table with many columns and no primary key or with textual primary key Suhosin configuration might lead to malfunction in some cases and it can not be fully avoided as phpMyAdmin is kind of application which needs to transfer big amounts of columns in single HTTP request what is something what Suhosin tries to prevent Generally all suhosin request suhosin post and suhosin get directives can have negative effect on phpMyAdmin usability You can always find in your error logs which limit did cause dropping of variable so you can diagnose the problem and adjust matching configuration variable The default values for most Suhosin configuration options will work in most scenarios however you might want to adjust at least following parameters suhosin request max vars should be increased eg 2048 suhosin post max vars should be increased eg 2048 suhosin request max array index length should be increased eg 256 suhosin post max array index length should be increased eg 256 suhosin request max totalname length should be increased eg 8192 suhosin post max totalname length should be increased eg 8192 suhosin get max value length should be increased eg 1024 suhosin sql bailout on error needs to be disabled the default suhosin log should not include SQL otherwise you get big slowdown You can

    Original URL path: http://www.zoninstituut.nl/phpmyadmin/Documentation.html (2015-12-05)
    Open archived version from archive

  • phpMyAdmin
    Español Spanish Eesti Estonian Suomi Finnish Français French Galego Galician Hindi Hrvatski Croatian Magyar Hungarian Bahasa Indonesia Indonesian Italiano Italian Japanese Lietuvi Lithuanian Norsk Norwegian Nederlands Dutch Polski Polish Português Portuguese Português Brazilian portuguese Român Romanian Russian Sinhala Slovenčina Slovak

    Original URL path: http://www.zoninstituut.nl/phpmyadmin/index.php (2015-12-05)
    Open archived version from archive

  • phpMyAdmin
    Español Spanish Eesti Estonian Suomi Finnish Français French Galego Galician Hindi Hrvatski Croatian Magyar Hungarian Bahasa Indonesia Indonesian Italiano Italian Japanese Lietuvi Lithuanian Norsk Norwegian Nederlands Dutch Polski Polish Português Portuguese Português Brazilian portuguese Român Romanian Russian Sinhala Slovenčina Slovak

    Original URL path: http://www.zoninstituut.nl/phpmyadmin/url.php?url=http%3A%2F%2Fwww.phpmyadmin.net%2F&token=6d3fc83201211431a1de64ae9584705a (2015-12-05)
    Open archived version from archive

  • phpMyAdmin
    Español Spanish Eesti Estonian Suomi Finnish Français French Galego Galician Hindi Hrvatski Croatian Magyar Hungarian Bahasa Indonesia Indonesian Italiano Italian Japanese Lietuvi Lithuanian Norsk Norwegian Nederlands Dutch Polski Polish Português Portuguese Português Brazilian portuguese Român Romanian Russian Sinhala Slovenčina Slovak

    Original URL path: http://www.zoninstituut.nl/phpmyadmin/changelog.php (2015-12-05)
    Open archived version from archive



  •