/BlogZero-Cost Cloud
Quick Answer: To create a MySQL database and user in cPanel: 1) Navigate to MySQL Databases (or MySQL Database Wizard), 2) Enter your database name and click Create Database, 3) Create a new MySQL user with a strong password, and 4) Under Add User to Database, select your user and database, check ALL PRIVILEGES, and … Read more
Quick Answer: To repair and optimize MySQL tables in WordPress, use WP-CLI by running wp db repair followed by wp db optimize. In phpMyAdmin, select all tables in your database and choose “Repair table” and “Optimize table” from the bottom action dropdown. On Linux VPS, execute mysqlcheck -u root -p –auto-repair –optimize –all-databases. ⏱️ 5 … Read more
Quick Answer: The “Error Establishing a Database Connection” screen occurs when WordPress cannot communicate with its MySQL/MariaDB database. To fix it: 1) Verify database credentials in wp-config.php (DB_NAME, DB_USER, DB_PASSWORD, DB_HOST), 2) Verify your MySQL server daemon is active and running (sudo systemctl restart mariadb), 3) Enable native WordPress repair mode (define(‘WP_ALLOW_REPAIR’, true);), and 4) … Read more
Quick Answer: To optimize MariaDB or MySQL for a 2GB or 4GB Linux VPS, edit /etc/mysql/my.cnf and allocate 65% to 70% of available RAM to the innodb_buffer_pool_size (1.4GB on a 2GB VPS, 2.8GB on a 4GB VPS), limit max_connections = 80, set innodb_log_file_size = 256M, and increase table_open_cache = 4000 to prevent disk I/O bottlenecks. … Read more
Quick Answer: To increase the phpMyAdmin upload file size limit from the default 2MB to 512MB+, adjust 4 core PHP directives in your active php.ini file: set upload_max_filesize = 512M, post_max_size = 512M, memory_limit = 512M, and max_execution_time = 300. In cPanel, navigate to Select PHP Version > Options or MultiPHP INI Editor to apply … Read more
Quick Answer: To export a large MySQL database without locking production tables, execute mysqldump -u username -p –single-transaction –quick dbname > backup.sql. To import a large SQL dump without web browser timeout errors, execute mysql -u username -p dbname < backup.sql (or pipe through pv backup.sql | mysql -u username -p dbname for live progress … Read more
Quick Answer: By default, Cloudflare only caches static files (images, CSS, JS) and passes all HTML requests to your origin server. Configuring “Cache Everything” Page Rules / Cache Rules caches the entire generated HTML page across Cloudflare’s 300+ edge data centers, delivering instant sub-30ms TTFB worldwide while safely bypassing the cache for logged-in administrators and … Read more
Quick Answer: To create a subdomain in cPanel, navigate to Domains, click Create a New Domain, enter your subdomain (e.g. staging.yourdomain.com), uncheck “Share document root”, and specify a custom directory path (public_html/staging). For Wildcard Subdomains, create a domain named *.yourdomain.com and point DNS A record * to your server IP. ⏱️ 5 min read (934 … Read more
Quick Answer: DNS TTL (Time to Live) is a numerical value (measured in seconds) that tells recursive DNS resolvers and ISP caching servers how long to cache a DNS record before requesting fresh data from the authoritative nameserver. 24 to 48 hours before migrating a website, you should lower your A record TTL to 300 … Read more
Quick Answer: To transfer a domain name between registrars with zero website or email downtime, decouple your DNS by routing through an independent nameserver (like Cloudflare or CpanelFree), unlock the domain at your current registrar, obtain the EPP / Authorization Code, initiate the transfer at the new registrar, and approve the ICANN transfer confirmation email. … Read more