Answered by the Webhosting Experts
Tags +
...

cPanel Servers
at Hivelocity

Introducing: Flat Rate Pricing
The most affordable way to run a cPanel Dedicated Server. Simple, flat rate pricing in 3 tiers.

1-500 Accounts $45/mo.

501-1000 $114/mo.

1001+ Accounts $189/mo.
(*Plus $.175/additional account)

Tags +
...
Tags
...
...

Mysql gives error of access denied for root@localhost ?

Solution

Make sure root pass is in /root/.my.cnf

This is usually the first root pass the box was given once cpanel is installed.

If it still does not work, you will need to reset the mysqld root pass.

First, stop the mysqld, usually /etc/rc.d/init.d/mysql stop

Then stop chkservd to keep it from interfering with mysqld while you work on it
with /etc/rc.d/init.d/chkservd stop

Start up mysqld , but, without the grant tables,

mysqld --skip-grant-tables -u mysql &

Then change the pass..

mysql -u root mysql
UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
FLUSH PRIVILEGES;

Now you just killall -9 mysqld and start it up normally with it’s safe_mysqld
script..

 

Share

Facebook
Twitter
LinkedIn
Email
WhatsApp

Need More Personalized Help?

If you have any further issues, questions, or would like some assistance checking on this or anything else, please reach out to us from your my.hivelocity.net account and provide your server credentials within the encrypted field for the best possible security and support.

If you are unable to reach your my.hivelocity.net account or if you are on the go, please reach out from your valid my.hivelocity.net account email to us here at: support@hivelocity.net. We are also available to you through our phone and live chat system 24/7/365.