Join Jon Peck for an in-depth discussion in this video Installing phpMyAdmin to manage databases, part of Up and Running with Linux for PHP Developers.
…We set up a based lamp stack for a development server.…As we add functionality, it'd be good to have a homepage…for convenience instead of keeping track of a bunch of bookmarks.…In this chapter, we'll add some more utilities…and create a barebones dashboard to save us time.…The first utility we'll install is phpMyAdmin which is a free and…open-source PHP tool for working with MySQL databases using a web browser.…phpMyAdmin is useful for debugging database driven applications by writing…and performing queries, and also for managing databases and users.…
In a production environment, phpMyAdmin is…a liability especially if it's not properly…secured, as unauthorized users can have…an incredibly dangerous access to the database.…As this is a local development server, we don't have that security concern.…Let's get started.…From a terminal, I'm going to install phpMyAdmin using apt.…So, sudo apt-get -y…install phpmyadmin.…
As part of the configuration, we'll need to configure phpMyAdmin.…Please don't rush through this because if you skip a step, it will not work.…
The demonstrations are performed with the Ubuntu LTS distribution of Linux, but the skills taught here are also applicable to other Linux distributions. Every command is described in detail in context, and a comprehensive quick reference is provided for convenience.
- What is Linux, and why should I use it?
- What's a LAMP, and why does it matter?
- Creating and configuring a virtual machine
- Working with the Linux command line
- Configuring the servers, including Apache virtual hosts
- Building a development server dashboard
- Using PHP package managers like Composer and PEAR
- Installing Drupal, WordPress, and more on the server
- Self-hosting Git repositories, including a web interface
- Enhancing the server with debugging and profiling
- Exporting a virtual appliance to use on another machine
- Server troubleshooting techniques
Skill Level Beginner
Q: The pecl installation of uploadprogress fails, saying it is not a valid package archive. How can I install uploadprogress?
A: There is a bug in Ubuntu's pecl that was introduced after the course was recorded; the workaround command is "sudo pecl install -Z uploadprogress"
Q: Where can I get the exact versions of the software used in this course?
Q: In Windows, git operations ask for a password. Why?
A: Make sure that pagent (PuTTY agent) is running and has the private key loaded. See Chapter 3, movie 4 for details.
PHP with MySQL Beyond the Basicswith Kevin Skoglund10h 26m Intermediate
1. Getting Started
2. Creating a Virtual Machine
3. Using the Server Command-Line Interface
4. Initial Server Configuration
5. Building a Development Server Dashboard
6. Installing PHP Applications for Site Development
7. Source Code Management
Introducing Git2m 16s
8. Enhancing the Development Server
9. Advanced VirtualBox Techniques
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.