Class Notes (861,051)
US (334,997)
CSUN (518)
AM 316 (1)
mrrason (1)
Lecture 4

A M 316 Lecture 4: Documentation

56 Pages
50 Views

Department
Civil Engineering and Construction Management
Course Code
AM 316
Professor
mrrason

This preview shows pages 1-4. Sign up to view the full 56 pages of the document.
Description
* Top * Requirements * Introduction * Installation * Setup script * Configuration * Transformations * FAQ * Developers * Credits * Translators * GlossaryphpMyAdmin 2.10.3 Documentation * phpMyAdmin homepage * SourceForge phpMyAdmin project page * Official phpMyAdmin wiki * Local documents: + Version history: ChangeLog + General notes: README + License: LICENSE * Documentation version: Id: Documentation.html 10510 20070720 13:03:09Z lem9 Requirements * PHP + You need PHP 4.1.0 or newer, with session support (see FAQ 1.31) + You need GD2 support in PHP to display inline thumbnails of JPEGs (imagejpeg: inline) with their original aspect ratio + You need PHP 4.3.0 or newer to use the textplain: external MIMEbased transformation * MySQL 3.23.32 or newer (details); * Not really a requirement but a strong suggestion: if you are using the cookie authentication method, having the mcrypt PHP extension on your web server accelerates not only the login phase but every other action that you do in phpMyAdmin. * Web browser with cookies enabled.IntroductionphpMyAdmin can manage a whole MySQL server (needs a superuser) as well as asingle database. To accomplish the latter youll need a properly set up MySQLuser who can readwrite only the desired database. Its up to you to look upthe appropriate part in the MySQL manual.Currently phpMyAdmin can: * browse and drop databases, tables, views, fields and indexes * create, copy, drop, rename and alter databases, tables, fields and indexes * maintenance server, databases and tables, with proposals on server configuration * execute, edit and bookmark any SQLstatement, even batchqueries * load text files into tables * create^1 and read dumps of tables * export^1 data to various formats: CSV, XML, PDF, ISOIEC 26300 OpenDocument Text and Spreadsheet, Word, Excel and L^AT[E]X formats * administer multiple servers * manage MySQL users and privileges * check referential integrity in MyISAM tables * using Querybyexample (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 BLOBdata as image or downloadlink * support InnoDB tables and foreign keys (see FAQ 3.6) * support mysqli, the improved MySQL extension (see FAQ 1.17) * communicate in 50 different languagesA word about users:Many people have difficulty understanding the concept of user management withregards to phpMyAdmin. When a user logs in to phpMyAdmin, that username andpassword are passed directly to MySQL. phpMyAdmin does no account management onits own (other than allowing one to manipulate the MySQL user accountinformation); all users must be valid MySQL users.^1) phpMyAdmin can compress (Zip, GZip RFC 1952 or Bzip2 formats) dumps andCSV exports if you use PHP with Zlib support (withzlib) andor Bzip2 support(withbz2). Proper support may also need changes in php.ini.Installation 1. Quick Install 2. Setup script usage 3. Linkedtables infrastructure 4. Upgrading from an older version 5. Using authentication modesphpMyAdmin does not apply any special security methods to the MySQL databaseserver. It is still the system administrators job to grant permissions on theMySQL databases properly. phpMyAdmins Privileges page can be used for this.Warning for Mac users:if you are on a Mac OS version before OS X, StuffIt unstuffs with Mac formats.So youll have to resave as in BBEdit to Unix style ALL phpMyAdmin scriptsbefore uploading them to your server, as PHP seems not to like Macstyle end oflines character (r).Quick Install 1. Choose an appropriate distribution kit from the phpmyadmin.net Downloads page. Some kits contain only the English messages, others contain all languages in UTF8 format (this should be fine in most situations), others contain all languages and all character sets. Well assume you chose a kit whose name looks like phpMyAdminx.x.xalllanguages.tar.gz. 2. Untar or unzip the distribution (be sure to unzip the subdirectories): tar xzvf phpMyAdmin_x.x.xalllanguages.tar.gz in your webservers document root. If you dont have direct access to your document root, put the files in a directory on your local machine, and, after step 4, transfer the directory on your web server using, for example, ftp. 3. Ensure that all the scripts have the appropriate owner (if PHP is running in safe mode, having some scripts with an owner different from the owner of other scripts will be a problem). See FAQ 4.2 and FAQ 1.26 for suggestions. 4. Now you must configure your installation. There are two methods that can be used. Traditionally, users have handedited a copy of config.inc.php, but now a wizardstyle setup script is provided for those who prefer a graphical installation. Creating a config.inc.php is still a quick way to get started and needed for some advanced features. + To manually create the file, simply use your text editor to create the file config.inc.php (you can copy config.sample.inc.php to get minimal configuration file) in the main (toplevel) phpMyAdmin directory (the one that contains index.php). phpMyAdmin first loads libraries config.default.php and then overrides those values with anything found in config.inc.php. If the default value is okay for a particular setting, there is no need to include it in config.inc.php. Youll need a few directives to get going, a simple configuration may look like this: Or, if you prefer to not be prompted every time you log in: For a full explanation of possible configuration values, see the Configuration Section of this document. + Instead of manually editing config.inc.php, you can use the Setup Script. First you must manually create a folder config in the phpMyAdmin directory. This is a security measure. On a LinuxUnix system you can use the following commands: cd phpMyAdmin mkdir config create directory for saving chmod o+rw config give it world writable permissions And to edit an existing configuration, copy it over first: cp config.inc.php config copy current configuration for editing chmod o+w configconfig.inc.php give it world writable permissions On other platforms, simply create the folder and ensure that your web server has read and write access to it. FAQ 1.26 can help with this. Next, open scriptssetup.php in your browser. Note that changes are not saved to disk until explicitly choose Save from the Configuration area of the screen. Normally the script saves the new config.inc.php to the config directory, but if the webserver does not have the proper permissions you may see the error Cannot load or save configuration. Ensure that the config directory exists and has the proper permissions or use the Download link to save the config file locally and upload
More Less
Unlock Document
Subscribers Only

Only pages 1-4 are available for preview. Some parts have been intentionally blurred.

Unlock Document
Subscribers Only
You're Reading a Preview

Unlock to view full version

Unlock Document
Subscribers Only

Log In


OR

Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit