523
525
<i>Note: starting with phpMyAdmin 2.6.1, configuring the controluser
524
to enable HTTP and cookie authentication applies only
526
to enable HTTP and cookie authentication applies only
525
527
to MySQL servers older than 4.1.2.</i>
527
529
This special account is used for 2 distinct purposes: to make possible
528
all relational features
529
(see <a href="#pmadb">$cfg['Servers'][$i]['pmadb']</a>) and, for a
530
MySQL server older than 4.1.2, to enable a multi-user installation
530
all relational features
531
(see <a href="#pmadb">$cfg['Servers'][$i]['pmadb']</a>) and, for a
532
MySQL server older than 4.1.2, to enable a multi-user installation
531
533
(http or cookie authentication mode).
533
535
When using HTTP or cookie authentication modes (or 'config'
2695
2697
you won't be able to run phpMyAdmin having enabled E_STRICT in your
2696
2698
error_reporting settings.
2700
<a name="faq1_32"></a><br />
2702
[1.32] Can I use HTTP authentication with IIS?
2705
Yes. This procedure was tested with phpMyAdmin 2.6.1, PHP 4.3.9 in ISAPI
2708
<li>In your <tt>php.ini</tt> file, set <tt>cgi.rfc2616_headers = 0</tt></li>
2710
<li>In <tt>Web Site Properties -> File/Directory Security -> Anonymous Access</tt> dialog box, check the <tt>Anonymous access</tt> checkbox and uncheck any other checkboxes (i.e. uncheck <tt>Basic authentication</tt>, <tt>Integrated Windows authentication</tt>, and <tt>Digest</tt> if it's enabled.) Click <tt>OK</tt>. </li>
2712
<li>In <tt>Custom Errors</tt>, select the range of <tt>401;1</tt> through <tt>401;5</tt> and click the <tt>Set to Default</tt> button. </li>
2699
2716
<a name="faqconfig"></a><br />
2700
2717
<h3>[2. Configuration]</h3>
3273
3290
Please upgrade to at least version 1.2.3.
3293
[5.16] With Internet Explorer, I get "Access is denied"
3294
Javascript errors. Or I cannot make phpMyAdmin work under Windows.
3297
Please check the following points:
3300
Maybe you have defined your <tt>PmaAbsoluteUri</tt> setting
3301
in <tt>config.inc.php</tt> to an IP address and you are starting
3302
phpMyAdmin with a URL containing a domain name, or the reverse situation.
3305
Security settings in IE and/or Microsoft Security Center are
3306
too high, thus blocking scripts execution.
3309
The Windows Firewall is blocking Apache and MySQL. You must
3310
allow http ports (80 or 443) and MySQL port (usually 3306)
3311
in the "in" and "out" directions.
3276
3316
<a name="faqusing"></a><br />
3277
3317
<h3>[6. Using phpMyAdmin]</h3>
3433
3473
[6.8] How can I produce a PDF schema of my database?
3436
First you have to fill the "relation", "table_coords"
3437
and "pdf_pages" configuration variables.
3476
First the configuration variables "relation",
3477
"table_coords" and "pdf_pages" have to be filled in.
3439
Then, think about your schema layout: which tables will go on which pages.
3479
Then you need to think about your schema layout. Which tables will go on
3442
<li>Click on your db name in the left frame</li>
3443
<li>Choose "Structure" in the navigation on top</li>
3444
<li>Choose "Edit PDF Pages" which should be somewhere at the
3445
bottom of the page</li>
3446
<li>Enter the name for a first pdf page and submit (you can also use
3447
the "Automatic layout", which will place on your page
3448
all the tables that are linked)</li>
3449
<li>Choose this page to edit</li>
3450
<li>Now add a table you want to show on this page and its coordinates and
3452
First you will have to guess those coordinates of course, so just expect
3453
to have an area of about 297 * 210 and put the tables coordinates
3454
somewhere in there, you will be able to have a look at what happened
3455
and change them later.<br />
3456
For example, x=100 and y=200 means that the table will be at 200 mm
3457
down and 100 mm right from the upper left corner.<br />
3458
Actually if you have a width of more than 300 or a height of more than
3459
200 then it will automatically be scaled but 200*100 is a good start to
3460
have an idea of what coordinates to use.</li>
3461
<li>There is also a visual editor (scratchboard) available, see the
3462
explanation at the <a href="#wysiwyg">$cfg['WYSIWYG-PDF']</a> section.</li>
3463
<li>After every table you submitted you will have the possibility to submit
3465
<li>When you have entered enough tables Click on your db name in the left
3467
<li>Now, again at the bottom of the page you should be able to choose
3468
"Display PDF schema"<br />
3469
For testing it might be useful to show the grid as well, so you can see
3470
the coordinates used.<br />
3471
Maybe also choose color and submit.</li>
3472
<li>Save the file he will offer you to something like <i>Schema.pdf</i>
3473
(Internet Explorer has some bug there which might make it offer it
3474
without an extension. Under Windows it is important to have the
3475
extension ".pdf", under other OSes you should be fine just
3476
saving the file under the name it offers).</li>
3483
<li>Select your database in the left frame.</li>
3484
<li>Choose "Operations" in the navigation bar at the top.</li>
3485
<li>Choose "Edit PDF Pages" near the bottom of the page.</li>
3486
<li>Enter a name for the first PDF page and click Go. If you like, you
3487
can use the "automatic layout," which will put all your
3488
linked tables onto the new page.</li>
3489
<li>Select the name of the new page (the action choice being set to Edit)
3491
<li>Select a table from the list, enter its coordinates and click Go.<br />
3492
Coordinates are relative; your diagram will
3493
be automatically scaled to fit the page. When initially placing tables
3494
on the page, just pick any coordinates -- say, 50x50. After clicking
3495
Go, you can then use the <a href="#wysiwyg">graphical editor</a> to
3496
position the element correctly.</li>
3497
<li>When you'd like to look at your PDF, first be sure to click the Go
3498
button beneath the list of tables and coordinates, to save any changes
3499
you made there. Then scroll all the way down, select the PDF options
3500
you want, and click Go.</li>
3501
<li>Internet Explorer for Windows may suggest an incorrect filename when
3502
you try to save a generated PDF. When saving a generated PDF, be
3503
sure that the filename ends in ".pdf", for example
3504
"schema.pdf". Browsers on other operating systems, and other
3505
browsers on Windows, do not have this problem.</li>
3510
3539
[6.12] I want to understand some Export options.
3513
"Complete inserts" adds the column names on every INSERT command,
3514
for better documentation (but resulting file is bigger).<br />
3515
"Extended inserts" provides a shorter dump file by using only
3516
once the INSERT verb and the table name.<br />
3517
"Enclose table and field names with backquotes" ensures that
3518
field and table names formed with special characters are protected.<br />
3519
"Add AUTO_INCREMENT value" ensures, that AUTO_INCREMENT value
3520
(if any) will be included in backup.<br />
3521
"Add into comments" includes column comments, relations and MIME
3522
types set in the PMA-DB in the dump as SQL comments (<i>/* xxx */</i>).<br />
3541
<p><b>Structure:</b></p>
3543
<li>"Add DROP TABLE" will add a line telling MySQL to
3544
<a href="http://dev.mysql.com/doc/mysql/en/drop-table.html">drop the table</a>,
3545
if it already exists during the import. It does NOT drop the table after
3546
your export, it only affects the import file.</li>
3547
<li>"If Not Exists" will only create the table if it doesn't exist. Otherwise,
3548
you may get an error if the table name exists but has a different structure.</li>
3549
<li>"Add AUTO_INCREMENT value" ensures that AUTO_INCREMENT value
3550
(if any) will be included in backup.</li>
3551
<li>"Enclose table and field names with backquotes" ensures that
3552
field and table names formed with special characters are protected.</li>
3553
<li>"Add into comments" includes column comments, relations, and MIME
3554
types set in the pmadb in the dump as SQL comments (<i>/* xxx */</i>).</li>
3558
<li>"Complete inserts" adds the column names on every INSERT command,
3559
for better documentation (but resulting file is bigger).</li>
3560
<li>"Extended inserts" provides a shorter dump file by using only
3561
once the INSERT verb and the table name.</li>
3562
<li>"Delayed inserts" are best explained in the
3563
<a href="http://dev.mysql.com/doc/mysql/en/insert-delayed.html">MySQL manual</a>.</li>
3564
<li>"Ignore inserts" treats errors as a warning instead. Again, more info
3565
is provided in the <a href="http://dev.mysql.com/doc/mysql/en/insert.html">MySQL
3566
manual</a>, but basically with this selected, invalid values are adjusted and inserted
3567
rather than causing the entire statement to fail.</li>
3526
3571
[6.13] I would like to create a database with a dot in its name.
3572
3617
[6.16] How can I simply move in page with plenty editing fields?
3575
You can use Ctrl+arrows for moving on most pages with plenty editing
3576
fields (table structure changes, row editing, etc.) (must be enabled in
3577
configuration - see. <a href="#CtrlArrowsMoving">$cfg['CtrlArrowsMoving']</a>). You can also have a look
3578
at the directive <a href="#DefaultPropDisplay">$cfg['DefaultPropDisplay']</a> ('vertical') and see if this
3579
eases up editing for you.
3620
You can use Ctrl+arrows (Option+Arrows in Safari) for moving on most pages
3621
with many editing fields (table structure changes, row editing, etc.)
3622
(must be enabled in configuration - see.
3623
<a href="#CtrlArrowsMoving">$cfg['CtrlArrowsMoving']</a>). You can also have
3624
a look at the directive
3625
<a href="#DefaultPropDisplay">$cfg['DefaultPropDisplay']</a> ('vertical') and
3626
see if this eases up editing for you.