Minimal phpmyadmin setup for open launch. How to log into phpmyadmin on hosting

When creating a new website project, a webmaster has to solve many problems regarding the content to be posted, its display, ensuring easy navigation through sections, etc. At the same time, making changes is complicated by the need to correlate them with databases located on the hosting server. This entails a significant waste of time and effort. In order to minimize costs and facilitate changes, many specialists use the http://localhost/Tools/phpMyAdmin tool, which allows them to simulate server space on a PC. As an example, consider the Denver software shell and one of the additional PhpMyAdmin tools.

So, Denver is a program that allows you to create a local server directly on your computer, and localhost/Tools/phpMyAdmin is one of the tools (a set of special PHP scripts) used to provide access to databases located on this server. With their help, you can manage and make changes to the site project databases, without the need to learn special MySQL commands.

Benefits of technology

The use of such technology allows you to obtain a number of advantages:

After the site project is ready, you can easily transfer it from a local server to a real one, and begin to fully use the site.

As for the PhpMyAdmin tool itself, its use eliminates the need to learn MySQL commands and makes the process of making changes to databases simple and accessible even for users with limited programming knowledge.

How to log in and use localhost/Tools/phpMyAdmin

To use the database tool, simply go to http://localhost/Tools/phpMyAdmin.

This will open the tool's interface, which allows you to create, modify, and delete new tables in databases using intuitive commands. These tables will be used to directly place the site content. The tool's interface is quite simple and clear, all important elements are labeled, so it will be easy to understand even for a beginner.

Why doesn't http://localhost/Tools/phpMyAdmin open?

When working in phpMyAdmin, please note that login features may vary depending on the tools used, operating system and development environment (admin panel). Let's look at the main options.

Attention!!! If you don’t know how to quickly and easily log into phpMyAdmin on localhost, then there is an accessible and fastest option - save the link directly in the browser, and you can always have access to the control panel. Direct link for versions 4 and 5: http://localhost/openserver/phpmyadmin/. The method works in a correctly configured environment.

How to log into phpMyAdmin on hosting

Depending on which one you choose, logging into the control panel may differ slightly. However, for Denver there are several standard options that allow you to quickly get into ISPManager. Once in your control panel, you can create a phpMyAdmin profile. Login information and the root password will also be stored here. All this information is available on the “Server Settings” tab in the “Server Databases” section. If you remember the password and know the login, then to enter the web interface just follow the link in personal account ISPManager or via standard link http://site_address/myadmin/.

If the databases were created correctly, then a login window will open where you need to enter your password and login.

Features of interaction on Denver

If you, like most webmasters, prefer to work using Denver and if you don’t know how to log into phpMyadmin on Denver, then these instructions are for you:

We launch Denver using the “Start Denver” shortcut.

The browser enters the address http://localhost.

We need the address http://localhost/Tools/phpMyAdmin, by clicking on which we can go directly to “phpMyAdmin”.

Since when purchasing hosting, most providers automatically create a user account and a database for the site, most likely you will only have to create a user on the local server, since it is already configured directly on the hoster’s server.

How to create a user on your local computer

First, you need to go to the “Privileges” tab on the phpMyAdmin page. Here you can see information on all connected users and accounts. The algorithm of actions is as follows:

Add a new user –> enter the new user’s data (login and password) –> mark all privileges and click the banner that says “GO”.

If registration is successful, you will be able to see a pop-up confirmation window about creating a new user. That's it, now to work with MySQL and the php script, you will only need the authorization data that you entered during registration to log in.

To effectively use the web interface, you need to navigate command line and know the basic command stack for management.

Features of phpMyAdmin working with the Linux operating system

For example, let’s take the simplest and available version Unix OS - Ubuntu. In order to log into phpMyAdmin on Ubuntu 16.04 (latest stable build), the standard algorithm of actions is performed:

Install phpMyAdmin from the repository.

In the terminal we enter the combinations:

sudo apt-get update sudo apt-get install

phpmyadmin php-mbstring php-gettext

During the installation process, the program will offer several configurations to choose from; you must select apache2. Installation and configuration software is carried out completely automatically. All you need to do yourself is to mark the PCP configurations. To do this, enter the following commands in the terminal:

sudo phpenmod mcrypt

sudo phpenmod mbstring

After completing all steps, the software is restarted and the changes made are analyzed by the team sudo systemctl restart apache2.

If the installation was successful, then when you enter the command https://domain_name_or_IP_address/phpmyadmin you will see a login window where you can enter all the necessary registration data and log into the web interface.

If you forgot your database password

Operation of phpMyAdmin may vary slightly depending on the admin panel.

If you have forgotten your password, then in order to restore access to the root password, you will need to take a number of steps:

For Windows

Stop the database server.
Start databases with option skip-grant-tables.
Connect to the server via command mysql -u root.
Set a new password – mysql> update user set password=PASSWORD('root_password') where user='root' and host='localhost'.
The final step is to stop all processes and restart the server to check the new password.

For Ubuntu

Stopping the system - sudo service mysql stop.
Launching databases - sudo /usr/bin/mysqld_safe --skip-grant-tables --user=root &.
We make changes and save them sudo mysql.user SET Password=PASSWORD(‘new password) WHERE User=’root’.
After this, you need to log out and reboot the databases using the service mysql restart or service mysql start command.

Webmasters who work in certain site admin areas (wordpress, joomla, etc.) quite often encounter the need to interact with databases. MySQL DBMS is the most popular and in-demand database that works well with PHP. Most RuNet sites are written using this particular language. Moreover, PHP is one of the most popular and popular languages for front-end and back-end website programming. There are several options to access MySQL:

Using the command line.
Using web applications.

The first method is the optimal solution for programmers and users who know bash well. For everyone else, the best solution is dedicated web interfaces. The most popular option is PhpMyAdmin, which allows you to manage and configure databases through a browser, without knowledge of the program code for this DBMS.

PhpMyAdmin Features

Database search system.
Creation and adjustment of tables, databases, records.
Direct execution of SQL commands.
Creating new users.

Essentially PhpMyAdmin is an Internet application created for database administration. The application is written in the PHP programming language and has open source code licensed under the General Public License, which gives everyone the right to use all the features of the web interface completely freely.

Its main purpose is to simplify the operation of the database and enable everyone to administer MySQL without learning program code. Automation and high degree security features have made this web interface extremely popular and popular among webmasters working in the Russian-speaking segment of the Internet.

From the author: Are you lost again and don’t know how to log into MySQL? You're not the first! Gather all those who are lost, and now let’s go straight to visit her. To whom “to her”? To the most popular DBMS on the World Wide Web!

Where is MySQL located in Denver?

This does not mean the capital of the state of Colorado in the USA, but a software package for creating and testing applications in PHP. The set for “gentlemen” includes a local Apache server, MySQL server and phpMyAdmin shell. It is with the help of this software package that “newbies” most often learn all the intricacies of working with this database management system.

Before logging into MySQL through a browser, you need to start the local server, then in address bar type localhost, and in the window that appears, “Hurray, it’s working!” In the utilities section, select phpMyAdmin.

After which you will find yourself there (in phpMyAdmin).

We go to the databases through the “labyrinth”

You and I will go into the “dense” forest and try to “get through” it to the database server. Don’t think that we are hiding from someone, we’ll just act like this now. Let's go!

Before logging into MySQL via the command line, you should find out where the main database server directory is located. If you use the DBMS in its “pure” form without “impurities” (outside the “gentleman’s” set), then the server root folder is located here: C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe

If you are using Denver, then the file you are looking for is located in this path: Z:\usr\local\mysql-5.5\bin\mysql.exe,

where Z is the virtual disk that is created after starting the local web server. You may have it under a different name (more precisely, a letter).

We are interested in the mysql.exe file. Let's run it by specifying the name of the database server, password and user under which we will log into MySQL.

How to enable MySQL via the command line: go to “Start”, select “Command Prompt” from the standard programs. We launch the utility, and from now on we will describe the entire procedure of “walking” in the dense forest step by step, so that the entire group of “lost” people does not get lost again. Let’s start:

In the black CMD (command line) window, enter the path where the MySQL executable file is stored, and next to it indicate the DBMS user name and password. Since we have a local server, we enter after the identifier u the username root without a password.

This is actually incorrect and there should be a password set for every MySQL server user. We will consider all DBMS security issues in more detail in one of our next publications.

Here is the whole piece of “code”: Z:\usr\local\mysql-5.5\bin\mysql.exe -u root

If everything went well, then information about the version of the running service, the year of release and other “unnecessary” information for us should appear below in the command line window.

Now, to check the correctness of the connection, we will enter a query after the mysql> operator that will display all the databases stored on the server. Request code:

db1 is the name of the database we need.

In the screenshot we see that the requested database contains only one table.

Let's dig deeper!

As they say, the “appetite” comes after receiving the results of executing the code. Therefore, we will try to dig even deeper to get the data that is stored in the table. Before logging into MySQL again, here is an example of an SQL query with which we can accomplish our plans:

SELECT * FROM animal;

SELECT * FROM animal ;

We enter the request, launch it for execution and... For some reason the server gave us an error.

And all because we forgot to tell MySQL which database we are interested in. So the server “swears” that none of the databases are allocated. This once again proves that working with a DBMS through the command line is very different from interacting with it through a software shell.

In phpMySQL, this query would be executed successfully and the server would return a selection of all rows contained in the requested table.

Let’s correct our common omission (it’s always difficult to admit one’s guilt), and before logging into MySQL through the console again, we’ll prepare a “specific” query with which we’ll point the system to the desired database:

After entering this line and executing it, the server will display a message confirming that the desired database has been allocated.

And now let’s enter and run a query to retrieve all data from the animal table again. “Let there be data!” - said the administrator, and launched SELECT. We got to the bottom of db1 and got the contents of the animal table. It’s not for nothing that before entering the MySQL database, we performed a whole “ritual” and wrote the correct “spell” in SQL.

What else can you dig up?

We dug deep to the very bottom of MySQL. Now let's dig a little to the side. What other information can be obtained through the command line by querying MySQL? Do you want to know the table structure, data types of all columns, primary key? Please! Run this query:

describe animal;

describe animal ;

Sometimes, in order to know how to enable the MySQL server, you need to get a list of all registered users of the DBMS. The following query is used for this.

Benefits of technology

The use of such technology allows you to obtain a number of advantages:

After the site project is ready, you can easily transfer it from a local server to a real one, and begin to fully use the site.

How to log in and use localhost/Tools/phpMyAdmin

To use the database tool, simply go to http://localhost/Tools/phpMyAdmin.

Why doesn't http://localhost/Tools/phpMyAdmin open?

When creating your first serious web project, sooner or later you will be faced with working on databases, and MySQL technology in particular. The MySQL database server is great for small and developing projects at an early stage of development due to the ease of working with it. The phpMyAdmin system makes the job even easier, giving the user access and GUI working with a database, managing tables, creating backup copies and many other useful functions. Of course, this speeds up the workflow and frees up developers’ time for more useful things.

How to login to phpMyAdmin on Denwer?

The most popular one for Windows is called Denwer, and it, as you might have guessed, includes phpMyAdmin. But there is one problem that users encounter all the time: in phpMyAdmin how to log into the admin panel?

If you use Denver, then to quickly enter the admin panel of the phpMyAdmin control system, you can add a special link to your browser bookmarks: http://localhost/Tools/phpMyAdmin.

But soon you will have to upload the site to real hosting, and if you plan to implement your development to the end, study the following questions in advance: how to work with the phpMyAdmin interface? How to log into the administrative control panel?

Instructions for logging into ISP Manager and CPanel

If your remote web hosting uses the ISPmanager control panel, then log in using the links in the example below:

If the CPanel panel is installed, then questions about phpMyAdmin, how to log into the host will not create problems. Use the following link: https: //your_site.com:2083/3rdparty/php My Admin/ - you will need to remove the spaces.

Instead of the words “your site.com”, use the domain of your resource, purchased and attached to the hosting in advance. If you do not own the required domain on at the moment, you can authorize by IP address, in which case in phpMyAdmin you will know exactly how to enter.

If you use some unpopular control panel or don’t know whether it exists at all, try adding the name of the control panel after the slash in the address of your site, or specify this word as a subdomain - this combination is used by some hosters.

Our users can use the MySQL DBMS on their virtual web servers within the framework provided by the relevant tariffs. Currently working Version: 5.6 Main encoding: cp1251 (Windows). Additionally, KOI8-R and UTF-8 are supported.

The cost of shared hosting plans that support MySQL services includes a certain number of MySQL databases and one MySQL user. In addition, databases are created for an additional fee according to the current price list.

Databases (DBs) are understood as data storage and processing systems that are accessed using the SQL (Structured Query Language) language. There are many various systems database management (DBMS), but in hosting conditions the MySQL DBMS is usually used. The reasons for this are the actual orientation of this DBMS for hosting tasks, availability on all popular server operating systems, as well as ease of setup and administration.

When choosing between different DBMSs, you need to take into account that if your web project does not have a particular load and complexity of solutions, and you, as a programmer and administrator, do not have sufficient qualifications and experience in working with various DBMSs, there are no alternatives to MySQL for you in this case not very much and it’s probably worth choosing MySQL. We direct you to the article “Why MySQL? » on the server hostinfo.ru, where you will learn in detail about the pros and cons of this particular system. Also on the MySQL developers website there is complete documentation in Russian.

Parameters and methods of connecting to MySQL

Hostname (server) hosting MySQL: uXXXXX.mysql.site
Port: 3306
Login: corresponds to the name of the virtual platform - uXXXXX
Password: specified in the letter that the user receives upon registration
Database name: corresponds to the name of the virtual site - uXXXXX

For security reasons, direct access to MySQL servers from the Internet is prohibited (with the exception of the ssh tunnel), and clients are provided with the following options for administering and using the database:

access MySQL command line from unix shell
working with the database from user scripts in Perl, PHP, etc.
database management via the phpMyAdmin web interface. Access credentials are provided during registration; the login and password coincide with the access credentials for the database itself

SSH tunneling to connect to a remote MySQL database

We use software: Putty v.0.70 (last stable release on 2017-07-08.)

Initial remote connection settings:

Host Name: website - Host for SSH connection, where uXXXX- your site number.
Port: 22
Protocol: SSH

Source Port: 3306 - port for local connection after tunnel installation.
Destination: Local - we indicate explicitly that the connection will be made on local port, mentioned above.
Destination: uXXXX.mysql.site:3306 - host with which tunneling will be carried out on a specific port (3306 - standard for MySQL)

Now you need to add settings to the menu Forwarded ports by clicking the “Add” button as shown in the figure below to achieve the following result:

The original documentation is available on the developers' website.

The setup is complete, go to the first “Session” menu, as in Figure 1, and click the “Open” button to establish a connection with the remote server via the SSH protocol. We go through authorization using your login and password, and get into bash, being locally on your site /home/uXXXX.

Meanwhile, according to our settings, the connection to the local MySQL server is tunneled using the SSH protocol and internal Putty tools. Thus, by connecting to the local port localhost:3306 and using any software for working with the MySQL server, we gain access to the administration of the remote database, while simultaneously protecting our connection via the SSH protocol.

phpMyAdmin - access MySQL via web browser

To access MySQL from a regular web browser, clients can use the tool phpMyAdmin. To do this, please refer to the page.

Access details for it are sent automatically to the contact address from the moment of purchasing a tariff plan with MySQL database support.

The only way to be sure of 100% data recovery is to perform regular backup information. To do this, you need to use the mysqldump utility, which is available through the unix shell.

Example commands for exporting and importing a database:

mysqldump -u username -p -h database_server_name database_name> dump.sql

The data will be saved in a file dump.sql. Next (if necessary) we restore the data from the backup copy (dump) like this:

mysql -u username -p -h database_server_name database_name

Utilities for working with MySQL launched in this way will ask for a password to the database. You must enter the password of the corresponding database user. If your password has been lost, you can change it yourself in the section Service tree(the drop-down menu is located at the very top line of the control panel on the right).

By default, the system considers that the data in the database is stored in UTF-8 encoding. If your data is stored in a different encoding, then after creating a backup copy (dump) for subsequent correct data recovery, you need to open the created file with a text editor and correct the line in it:

/*!40101 SET NAMES utf8 */;

For example, for Windows-1251 encoding you need to specify:

/*!40101 SET NAMES cp1251 */;

Additional options for the mysqldump utility:

--add-drop-table - option that adds the DROP TABLE command before creating tables. Before restoring tables from a dump, tables with the same name in the production database will be deleted and recreated from the backup. Recommended for use to prevent possible errors after recovery;

--add-locks - option that adds LOCK TABLES commands before execution and UNLOCK TABLE after execution of each table dump. Used to speed up access to MySQL;

--quote-names- an option that tells the utility to put quotation marks for table and column names. Recommended for use for MySQL versions younger than 4.1.1. In older versions it is enabled by default.

In this case, the mysqldump utility generates an error:

mysqldump: Out of memory (Needed XXXXX bytes) mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from server

As a result, the line to create a copy of the database is as follows:

mysqldump --opt -u username -p -h database_server_name --add-drop-table database_name> dump.sql

or like this:

mysqldump --quick -u username -p -h database_server_name --add-drop-table database_name> dump.sql

For compatibility of a dump made on a third-party server, we recommend creating a database dump with the key:

--set-variable max_allowed_packet=2M-O max_allowed_packet=2M

If during import you receive an error like

mysqldump: Error 2020: Got packet bigger than "max_allowed_packet" bytes when dumping table `some_table_name` at row: 2 This means that your database contains data that cannot be divided into separate parts, each no more than two megabytes.

Typically, this happens if a MySQL database is used to store the contents of various files, for example, pictures or music, without placing them directly in file system. In this case, if the size of any file exceeds a certain value, the database becomes unsuitable for use on our servers and you will need to either delete such data from your database, or consider using a database server on a VPS server, where you can set the desired limit max_allowed_packet to the required value, or not use it at all.

If MySQL 4.0.x is installed on your server, then to correctly transfer data from third-party servers, you must use the key when exporting the database:

Compatible=mysql40

How to work with MySQL from Perl scripts

To work with MySQL from Perl scripts, the DBI module is usually used. This allows you to conveniently open and close connections to the DBMS, prepare and execute queries to the database, handle errors, and so on. If you do not have experience working with MySQL from Perl, we recommend the book “Programming in Perl DBI” (Russian, English).

So, an example of working with MySQL from Perl DBI:

#!/usr/bin/perl use DBI; my $host = "u12345.mysql.site"; # fictitious MySQL server my $port = "3306"; # port to which we open the connection my $user = "u12345"; # username (fictitious) my $pass = "password"; # password my $db = $user; # database name -default equal to username print "Content-type: text/html\n\n"; $dbh = DBI->connect("DBI:mysql:$db:$host:$port",$user,$pass); $sth = $dbh->prepare("select field1 from table2");# prepare the query $sth->execute; # execute the request while ($ref = $sth->fetchrow_arrayref) ( print "$$ref\n"; # print the result ) $rc = $sth->finish; # close $rc = $dbh->disconnect; # connection

In this example, we first define variables with MySQL access parameters, then issue an HTTP header, since this is a script to be launched via the web, then connect to the database, prepare and send a select query, receive and print the results, and then close compound. This is the simplest script for working with MySQL from Perl. You can find more detailed examples in this article.

How to work with MySQL from PHP scripts

To work with MySQL, you can use the tools built into the PHP language, which are already supported by the hosting. PHP has a developed and understandable interface to this DBMS, which makes working with MySQL from PHP the easiest and most convenient, especially for novice webmasters and web programmers.

# connect to the server and select your database mysql_connect("u12345.mysql.site","u12345","password"); mysql_select_db("database"); # prepare and execute a query to the database $query = "SELECT * FROM table"; $result = mysql_query($query) or die(mysql_error()); # display the results of the query while($i = mysql_fetch_row($result)) ( echo $i; echo $i; ..... )

Complete documentation in Russian on working with MySQL from PHP scripts is available. In addition to descriptions, you will also find advice from experienced users and examples of using the functions mentioned in the documentation. We also recommend you the article “” on the hostinfo.ru server.

Loading data using LOAD DATA

Since MySQL version 3.23.49, LOAD DATA LOCAL is disabled by default for security reasons and must be specifically enabled.

Our MySQL server runs with LOAD DATA LOCAL enabled, but this functionality must be enabled on the client side.

For the mysql utility there are several options for enabling this option:

Parameter --local-infile=1
Create a file in your home directory .my.cnf and in it allow this option for the group used by this utility: local-infile=1

Enabling this mode from perl: you need to specify the mysql configuration file in dsn when connecting (since the libmysql library by default does not read any additional configuration files) and a group in it, create this group in the file, and set for this group local-infile=1:

For example, we enter in ~/.my.cnf

Local-infile=1 and in the script we configure the connection like this: my $dsn = "DBI:mysql:database:hostname;mysql_read_default_group=perl;". "mysql_read_default_file=~/.my.cnf"; my $dbh = DBI->connect($dsn, "username", "password") ||die ": Can"t connect to MySQL: $!";

Enabling this mode from PHP: You must have your own compiled PHP interpreter installed.

In function mysql_connect() you must use argument 128 (the value of the CLIENT_LOCAL_FILES constant) as the fifth parameter.

$dbh = mysql_connect($server, $user, $pass, false, 128);

Additional MySQL database and MySQL access (MySQL user)

Users are provided with a certain number of MySQL databases as part of the purchased tariff. In this case, one database is automatically connected, and the access details for it are communicated in a letter notifying about the establishment of services. Clients can independently create additional databases and MySQL accesses.

To do this, you need to go to the section Service tree select the site for which you want to create additional service and in the “MySQL” table, select the “add” command for the “MySQL-access (add.)” or “MySQL-base (add.)” service. Database access passwords can be changed by calling the “change” command for the required MySQL access.

Additional documentation and useful links

MySQL is the most popular among database developers. Its popularity is accompanied by the presence of comprehensive and very high-quality documentation. Once you learn how to use it, you will have no problems accessing high-quality descriptions of the necessary MySQL features.

“Using MySQL in PHP scripts” - hostinfo.ru
“MySQL in web projects” - hostinfo.ru

phpMyAdmin is a LAMP application created specifically for administration MySQL servers. Written in PHP and accessible via a web browser, phpMyAdmin provides a graphical interface for database administration tasks.

Installation

Before installing phpMyAdmin, you will need access to the MySQL database on the same computer where you are installing phpMyAdmin, or on a remote computer accessible over the network. See the MySQL section for details. To install in the terminal, enter:

Sudo apt-get install phpmyadmin

When prompted, select which web server will be configured for phpMyAdmin. This section assumes use as a web server Apache2.

Sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf sudo a2enconf phpmyadmin sudo /etc/init.d/apache2 reload

In your browser, go to http:// localhost/phpmyadmin. On the login page, enter root as the username, or another user if you configured one, and the MySQL password for that user.

If in the previous step, when you go to the address http:// localhost/phpmyadmin, the server gives an error 404 - Not found, check the file location phpmyadmin.conf. In case of ubuntu 12.04: if the file is missing at the address /etc/apache2/conf.d/phpmyadmin.conf and at the same time exists at the address /etc/phpmyadmin/apache.conf, then move the file and restart the server: sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf sudo /etc/init.d/apache2 restart

After that, try logging in through your browser again.

Settings

The phpMyAdmin configuration files are located in /etc/phpmyadmin. The main settings file is /etc/phpmyadmin/config.inc.php. This file contains configuration options that apply to phpMyAdmin globally.

To use phpMyAdmin to manage MySQL on another server, set up the following entry in /etc/phpmyadmin/config.inc.php:

$cfg["Servers"][$i]["host"] = "db_server";

Replace db_server to the current IP address of the remote database server. Also make sure that the computer with phpMyAdmin has access rights to the remote database.

After setup, log out of phpMyAdmin and log in again and you will have access to the new server.

The files config.header.inc.php and config.footer.inc.php are used to add HTML top and bottom headers for phpMyAdmin.

To connect to phpMyAdmin you can use the already created database u1234567_default(Where u1234567— your hosting login), which is automatically created when you order hosting. Access details for this database are given in the article.

Attention Database u1234567_default is created only when ordering tariff plans from “Host-0” and higher. If you ordered tariff plan“Host-Lite”, and then upgraded it to a higher one, this database is not created. You need to create the database yourself according to the instructions:

I can't login to phpMyAdmin

To log into phpMyAdmin you need to use database user login and password. Do not confuse the database user login and password with the hosting service login and password (u1234567).

If the database password is not suitable, you can change it to a new one using the instructions:

How to create, delete or modify a table in the phpMyAdmin database?

Attention! Editing the database may cause your site to not work correctly. Before making changes, create a backup of your site or contact the developers.

How to add a new table to a database?

When creating your first serious web project, sooner or later you will be faced with working on databases, and MySQL technology in particular. The MySQL database server is great for small and developing projects at an early stage of development due to the ease of working with it. The phpMyAdmin system makes the work even easier, which provides the user with access and a graphical interface for working with the database, managing tables, creating backups and many other useful functions. Of course, this speeds up the workflow and frees up developers’ time for more useful things.

How to login to phpMyAdmin on Denwer?

If you use "Denver", then to quickly enter the admin panel of the phpMyAdmin control system, you can add a special link to your browser bookmarks: http://localhost/Tools/phpMyAdmin.

Instructions for logging into ISP Manager and CPanel

If your remote web hosting uses the ISPmanager control panel, then log in using the links in the example below:

Instead of the words “your site.com”, use the domain of your resource, purchased and attached to the hosting in advance. If you do not currently own the required domain, you can authorize by IP address, in which case phpMyAdmin you will know exactly how to enter.