Bài giảng Introduction to phpMyAdmin - Leandro Hermida

Chia sẻ: Tong Quoc Dinh | Ngày: | Loại File: PDF | Số trang:10

Thêm vào BST

Báo xấu

79
lượt xem 4
download

Download Vui lòng tải xuống để xem tài liệu đầy đủ

Bài giảng Introduction to PhpMyAdmin present of: Web Site, Installation, Configuration of the PhpMyAdmin. Bài giảng Introduction to PhpMyAdmin helps you have more knowledge of Information Technology.

Chủ đề:

Bình luận(0) Đăng nhập để gửi bình luận!

Lưu

Nội dung Text: Bài giảng Introduction to phpMyAdmin - Leandro Hermida

Introduction to phpMyAdmin Leandro Hermida EMBnet August 28, 2007
Introduction to phpMyAdmin • Web Site – http://www.phpmyadmin.net/ • Installation – Method 1: RPM package distribution • Fedora package is phpMyAdmin • As root, from the terminal execute yum install phpMyAdmin • Dependencies will be installed for you – Method 2: From web site distribution • Download zip archive • As regular user, unzip into /home • As root, unzip into /usr/local or /opt • Additionally must manually configure Apache httpd.conf with container for phpMyAdmin 27-Aug-2007 2
Introduction to phpMyAdmin • Configuration – Important files: • /etc/httpd/conf.d/phpMyAdmin.conf Apache VirtualHost setup • /usr/share/phpMyAdmin/config.inc.php phpMyAdmin configuration • /etc/php.ini General PHP configuration – For security reasons phpMyAdmin can only be used from localhost by default. You might have to change the phpMyAdmin.conf file to allow from IPv6 socket ::1 for localhost instead of 127.0.0.1 so look at /etc/hosts to see what localhost refers to. 27-Aug-2007 3
Introduction to phpMyAdmin • phpMyAdmin SHOW DATABASES; 27-Aug-2007 4
Introduction to phpMyAdmin • phpMyAdmin SHOW STATUS; SHOW INNODB STATUS; 27-Aug-2007 5
Introduction to phpMyAdmin • phpMyAdmin SHOW VARIABLES; 27-Aug-2007 6
Introduction to phpMyAdmin • phpMyAdmin GRANT privilege1, privilege2, ... ON ... TO user@hostname [ identified by password ]; REVOKE privilege1, privilege2, ... ON ... FROM user@hostname [ identified by password ]; 27-Aug-2007 7
Introduction to phpMyAdmin • phpMyAdmin SHOW PROCESSLIST; SHOW FULL PROCESSLIST; 27-Aug-2007 8
Introduction to phpMyAdmin • phpMyAdmin [user@computer ~]$ mysqldump -u username -h host -ppassword database > export.sql 27-Aug-2007 9
Introduction to phpMyAdmin • phpMyAdmin [user@computer ~]$ mysql -u username -h host -ppassword -D database < import.sql USE database_name; SOURCE import.sql; 27-Aug-2007 10