When developing web resources or transferring sites, it is necessary to get access to the DB – the project database on the server. The easiest method is the command line.
Another option is a graphical interface that helps to present data in the form of hierarchical lists. PhpMyAdmin is a popular tool for working with databases, it has an open source code written in the PHP language. Works through a browser, can be integrated into the software interface or hosting control panel.
PhpMyAdmin
It is a convenient working environment for beginners and professionals. Intuitive layout of the main elements helps to quickly access the databases. The interface is translated into several languages, including Russian. The free license contributed to the spread of the program around the world.
The product is integrated into Openserver, Denver and other developments. The first version appeared in 1998, developed by Tobias Rothschild. Supported on all operating systems. Readable file formats: xml, csv, jason, pdf, xml. Starting with the third version, PHP 5.2 is required for operation.
Let’s figure out why phpMyAdmin can be useful to a novice webmaster. Using the graphical interface, you can search for data in the database, execute SQL commands, add new users and grant them administrator rights, change account names and passwords, and correct existing records.
The workspace is divided into three zones. In the column on the left is the database of the site, presented in the form of a tree structure. Navigation is carried out using the search bar or by moving from the upper level to the lower level. In the settings, the user chooses the conditions for grouping tree points, the way the table is displayed.
In the right part of the screen, the database server, web service and instructions for working with PHP My Admin are indicated. Above the central part of the page is the main menu. It is used to configure the mapping of encodings, the appearance of the workspace: language, theme, font size.
The interface allows you to import or export files, restore the user’s default settings with one click. By selecting the table in the side menu, you can add a new user, set access privileges.
In addition to the tables, there are two more windows in the working environment. In the first, SQL queries to the server are executed. In the second, the used network traffic is displayed since the start.
So why do you need phpMyAdmin?
This is the main tool for working with dynamic sites. To create content, you need to create an HTML frame and display information from the database on the page using PHP scripts.
First, a user database with administrator privileges is generated: you can create, delete, edit tables, add new rows. The intuitive interface does not require knowledge of the language, it is enough to understand the syntax: Type, Table, Alter, Create. The required string can be found using a quick search.
What is an FTP server?
An FTP server is a computer with special software, the main task of which is to store files. In addition, the FTP server is responsible for client authentication.
In order to connect to FTP, the following data is required:
- Server name (host)
- Login
- Password
- FTP port (default 21)
- An FTP server that does not require authorization is called an anonymous FTP server.
By default, the data exchange between the client and the server is carried out in an open form. This can lead to access data theft. To avoid this, you can use additional FTPS protocols.
FTPS is an application layer protocol created as an extension of the FTP protocol. It is designed to establish a secure connection using TLS. With its help, all commands and data transmitted over the communication channel are encrypted.
FTP connection can be organized using active or passive mode. In the first case, the connection is established after sending the PORT command. If the user uses a proxy or a firewall, this mode of operation may be prohibited. To solve this problem, a passive connection mode is used. In passive mode, the client receives a TCP port number to which it can connect.
The FTP server supports file transfer in two modes
Text (ASCII). It is used to transfer text data, for example, HTML, php scripts, perl scripts, as well as css and JS files.
Binary (BINARY). Images and binaries are transferred in this mode.
Choosing the right data transfer mode is very important. For example, Perl scripts will not run on the server if they are loaded in binary mode. Most modern FTP clients can automatically determine the required mode for uploading files.
Scope of FTP servers
The most common use of FTP is working with hosting files. Using FTP is the easiest method to transfer files to a server.However, its capabilities are not limited to this. FTP is a good alternative to the usual data carriers, capable of providing fast and convenient file transfer between users of the global network.
Thanks to it, you can forget about disks and flash drives, because it is easier to upload all files to an FTP server, where they will be available to users from different parts of the world. There is even a special service called “FTP hosting”.