The following article will demonstrate an alternative way to connect to Cloud Databases using MySQL Workbench. Let's take a look below.
1. In the step, we'll head to http://www.mysql.com/products/workbench/. Once installed,...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This article is about setting up MySQL Master-Slave replication between two Cloud Servers. The operating system we are going to use for this example is CentOS 5.5, built from a Rackspace Cloud Server base image.
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...
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
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...
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...
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...
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...
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.
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...
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...