CGI/ASP/PHP/MySQL/JSP
25 August 2007Q. None of my cgi scripts are working on the server. How do I get them to work?
A. First make sure that they are chmoded to 755 if that dosen’t work trouble shoot it
Q. How do I create databases and manage them?
A. 1) In cPanel select the link “MySQL Databases.
2) In the “Db:” section specify a name for the database that you are creating (ex: store, forum, etc..). After you have specified the name click “Add Db” and the database will be created.
3) In the “Users:” section specify a “Username,” & “Password” for the database that you are creating (Note: you may use the same User/Password for all of your Databases).
4) At the bottom of the “Databases:” section you will now see “User: (username_yourname),” “Db: (username_databasename).” Select the “User” from the left dropdown menu and “Db” from the right dropdown menu that you want to use. “Click Add User to Db.”
After your database is created you can manage it from phpmyadmin. This can be found at the very bottom of the MySQL page.
Q. How to connect to the MySQL server remotely
A. To make a remote connection to the server you must add the IP address of the server you are trying to conenct from to the list of ‘access hosts’ on the ‘MySQL databases’ page of the account cpanel.
Once you have added the IP address you will need to re-add the users to the databases to ensure the correct access permissions are applied.
To connect to the server you would use the account domain name or IP address as the hostname and the database user name and password that you created on the ‘MySQL database’ page of the cpanel.
Sorry, the comment form is closed at this time.
