How to install php and mysql in redhat

This article introduces how to install php and mysql in redhat in detail. The content is detailed, the steps are clear, and the details are handled properly. I hope this article on how to install php and mysql in redhat can help you solve your doubts. Slow down, let's learn new knowledge together.

How to install php and mysql in redhat: 1. Install Apache2 through yum install httpd and start it; 2. Use yum install mysql mysql-server to install MySQL and start it; 3. Install PHP through yum install php, and then restart Apache to make PHP take effect.

Install and deploy Apache+MySQL+PHP environment on RedHat

1. Install Apache2

yum install httpd

After the Apache installation is complete, manually start Apache2

/etc/init.d/httpd start

At this time, directly enter the IP address of the server in the browser, and you can see the default page of Apache2. At this time, Apache can only provide HTTP services, and cannot execute php, nor can it connect to the MySQL database.

2. Install MySQL

yum install mysql mysql-server

After completion, use the following Command to start MySQL service:

/etc/init.d/mysqld start

3. Install PHP5

yum install php

After installing php5, you must restart Apache to make php take effect:

/etc/init.d/httpd restart

At this point, Apache can already parse and execute php scripts. Since Apache's default website root directory is located at: /var/www/html/, create an info.php in this directory to test ApacheWhether e+PHP is installed correctly:

echo "" > /var/www/html/info.php

Then visit IP/info.php in the browser, if the output information of PHPINFO appears, it means the installation is successful

Install the mysql module of php

yum install php-mysql

Restart Apache again after completion

/etc /init.d/httpd restart

Finally, you need to set the LAMP component to start automatically:

chkconfig --levels 2345 httpd on chkconfig --levels 2345 mysqld on

Test environment (virtual machine):

Log in to the local MySQL to create a table, create a user, set The user's operation authority on the table

use test; 
create table login( 
uid char(20), 
dt int, 
text char(50) 
); 
grant select,insert,update,delete on *.* to [email protected]"%" identified by 'password';
 test.php
 <?php 
$host = 'xxx.xxx.xxx.xxx';
 
$user = 'alan';
 
$passwd = 'password';
 
$db = 'test';
 
 
 
$conn = mysql_connect($host,$user,$passwd);
 if (!$conn) {
 
        die('Could not connect: ' . mysql_error());
 
}
 echo "select data from MySQL<br \>";
 
mysql_select_db($db, $conn);
 
 
 
$select_sql = "select * from login";
 
$result = mysql_query($select_sql);
 
 
 echo "<table border='1'><tr><th>uid</th><th>time</th><th>text</th></tr>";
 
 
 while ($row = mysql_fetch_array($result)) {
 
        echo "<tr>";
 
        echo "<td>".$row['uid']."</td>";
 
        echo "<td>".$row['dt']."</td>";
 
        echo "<td>".$row['text']."</td>";
 
        echo "</tr>";
 
}
 echo "</table><br \>";
 
 
 echo "<form action='insert.php' method='post'>
        Name:<input type='text' name='uid' />
        text:<input type='text' name='text' />
        <input type='submit'></form>";
 
 
 
mysql_close($conn);
 ?>insert.php
 <?php 
$host = 'xxx.xxx.xxx.xxx';
 
$user = 'alan';
 
$passwd = 'password';
 
$db = 'test';
 
 
 
$conn = mysql_connect($host,$user,$passwd);
 if (!$conn) {
 
        die('Could not connect: ' . mysql_error());
 
}
 
mysql_select_db($db, $conn);
 
$dt = time();
 
$insert_sql = "insert into login(uid,dt,text) values('$_POST[uid]', $dt, '$_POST[text]')";
 echo "SQL: ".$insert_sql."<br \>";
 if (!mysql_query($insert_sql, $conn)) {
 
        die('Error: ' . mysql_error());
 
}
 echo "1 record added.<br \>";
 
 
 
mysql_close($conn);
 
 
 ?>

1. Access the page

2. Submit the form and execute a sql insert statement

3. Return to the page to refresh and view the results

Related configuration and environment

Apache main configuration file: /etc/httpd /conf/httpd.conf

Apache main configuration directory, you can put different types of configuration into this directory: /etc/httpd/conf.d/

Apache website root Directory: /var/www/html/

Apache log file directory: /var/log/httpd

My.cnf configuration file of MySQL: /etc/my.cnf

MySQL database file location: /usr/lib/mysql