ERROR 1045 (28000): Access denied for user ‘user’@’localhost’ (using password: YES)

Issue: I got the above error while accessing MySQL as a user

root@afsal []# mysql -u test_tricks -p
Enter password:
ERROR 1045 (28000): Access denied for user  ‘test_tricks’@’localhost’ (using password: YES)
root@afsal []#

Solution:

Give grant all privilege for the user to particular database

grant all privileges on test_wordpress.* to ‘test_tricks@localhost’ identified by ‘password’;

Note:  test_wordpress -> database name

test_tricks           -> mysql user

Password             -> mysql user’s password

 

ERROR 1044 (42000): Access denied for user ‘root’@’localhost’ to database ‘cphulkd’

Issue : I got the above error while accessing any database as root user

Solution :

1. Try after giving grant all privilege to the root user

If it not works please do the following steps.

1. Stop mysqld and restart it with the --skip-grant-tables option.
2. Connect to the mysqld server with just: mysql (i.e. no -p option, and username may not be required).
3. Issue the following commands in the mysql client:

   UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';

   FLUSH PRIVILEGES;

After that, you should be able to run GRANT ALL ON *.* TO 'root'@'localhost';

Now try to access the database. That’s all 🙂

Internal server error 500 : rvsite builder (for a single domain)

I got internal server error while accessing rvsite builder for one domain only in a shared server.

 

Solution:

1.Kill all cpanel process and restart cpanel

2.If it not works update rvsite builder.

You can update it using the following commands.

# rm -f /var/cpanel/rvglobalsoft/rvsitebuilder/var/INSTALL_COMPLETE.php
# rm -f /var/cpanel/rvglobalsoft/rvsitebuilder/rvsitebuilderversion.txt
# perl /usr/local/cpanel/whostmgr/docroot/cgi/rvsitebuilderinstaller/autoinstaller.cgi –force

3.if any issue still persist check the permission of the file /var/cpanel/rvglobalsoft/rvsitebuilder/www/userdata/usrname

It should be like

 

lrwxrwxrwx 1 username username 34 Aug 21 2013 upload -> /home/usrname/.rvsitebuilder/upload/

 

In my case the ownership of the file was wrong and i have changed it using the following command

 

chown -R user. /var/cpanel/rvglobalsoft/rvsitebuilder/www/userdata/username

 

now refresh cpanel and try to load the rvsite builder now

Sorry, the domain is already pointed to an IP address that does not appear to use DNS servers associated with this server.Please transfer the domain to this servers nameservers or have your administrator add one of its nameservers to /etc/ips.remotedns and make the proper A entries on that remote nameserver.

I got the above error while adding an addon domain through cpanel

 

Solution:

 

1.Go to WHM

2. Home »Server Configuration »Tweak Settings

3. Then enable the “Allow remote domain”

Allow Remote Domains >> On