辅导phpmyadmin留学生、讲解SQL语言、SQL程序设计调试、讲解PHP script 辅导Python编程|讲解SPSS
- 首页 >> Web Overview:In this assignment, you will set up a MySQL server, and install a PHP script that reads it. The primary materiel for this assignment is contained in lecture 19.You have the option of using the mysql interface to manage the databases, or if you wish, you can install phpmyadmin.
Step 1:
Install MySQL on your linux server.
Run the myssql_secure_installation to configure basic options.
To test the installation, go into the mysql interface (the command "mysql"), and enter the sql command "show databases;" You should see a list of available databases.
Step 2:
Create an account & database that can use that account.
To create the university database, run this script through mysql.
The mysql command "show databases" can be used to list the database. The mysql command "show grants" can be used to show user permissions.
Step 3:
Install php-mysql module, restart the apache service.
Upload a PHP web page that queries the database with a result.
To test this, use a web browser to view the page.
Step 1:
Install MySQL on your linux server.
Run the myssql_secure_installation to configure basic options.
To test the installation, go into the mysql interface (the command "mysql"), and enter the sql command "show databases;" You should see a list of available databases.
Step 2:
Create an account & database that can use that account.
To create the university database, run this script through mysql.
The mysql command "show databases" can be used to list the database. The mysql command "show grants" can be used to show user permissions.
Step 3:
Install php-mysql module, restart the apache service.
Upload a PHP web page that queries the database with a result.
To test this, use a web browser to view the page.