MySQL Root Password on Magento droplet.
How can I get MySQL root password on a magento droplet installation, the MOTD only gives the admin and password for magento admin.
A question can only have one accepted answer. Are you sure you want to replace the current answer with this one?
You previously marked this answer as accepted. Are you sure you want to unaccept it?
I got a notification from DO today saying my server has been causing DDoS attacks (the second time with 2 different servers) Now we are trying to recover our database before we destroy this droplet (which has been locked by DO) We keep getting this on console access through the DO account area Screenshot - http://d.pr/i/1b850
Hi, I am trying to connect to my remote database via SSH using Sequel Pro. This is my setup: * Name: MyWebApp * MySQL-Host: 220.127.116.11 * User: localhost * Password: mySQLpassword * Database: rails * Port: 3306 ------ * SSH host: mywebapp.com * SSH user: root * SSH key: ~/.ssh/id_rsa * SSH port: 22 When trying to connect I get: ``` SSH Port forwarding failed. Lost connection to MySQL server at 'reading initial communication packet', system error: 0 ``` ``` Used command: /usr/bin/ssh -v -N -o ControlMaster=no -o ExitOnForwardFailure=yes -o ConnectTimeout=10 -o NumberOfPasswordPrompts=3 -i /Users/tintin/.ssh/id_rsa -o TCPKeepAlive=no -o ServerAliveInterval=60 -o ServerAliveCountMax=1 -p 22 email@example.com -L 61232/18.104.22.168/3306 OpenSSH_6.2p2, OSSLShim 0.9.8r 8 Dec 2011 debug1: Reading configuration data /etc/ssh_config debug1: /etc/ssh_config line 20: Applying options for * debug1: Connecting to mywebapp.com [22.214.171.124] port 22. debug1: fd 3 clearing O_NONBLOCK debug1: Connection established. debug1: identity file /Users/tintin/.ssh/id_rsa type 1 debug1: identity file /Users/tintin/.ssh/id_rsa-cert type -1 debug1: Enabling compatibility mode for protocol 2.0 debug1: Local version string SSH-2.0-OpenSSH_6.2 debug1: Remote protocol version 2.0, remote software version OpenSSH_6.0p1 Debian-3ubuntu1.2 debug1: match: OpenSSH_6.0p1 Debian-3ubuntu1.2 pat OpenSSH* debug1: SSH2_MSG_KEXINIT sent debug1: SSH2_MSG_KEXINIT received debug1: kex: server->client aes128-ctr hmac-md5 none debug1: kex: client->server aes128-ctr hmac-md5 none debug1: SSH2_MSG_KEX_DH_GEX_REQUEST(1024<1024<8192) sent debug1: expecting SSH2_MSG_KEX_DH_GEX_GROUP debug1: SSH2_MSG_KEX_DH_GEX_INIT sent debug1: expecting SSH2_MSG_KEX_DH_GEX_REPLY debug1: Server host key: RSA 42:f3:30:1b:ff:24:92:17:62:19:13:03:e9:65:0d:42 debug1: Host 'mywebapp.com' is known and matches the RSA host key. debug1: Found key in /Users/tintin/.ssh/known_hosts:4 debug1: ssh_rsa_verify: signature correct debug1: SSH2_MSG_NEWKEYS sent debug1: expecting SSH2_MSG_NEWKEYS debug1: SSH2_MSG_NEWKEYS received debug1: Roaming not allowed by server debug1: SSH2_MSG_SERVICE_REQUEST sent debug1: SSH2_MSG_SERVICE_ACCEPT received debug1: Authentications that can continue: publickey,password debug1: Next authentication method: publickey debug1: Offering RSA public key: /Users/tintin/.ssh/id_rsa debug1: Server accepts key: pkalg ssh-rsa blen 279 debug1: Authentication succeeded (publickey). Authenticated to mywebapp.com ([126.96.36.199]:22). debug1: Local connections to LOCALHOST:61482 forwarded to remote address 188.8.131.52:3306 debug1: Local forwarding listening on ::1 port 61482. debug1: channel 0: new [port listener] debug1: Local forwarding listening on 127.0.0.1 port 61482. debug1: channel 1: new [port listener] debug1: Requesting firstname.lastname@example.org debug1: Entering interactive session. debug1: Connection to port 61482 forwarding to 184.108.40.206 port 3306 requested. debug1: channel 2: new [direct-tcpip] channel 2: open failed: connect failed: Connection refused debug1: channel 2: free: direct-tcpip: listening port 61482 for 220.127.116.11 port 3306, connect from 127.0.0.1 port 61484, nchannels 3 ``` (I replaced my ip address, user name, and app name with fake data wherever I could.) I've logged into my server through SSH multiple times already, so I can't figure why it's not working with Sequel Pro as well. What am I missing here? Thanks for any help.
I've just created a new droplet with digital ocean to run my wordpress site. All has gone well until I try to connect Sequal Pro. I am using the SSH tab in Sequal Pro and have entered the following details... https://www.dropbox.com/s/81wrlkc7cc7sgbc/Screen-Shot-2015-06-19-at-12.52.32.png?dl=0 My Password is the one found in /root/.my.cnf When attempting to connect I keep getting asked to put in my password for root@myipaddress. Can anyone help me please? What am I doing wrong? Thanks
Hello, I forgot my MySQL password, and following these steps to reset it... [How To Import and Export Databases and Reset a Root Password in MySQL](http://https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-and-reset-a-root-password-in-mysql#how-to-reset-a-root-password-) When I type that command.... ``` # mysqld_safe --skip-grant-tables ``` I get that message... How I fix it? ``` 150924 14:01:12 mysqld_safe Can't log to error log and syslog at the same time. Remove all --log-error configuration options for --syslog to take effect. 150924 14:01:12 mysqld_safe Logging to '/var/log/mysql/error.log'. 150924 14:01:12 mysqld_safe A mysqld process already exists ```