MySQL development

Get solutions and answers to your MySQL development questions here.

Connecting to MySQL from the command line

Learn how to connect to MySQL from the command line using the MySQL program with this guide including detailed instructions, code snippets, and links to related articles.

Connecting to MySQL using PHP

There are several ways you can connect to a MySQL database using PHP. This article covers how to connect to a MySQL database using MySQL Improved, PHP Data Objects (PDO,) legacy PHP functions, and how to connect to a remote MySQL database using PHP.

Connecting to MySQL using Python

There are several ways you can connect to a MySQL database using Python. This article includes sample code that shows how to use the mysqlclient, mysql-connector-python, and PyMySQL packages to access MySQL databases.

Connecting to MySQL using Node.js

This article demonstrates how to connect to a MySQL database using Node.js and the node-mysql package. It includes a code sample you can use in your own projects.

Connecting to MySQL using Perl

Learn how to connect to a MySQL database using either the DBI (Database Interface) module or the legacy MySQL module using Perl.

Connecting to MySQL using Microsoft .NET

Learn how to add MySQL support to Visual Studio, and develop .NET applications that can access MySQL databases on Hostvento Hosting servers. This article provides detailed instructions and code samples you can use in your own projects.

Importing and exporting a MySQL database

Learn how to how to import MySQL databases and export MySQL databases. If you already have a database that you want to install on an Hostvento Hosting server, or you want to back up your database, this article shows you how as well as how to troubleshoot any potential issues.

Remote MySQL connections

There are two options for connecting to MySQL databases remotely: setting up an SSH tunnel or setting up a direct connection. This article explores both methods, troubleshooting, and showcases an example of an ODBC connection.

MySQL client applications

You can use MySQL client applications, such as MySQL Workbench, to manage your MySQL databases remotely. These client applications are often faster and easier to use than cPanel or the command line. This article covers two ways to connect to your MySQL databases using MySQL Workbench: using a direct connection, and using an SSH connection.

Managing MySQL databases, users, and tables from the command line

Learn how to do common MySQL administration tasks from the command line. This article covers how to create and delete MySQL users, databases, and tables. Please note that this article only applies to unmanaged products.

Converting a MySQL database to UTF-8

Many MySQL databases use the Latin character set, which can be limiting depending upon the application. Learn how to determine a MySQL database’s character encoding set, and then convert the character encoding set to UTF-8 (Unicode,) that supports many alphabets and characters, with this article.

Converting the MySQL time zone

Learn how to convert the time zone in MySQL by using the CONVERT_TZ function to another time zone in this article.

MySQL database backups using cron jobs

Learn how to set up a cron job that automatically backs up a MySQL database at defined intervals. This article covers two methods, one which includes the MySQL login information in the cron job command and the other uses a configuration file to store MySQL login information.

MySQL database backups using AutoMySQLBackup

The AutoMySQLBackup tool enables you to quickly and easily create MySQL database backups. You can specify backup intervals, rotate backups, and even send backup files to e-mail accounts. This article covers how to download, install, configure, and run AutoMySQLBackup.

The information_schema database

When you view MySQL databases in phpMyAdmin or by using the mysql command-line program, you may also notice an information_schema database. This article explains what this database is and its purpose.

Resetting the MySQL root password

You can reset your MySQL root password if you have forgotten it. This article shows you step-by-step how to change the root password from the command line. Note that you must have root access to your server to accomplish this.

MySQL runs out of memory or does not start

MySQL server may run out of memory or not start at all on an unmanaged server with limited memory. This article covers how to work around this problem by making changes to the my.cnf file.

MySQL user privileges on shared servers

Due to the nature of shared hosting environments, some MySQL privileges are restricted on user accounts. This means some MySQL features, such as the Event Scheduler, are not available on shared hosting accounts. Learn more here.

Creating and executing MySQL stored functions and procedures

Learn how to create and execute MySQL stored functions and procedures on your Hostvento Hosting account.

MySQL views

MySQL views enable you to store predefined queries. Learn how to create and use them on your Hostvento Hosting account in this article.

MySQL triggers

MySQL triggers are a powerful tool that you can use to add advanced database functionality. Learn how to create and use them in this article.

Working with MySQL database engines

This article provides an introduction to MySQL database engines, showing you how to determine and change the default database engine, how to determine and change a table’s current database engine, as well as how to create a new table with a specific database engine.

Checking MySQL database and table sizes

This article demonstrates how to check the size of MySQL databases and tables by using the phpMyAdmin web interface or the command-line “mysql” program.

Repairing MySQL databases and tables

Learn how to repair MySQL tables and databases. This article covers how to run mysqlcheck, and engine-specific diagnostics with myisamchk and the InnoDB recovery process. Please note that this article only applies to accounts that have root access to the server.

Enabling the slow query log in MySQL

The MySQL slow query log can help you to determine which database queries take a long time to run. This article shows how to enable the slow query log from the command line.

Renaming a MySQL database

There are scenarios such as data migration or site development where you may want to rename a MySQL database. Although MySQL itself does not provide a way to rename a database in one operation, you can do this using other methods. Learn how to rename a database from cPanel and the command line in this article.

Using indexes to improve MySQL query performance

Indexes can help improve MySQL database query performance. This article gives an overview of indexes, demonstrates how to analyze database queries (so that you can determine which tables may benefit from using indexes), and how to add, remove, and view indexes in a table.

Restricting MySQL port access

Port 3306 is open on some Linux distributions after you install MySQL on an unmanaged server. This article demonstrates how to restrict access to port 3306, or how to block it altogether, with two methods: disabling MySQL networking and configuring firewall rules.

Installing phpMyAdmin on managed hosting accounts

Learn how to install phpMyAdmin locally on a managed hosting account with Softaculous or with a manual installation. You may want to do this if you need to run a version of phpMyAdmin newer than the version included with cPanel.

Creating a MySQL installation for local testing

Learn how to install MySQL locally for testing and development.

Troubleshooting MySQL definer issues

The MySQL DEFINER attribute is used to control access to stored objects (views, triggers, functions, and stored procedures). This article covers how to troubleshoot issues that can arise when using MySQL definers.

Using SELECT INTO OUTFILE in MySQL

This article discusses where you can use MySQL’s SELECT INTO OUTFILE statement. It also provides an alternative to SELECT INTO OUTFILE in case your hosting package does not allow it.

Determining the MySQL version

Learn how to determine which version of MySQL is installed on a server using cPanel, phpMyAdmin, or the command line.

Handling MySQL Error 1064

MySQL Error 1064 is a syntax error that indicates an issue with SQL syntax in the commands, which is frequently caused by incorrect use of reserved terms, missing data, or mistyped commands. This article will teach you how to read and handle MySQL Error 1064.