How to connect to MySQL using PHP

This article describes several methods to connect to a MySQL database using PHP: MySQL Improved (mysqli) PHP extension PDO (PHP Data Objects) Legacy MySQL (mysql_) functions Connect to remote MySQL database using PHP The MySQL databases and users must already exist before you can use these methods.Method #1: Connect to MySQL using MySQL Improved The MySQL Improved extension uses the ...

How to import and export a MySQL database

This article describes how to import MySQL databases and export MySQL databases. You can import and export databases for a variety of scenarios, including: Transferring a MySQL database from one web hosting account or provider to another. Importing a third-party MySQL database. Backing up a MySQL database.How to export a MySQL database You can export a MySQL database to ...

How to clear the DNS cache on your computer

This article describes how to clear the DNS cache on your computer. Many computer operating systems use caching to store DNS lookup results. Normally this is not a problem, and accelerates network performance. However, when you are developing a web site or configuring domain settings, your computer's DNS cache can get in the way, preventing you from accessing the correct ...

How to manage MySQL databases, users, and tables from the command line

This article describes how to do common MySQL database administration tasks from the command line using the mysql program. These common tasks include creating and deleting databases, users, and tables.This article only applies to the products listed in the Article Details sidebar. If your account includes cPanel, you should use it instead to manage MySQL databases and users.Creating ...

How to clear a web browser's cache and cookies

This article describes how to clear the cache and cookies for a variety of popular web browsers. Web browsers use caching to speed up the browsing experience. Normally, this is not a problem. However, when you are developing pages for your web site or configuring domain settings, the browser's local cache and cookies can get in the way. For example, ...

How to Check the MySQL Version

In this quick tutorial, we'll learn how to check the MySQL version of a server. Without a doubt, MySQL is one of the most popular RDBMS (Relational database management system) options available, so you'll find it pretty much everywhere. There can be some pretty staggering differences between MySQL versions, so knowing which version you're working with is important. Learn here ...

What is the Default Password for PostgreSQL?

When connecting to PostgreSQL on Linux for the first time many admins have questions, especially if those admins are from the MySQL world. By default, when PostgreSQL is installed, a postgres user is also added. If you run the command: cat /etc/passwd … you’ll see the postgres user. postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash The first ...

What is a MySQL Trigger and how to add Database Triggers in phpMyAdmin?

Introduction A MySQL trigger is a stored code sequence that the database server executes each time your database triggers a specific event within the table. Examples of such events are the UPDATE, INSERT, or DELETE statements. Standard usage of a MySQL database trigger involves performing a check whenever a piece of content is inserted inside a table or a re-calculation ...

How to connect to MySQL using Python

Python provides several ways to connect to a MySQL database and process data. This article describes three methods.The MySQL databases and users must already exist before you can use any of the following methods.Connecting to MySQL using PythonBefore you can access MySQL databases using Python, you must install one (or more) of the following packages in a virtual ...

How to connect to MySQL using Microsoft .NET

This article describes how to add MySQL support to Microsoft Visual Studio. With MySQL and Visual Studio integration, you can develop Microsoft .NET applications that access MySQL databases onUltaHost Hosting servers. Adding MySQL support to Visual Studio Visual Studio does not include support for MySQL by default. To add MySQL support to Visual Studio, you must install the following components: ...

How to connect to MySQL using PHP

This article describes several methods to connect to a MySQL database using PHP: MySQL Improved (mysqli) PHP extension PDO (PHP Data Objects) Legacy MySQL (mysql_) functions Connect to remote MySQL database using PHP The MySQL databases and users must already exist before you can use these methods.Method #1: Connect to MySQL using MySQL Improved The MySQL Improved extension uses the ...

How to reset the MySQL root password

This article describes how to reset the MySQL root password. You may need to do this, for example, if you have forgotten the password. You must have root access on the server to reset the MySQL root password. Resetting the MySQL root password To reset the root password for MySQL, follow these steps:     1.Log in to your account ...

What is my MySQL Server Hostname?

If you want to connect to your database from an application or a PHP script on your UltaHost hosting account, you can simply use localhost as MySQL hostname.If you’re accessing your database from a remote server, you need to grant it access first following the instructions in our Remote MySQL tutorial and then use your domain name as ...

How to Setup a POP3 Email Account in Microsoft Outlook 365 (Windows)

Microsoft has made some improvements to it’s Outlook Email Application making it easier than before to add a new email account so you can send and receive email. All ChemiCloud hosting plans include POP, IMAP, and SMTP access for your email users, as well as webmail access. In this Knowledgebase article, we will cover how to add a new ...

What MySQL storage engines are supported on your servers?

Our servers support InnoDB and myisam MySQL storage engines.

Do you support foreign keys in phpmyadmin?

Foreign keys are supported on all of our packages!

#1064 You have an error in your SQL syntax

The error 1064 occurs due to MySQL version mismatch. Different versions have different reserved words, which, if they are used by a previous version, causes the error to occur.

Do you support foreign keys in phpmyadmin?

Foreign keys are supported on all of our packages!

How can I modify database charset?

You can modify database charset using phpmyadmin at any time. Simply select the database you want to edit, click 'Operations' tab and look for 'Collation' field. Select new charset and click 'Go' button to save your changes. If you need to modify charset for an individual table or even field, you can repeat the same operation after selecting the desired ...

How many mysql user connections do you allow (at the same time)?

Our servers are set to use up to 15 simultaneous MySQL connections for one MySQL user at the same time.