Shared Signature: Managing MySQL Services
	What's New in IT IT Consulting Phones/VoIP Internet Security About Us Home

	Web Site Hosting	Web Design	Broadband/Access	E-Mail Solutions	Accept Credit Cards	Hosting Support

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

1. Log in to your Control Panel.
2. Select My Website from the drop-down list at the top of the window. The My Website Home page appears.
3. Click the Add Ons tab. The FrontPage Extensions window appears.
4. Click the MySQL sub-tab. The MySQL window appears.
5. Type a password your programmer will use to connect to MySQL in the appropriate text boxes.
6. Click Initialize and Enable MySQL. The window refreshes with a message informing you that MySQL is enabled.

After enabling MySQL through the Control Panel, you can disable or enable the program via the Control Panel interface. You may also start, stop, or restart the MySQL daemon from a SSH 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.

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

PhpMyAdmin

PhpMyAdmin is available to install on your account via the Add Ons tab described above. This add on provides a web interface for managing MySQL data.

The mysql Client

To use the mysql client program, 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.

NOTE: As an alternative to using the mysql program, you can use a graphical utility such as phpMyAdmin, which can be installed via your Control Panel. See the Online Help for details.

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 our 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:

• MySQL Online Documentation

Please note: the information on this page applies to ITS web hosting plans. It may or may not apply to other environments. If you are looking for a feature described here, or better support from your hosting provider, please consider hosting your site with ITS!

Copyright © 1996-2024, Integrated Technical Solutions, Inc., all rights reserved. See Terms/Legal for trademarks, copyright, and terms of use.