In your code, try enclosing password inside single quote. Alternatively, as per the documentation of mysql, following should work – SET PASSWORD FOR ‘jeffrey’@’localhost’ = PASSWORD(‘cleartext password’); FLUSH PRIVILEGES; The last line is important or else your password change won’t take effect unfortunately. EDIT: I ran a test in my local and it worked – … Read more
It worked using PSCP. Instructions: Download PSCP.EXE from Putty download page Open command prompt and type set PATH=<path to the pscp.exe file> In command prompt point to the location of the pscp.exe using cd command Type pscp use the following command to copy file form remote server to the local system pscp [options] [user@]host:source target … Read more
OK, there was a small typo in my key. Apparently when pasting to file the first letter was cut off and it started with sh-rsa instead of ssh-rsa. nrathathaus – your answer was very helpful, thanks a lot, this answer is credited to you 🙂 I did like you said and set this in sshd_conf: … Read more
For those of you who are setting up MSYS Git on Windows using PuTTY via the standard command prompt, the way to add a host to PuTTY’s cache is to run > plink.exe <host> For example: > plink.exe codebasehq.com The server’s host key is not cached in the registry. You have no guarantee that the … Read more
This is probably not a direct answer to what you’re asking, but when I need to transfer files over a SSH session I use WinSCP, which is an excellent file transfer program over SCP or SFTP. Of course this assumes you’re on Windows.
The answer is in Numpad in PuTTY while using vi [Cialug]: In the configuration, go to Terminal->Features and check “Disable application keypad mode”. Save the settings and enjoy a numeric pad that works!
Use PuTTYGen Creating and Using SSH Keys Overview vCloud Express now has the ability to create SSH Keys for Linux servers. This function will allow the user to create multiple custom keys by selecting the “My Account/Key Management” option. Once the key has been created the user will be required to select the desired SSH … Read more
Terminate the query with \G in place of ;. For example: SELECT * FROM sometable\G This query displays the rows vertically, like this: *************************** 1. row *************************** Host: localhost Db: mydatabase1 User: myuser1 Select_priv: Y Insert_priv: Y Update_priv: Y … *************************** 2. row *************************** Host: localhost Db: mydatabase2 User: myuser2 Select_priv: Y Insert_priv: Y Update_priv: … Read more
puttygen supports exporting your private key to an OpenSSH compatible format. You can then use OpenSSH tools to recreate the public key. Open PuttyGen Click Load Load your private key Go to Conversions->Export OpenSSH and export your private key Copy your private key to ~/.ssh/id_dsa (or id_rsa). Create the RFC 4716 version of the public … Read more
Export cmd.exe, requires elevated prompt due to regedit: Only sessions (produces file putty-sessions.reg on the Desktop): regedit /e “%USERPROFILE%\Desktop\putty-sessions.reg” HKEY_CURRENT_USER\Software\SimonTatham\PuTTY\Sessions All settings except ssh keys (produces file putty.reg on the Desktop): regedit /e “%USERPROFILE%\Desktop\putty.reg” HKEY_CURRENT_USER\Software\SimonTatham Powershell: Only sessions (produces file putty-sessions.reg on the Desktop): reg export HKCU\Software\SimonTatham\PuTTY\Sessions ([Environment]::GetFolderPath(“Desktop”) + “\putty-sessions.reg”) All settings except ssh keys … Read more