Difference between revisions of "MySQL FAQ"

From XMission Wiki
Jump to: navigation, search
m (How do I log in to my database?)
 
(13 intermediate revisions by 5 users not shown)
Line 1: Line 1:
 
{{archived}}
 
{{archived}}
 +
 
==What is SQL?==
 
==What is SQL?==
 
SQL stands for "Structured Query Language". SQL is the most common  standardized language used to access databases.
 
SQL stands for "Structured Query Language". SQL is the most common  standardized language used to access databases.
Line 7: Line 8:
  
 
==What version of MySQL does XMission use?==
 
==What version of MySQL does XMission use?==
XMission currently has two versions of MySQL running: version 5.0.24a and version 4.1.11. The current version is also displayed when you log in to the MySQL server.  
+
XMission currently has a few versions of MySQL running. The current version is also displayed when you log in to the MySQL server.
  
 +
Note: MySQL 5.0 and 4.1 are at the End of Product Lifecycle. All new databases will be created on the 5.1 MySQL server.
  
 
==How much does a database at XMission cost?==
 
==How much does a database at XMission cost?==
If you have a Deluxe Hosting or Pro Hosting account, an SQL database  is included in your account package. For any other account type, the charge is $5 per month.
+
If you have a Select Hosting or Pro Hosting account, an SQL database  is included in your account package. For any other account type, the charge is $5 per month.
  
  
 
==How do I get a database set up for my account?==
 
==How do I get a database set up for my account?==
To add a database to your account, either [mailto:sql@xmission.com email sql@xmission.com] or contact sales.  
+
To add a database to your account, either [mailto:support@xmission.com email support@xmission.com] or contact sales.  
  
  
 
==How do I log in to my database?==
 
==How do I log in to my database?==
Depending on your MySQL version, you will need to connect to a different host. For MySQL version 4.x, the server name is ''mysql-41.xmission.com''
 
<div class="messagebox metadata">'''Note''': ''mysql.xmission.com'' is the same machine, and will work for legacy purposes.</div>
 
  
For MySQL version 5.x the server name is ''mysql-50.xmission.com''
+
We are in the process of migrating all of our database customers from our old mysql-55.xmission.com server to your Shared Hosting servers. In the coming months you may be notified regarding this process.
 +
 
 +
In the mean time if you need to access your database here are instructions, as our web interface is no longer in production.
 +
 
 +
*For MySQL version 5.1 the server name is ''mysql-51.xmission.com''
 +
*For MySQL version 5.5 the server name is "mysql-55.xmission.com"
 +
 
 +
<strike>To use a web interface to access your database, visit https://phpmyadmin.xmission.com/ </strike>
  
To use a web interface to access your database, visit https://phpmyadmin.xmission.com/
+
'''NOTE''' ''' As noted above, the web interface is currently not working to connect to your database, use the below instructions.'''
  
 
To connect directly to the database from our shell server:
 
To connect directly to the database from our shell server:
Line 31: Line 38:
 
#This will prompt you for a password, which is not necessarily the same as your login password.
 
#This will prompt you for a password, which is not necessarily the same as your login password.
  
For example: to connect to a MySQL version 5.x database, you would use:
+
For example: to connect to a MySQL version 5.1 database, you would use:
<tt>mysql -u acctname -h mysql-50.xmission.com -p databasename</tt>
+
<tt>mysql -u acctname -h mysql-51.xmission.com -p databasename</tt>
  
 
==What can I use to access my database?==
 
==What can I use to access my database?==
Line 51: Line 58:
  
 
==What do I do if I forgot my password?==
 
==What do I do if I forgot my password?==
[mailto:sql@xmission.com Email sql@xmission.com] to have  your password reset.  
+
[mailto:support@xmission.com Email support@xmission.com] to have  your password reset.  
  
  
Line 61: Line 68:
 
==Can I use stored routines?==
 
==Can I use stored routines?==
  
Our MySQL 5.0 server support stored functions, procedures, triggers, and other such routines.  Since it is a shared server, we do not allow users to create or edit their own routines.  If you would like to have a routine installed, please contact support, providing a full copy of the routine you'd like installed.  We will install the routine if we decide the code does not cause any problems or cause an unreasonable support burden.  If you would like more complete control over database routines, please consider our [[VPS]] or [[Colocate]] products.
+
Our MySQL 5.x servers support stored functions, procedures, triggers, and other such routines.  Since it is a shared server, we do not allow users to create or edit their own routines.  If you would like to have a routine installed, please contact support, providing a full copy of the routine you'd like installed.  We will install the routine if we decide the code does not cause any problems or cause an unreasonable support burden.  If you would like more complete control over database routines, please consider our [[VPS]] or [[Colocate]] products.
  
 
==Where can I get more information about using MySQL?==
 
==Where can I get more information about using MySQL?==
Line 68: Line 75:
  
  
{{Footer}}
 
 
[[Category:Hosting Archives|MySQL FAQ]]
 
[[Category:Hosting Archives|MySQL FAQ]]
 
[[Category:FAQ|MySQL]]
 
[[Category:FAQ|MySQL]]

Latest revision as of 16:45, 29 October 2021

Archives.png


What is SQL?

SQL stands for "Structured Query Language". SQL is the most common standardized language used to access databases.

XMission uses MySQL, which is a very popular open-source database management system.


What version of MySQL does XMission use?

XMission currently has a few versions of MySQL running. The current version is also displayed when you log in to the MySQL server.

Note: MySQL 5.0 and 4.1 are at the End of Product Lifecycle. All new databases will be created on the 5.1 MySQL server.

How much does a database at XMission cost?

If you have a Select Hosting or Pro Hosting account, an SQL database is included in your account package. For any other account type, the charge is $5 per month.


How do I get a database set up for my account?

To add a database to your account, either email support@xmission.com or contact sales.


How do I log in to my database?

We are in the process of migrating all of our database customers from our old mysql-55.xmission.com server to your Shared Hosting servers. In the coming months you may be notified regarding this process.

In the mean time if you need to access your database here are instructions, as our web interface is no longer in production.

  • For MySQL version 5.1 the server name is mysql-51.xmission.com
  • For MySQL version 5.5 the server name is "mysql-55.xmission.com"

To use a web interface to access your database, visit https://phpmyadmin.xmission.com/

NOTE As noted above, the web interface is currently not working to connect to your database, use the below instructions.

To connect directly to the database from our shell server:

  1. telnet or ssh to shell.xmission.com
  2. mysql -u acctname -h servername -p databasename
  3. This will prompt you for a password, which is not necessarily the same as your login password.

For example: to connect to a MySQL version 5.1 database, you would use: mysql -u acctname -h mysql-51.xmission.com -p databasename

What can I use to access my database?

There isn't a "recommended" method to access your database, but here is a list of the more popular programing languages connection methods which we support.

perl : DBI module

python : mysql module or MySQLdb module

php : php has been compiled with the mysql functions built in

C : The header and libraries for mysql are installed so #include <mysql/mysql.h> will need to be present in your source files.

C++ : same as C, but we also have mysql++ headers and libraries on XMission servers. To use this, #include <sqlplus>

Java : JDBC classes are available


What do I do if I forgot my password?

Email support@xmission.com to have your password reset.


Do I have a size limit (quota) for my database?

Yes. The size of your database counts against your /home quota, which is 100MB default for most account types. Pro Hosting accounts get 200MB /home storage, and additional storage can be purchased.


Can I use stored routines?

Our MySQL 5.x servers support stored functions, procedures, triggers, and other such routines. Since it is a shared server, we do not allow users to create or edit their own routines. If you would like to have a routine installed, please contact support, providing a full copy of the routine you'd like installed. We will install the routine if we decide the code does not cause any problems or cause an unreasonable support burden. If you would like more complete control over database routines, please consider our VPS or Colocate products.

Where can I get more information about using MySQL?

Thorough documentation can be found at MySQL.com.