Nucleus installation error

ERROR : Cannot connect to mysql !!!!

(nucleus script installation)

This is a common error you get while installing the nucleus script in your cpanel. The reason for this is the permission of the file config.php in the nucleus(version) folder. The mysql settings(username,password,database name etc) are written in to the folder. The file has default permission 644,please change the permission as 666 and run the installation url :

http://yourdomain/nucleus(version)/install.php.

It will resolve the error.

Don't forget to change the permission to 644 again for security reasons….

Error in PhpMyAdmin

Error while connecting to PhpMyAdmin 

 Getting the following error when connecting to PhpMyAdmin :

"#2013 Cannot log in to the MySQL server"

Solution:

# vi /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php // Configuration file of PhpMyAdmin

Add localhost as follows

$cfg['Servers'][$i]['host'] = 'localhost';

save and quit the file.

Password reset in Mysql

How to reset Mysql root password in Centos

#  /etc/init.d/mysqld stop

 Start MYSQL server without password
 #  mysqld_safe --skip-grant-tables &

Connect MYSQL server using the following command
# mysql -u root

Then, you will get MYSQL prompt

mysql>

Then, we have to set up new MYSQL root Password

mysql> use mysql;
mysql> update user set password=PASSWORD(“newrootpassword”) where user=’root’;
mysql> flush privileges;
mysql> quit

# /etc/init.d/mysqld stop
 Then, connect to MYSQL database using new password
# mysql -u root -p

Hello Friends,
  
                  This Blog contains some Linux oriented informations, which I encounter during the server administration process in my life.