Hello,
I have an MySQL Database on my own Server. I have saved the password of them in FileZilla. But today the "save" was away, and I have forgotten my Password (root).
So i would reset the password and searched in the Internet and than used this commands:
Quote:
/etc/init.d/mysql stop
mysqld_safe --skip-grant-tables
|
but with: mysqld_safe --skip-grant-tables
I got this output:
Quote:
150102 23:11:45 mysqld_safe Logging to syslog.
150102 23:11:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
|
and nothing happens, so I used ctrl+c and then get this Error:
Quote:
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
150102 23:14:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
|
I changed my root Password of MySQL now, with an other method, but when I try to connect with FileZilla on the Server (with root) I get every time this Error:
Quote:
Error: Authentication failed.
Error: Critical error: Failed to connect to server
|
(My Error was in German, this is only translated)
I donīt know, what do to...
I hope some of you can help me, also with not many Informations but i also donīt have more...
DKI