LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 01-02-2015, 05:17 PM   #1
DKI
Member
 
Registered: Nov 2014
Posts: 46

Rep: Reputation: Disabled
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
 
Old 01-02-2015, 05:48 PM   #2
Habitual
LQ Addict
 
Registered: Jan 2011
Posts: 7,680
Blog Entries: 10

Rep: Reputation: 2080Reputation: 2080Reputation: 2080Reputation: 2080Reputation: 2080Reputation: 2080Reputation: 2080Reputation: 2080Reputation: 2080Reputation: 2080Reputation: 2080
Filezilla passwords are in plain text in ~/.filezilla/sitemanager.xml
 
Old 01-02-2015, 07:33 PM   #3
DKI
Member
 
Registered: Nov 2014
Posts: 46

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by Habitual View Post
Filezilla passwords are in plain text in ~/.filezilla/sitemanager.xml
And how can i get there? (in Putty)
 
Old 01-03-2015, 10:06 AM   #4
Habitual
LQ Addict
 
Registered: Jan 2011
Posts: 7,680
Blog Entries: 10

Rep: Reputation: 2080Reputation: 2080Reputation: 2080Reputation: 2080Reputation: 2080Reputation: 2080Reputation: 2080Reputation: 2080Reputation: 2080Reputation: 2080Reputation: 2080
Quote:
Originally Posted by DKI View Post
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Debian Etch, Wordpress+mysql: setup-mysql script = permission denied oznola Linux - Server 9 04-07-2010 09:08 PM
LXer: MySQL Backup And Recovery With mysql-zrm On Debian Sarge LXer Syndicated Linux News 0 09-28-2006 09:21 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM


All times are GMT -5. The time now is 06:21 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration