Knowledgebase
Help Center
Databases
Databases, users, privileges, application connections, imports, exports, restores, and troubleshooting.
Subcategories
Refine the topic before choosing an article.
Connections, Imports & Database TroubleshootingDetailed customer guidance for database connections, imports, exports, restores, and troubleshooting, including authentication, privileges, SQL files, character sets, definers, file sizes, locks, row counts, and application migrations.
Databases & UsersDetailed customer guidance for databases and database users, including full names, hosts, ports, credentials, assignments, privileges, application configuration, and credential rotation.
Articles
20 published guides in this category.
Database server, host, name, username, and password terminology explained
Database server, host, name, username, and password terminology explained is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for r…
Recommended database client software for Spark Rack databases
Recommended database client software for Spark Rack databases is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for readers who m…
Connecting to a Spark Rack database with DBeaver Community
Connecting to a Spark Rack database with DBeaver Community is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for readers who may…
Connecting to a Spark Rack database with HeidiSQL
Connecting to a Spark Rack database with HeidiSQL is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for readers who may not admin…
phpMyAdmin versus a desktop database client
phpMyAdmin versus a desktop database client is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for readers who may not administer…
Fixing Access denied for user in MySQL or MariaDB
Fixing Access denied for user in MySQL or MariaDB is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for readers who may not admin…
Fixing Unknown database errors in an application
Fixing Unknown database errors in an application is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for readers who may not admini…
Fixing Cannot connect to MySQL server errors
Fixing Cannot connect to MySQL server errors is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for readers who may not administer…
Why localhost may be the wrong database hostname
Why localhost may be the wrong database hostname is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for readers who may not admini…
Database port 3306 explained and why it may not be publicly reachable
Database port 3306 explained and why it may not be publicly reachable is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for reade…
Database privileges explained: SELECT, INSERT, UPDATE, DELETE, and more
Database privileges explained: SELECT, INSERT, UPDATE, DELETE, and more is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for rea…
Importing a SQL database dump safely
Importing a SQL database dump safely is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for readers who may not administer servers…
Exporting a database backup that can actually be restored
Exporting a database backup that can actually be restored is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for readers who may n…
Working around browser upload limits during a large database import
Working around browser upload limits during a large database import is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for readers…
Character sets and collations explained for MySQL and MariaDB
Character sets and collations explained for MySQL and MariaDB is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for readers who m…
Fixing Duplicate entry errors during an import or application update
Fixing Duplicate entry errors during an import or application update is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for reader…
Understanding Too many connections database errors
Understanding Too many connections database errors is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for readers who may not admi…
What to do when a database table is reported as crashed or corrupted
What to do when a database table is reported as crashed or corrupted is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for reader…
Finding the database settings used by a website application
Finding the database settings used by a website application is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for readers who may…
Safely replacing an old domain name inside a website database
Safely replacing an old domain name inside a website database is a practical Spark Rack customer guide about database servers, names, users, privileges, connections, imports, and exports. It is written for readers who m…
