Post Category → Windows

Control more servers at once – via Putty and PuTTYCS

Have you ever thought about how to control more servers at once? For example, you need to update few or more Linux servers. In Linux, you can use great tool called Cluster SSH, which controls a number of xterm windows via a single graphical console window to allow commands to be interactively run on multiple servers over an ssh connection.

When you’re running Windows, and want to do something like this, you can use great little application PuTTYCS.
Just start your PuTTY sessions, and then start PuTTYCS. Here is how it looks like:

Jovica Ilic Blog

 

Now just type command you need, and click Send. For example, I use it to control my CentOS servers. When I want to update all of them, I just type in here: yum update 

Makes life easier.


If you liked the post, we should get connected - follow me on Twitter

Import Big SQL File Into MySQL with phpMyAdmin

If you have problem to import large SQL files into MySql using phpMyadmin, the official documentation offers a few solutions, but the easiest method to solve this problem is:

  • Find the config.inc.php file located in the phpMyadmin directory. If you have Wamp installed, it is probably located here:
C:\wamp\apps\phpmyadmin3.4.10.1\config.inc.php
  • Find the line with $cfg[‘UploadDir’] on it and update it to:
$cfg['UploadDir'] = 'upload';
  • Create a folder called ‘upload’ in the same folder where config.inc.php file, so now you have:
C:\wamp\apps\phpmyadmin3.4.10.1\upload\

Then copy the big sql file that you are trying to import into the new upload folder.

Now when you go to phpMyAdmin, at the import page you choose a drop down present that wasn’t there before – it contains all of the sql files in the upload directory that you have just created. You can now select your file, and start with the import.

Simple as that.

 

Picture source.


If you liked the post, we should get connected - follow me on Twitter

Reset Forgotten MySql root Password Under Windows

If you forgot root password for your MySQL database server running under Microsoft Windows, there is still a way to access your database and even reset your password using the command prompt.

Follow next steps:

 

1. Stop your MySQL server completely. This can be done from Wamp(if you use it), or start “services.msc” using Run window, and stop the service there.

2. Open your MS-DOS command prompt using “cmd” inside the Run window. Then go to your MySQL bin folder, such as C:\MySQL\bin. Path is different if you use Wamp.

3. Execute the following command in the command prompt:

  mysqld.exe -u root --skip-grant-tables

4. Leave the current MS-DOS command prompt as it is, and open a new MS-DOS command prompt window.

5. Go to your MySQL bin folder again.

6. Enter “mysql” and press enter.

7. You should now have the MySQL command prompt working. Type “use mysql;” so that we switch to the “mysql” database.

8. Execute the following command to update the password:

UPDATE user SET Password = PASSWORD('your_new_passowrd') WHERE User = 'root';

However, you can now run almost any SQL command that you wish.

After you are finished close the first command prompt, and type “exit;” in the second command prompt.

 

You can now start the MySQL service. That’s it.

Check out my book Mastering Vim Quickly: From WTF to OMG in no time

 


If you liked the post, we should get connected - follow me on Twitter