MySQL on Signature Hosting
To enable MySQL
on your Signature Hosting product, do the following:
- Log in to your Control Panel.
- Select Databases from the menu list at the left of the window.
- Click the MySQL tab.
- Type your password in the appropriate text boxes.
- Click Enable Mysql. The window refreshes with a message informing you that Mysql is enabled.
NOTE: The Signature Hosting Starter 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. Logging in as the admin user does allow you to create and manage the databases and users you may create.
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:
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:
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:
|
