Technical FAQ
General | PHP | CGI | E-Mail | MySQL < || > Online Manual
- 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!
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.
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.)
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.]
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.
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'.
A: At this time we do not support ODBC.
A: At this time we do not support JDBC.
- Last modified on