Important: To create a database, you must login to your Web Control Panel (http://YourDomain.com/cgi-bin/plusmail), click on "Applications", then click on "MySQL Database", and follow the directions provided. Activation takes place within 15 minutes.
- Do you support w3-msql?
- Can I use ODBC with MySQL?
- How do I connect to MySQL using MySQLPerl Module?
- Can I use JDBC with MySQL?
- How many databases can I create?
- What's the telnet (SSH) command to activate msql?
- How do I connect to MySQL through PHP?
- What's the telnet (SSH) commands to access MySQL?
- Can I use phpMyAdmin to administer MySQL?
- How do I activate phpMyAdmin to administer MySQL?
NOTE: More information on MySQL is available in our Online Support Manual: Part 7 - Databases.
Do you support w3-msql?
Yes, we support w3-msql lite. You can request that it be put into your cgi-bin.
top
Can I use ODBC with MySQL?
At this time, our Linux operations do not support ODBC due to security concerns. You may use ODBC on select Windows Web Hosting accounts.
top
How do I connect to MySQL using MySQLPerl Module?
Use the following outline to connect and begin querying the MySQL server from a Perl script. Remember that you can not connect to your databases remotely due to security concerns, you can only connect from localhost.
- Declarations. You must require the MySQL package for your script to function properly. Do this by including the following line in your code:
use Mysql;
- Connect To The Database. Somewhere near the beginning of your script, you need to make your initial connection to the database server. Using the following form - substitute your database, username and password for the examples to connect succesfully.
Mysql->connect('localhost','DATABASENAME','USERNAME','USERPASSWORD');
- Executing A Query. You are now ready to begin querying the database server. Most problems that you may incur will generally occur due to invalid permission settings for the specified user.
Here's an example perl script:
#!/usr/bin/perl
use Mysql;
$database = "YourDatabasename";
$user = "YourUserName";
$password = "YourPassword";
$dbh=Mysql->connect("localhost",$database,$user,$password);
$dbh->selectdb($database);
print "This should say 'mydata': $database\n";
Remember, upload your scripts in ascii format.
top
Can I use JDBC with MySQL?
At this time, our Linux operations do not support JDBC.
top
How many databases can I create?
We allow 4 individual databases to be created using your Web Control Panel on the Linux systems. (The iStarter accounts allow 1 database.) You may purchase additional databases if necessary. Unlimited databases are available with select Windows Web Hosting accounts.
top
What's the telnet (SSH) command to activate msql?
msql dbname
top
How do I connect to MySQL through PHP?
Use the following outline to connect and begin querying the MySQL server from within your PHP scripts. Remember that you can not connect to your databases remotely due to security reasons. You can only connect to them form localhost.
- Connect to the MySQL Server. Use the following statement to connect to the database server. Substitute the username and password for the ones you created in the Web Control Panel.
MYSQL_CONNECT('localhost','USERNAME','PASSWORD');
- Select your Database. Use the following statement to select the database you wish to connect to. Make sure you substitute the example with your database name.
@mysql_select_db("DATABASENAME");
- Executing a Query. You are now ready to execute your queries. Most problems that arise with your scripts will be due to incorrect permission settings.
top
What's the telnet (SSH) commands to access MySQL?
Use the following outline to connect and begin querying the MySQL server from Telnet (SSH). Remember that you can not connect to your databases remotely due to security concerns, you can only connect from localhost.
- Connect to the MySQL Server
servername:> mysql -u USERNAME -p
Enter Password: PASSWORD
- Connect To The Database
mysql> use DATABASENAME;
- Receving Help
mysql> help
top
Can I use phpMyAdmin to administer MySQL?
Yes, phpMyAdmin is available for all accounts. Use your Web Control Panel to activate phpMyAdmin.
top
How do I activate phpMyAdmin to administer MySQL?
You can install phpMyAdmin once your database name is created. Via the Web Control Panel, (http://YourDomain.com/cgi-bin/plusmail), create your database name first. Click on "Applications", then click on "MySQL Database", and then follow the onscreen instructions. Once phpMyAdmin is installed, you can access it from http://www.YourDomainName.com/pma
On the left navigation bar, click on the database you want to work on.
You can customize the configuration of phpMyAdmin by modifying the config.inc.php3 file located in your /pma directory. It's a good idea to make a copy of the original before making any changes. That way, in case of problems, you can always go back to the original quickly.
top
