
	Search: For: ~ Advanced Search

Support Home > Signature Hosting > Databasess >

Monday, October 06, 2008

MySQL on Signature Hosting

To enable MySQL 4.1.21 on your Signature Hosting product, do the following:

Log in to your Control Panel.
Select My Website from the drop-down list at the top of the window. The My Website Home page appears.
Click the Add Ons tab. The FrontPage Extensions window appears.
Click the Mysql sub-tab. The Mysql window appears. If your browser opens another window, click Cancel.
Type your password in the appropriate text boxes.
Click Initialize and Enable Mysql. The window refreshes with a message informing you that Mysql is enabled.

NOTE: The Signature Hosting Mini plan does not offer support for MySQL. If you have problems or the MySQL tab is missing, check your plan to assure MySQL is supported.

After enabling MySQL through the Control Panel, you can start, stop, or restart the MySQL daemon from the command prompt with the following command:

~/etc/rc.d/mysql-server.sh (start|stop|restart)

While the the MySQL daemon is running, the mysql.sock file will be stored in your ~/tmp directory.

NOTES: After you enable MySQL it is not necessary to run the mysql_install_db as described in Section 6.7 of the MySQL manual.

The mysql Client

To use the mysql client, connect to your server via SSH or Telnet and type:

% /usr/local/bin/mysql (-u LOGIN) -p

If you want to login as your main administrative user, you do not need to use the -u option. Use the -u option to connect to MySQL as the LOGIN user.

Signature Hosting plans have some limitations for MySQL. You cannot connect to MySQL as the root user with Signature Hosting plans. For a more robust MySQL solution, see the VPS and MPS hosting plans.

You can add MySQL users by following the directions in the MySQL Reference Manual:

MySQL Documentation: 5.7.2 Adding New Users to MySQL

The MySQL client is designed to be able to report errors in numerous languages. While this does not affect the way you use MySQL, having the error messages in your native language could make understanding the errors easier. For more information, see the following:

MySQL Documentation: 5.9.2 Setting the Error Message Language

To customize the starting of MySQL, you can use a configuration file with all your start-up options. To do this, edit the my.cnf file in your ~/var/mysql/ directory. The contents of the file would look like this if you wanted MySQL to report error messages in Japanese:

[client]
user=LOGIN
[mysqld]
language = japanese
default-character-set = ujis

Documentation

Manpages are available and can be accessed by typing the following during a telnet or SSH session with your Signature Server:

% man mysql

There is also a considerable volume of documentation on the MySQL web site:

Technical Support

°	Getting Started Guides
	FreeBSD
°	Basic Hosting Help
°	Signature Hosting Help
°	VPS v1 Help
°	VPS v2/3 Help
°	MPS v2/3 Help
	Linux
°	VPS v3 Help
°	MPS v3 Help
	SaaS
°	Sugar CRM
	DNS
°	Domain Name Service
°	Domain Registration
°	Help Desk
°	Knowledgebase
°	Support Policies
°	Disclaimer

°	AlpineWeb Home
°	Compare Hosting Plans
°	Network Topology

°	Rates & Fees
°	Order Center

Home | Site Map | Customer Backroom