How do I install MySQL for my website?
MySql is available for install in your account home directory. The central mysql binary area is in /usr/local/mysql. If MySQL is part of your webhosting package, you can install it for your website by running two scripts. The scripts will install the required files from the /usr/local/mysql install area.
- mysql_install_db - This script creates the initial MySQL databases and tables under the mysql subdirectory of your home directory. No arguments are needed.
- mysql.server {start|stop} - This script starts and stops the mysqld daemon associated with your installation of MySQL.
Installing MySQL in this manner gives the website owner full administrative authority (and responsibility) within MySQL.
Note: Access to your mysqld and thus the databases, will be through a unique port and socket, not the MySQL default. This port and socket information is in the file .my.cnf in the user home directory. The port or socket will need to be used in PHP and Perl 'connect' functions as well in 'mysql' and 'mysqladmin' commands.
It should also be noted that the data area of the MySQL databases for each account are within the home directory and count against the overall disk quota.
This information above can also be found within the README.mysql file that is located in your home directory.
Top
Print Page |
Contact Us |
