www.phpmyadmin.net/documentation/#linked-tables
Introduction phpMyAdmin can manage a whole MySQL server (needs a super-user) as well as a single database. To accomplish the latter you'll need a properly set up MySQL user who can read/write only the desired database. It's up to you to look up the appropriate part in the MySQL manual. Currently phpMyAdmin can: * create and drop databases * create, copy, drop, rename and alter tables * do table maintenance * delete, edit and add fields * execute any SQL-statement, even batch-queries * manage keys on fields * load text files into tables * create and read dumps of tables * export data to CSV, XML and Latex formats * administer multiple servers * manage MySQL users and privileges * check referential integrity in MyISAM tables * using Query-by-example (QBE), create complex queries automatically connecting required tables * create PDF graphics of your Database layout * search globally in a database or a subset of it * transform stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link or ...
Installation NOTE: phpMyAdmin does not apply any special security methods to the MySQL database server. It is still the system administrator's job to grant permissions on the MySQL databases properly. Warning for Mac users:if you are on a MacOS version before OS X, StuffIt unstuffs with Mac formats. So you'll have to resave as in BBEdit to Unix style ALL phpMyAdmin scripts before uploading them to your server, as PHP seems not to like Mac-style end of lines character ("\r"). If you don't have direct access to your document root, put the files in a directory on your local machine, and, after step 3, transfer the directory on your web server using, for example, ftp.
phpMyAdmin should now display a welcome screen and your databases, or a login dialog if using HTTP or cookie authentication mode. htaccess file in that folder, for other webservers, you should configure this yourself. Such configuration prevents from possible path expossure and cross side scripting vulnerabilities that might happen to be found in that code.
In case you just want to download configuration, you don't have to perform any additional actions. For saving file on webserver, or loading previous configuration you have to create config directory in phpMyAdmin's top level directory and make it writable to web server. For loading previous configuration, place it there (and make sure it has write permissions for webserver). After saving your configuration move generated configuration to top level directory and delete created config directory. Please note that it does not allow to configure everything, so for some additional features you still need to manually edit the configuration file. Those tables can be located in your own database, or in a central database for a multi-user installation (this database would then be accessed by the controluser, so no other user should have rights to it).
You can use your phpMyAdmin to create the tables for you. Please be aware that you may need special (administrator) privileges to create the database and tables, and that the script may need some tuning, depending on the database name.
You will also need to have a controluser with the proper rights to those tables (see section Using authentication modes below). php from previous installation into a newly unpacked one. Using authentication modes * HTTP and cookie authentication modes are recommended in a multi-user environment where you want to give users access to their own database and don't want them to play around with others. Even in a single-user environment, you might prefer to use HTTP or cookie mode so that your user/password pair are not in clear in the configuration file.
However, keep in mind that the password travels in plain text, unless you are using the HTTPS protocol. In cookie mode, the password is stored, encrypted with the blowfish algorithm, in a temporary cookie. tables_priv (all columns except "Grantor" & "Timestamp") tables.
The following example assumes you want to use pma as the controluser and pmapass as the controlpass, but this is only an example: use something else in your file! Of course you have to replace localhost by the webserver's host if it's not the same as the MySQL server's one.
Of course, the above queries only work if your MySQL version supports the GRANT command. Normally you shouldn't give global privileges to an ordinary user, unless you understand the impact of those privileges (for example, you are creating a superuser).
Configuration Warning for Mac users: PHP does not seem to like Mac end of lines character ("\r"). So ensure you choose the option that allows to use the *nix end of line character ("\n") in your text editor before saving a script you have modified.
string Sets here the complete URL (with full path) to your phpMyAdmin installation's directory. Note also that the URL on some web servers are case-sensitive. In most cases phpMyAdmin automatically detects the proper setting.
A good test is to browse a table, edit a row and save it. There should be an error message if phpMyAdmin is having trouble auto-detecting the correct value. If you get an error that this must be set or if the autodetect code fails to detect your path, please post a bug report on our bug tracker so we can improve the code.
If you tried to set this up and it does not work for you, have a look on the "Structure" page of one database where you would like to use it. You will find a link that will analyze why those features have been disabled. If you do not want to use those features set this variable to TRUE to stop this message from appearing.
If you are using the 'cookie' auth_type, enter here a random passphrase of your choice. It will be used internally by the blowfish algorithm: you won't be prompted for this passphrase. The maximum number of characters for this parameter seems to be 46.
string What type connection to use with the MySQL server. It defaults to 'tcp' as that is nearly guaranteed to be available on all MySQL servers, while sockets are not supported on some platforms. To use the socket mode, your MySQL server must be on the same machine as the Web server.
Whether config or cookie or http authentication should be used for this server. Username and password are stored in cookies during the session and password is deleted when it ends.
string When using auth_type = 'config', this is the user/password-pair which phpMyAdmin will use to connect to the MySQL server. This user/password pair is not needed when HTTP or cookie authentication is used and should be empty.
string or array If set to a (an array of) database name, only this (these) database will be shown to the user. This setting is an efficient way to lower the server load since the latter does not need to send MySQL requests to build the available database list. But it does not replace the privileges rules of the MySQL database server. If set, it just means only these databases will be displayed but not that all other databases can't be used.
string Only useful when using phpMyAdmin with multiple server entries. If set, this string will be displayed instead of the hostname in the pull-down menu on the main page. This can be useful if you want to show only certain databases on your system, for example.
Linked-tables infrastructure section in this document to see the benefits of this infrastructure, and for a quick way of creating this database and the needed tables. If you are the only user of this phpMyAdmin installation, you can use your current database to store those special tables;
To do this it needs two tables "pdf_pages" (storing information about the available PDF pages) and "table_coords" (storing coordinates where each table will be placed on a PDF schema output).
If you don't want to use a table- based history, you can use the JavaScript-based history. Using that, all your history items are deleted when closing the window.
you can specify an amount of history items you want to have on hold. On every login, this list gets cut to the maximum amount. The query history is only available if JavaScript is enabled in your browser.
If the above va...
|
http://csua.com/feed/