Skip to main content

Installing MySQL on Windows using a noninstall zip archive

At-least for me, configuring MySQL zip archive on server by reading MySQL team's unfriendly, multi-navigational document has been quite a challenging task.

Here is my simplified version:
  • Download mysql noninstall zip from here: http://dev.mysql.com/downloads/mysql/
  • Extract do C:\mysql folder
  • Under c:\mysql folder you will find my-default.ini file, make a copy of it and rename it to my.ini
  • Open my.ini in notepad, You will find basedir and datadir as commented statements, just uncomment them (by removing # from the starting position of each line) and do the changes shown below
    • basedir = c:\\mysql #installatin directory
    • datadir = c:\\data   #data directory, it can be in some other drive too!
  • Open cmd.exe as administrator and type below commands one after the other
    • Go to bin folder where mysqld.exe file is present
      • cd c:\mysql\bin
    • Below command will initialize the data directory, by reading my.ini file (in our case its in c:\mysql folder)
      • mysqld --initialize-insecure
    • Install mysql as background running service in Windows.
      • mysqld --install 
    • Verify MySQL server service installation
      • in command prompt just type services.msc and hit enter
      • and look for MySQL service in the services list, set it as "Automatic"
  • That's it!
  • MySQL server will be up and running and can be accessed over 3306 port
  • Download and install the MySQL Workbench and connect to server as root with no password.

Uninstalling MySQL

  • open command prompt in administrative mode
  • Stop the mysqld for service activity
    • net stop MySQL
  • Uninstall the serivce
    • sc delete MySQL
  • Delete the c:\mysql folder

One of the best info out there for you to setup MySQL on Ubuntu

Labels:

Comments

App Development Mumbai said…
Hi, Really great effort. Everyone must read this article. Thanks for sharing.
6:07 PM
Buy Contact Lenses Online in India said…
Hey keep posting such good and meaningful articles.
12:12 PM
Post a Comment

Popular posts from this blog

How a university is saving 2.5 tons of paper every year?

Considering the current environmental imbalances, many non-profit organizations (like The Nature Conservity , SayTree …and many others) around the world working desperately to save plant  and trees. It is our responsibility too. We felt starting with universities is the better place to spread the awareness. With this, we also made universities administrative work more manageable and effective. The story I am going to share tells you how a university quietly worked and stands as a role model by saving tons of paper and millions of rupees of its own and its students. In the year 2012, VT University (Visvesvaraya Technological University also popularly known as “ VTU ”) Belgavi (India), has moved its thesis evaluations to online to effectively reduce its use of paper and streamline the process online. University’s this decision made it save several Lakhs of rupees (~ tens of thousands of dollars) every year in paper cost while giving faculty and administrators more direct a...
Post a Comment
Read more

Windows forgets visual effects settings on log-out or reboot for non-administrator account

Steps given here worked for me with Windows 7 SP1. Hope you may find it useful. Start -> Run-> cmd (press enter) -> type SystemPropertiesPerformance.exe This gets you the "System Properties" window, go to   Advanced tab -> Performance Settings -> Visual Effects tab and choose "Adjust for best performance" and click OK. Note: While doing all these UAC doesn't show-up as all changes you are doing will be saved in your logged-in profile account. Reference material used:  http://msdn.microsoft.com/en-us/library/ee330866.aspx Feel free to comment your findings.
Post a Comment
Read more

Why Akbar was Great?

I have fanatical interest to be acquainted with what made Indian emperors take influential decisions during their reign. Few great kings’ valuable decisions created a remarkable history. When Akbar accepts the marriage proposal of Hindu King (Bharmal of Amer), he wishes to make an attempt to set an example for two culture and religions and convey the message of peace. Later, destiny takes him to the critical path of life having most depraved political and family oriented problems. Being a true great emperor, Akbar learns and conclude challenges by demonstrating his exceptional leadership qualities. With his verdicts, Akbar stands as an incomparable king of all time. “Jodha Akbar” – brings 16th-century incidents to life and shows beginning part of Akbar’s married life which was, in fact, a deal for political gain. This decision slowly unleashes Akbar’s loving life, internal dreadful politics, painfully desirous people around him and betraying family members. Jalaluddin Mohamma...
8 comments
Read more