TMDHosting

In order to change the password for certain user associated with some database there are few things that should be done. First of all if you want to change the password for certain user you should log in into your cPanel feature provided with all packages that we are offering. Next an icon called MySQL [...]

There are no passwords for the mysql databases and by that question your probably mean the password for the user associated with certain database. The password for the user can be changed via cPanel -> Mysql databases. At the bottom of the page there is a table which is displaying the usernames associated with certain [...]

The phpMyAdmin feature can be accessed directly via the following URL structure: http://www.domain.com:2082/3rdparty/phpMyAdmin/index.php By simply changing the domain.com with your domain name and entering this URL into your browser you  will be able to login directly to the phpMyAdmin service using your cPanel login credentials.

The path to the mysql binary executable file on all of the servers associated with our company is as it follows: /usr/bin/mysql

There are no settings which allows you to change the timezone of the mysql database. However, you can manipulate the results of some statements in the SQL console. The normal comand which will return the MySQL database current date and time is NOW(). SELECT NOW(); This statement will return the current date and time: 2011-12-29 [...]

The most easiest way to export large databases via PhPmyAdmin is maybe the all known practice of separating the database tables into several separated queries. When the export process is needed you should determinate the size of the database using the cPanel → Mysql databases feature where you will be able to see the size [...]

In order to change a table engine you should be loged into your cpanel. Next the icon for the PhPmyAdmin applciation should be selected. Right after you are redirected to the PhPmyAdmin applciation page you should select the database. When the tables contained into the databse are shown youshould select one of them and after [...]

In order to rapair a broken database you have many option many of which are custom depending on the certain issue that is detecting with the databse. Other option might be the feature provided by the cPanel. The feature is called Repair DB. In order to reach it you should be loged into your cPanel. [...]

Such changes are impossible to be done via phpMyAdmin or any oher feature that we provide for you. In order to change the collation for all of the tables in certain database yoou shoould create a custom script and execute it on the server. The script should have the following code: <?php $database_name=’dbname’; $database_username=’dbusername’; $database_password=’dbpassword’; [...]

In order to optimize a database via PhPmyAdmin can can simply login into your cPanel, click on the PhPmyAdmin icon, then select the database you want to optimize. When you are able to see all of the tables within the selected database, at the bottom of the page there is a dropdown menu located which [...]

The information_shema is a system database for the certain user. This database is located into the PhPmyAdmin application and can be accessed via the application itself. This database holds the information abot every single database created for every account that the you own. In this database can be found also the privileges given to the [...]

When you receive such error is your web-site that massage does not mean literally that the mysql service is down or there is something wrong with it. This massage is received usually due the improper comunication of the application with the server environment. In other words when the application is making a large query to [...]

There is no option provided for this action. In order to change the database name you have only one option. First of all you should be loged into you cpanel provided with all ot the packages we are offering. Next you should search for the PhPmyAdmin icon which will lead you to an interface for [...]

In order to empty a database  you should login into  you cPanel. Right after that you should search for an icon called PhPmyAdmin. By pressing on this icon you will be redirected to interface which are giving the options to edit/drop databases. First of all a database should be selected from the menu in the [...]

There is no way a database to be created by you via the PhPmyAdmin software due the fact that you have no privileges to directly create a database. The only way which is provided to you is via the cPanel feature -> MySQL databases Wizard.

When an aplicaton is installed via the Sotacolous web-installer provided with all of the packages we offer and installation email is sent to the email with which the user  have signed up for our hosting services. This email i set by default in the Softacolous web-installer and can be changed via cPanel -> Softacolous-> Email [...]

The most easiest way to create a database is from the cPanel feature provided by all of the packages we are offering. After you are logged into your cPanel feature there should be an icon called Mysql Database Wizard. This wizard will guide you in the successfull database/user/privileges creation. Other way for simply genearting a [...]

A you may change the collaton of certain mysql database via his/her cPanel -> PhPmyAdmin-> select the database for which you would like to change the collation -> Operations -> Collation interface. When you are logged into your cpanel there is an icon called PhPmyAdmin. By pressing on this icon you will be redirected to [...]

Depending of the application the setting for the database connection are different. But in most casses there is the pattern that is repeating in every single application. The database host is a varriable which is presenting the physical location of the database. In case the database is located on the server on which the application [...]

There are several reasons for this issue. First of all when you receive that massage you should check the settings the are used in the configuration file of the application which is executed. Usually these files are located in the main public_html directory or in subdirectories such as inc/, includes/, settings/ etc. The files usually [...]

The remote connection to the database is made usually by mysql clients or other web-sites from  remote locations different than the server on which the mysql service is located. Basically the method of connecting is as it follows: 1. Theres should be certain settings added to the configuration of the applciation which  should be connected [...]

The reason for that massage is that th user or the password you is using are incorrect. In order to handle with this issue you should simply recheck the credentials he/she is using. Other possible reason for that issue is that you have no privileges for creating the database  database_name. In order to handle the [...]

The reason for this issue lies in the settings of the environment configured by the administrators. In order to import a large database without facing the timing out issue you have many options. Here are some of them. 1. You can use a remote connection using some MySQL managing software which will import the databases [...]

Usually we suport PostgreSQL databases but not on all of our servers. By default this feature is disabled and if you require the PostgreSQL databases you should inform us when you purchase your hosting account