Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2021-01-21, 03:12:02

Author Topic: mysql connection  (Read 647 times)

0 Members and 1 Guest are viewing this topic.

Offline nemo1112

  • Valuable Member
  • *
  • Posts: 54
  • Karma: +0/-0
    • View Profile
mysql connection
« on: 2020-11-24, 14:38:38 »
i have a problem connecting to mysql
everytime i get this error

Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

this happens alot
right now i can't enter using root

any help ?

Offline atljohnsen

  • Valuable Member
  • *
  • Posts: 70
  • Karma: +3/-0
    • View Profile
Re: mysql connection
« Reply #1 on: 2020-11-28, 14:00:55 »
Have you tried to reset mysql password?

if not, you can try it from SSH with:

sh /script/reset-mysql-root-password <newpassword>

Then

sh /script/restart-mysql


Offline nemo1112

  • Valuable Member
  • *
  • Posts: 54
  • Karma: +0/-0
    • View Profile
Re: mysql connection
« Reply #2 on: 2020-11-29, 14:46:02 »
i have tried this and still nothing

Offline azzureal

  • Master
  • **
  • Posts: 415
  • Karma: +1/-0
    • View Profile
Re: mysql connection
« Reply #3 on: 2020-11-30, 04:24:10 »
pls retry 3 times

Offline azzureal

  • Master
  • **
  • Posts: 415
  • Karma: +1/-0
    • View Profile
Re: mysql connection
« Reply #4 on: 2020-11-30, 04:24:34 »
don't input special charater

Offline nemo1112

  • Valuable Member
  • *
  • Posts: 54
  • Karma: +0/-0
    • View Profile
Re: mysql connection
« Reply #5 on: 2020-12-07, 12:27:54 »
still nothing
i have tried the user of each database and it worked but the root still not working
emails is on root so it's not working

any idea ?

Offline nemo1112

  • Valuable Member
  • *
  • Posts: 54
  • Karma: +0/-0
    • View Profile
Re: mysql connection
« Reply #6 on: 2020-12-27, 23:04:26 »
any help the problem has became urgent ?

Offline azzureal

  • Master
  • **
  • Posts: 415
  • Karma: +1/-0
    • View Profile
Re: mysql connection
« Reply #7 on: 2021-01-04, 04:41:59 »
pls it by manual.

service mysql stop
mysqld_safe --skip-grant-tables &
mysql
UPDATE mysql.user SET Password=PASSWORD('new-password') WHERE User='root';
FLUSH PRIVILEGES;
exit;

 


Top 10 Social Networking:    Facebook    Twitter    LinkedIn    Pinterest    Google Plus    Tumblr    Instagram    VK    Flickr    Vine
Click Here

Page created in 0.072 seconds with 22 queries.

web stats analysis