Group test There are plenty of reasons for wanting a lowresource distro running on your computer. Maybe you have some ancient hardware that you need to breathe new. 21 gedachten over Remote wipe for Windows clients None december 16, 2010 om 112 pm. Hmmm, overly complicated, obfuscated scripting that is intended to. Martin It sure was. Nothing in this world is impossible is it Expect more versions Of Leopard to come in the future that will be much more easier to install on. Ham Radio Software on Centos Linux Configuring multitudes of Amateur HAM Radio software for Centos6 Centos5 Linux. Find and contact HP Customer Support, download drivers, manuals and troubleshooting information for HP products, including pcs, laptops, desktops, printers, tablets. Install LAMP Linux, Apache, Maria. DB or My. SQL and PHP Stack on Debian 9. Early this week June 1. Debian project announced the availability of the new stable version Debian 9 codenamed Stretch. With this release, the well known and widely used Debian 8 Jessie gained old stable status, which designates the previous stable repository. As it always happens with the release of a new stable version, Stretch includes hundreds of new packages, and updates to thousands of others. Since Debian powers a large percentage of web servers all over the world, in this article we will explain how to install the LAMP stack in Debian 9 Stretch. This will allow system administrators to set up brand new web servers on top of Stretch using the recent updates to the distributions official repositories. It is assumed that you have installed Debian 9 on a bare metal, virtual machine, or VPS, or have upgraded from Jessie. Installing LAMP in Debian 9 Stretch. The M in LAMP stands for Maria. DB or My. SQL, the database server for the stack. Depending on your choice, you can install the database server and the other components the Apache web server and PHP as follows. Linux has made some serious headway over the past decade, elevating itself from that open source operating system to wow, this thing is actually usable. Install LAMP with Maria. DB on Debian 9 aptitude update aptitude install apache. Contents Dive into the world of hacking with this indepth manual that covers the big topics from the Linux kernel and wider opensource OS to hacking servers, the web. For preppers that purchase items online, store manuals or connect with other survivors, switching to Linux may be one of a kind resource. The following tutorial will explain the following topics How to access the BIOS Setup Choosing a boot menu Start a system recovery It is not. Install LAMP with My. SQL on Debian 9 aptitude update aptitude install apache. As a personal preference, I will use Maria. DB in the rest of this article. Once the installation is complete, let us make sure all the services are running. If so, the following commands. systemctl is active apache. Otherwise, start both services manually systemctl start apache. Finally, before proceeding lets use mysqlsecureinstallation to set up the password for the database root account. If you dont know how to do this, you can refer to step 4 in How to Install Maria. DB 1. 0 on Debian and Ubuntu. Testing LAMP on Debian 9 Stretch. To begin, we are going to create and populate a sample database. Next, we will use a basic PHP script to retrieve a set of records from the database in JSON format. Finally, we will use Firefoxs developer tools to verify the version of Apache being used. Although we could find out this same information with. apache. Creating and Populating a Database. Lets enter the Maria. DB prompt with the following command. mysql u root p. Now we will create a database named Library. DB as follows Maria. DB none CREATE DATABASE Library. DB. and add two tables named Authors. TBL and Books. TBL Maria. DB none USE Library. DB. CREATE TABLE Authors. TBL. Author. ID INT NOT NULL AUTOINCREMENT. Full. Name VARCHAR1. NOT NULL. PRIMARY KEYAuthor. ID. Maria. DB none CREATE TABLE Books. TBL. Book. ID INT NOT NULL AUTOINCREMENT. Author. ID INT NOT NULL. ISBN VARCHAR1. 00 NOT NULL. Title VARCHAR1. 00 NOT NULL. Year VARCHAR4. PRIMARY KEYBook. ID. FOREIGN KEYAuthor. ID REFERENCES Authors. TBLAuthor. ID. For security reasons, we will create a special account to access our database Maria. DB none CREATE USER librarianlocalhost IDENTIFIED BY Today. Maria. DB none GRANT ALL PRIVILEGES ON Library. DB. TO librarianlocalhost. The last step now consists of populating the tables with Authors and Books Maria. DB none INSERT INTO Authors. TBL Full. Name VALUES Paulo Coelho, Isabel Allende, Jorge Luis Borges. Maria. DB none INSERT INTO Books. TBL Author. ID, ISBN, Title, Year VALUES. El alquimista, 1. El peregrino, 1. La casa de los espiritus, 1. El Aleph, 1. 94. Testing Database Connection with PHP Script. The following PHP script will first connect to the database and retrieve the records that match the query. If an error occurs, a descriptive message will be displayed so as to give us a hint on whats wrong. Save the following script as booksandauthors. Show PHP version. Current PHP version. Connect to database. Today. 12. 3,Library. DB or dieError. SELECT A. ISBN, A. Title. A. Year, B. Full. Name. FROM Books. TBL A JOIN Authors. TBL B. ON A. Author. ID B. Author. ID. Error. mysqlierrorconnection. Populate an array with the query results. Convert to JSON. echo jsonencodelibraryarray. Change the ownership to www data and add the appropriate permissions chown www data www data varwwwhtmlbooksandauthors. Finally, open a web browser and point it to the URL where the script resides. Verify LAMP on Debian 9. Thats it In this article we have explained how to install and test the LAMP stack on Debian 9. If you have questions or comments about this article, dont hesitate to let us know by using the form below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2018
Categories |