Setting or Changing MYSQL Root Password

Setting/changing MYSQL root Password
Setting up mysql database password is one of the important tasks which a webmaster should take care of. If you have never set a root password for MySQL, then server does not require a password at all for connecting as root and if you have already set password for your database and for some reason if you want to change it then you can do so using following commands.
To setup root password for MySQL databases for first time you need to login to your server as root and will have to use mysqladmin command at shell prompt as follows:

$ mysqladmin -u root password “mysql_password“

However, if you want to change/update your root password, then you will have to use following command

$ mysqladmin -u root -p oldpassword newpassword

after you fire above command you will have to provide password for your MySQL database.

Posted under Linux cPanel Hosting, Shared cpanel Hosting, cPanel Hosting, cPanel hosting accounts

This post was written by on November 5, 2008

Tags:

Solving common Fantastico error

ERROR :  “You cannot install more than one script in root directory”

Sometime when you try to install some script in root directory of your domain/addon domain you may get following error message “You cannot install more than one script in the root directory of a domain.

You are getting this error due to 2 reasons :
1) If you have removed previously installed script manually which are installed in the root folder of your main domain or any addon domain.
2) There can be chances that Fantastico haven’t removed the previously installed script properly.
If you are facing this problem you need to edit a file (installed_in_root.php) which is located under .fantasticodata folder.
Solution :

You need to login to your control panel cPanel, need to select Filemanager where you will find a folder named .fantasticodata, you need to access this folder and you will get a file named as “installed_in_root.php “ just open it and remove following code from it.
PHP Code:

After you remove this code just save the file, now you can install required script in the root for required domain/addon domain.

Posted under Uncategorized

This post was written by on November 2, 2008

Tags:

More about SSH access

SSH or Secure shell is a protocol which is intended for exchanging data in most secure format over a network. You can get access to any remote machine and can operate it using this protocol. Most webhosting service provider will offer you root SSH access on higher hosting plans such as VPS or dedicated servers. Few webhost may offer you shell access on their shared hosting plans but its not a pure SSH access rather its Jailed SSH that mean you don’t have full SSH access to your account.
If you have SSH Root access you can easily login to any remote system and can fire any command you want, you have full access to the server you have logged into. Most important feature of SSH access is that its most secure as compare to other methods like rlogin or telnet. While using SSH access your system is connected and will exchange data through a communication of encrypted messages. You have session compression feature as an added advantage. One of the most important benefit of SSH in root access is the prevention of IP spoofing.

If you are login to your server using SSH then password of your system will not be hacked easily by mediator. People who act as mediators try to hack and spoof  your private data thus using SSH such sorts of violations are not possible. SSH works on authentication process before entering into a network for accessing any remote system. SSH uses public/private key cryptographic methods so as to ensure the identity of the requesting user for root getting access thus it ensure that there is no chance that a user can spoof as another user and login to the remote system.
SSH works with the help of many configuration files. It caches all host names with which it had acquaintance , it have its own list of  all host names this helps in authentication process to execute faster.

Posted under Linux cPanel Hosting, Uncategorized, cPanel Hosting, cPanel hosting accounts

This post was written by on November 1, 2008

Tags: