Technical FAQ

General | PHP | CGI | E-Mail | MySQL < || > Online Manual

MySQL

- How many databases can I create?
-
How can I create a MySQL database?
- How do I connect to MySQL through PHP?
- How do I connect to MySQL using MySQLPerl Module?
- How can I administer MySQL over the web?
- How do I use phpMyAdmin?
- Can I use ODBC with MySQL?
-
Can I use JDBC with MySQL?

 


Q: How many databases can I create?

A: We allow 1 individual database with the Economy plan, that you can create using your WebControl System.
Note: It may take several minutes until the database has been created by the system!

Back to top


Q: How can I create a MySQL database?

A: Go to your Control Panel, and under "Databases" click on Manage MySQL.
Add a new database, then create a user.
Then all you need to do is add the user into the database.

Back to top


Q: How do I connect to MySQL through PHP?

A: Use the following outline to connect and begin querying the MySQL server from within your PHP scripts. Remember that you cannot connect to your databases remotely due to security reasons. You can only connect to them from localhost.

1. Connect to the MySQL Server
Use the following statement to connect to the database server. Substitute the username, and password for ones you have created in the WebControl System.

MYSQL_CONNECT('localhost','username','password');

2. 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("database_name");

3. 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.)

Back to top


Q: How do I connect to MySQL using MySQLPerl Module?

A: Use the following outline to connect and begin querying the MySQL server from a Perl script. Remember that you cannot connect to your databases remotely due to security concerns. You can only connect from localhost.

1. 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;

2. 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 successfully.
Mysql->connect('localhost','database_name','username','password');

3. 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.]

Back to top


Q: How can I administer MySQL over the web?

A: We have installed a powerful web interface that makes it very easy to administer your database. This interface, called phpMyAdmin, is based on the PHP scripting language and lets you create, drop, edit, and manage tables and data in your database. You can read more on phpMyAdmin here.

Back to top


Q: How do I use phpMyAdmin?

A: After using your Control Panel --> Databases --> Manage MySQL to add MySQL databases, go back to the main menu in your web control panel and click on "phpMyAdmin" under menu 'Databases'.

Back to top


Q: Can I use ODBC with MySQL?

A: At this time we do not support ODBC.

Back to top


Q: Can I use JDBC with MySQL?

A: At this time we do not support JDBC.

Back to top


- Last modified on 3/16/2003 -


Home / Hosting / Domain Lookup / Support / Email Contact

© 1998-2017 Spunkyworld Internet Services - All rights reserved