LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   Debian-MySQL (https://www.linuxquestions.org/questions/linux-newbie-8/debian-mysql-4175529850/)

DKI 01-02-2015 04:17 PM

Debian-MySQL
 
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

Habitual 01-02-2015 04:48 PM

Filezilla passwords are in plain text in ~/.filezilla/sitemanager.xml

DKI 01-02-2015 06:33 PM

Quote:

Originally Posted by Habitual (Post 5294361)
Filezilla passwords are in plain text in ~/.filezilla/sitemanager.xml

And how can i get there? (in Putty)

Habitual 01-03-2015 09:06 AM

Quote:

Originally Posted by DKI (Post 5294418)
And how can i get there? (in Putty)

I'm referring to the GUI Filezilla client installed on your local machine.
Open a terminal and type
Code:

less ~/.filezilla/sitemanager.xml


All times are GMT -5. The time now is 04:06 PM.