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. 2024-03-28, 09:21:39

Author Topic: mysql connection  (Read 10166 times)

0 Members and 1 Guest are viewing this topic.

Offline nemo1112

  • Valuable Member
  • *
  • Posts: 56
  • 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: 72
  • 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: 56
  • 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: 420
  • 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: 420
  • 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: 56
  • 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: 56
  • 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: 420
  • 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;

Offline nemo1112

  • Valuable Member
  • *
  • Posts: 56
  • Karma: +0/-0
    • View Profile
Re: mysql connection
« Reply #8 on: 2021-01-26, 14:14:02 »
now i am getting this as error

-bash: syntax error near unexpected token `newline'



Offline azzureal

  • Master
  • **
  • Posts: 420
  • Karma: +1/-0
    • View Profile
Re: mysql connection
« Reply #9 on: 2021-01-28, 11:35:26 »
i think this is php source ussu,

pls check your source

Offline nemo1112

  • Valuable Member
  • *
  • Posts: 56
  • Karma: +0/-0
    • View Profile
Re: mysql connection
« Reply #10 on: 2021-01-28, 12:51:24 »
can you fix the problem to me i am willing to pay for server support

Offline azzureal

  • Master
  • **
  • Posts: 420
  • Karma: +1/-0
    • View Profile
Re: mysql connection
« Reply #11 on: 2021-02-04, 08:52:04 »
service mysqld stop
service mysql stop

mysqld_safe --skip-grant-tables &

mysql

PDATE mysql.user SET Password=PASSWORD('new-password') WHERE User='root';

FLUSH PRIVILEGES;
exit;

service mysqld start

vi /root/.my.cnf

[client]
user="root"
pass="password"

 


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

Page created in 0.038 seconds with 22 queries.

web stats analysis