How to run MySQL queries from Windows Command Prompt (cmd)

Warning: READ CAREFULLY

I am writing this post because I cannot find something like this over the internet. For some reasons that you do not want to use MySQL GUI and just wanted to run mysql cmd but you cannot seem to run its own command line, your other option is to run it through window's cmd. I just want to point out that there are two command prompts that you can use to manipulate your MySQL database. One is MySQL server's command line and the other is through Window's command prompt. BOTH OF THESE METHODS REQUIRE YOU TO HAVE A MySQL SERVER INSTALLED IN YOUR UNIT.

You can get MySQL Server through (but not limited to) the following:
1. Downloading and installing MySQL Server.
2. Using application server platforms like Wamp, Xampp, lamp or mamp, whichever works for your unit. These application servers installs MySQL Server too.

The point is, you have to have a MySQL Server installed in your unit!

To be able to run MySQL in Windows command line, do the following:

1. Make sure that your MySQL is turned on. 

• In application servers (wamp, xampp, etc.), you may start the service of MySQL.
• To force start of server, locate the MySQL files and run mysqld.exe.  

2. Locate your MySQL server executable file.

• Look for your MySQL server exe file. Usually, it is installed in C:\Program Files\MySQL\MySQL Server x.x\bin. 
• The MySQL Server x.x defines the version of MySQL in your unit. Example: C:\Program Files\MySQL\MySQL Server 5.6\bin
• You may use Window's search to find this.

3. Open windows cmd.

• You can either open this from your Start button or use Windows+r to run cmd to open the command prompt.

4. Go to the root directory in Windows cmd. 

Type cd.. then hit Enter button until you encounter the root directory of your unit (C:\)

5. Type the address of your MySQL Server

• Your address should not contain the C:\ directory instead, replace it with cd. Example: cd Program Files\MySQL\MySQL Server 5.6\bin
• The directory should change based on the address you typed. 

5. Login to MySQL Server

• Type the login statement: mysql -u username -p
• For example, mysql -u root -p
• Enter your password

6. DONE! You've now successfully logged in into MySQL using Windows cmd.

You can now make your database, tables, queries, etc.

Read More

How to change Word 2013 Review pane to No Markup by Default

The case: Whenever you open and type on your document, the changes are being tracked because your review pane is showing Simple Markup or All Markup by default. Annoying Right?

Solution:

Carefully read and follow ALL steps.

Step 1 Open any document you want to edit.

Step 2 Go to the REVIEW pane, select to show No Markup

Step 3 Go to File >> Options >> Trust Center >> Trust Center Settings >> Privacy Options then uncheck Make hidden markup visible when opening or saving. Click OK button then another OK button to click before the window closes.

Step 4 !important! Make changes on the document like typing a space then Save your file.
Note: This step is important. If you miss this, the changes won't apply so you have to do all the steps all over again.

You may refer to the official post by Microsoft here: https://support.microsoft.com/en-us/kb/831771

Read More

How to change WIFI name and password for PLDT HomeBro Ultera or upgraded SmartBro connection

Attention: This is to inform everyone that this post is not an official post from PLDT support nor its technicians. I am just a lowly housewife (that's why the name of the blog is techiehousewife) who've discovered how to do these stuffs. For more technical concerns, please contact pldt. Thanks!

TIP: Before continuing to this article, make sure to check your router, modem and connection if it is PLDT Home Ultera.

Recently, technicians from Smart came to our home to change our antenna and router because, they said, they need to upgrade these things for all consumers for free. Of course I agreed because it's FREE! Now, they changed our Smart Broadband connection to PLDT Home Ultera, which is LTE connection. This is how you change the wifi name and password.

1. GET THE DEFAULT GATEWAY IP ADDRESS
For SmartBro, the default IP address is 192.168.1.1 but PLDT Home Ultera has different IP address depending on the router provided. To check, go to CMD. For windows, you can easily press and hold the Windows button on your keyboard (usually near the space bar) and press letter R. That would be Windows+R, which will open the RUN window. Type cmd on the input box and press Enter which will open the CMD. Type ipconfig in cmd.


2. IN THE BROWSER, GO TO THE IP ADDRESS FROM DEFAULT GATEWAY


3. LOGIN
The default Username is homebro and password is homebro. If this doesn't work, call your local Smart or PLDT customer service to ask what settings did their technician put.


4. CHANGE WIFI NAME
To change the WIFI name, click Wireless from the menu then Basic Settings. Change the value in SSID then click Modify button.


5. CHANGE WIFI PASSWORD
 To change WIFI password, click Wireless from the menu then Security. Change the value in Pre-shared Key then click Modify button.


You're Done! You can change other values in your settings but I advise that if you are not familiar with them, do not attempt to change them.

Read More