How to install php and mysql in redhat

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. Through "yum install php "Install PHP and then restart Apache to make php take effect.

The operating environment of this tutorial: Windows 10 system, PHP5 version, DELL G3 computer

How to install php and mysql in redhat?

Install and deploy Apache MySQL PHP environment on RedHat

1. Install Apache2

yum install httpd

After the Apache installation is completed, manually start Apache2

/etc/init.d/httpd start

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

2. After installing MySQL

yum install mysql mysql-server

, use the following command to start the MySQL service:

/etc/init.d/mysqld start

3. Install PHP5

yum install php

After installing php5, Apache must be restarted to make php take effect:

/etc/init.d/httpd restart

At this time, Apache can parse and execute php scripts. Since the default website root directory of Apache is located at: /var/www/html/, create an info.php in this directory to test whether Apache PHP is correctly installed:

echo "<?php phpinfo(); ?>" > /var/www/html/info.php

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

Install the mysql module of php

yum install php-mysql

After completion, restart Apache again

/etc/init.d/httpd restart

Finally, you need to The LAMP component is set 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, and set the user's operation permissions on the table

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

1. Visit the page

2. Submit the form and execute a sql insert statement

3 . Return to the page and refresh to 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 configurations into this directory: /etc/httpd/conf.d/

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

Apache log file directory:/var/log/httpd

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

MySQL database file location:/usr/lib/ mysql

Recommended learning: "PHP Video Tutorial"

The above is the detailed content of How to install php and mysql in redhat. For more information, please follow other related articles on the PHP Chinese website!