Databases (MySQL / phpMyAdmin)

7 articles

Articles

Using phpMyAdmin in DirectAdmin

phpMyAdmin is the web tool for working inside a MySQL or MariaDB database from your browser: browsing tables, editing rows, running SQL, and importing or export...

361Updated 5 days ago

Read article

Creating and Managing MySQL Databases in DirectAdmin

In DirectAdmin you create a MySQL database, and the user that connects to it, in one step under Account Manager › Databases. Your website then connects with hos...

Advanced6 min643Updated 5 days ago

Streamlined Bulk MySQL/MariaDB User Recovery: Your Complete Backup File Manual

Restoring MySQL users from backup files can be a daunting task, but with the right approach, it can be automated and streamlined. This guide will walk you throu...

Intermediate6 min1,250Updated 5 days ago

Optimizing Queries for Better Performance

Most slow MySQL queries are slow for the same reason: MySQL has to read far more rows than it returns. You fix that by writing queries that can use an index, an...

Advanced6 min1,507Updated 1 weeks ago

Building a User Registration System with PHP, MYSQL

A registration and login system is the first real feature most PHP projects need, and the one most often built insecurely. This guide builds a small, complete v...

Advanced8 min7,102Updated Today

Creating and Connecting to a MySQL Database in DirectAdmin

To use a MySQL database in DirectAdmin, you create the database and its user in Account Manager › Databases, then connect your website with host localhost, the ...

Advanced7 min2,823Updated 5 days ago

What is SQL mode & Why is ONLY_FULL_GROUP_BY SQL mode

SQL mode is a MySQL and MariaDB setting that decides how strict the database is about the queries and data you send it. One mode, ONLY_FULL_GROUP_BY, causes mor...

Advanced9 min12,436Updated 1 weeks ago

About this category

Articles

Topics

Updated 5 days ago

Can't find what you need?

Our support team is available 24/7 to help.

Submit a Ticket Browse All Articles