phpMyAdmin

phpMyAdmin is a web interface designed to handle a wide range of administrative operations for MySQL and MariaDB. It simplifies database management by offering an intuitive interface for common tasks (managing databases, tables, fields, relations, indexes, users, permissions) while retaining the ability to directly execute any SQL statement.

Key Features and Benefits

• Intuitive Web Interface. User-friendly environment for managing database operations without command-line complexity.
• Comprehensive Database Management. Browse, drop, create, copy, rename, and alter databases, tables, views, fields, and indexes.
• Advanced SQL Capabilities. Execute, edit, and bookmark any SQL statement, including batch queries. Build complex queries using Query-by-example (QBE).
• Data Import and Export. Import data from CSV and SQL. Export data to various formats including CSV, SQL, XML, PDF, ISO/IEC 26300, Word, and LaTeX.
• User Administration. Manage MySQL user accounts and granular privileges.
• Visualization. Create graphics of your database layout in various formats.
• Additional Tools. Global search within a database, support for stored procedures and triggers, and administration of multiple servers.

1. Make sure you have a deployed Managed Service for MySQL cluster.
2. Create a service account with the roles managed-mysql.viewer, compute.editor, iam.serviceAccounts.admin, resource-manager.admin, vpc.admin (the admin role includes all the specified roles).
3. In the management console select the Cloud Apps service.
4. In the left panel, select Application Store.
5. Select phpMyAdmin and click the Use button.
6. Specify:
   • Application name.
   • (Optional) Application description.
   • The service account created earlier.
   • The Managed Service for MySQL cluster you want to access through phpMyAdmin.
   • The cloud subnet from the same VPC network where the Managed Service for MySQL cluster is located.
   • TLS connection setup method for phpMyAdmin:
     • Certificate Manager — select a certificate from Certificate Manager (the service will help you issue a publicly trusted Let’s Encrypt certificate or you can upload your own issued certificate)
     • Self-Signed — issue a self-signed certificate; in this case, you can optionally specify a Hostname for which the self-signed certificate will be issued.
   • IP address mask from which access to phpMyAdmin will be opened; if the field is left empty — there will be no additional IP restrictions.
7. Click the Install button and wait for the application to install.
8. Follow the link in the Output parameters section on the application page (the application may be unavailable for a few minutes after installation). If a self-signed certificate is used, the browser will display a security warning — confirm to proceed.
9. Enter the Username and Password for the Managed Service for MySQL user and use the application.

• Web-based administration of MySQL and MariaDB databases.
• Execution and testing of SQL queries.
• Data backup and restoration via import/export features.
• Management of database users and access privileges.
• Visualizing database schemas and table relationships.

Yandex Cloud technical support is available 24/7. The types of requests you can submit and the appropriate response time depend on your pricing plan. You can switch to the paid support plan in the management console. You can learn more about the technical support terms here.