CHROMEIS Ltd.

3306 is the default mysql port.

For connecting to a PostgreSQL database from PHP you can use the standard pg_Connect() function.

Log in to your cPanel and open the phpPgAdmin tool. Then click on the PostgreSQL link at the left tree menu and log in to the Postgre server using your cPanel login details. Next, select the database you want to import data into and click on the SQL button. You have two options. You can […]

In order to create a PostgreSQL user you should go to your cPanel -> PostgreSQL Databases interface. In the Add New User form enter the username and password. Note that the username will always include your cPanel username as a prefix. Then you can add the newly-created username to an existing database. For this purpose […]

Creating a PostgreSQL database is a straight-forward process. All you need to do is log in to your cPanel -> PostgreSQL Databases. In the Database Name: field enter the desired database name and click the Create Database button. Note that the database will always include your cPanel username as a prefix for the chosen database […]

It is possible to use a PostgreSQL database for all applications that support this database type. The installation is not in anyway different from installation using a MySQL database. You just need to specify the database type you are using. For example, in Drupal there is a radio button which you can use to specify […]

In order to access phpPgAdmin directly via your domain name without having to access your cPanel first, you need to install phpPgAdmin on your hosting account. The installation is very easy and consists of 3 simple steps: Download the latest version of phpPgAdmin. Upload the package to your public_html folder. Extract the package. By default […]

In order to enable Mod_Rewrite for your site you should create a text file called .htacccess in the directory where you wish the rewrite rules to apply. The first line of this text file should be: RewriteEngine On After that you can place your rewrite rules. Here are some examples for Joomla’s SEF option: RewriteCond […]

In this article we will show you two ways to repair a MySQL database. 1) Through cPanel: Log in to your cPanel and go to MySQL Databases. In the section Modify Databases, select a database from the drop-down box next to Repair DB: and then click the Repair DB button. If the database engine used […]

In this article we will show you how to change the database engine of a MySQL table. Let’s assume that you have a database table called my_table using MyISAM engine and you wish to change the engine from MyISAM to InnoDB. The MySQL query that should be used is: ALTER TABLE my_table ENGINE = InnoDB; […]