Linux Knowledge IX: LAMP.phpMyAdmin installation. Configuration. Integration and use of Detailed

2010-11-12  来源:本站原创  分类:OS  人气:159 

Linux system installation and use of bear in mind:
1, view the permissions are allowed.
2, see whether the subsidiary version of the corresponding software version.
3, the view directory services directory is corresponding with the operation.

apache Knowledge: netstat-a-o: View listener's port and the corresponding procedures and procedures for port PID.
netstat-lnp | grep port: port number of procedures they use information
# Ps port number: See the port number information, kill -9 port: port number to kill.
/ Etc / httpd / conf: httpd files are generally all locations.
<Directory "D:/Apa/blabla"> Options Indexes FollowSymLinks AllowOverride None </ Directory>: Indexes, said not to retain the main display page, the page will be displayed in the list.
. / Configure - prefix = / usr / local / apache / ...-enable-dav-enable-so-enable-maintainer-mode-enable-rewrite: Install editing to add the suffix should be with the other program (SVN) integration to use.
When accessing the main page shows the contents of the directory is: Apache 2 Test Page [powered by CentOS] ... ... When: Edit / etc / httpd / conf.d / welcome.conf files, comment ErrorDocument 403 / error / noindex.html related content .
netstat-utl: See apache is started.
netstat-tuln | grep ': 80': View 80-port status.
Permissions settings example:
<Directory "/home/test/public_html/cgi">
Options ExecCGI
SetHandler cgi-script
<Limit GET>
order allow, deny
deny from 192.168.100
allow from all
</ Limit>
<Limit POST>
order allow, deny
allow from
deny from all
</ Limit>
order allow, deny
deny from
allow from all
</ Directory>
Virtual Host Configuration example:
# In the bottom of this file by adding the words below!
Set your virtual host # Criteria! Here is the * that is,
NameVirtualHost *
# All connected to the name of the machine will be used as a virtual host to use the settings!
<VirtualHost *>
DocumentRoot / home/mdk90
</ VirtualHost>
<VirtualHost *>
DocumentRoot / home/www.mdk90
CustomLog / var / log / httpd / www.access_log combined # log files will be extra special separate
</ VirtualHost>
<VirtualHost *>
DocumentRoot / home/phorum.mdk90
</ VirtualHost>
ab: Apache performance test, / usr / sbin / ab [-dSk] [-c number] [-n number] pages. php, Parameter Description:
-D: Do not display information on the percentage saved table; usually do not want that data, it will be added-d
-K: above KeepAlive remember it! -K will be added to such a functional test;
-S: do not display a long message, only show a similar min / avg / max short easy to understand message!
-C: while the number of online 』『 same set (which can be thought of as the same time-line IP)
-N: the creation of several requirements with an online channel! (Which can be thought of as the same IP requested several on-line.)
403: Forbidden You don't have permission to access / on this server problem-solving method:
1, see the true role of httpd after opening with the location, location: / etc / httpd / conf / httpd.conf.
2, Directory <"\ www \">: in the brackets is that you change the contents of the new value, conf configuration file: # Options Indexes FollowSymLinks, AllowOverride Non, Order allow, deny, Allow from all.
3, you do not set the guest directory or the file group permissions, chmod-R 755 / www.

mysql knowledge: chown-R Account: Password / usr / local / mysql: belongs to the user to modify folder permissions.
ps-auxwww | grep mysql: mysql check whether the service started.
service mysqld start: open the mysql service.
mysql-uroot-p -S/tmp/mysql.sock: use the-S parameter at run time, specify the correct socket.
rpm-qa | grep mysql | mysql - version: View installed version of mysql.
yum install mysql-server php-mysql: mysql installation services.
mysql-uroot-p123456: into the mysql installation directory in the mysql bin in the registry.
# / Etc / init.d / mysql stop, # mysqld_safe - user = mysql - skip-grant-tables - skip-networking &, # mysql-u root mysql, mysql> UPDATE user SET Password = PASSWORD ('newpassword ') where USER =' root ', mysql> FLUSH PRIVILEGES: modify the database password.
mysqladmin-uroot-p password shutdown: Stop mysql service.
long_query_time = 2; log-slow-queries = / usr / var / slowquery.log: Setting SQL statement to query is slow, the output SQL statements to the specified file.
mysqldump-uroot-p password database name> backup.sql: backup database to the specified directory.
mysql-uroot-p database name <backup.sql: Restore the database.
System appears: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/ tmp / mysql.sock' (2) error: you can use to restart service mysqld restart.
vi / etc / rc.d / rc.local: # This file is the last to join this line (cd / usr / local / mysql; / usr / local / mysql / bin / safe_mysqld - user = mysql &) # this way , each boot can automatically start MySQL Hello!

mysql and phpMyAdmin integration of knowledge:
Integration with php mysql remember to use when installing yum install php-mysql php-mysql.
Copy library / config.default.php to .. /, file permissions are all 755, modify the content:
$ Cfg ['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin/';
$ Cfg ['Servers'] [$ i] ['host'] = 'localhost'; # value will be host to localhost or or the real IP, as I write
$ Cfg ['Servers'] [$ i] ['socket'] = '/ tmp / mysql.sock';
$ Cfg ['Servers'] [$ i] ['user'] = 'root';
$ Cfg ['Servers'] [$ i] [' password '] = '123456';
Error: # 2002 - server is not responding (or the local MySQL server's socket is not correctly configured) solution:
1, view the my.cnf file in the bind-address = and parameter $ cfg ['Servers'] [$ i] ['host'] = 'localhost'; the localhost to 127.0. 0.1.
2, View phpinfo.php input parameters in the mysql.sock file in the location of php configuration file corresponding to my.cnf socket = / tmp / mysql.sock properties are the same, and then restart.
Error: # 1045 - Access denied for User 'root' @ 'localhost' (using password: NO) solution:
1, the first use of phpMyAdmin may not set the user name and password.
2, if you want to set, set the note of the following places:
$ Cfg ['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/';
$ Cfg ['PmaNoRelation_DisableWarning'] = FALSE;
$ Cfg ['blowfish_secret'] = 'husumiao';
$ I = 1;
$ I + +;
$ Cfg ['Servers'] [$ i] ['host'] = 'localhost'; / / MySQL hostname or IP address
$ Cfg ['Servers'] [$ i] ['port'] =''; / / MySQL port - leave blank for default port
$ Cfg ['Servers'] [$ i] ['socket'] =''; / / Path to the socket - leave blank for default socket
$ Cfg ['Servers'] [$ i] ['connect_type'] = 'tcp'; / / How to connect to MySQL server ('tcp' or 'socket')
$ Cfg ['Servers'] [$ i] ['extension'] = 'mysql'; / / The php MySQL extension to use ('mysql' or 'mysqli')
$ Cfg ['Servers'] [$ i] ['compress'] = FALSE; / / Use compressed protocol for the MySQL connection
$ Cfg ['Servers'] [$ i] ['auth_type'] = 'cookie'; / / Authentication method (config, http or cookie based)?
$ Cfg ['Servers'] [$ i] ['user'] = 'root'; / / MySQL user
Error: extension not found PHP to set mbstring, and the current system seemed to use the wide character set. Mbstring extension phpMyAdmin can not correctly identify the strings, the result may have not expected solution: yum install php-mbstring installed.

php Knowledge:
. / Configure - prefix = / usr/local/php5 - with-apxs2 = / usr / local / apache / bin / apxs - with-config-file-path = / usr / local / lib - enable-track -vars - with-xml - enable-pdo - with-mysql = / user / mysql - with-pdo-mysql = / usr / bin / mysql - with-mysql-sock = / tmp / mysql.sock Here - enable-pdo PDO connection is the use of MySQL, - with-pdo-mysql = / usr / bin / mysql mysql path specified.
- With-mysql-sock = / tmp / mysql.sock mysql.sock path specified.
Can not find the path, please use the find /-name xxxx to find.
Modify httpd.conf: find AddType application / x-gzip. Gz. Tgz to add the following in its: AddType application / x-httpd-php. Php, AddType application / x-httpd-php-source. Phps, after the installation contents of the file must be configured.
Modify httpd.conf: remove LoadModule xxxxx moudule / front of the required # to open. So file.
Integration of apache and php: / usr / share / apache / modules / or / etc / httpd / conf / modules directory exists file (must be present), edited httpd.conf add: LoadModule php5_module modules/ Then add: AddType application / x-httpd-php. Php. Php3, AddType application / x-httpd-php-source. Phps.

  • Linux Knowledge IX: LAMP.phpMyAdmin installation. Configuration. Integration and use of Detailed 2010-11-12

    Linux system installation and use of bear in mind: 1, view the permissions are allowed. 2, see whether the subsidiary version of the corresponding software version. 3, the view directory services directory is corresponding with the operation. apache

  • Linux Knowledge nine: LAMP.phpMyAdmin installation. Configuration and use of Detailed Integration 2010-11-12

    Linux system installation and use of remember: 1, view privileges are allowed. 2, check whether the version with the version of the software corresponding to the subsidiary. 3, view the directory services directory is corresponding with the operation

  • oracle - Linux - Unix under the ODBC installation. Configuration and Programming 2010-04-12

    Transfer from: Linux / Unix under the ODBC installation, configuration and programming 2004-04-23 15:18 pm From: Linux documents are shown: Www.8s8s.coM Address: unknown Content: ODBC principle Linux / Unix

  • CentOS 6.0 server installation. Configuration. Optimization (Beginners) 2011-09-07

    Let me know about the recent head, Linux CentOS under the server installation, configuration, natural means in the linux solution may be batch start. Previously, the college to find out about the operation even less, now had to study step by step fro

  • Linux phpMyAdmin installation Raiders 2010-07-22

    1, first download the phpMyAdmin installation package, 2, upload phpMyAdmin-3.3.4-all-languages.tar.gz extract to / var / www / html /, execute the command: tar-zxvf phpMyAdmin-3.3.4-all-languages.tar.gz, if the password Emp

  • JDK1.6 installation configuration under the LINUX 2010-03-25 DK1.6 under the LINUX install and configure Java for beginners is a must to start Java programming, how JDK1.6 installation and configuration under the LINUX became the primary issue, then this article

  • Linux vsftpd installation configuration to use (more) 2010-02-26

    Linux vsftpd installation configuration to use (more) In this paper, a number of previous articles written on many occasions with their own installation and configuration experience, written in more detail, the article finally ftp command set with al

  • Reprinted: Xp under the Apache + PHP + MySQL + Zend Optimizer + phpMyAdmin Installation and Configuration 2010-05-19

    Xp under the Apache + PHP + MySQL + Zend Optimizer + phpMyAdmin Installation and Configuration <br /> Published :2009-07-25 23:55:12 Views: 897 Posted: superadmin set the font medium and small] [ First, t

  • PHP Learning (4) phpMyAdmin Installation and Configuration 2010-11-10

    1, first download the phpMyAdmin installation package: Official Website abroad, click on the navigation bar on the "DOWNLOADS" link to the download page, select the "" version to download to

  • Notes from office server installation - installation configuration chapter 2010-04-06

    Host Configuration: Single Intel Xeon E5405 2.0G Quad-Core CPU, 4 A 500G Seagate SATA II hard disk server, 4G memory. OS: CentOS 5.3 Installation: CentOS 5.3 raid5 array + LVM logical volume of soft First, install the operating system Install the ope

  • JDK installation configuration 2010-03-27

    JDK installation configuration Description: JDK installation is divided into windows and linux operating systems such as Alto, the other server or installation. Side of the article involves JAVA-based learning to learn. If you want to install the tom

  • Linux (ubuntu) under the apache and tomcat integration (update) 2010-04-09

    Master flash Main aim is to ubuntu 9.10 install apache 2.2 + tomcat 6.0.20 + jk 1.2.28., Of course, also in the period under review the basic linux commands, basic shell programming statements, such as: expr if while test and other research tomcat st

  • linux under one of several server configuration to use: nfs tftp 2010-04-18

    nfs server configuration: 1, install nfs server (usually on a PC machine with linux systems have just started) 2, create or modify / etc / exports configuration file [Sharing directory] [host name or IP (parameter, parameter)] [Sharing directory] [Ho

  • centos zendce red5 ffmpeg installation configuration 2010-05-25

    This is mainly spoke of the centos server, how to quickly set up AMP environment and the streaming media servers. As for performance testing and tuning shelving. First, assume that the server is already installed centos system. Recommend a small soft

  • under linux Apache2 + mysql5 + php5 source installation details 2010-08-09

    under linux Apache2 + mysql5 + php5 source installation details 1: Prepare the package Here I will download all the installation package and kept in / root / Software / directory, note the following installation package as much as possible to find th

  • phpmyadmin Installation 2010-10-28

    phpmyadmin installation method is as follows: 1. Download multi language pack After extracting all renamed phpmyadmin note lower case, put it under the htdocs folder 2. The changed its name to 3, the preparation o

  • viewvc installation configuration 2009-12-06

    System: ubuntu 8.04 Here I think you have already installed Subversion and apache, you can see here, see the subversion apache installation configuration. Viewvc Installation 1. Viewvc environment needs For CVS Support: * Python 1.5.2 or later (http:

  • Webalizer installation configuration 2011-07-13

    Webalizer is a useful Web Server log file analysis software, in addition to its ability to analyze Apache web server log files generated by the log, but also to analyze the FTP Log file to output HTML pages quite beautiful, quite a number of sites cu

  • Linux and windows Vmware Server installation notes 2011-05-13

    Quote from 2009-08-06 23:33:44 Tags: vmware server linux windows Original works, for permission to reproduce, reprint, please be sure to indicate the form of hyperlinks original source of article, author i

  • ubuntu installation configuration under svn + apache2 2011-06-14

    ubuntu installation configuration under svn + apache2 1 installed (using apt-get install installation) sudo apt-get install subversion sudo apt-get install libapache2-svn sudo apt-get install Apache2 2 Create the parent directory repository sudo mkdi