• Sales: 1-800-961-2888
  • Support: 1-800-961-4454

mysql


MySQL

A MySQL server timeout can occur for many reasons, but happens most often when a command is sent to MySQL over a closed connection. The connection could have been closed by the MySQL server because of an idle-timeout; however, in...
0 Comments
Filed in: Cloud Servers
Manipulating a database server
Running a well-tuned and efficient database server takes a lot of knowledge and hard work. We're not going to help you do that here.
No, this is a quick and dirty list of common tasks, using the...
1 Comments
Filed in: Cloud Servers
Beyond the defaults
In the previous article we covered a basic MySQL server setup on Arch Linux. We set the root password, created a database, and created a user for the database. Now let's look at MySQL in a little more detail...
0 Comments
Filed in: Cloud Servers
Beyond the defaults
In the previous article we covered a basic MySQL server setup on Gentoo Linux. We set the root password, created a database, and created a user for the database. Now let's look at MySQL in a little more detail...
0 Comments
Filed in: Cloud Servers
Beyond the defaults
In the previous article we covered a basic MySQL server setup on Red Hat Linux. We set the root password, created a database, and created a user for the database. Now let's look at MySQL in a little more...
0 Comments
Filed in: Cloud Servers
Beyond the defaults
In the previous article we covered a basic MySQL server setup on Fedora Linux. We set the root password, created a database, and created a user for the database. Now let's look at MySQL in a little more detail...
0 Comments
Filed in: Cloud Servers
Beyond the defaults
In the previous article we covered a basic MySQL server setup on CentOS Linux. We set the root password, created a database, and created a user for the database. Now let's look at MySQL in a little more detail...
7 Comments
Filed in: Cloud Servers
Beyond the defaults
In the previous article we covered a basic MySQL server setup on Debian Linux. We set the root password, created a database, and created a user for the database. Now let's look at MySQL in a little more detail...
0 Comments
Filed in: Cloud Servers
Beyond the defaults
In the previous article we covered a basic MySQL server setup on Ubuntu Linux. We set the root password, created a database, and created a user for the database. Now let's look at MySQL in a little more detail...
0 Comments
Filed in: Cloud Servers
Meet MySQL
MySQL is an open-source relational database. In a nutshell, for those unfamiliar with it: A database is where an application keeps its stuff.
To break it down a little further, "relational database" is a term that...
0 Comments
Filed in: Cloud Servers
Meet MySQL
MySQL is an open-source relational database. In a nutshell, for those unfamiliar with it: A database is where an application keeps its stuff.
To break it down a little further, "relational database" is a term that...
2 Comments
Filed in: Cloud Servers
Meet MySQL
MySQL is an open-source relational database. In a nutshell, for those unfamiliar with it: A database is where an application keeps its stuff.
To break it down a little further, "relational database" is a term that...
0 Comments
Filed in: Cloud Servers
Meet MySQL
MySQL is an open-source relational database. In a nutshell, for those unfamiliar with it: A database is where an application keeps its stuff.
To break it down a little further, "relational database" is a term that...
0 Comments
Filed in: Cloud Servers
Meet MySQL
MySQL is an open-source relational database. In a nutshell, for those unfamiliar with it: A database is where an application keeps its stuff.
To break it down a little further, "relational database" is a term that...
5 Comments
Filed in: Cloud Servers
Meet MySQL
MySQL is an open-source relational database. In a nutshell, for those unfamiliar with it: A database is where an application keeps its stuff.
To break it down a little further, "relational database" is a term that...
1 Comments
Filed in: Cloud Servers
Meet MySQL
MySQL is an open-source relational database. In a nutshell, for those unfamiliar with it: A database is where an application keeps its stuff.
To break it down a little further, "relational database" is a term that...
3 Comments
Filed in: Cloud Servers
What is MySQL?
MySQL is a database server, software that stores and retrieves data for other applications. You might need a database that will work with an application you're developing, or you may just want a database so you can...
0 Comments
Filed in: Cloud Servers

Contents
1 MySQL Master-Master Replication
1.1 Setup Outline
1.2 Creating the Cloud Servers
1.3 Installing MySQL
1.4 Configuring Replication
1.5 Testing the scenarios



MySQL Master-Master Replication
This article is about...
2 Comments
Filed in: Cloud Servers
This article is about setting up MySQL Master-Slave database replication between two Cloud Servers. Master-Slave data replication allows for replicated data to be copied to multiple computers for backup and analysis by multiple...
1 Comments
Filed in: Cloud Servers


Contents

1 Abstract


2 Introduction


3 SQL Injection Examples


4 Cheat Sheet On SQL Injection Attacks Against MySQL Databases


5 SQL Injection by Exploiting the...
0 Comments
Filed in: Cloud Servers
Installing MySQL on Ubuntu Intrepid is very simple using the 'aptitude' package manager.
This article will go through the install process and also look at what other packages are need for MySQL to integrate with Ruby on Rails and...
0 Comments
Filed in: Cloud Servers
This tutorial will walk you through setting up a user on your MySQL server to connect remotely.
The following items are assumed:
You have access to login as the 'root' MySQL user

Contents
1 Getting your IP address
2 Granting...
11 Comments
Filed in: Cloud Servers
This article will walk you through creating/editing columns in tables. It will also walk you through adding rows to your tables.

Contents
1 Preparation
2 Log in
3 Add a column
4 Inserting a record
5 Selecting a record
6 Update a...
0 Comments
Filed in: Cloud Servers
This article will teach you how to create and delete tables in your MySQL server.

Contents
1 Preparation
2 Log in
3 Which database?
4 Create a table
5 Show
6 Rename
7 Drop


Preparation
If you deleted 'mytestdb' then please see...
1 Comments
Filed in: Cloud Servers
Creating users for MySQL runs along the same lines as adding users on the Cloud Server itself - you create a user with a password and assign permissions to different databases as needed.
As with the other MySQL commands, you will...
3 Comments
Filed in: Cloud Servers
The MySQL root password allows full access to the MySQL database and allows for all actions to be undertaken including creating new users, new databases, setting access rules and so on.
Losing one can be a difficult issue to...
13 Comments
Filed in: Cloud Servers
MySQL replication enables one database server (we'll call it the Master server) to be replicated to one or more database servers (we'll call those the Slave servers). With MySQL, replication is asynchronous. This means your Slave...
4 Comments
Filed in: Cloud Servers

Windows Server 2012

Follow the procedure below to set up MySQL on Windows Server 2008R2 and 2012 with the Microsoft Web Platform Installer or WebPI. 
Installing MS WebPI
The Microsoft Web Platform Installer makes it simple to install a variety of...
0 Comments
Filed in: Cloud Servers

Databases

Note: To complete this process, you will need both a cloud server and a cloud database.
Use the following steps to connect to Cloud Databases by using MySQL Workbench.
Go to http://www.mysql.com/products/workbench/ and install...
0 Comments
Filed in: Cloud Databases

FTP

Now available in Cloud Sites - MySQL 5.1!  
Read on to learn the process of migrating your current Cloud Sites running MySQL 5.0 to begin running on a MySQL 5.1 database.  
Migrating your sites to a newer version of MySQL will...
2 Comments
Filed in: Cloud Sites
 
Cloud Sites currently supports the following versions of the software:
 
Technology
Versions Supported

Linux


PHP


5.3 and 5.4


Apache


2.2


MySQL


5.0, 5.1


Windows


ASP.NET


2.0, 3.5 SP1, 4.0, and 4.5


Windows...
25 Comments
Filed in: Cloud Sites

Linux and PHP

Now available in Cloud Sites - MySQL 5.1!  
Read on to learn the process of migrating your current Cloud Sites running MySQL 5.0 to begin running on a MySQL 5.1 database.  
Migrating your sites to a newer version of MySQL will...
2 Comments
Filed in: Cloud Sites
 
Cloud Sites currently supports the following versions of the software:
 
Technology
Versions Supported

Linux


PHP


5.3 and 5.4


Apache


2.2


MySQL


5.0, 5.1


Windows


ASP.NET


2.0, 3.5 SP1, 4.0, and 4.5


Windows...
25 Comments
Filed in: Cloud Sites

Linux MySQL

Now available in Cloud Sites - MySQL 5.1!  
Read on to learn the process of migrating your current Cloud Sites running MySQL 5.0 to begin running on a MySQL 5.1 database.  
Migrating your sites to a newer version of MySQL will...
2 Comments
Filed in: Cloud Sites
 
Cloud Sites currently supports the following versions of the software:
 
Technology
Versions Supported

Linux


PHP


5.3 and 5.4


Apache


2.2


MySQL


5.0, 5.1


Windows


ASP.NET


2.0, 3.5 SP1, 4.0, and 4.5


Windows...
25 Comments
Filed in: Cloud Sites
Cloud Sites will be retiring MySQL 4 soon in favor of MySQL 5. Any sites using MySQL 4 after November 1, 2011, will be automatically migrated to MySQL 5.
Migrating affected sites between MySQL versions will of necessity involve...
0 Comments
Filed in: Cloud Sites


Contents

1 Abstract


2 Introduction


3 SQL Injection Examples


4 Cheat Sheet On SQL Injection Attacks Against MySQL Databases


5 SQL Injection by Exploiting the...
0 Comments
Filed in: Cloud Servers

Backing Up Your MySQL Database
To manage your MySQL database, you'll first need to login to the online manager (phpMyAdmin).
After you are logged into the online manager, click on a database or table in the left frame as shown...
2 Comments
Filed in: Cloud Sites
Importance of using Indexes in your MySQL database:
Indexes help the system to access data fast and provide an ordering on the rows of a table as well as help enforce uniqueness of the values in a table. A lot of performance...
0 Comments
Filed in: Cloud Sites
NOTE: This article is written for our Classic Cloud Control Panel. You can access this interface from the New Cloud Control Panel by clicking your username in the upper-right of the control panel and choosing the previous control...
2 Comments
Filed in: Cloud Sites

MSSQL

 
Cloud Sites currently supports the following versions of the software:
 
Technology
Versions Supported

Linux


PHP


5.3 and 5.4


Apache


2.2


MySQL


5.0, 5.1


Windows


ASP.NET


2.0, 3.5 SP1, 4.0, and 4.5


Windows...
25 Comments
Filed in: Cloud Sites

IIS and ASP.NET

 
Cloud Sites currently supports the following versions of the software:
 
Technology
Versions Supported

Linux


PHP


5.3 and 5.4


Apache


2.2


MySQL


5.0, 5.1


Windows


ASP.NET


2.0, 3.5 SP1, 4.0, and 4.5


Windows...
25 Comments
Filed in: Cloud Sites

High Availability - HA


Contents
1 MySQL Master-Master Replication
1.1 Setup Outline
1.2 Creating the Cloud Servers
1.3 Installing MySQL
1.4 Configuring Replication
1.5 Testing the scenarios



MySQL Master-Master Replication
This article is about...
2 Comments
Filed in: Cloud Servers

Security



Contents

1 Abstract


2 Introduction


3 SQL Injection Examples


4 Cheat Sheet On SQL Injection Attacks Against MySQL Databases


5 SQL Injection by Exploiting the...
0 Comments
Filed in: Cloud Servers

Security Tools



Contents

1 Abstract


2 Introduction


3 SQL Injection Examples


4 Cheat Sheet On SQL Injection Attacks Against MySQL Databases


5 SQL Injection by Exploiting the...
0 Comments
Filed in: Cloud Servers

Ruby on Rails

Installing MySQL on Ubuntu Intrepid is very simple using the 'aptitude' package manager.
This article will go through the install process and also look at what other packages are need for MySQL to integrate with Ruby on Rails and...
0 Comments
Filed in: Cloud Servers

Other Mail Servers

Following from the previous article, we now have our firewall opening the correct ports.
Now we can start adding domains and users to the MySQL 'mail' database.

Contents
1 Overview
2 Domains
3 Users
4 Reload Postfix
5 Test
6...
17 Comments
Filed in: Cloud Servers

Performance

Importance of using Indexes in your MySQL database:
Indexes help the system to access data fast and provide an ordering on the rows of a table as well as help enforce uniqueness of the values in a table. A lot of performance...
0 Comments
Filed in: Cloud Sites

Uncategorized

NOTE: This article is written for our Classic Cloud Control Panel. You can access this interface from the New Cloud Control Panel by clicking your username in the upper-right of the control panel and selecting "First-Generation...
2 Comments
Filed in: Cloud Sites