Installation of MySQL Server
Unzip the setup file and execute the downloaded MSI file. Follow the instructions below exactly when installing MySQL Server:
Click on the "setup"
Check box to configure MySQL Server
If you checked the Configure the MySQL Server now check box on the final dialog of the MySQL
Server installation, then the MySQL Server Instance Configuration Wizard will automatically start.
Follow the instructions below carefully to configure your MySQL Server to run correctly with
EventSentry.
Select Detailed Configuration
I was installing it on my local machine where other applications & tools are running I decided to opt "developer machine" but it is recommended that you use a Dedicated MySQL Server Machine for your MySQL database, if this is not an option then select "Server Machine".
If you selected Dedicated MySQL Server Machine and your MySQL service does not start after the wizard completes, then try to re-run the wizard (or re-install) MySQL, but this time select the Server Machine option.
I have checked "Multifunctional databases" as I wanted MyISAM as default storage engine but if you want you can select "Transactional Database Only", this will make sure that InnoDB is the main storage engine. If you have checked 3rd option then only myISAM engine would be available
Select the drive where the database files will be stored.
Select the drive on the fastest drive(s) on your server
It is recommended that you leave the default port 3306 in place, however
EventSentry will also work with non-standard ports if necessary.
It is highly recommended that you run the MySQL Server as a Windows
service(you can disable this if you want to start it manually whenever required) and include the binary directory in the search path.
Specify a secure root password, you may want to check the box Enable root access
from remote machines if you plan on administering your MySQL server
from your workstation or other servers.
If you are getting an error message after clicking the Next button, then please enable port 3306
in the Windows XP Firewall Settings
in the Windows XP Firewall Settings
Done!!!
But if you are installing MySQL on a Windows XP workstation, or any other computer that has a firewall enabled, and the wizard fails with an error message similar to the one shown below (Can't connect to MySQL server on 'localhost'), then you will have to exclude the MySQL daemon from your firewall configuration
On Windows XP, you can exclude MySQL from the firewall by following the steps below:
1. Navigate to Start -> Settings -> Control Panel -> Windows Firewall
But if you are installing MySQL on a Windows XP workstation, or any other computer that has a firewall enabled, and the wizard fails with an error message similar to the one shown below (Can't connect to MySQL server on 'localhost'), then you will have to exclude the MySQL daemon from your firewall configuration
On Windows XP, you can exclude MySQL from the firewall by following the steps below:
1. Navigate to Start -> Settings -> Control Panel -> Windows Firewall
91 comments:
I am trying to install MySQL and for some reason it is not completing the task. I get the message start service failed. This is in the last window. It has a red x on start service. Help
I am trying to install MySQL and for some reason it is not completing the task. I get the message start service failed. This is in the last window. It has a red x on start service. Help
Could you check the MySQL error log (file should be in MySQL datadir)and see what it is reporting? also try to install it in C:/mysql or D:/mysql and try to avoid the space between installation path i.e c:/program files
Thanks,
Umesh
In the last step of instalation the " Start service " is crossed in red and not ticked.
The error message is " Cannot create Windows service for MySQL.Error: 0
make sure there isn't any space between your directory name such as "program files" ..instead make sure you install it on c:/mysql or D:/mysql etc
Pls take a look on this post.. it may help you in resolving your installation issue
http://ushastry.blogspot.com/2009/07/cannot-create-windows-service-for.html
Thank you Umesh!!! You saved my day!
-Kim
Hi Umesh,
But we don't have the option to change the installation directory.. (to put the c:\sql directory).
Please advise how to do this ?
Thanks in advance.
--Sridevi (snanubala@gmail.com)
Hi Umesh,
But we don't have the option to change the installation directory.. (to put the c:\sql directory).
Please advise how to do this ?
Thanks in advance.
--Sridevi (snanubala@gmail.com)
Hi Umesh,
But we don't have the option to change the installation directory.. (to put the c:\sql directory).
Please advise how to do this ?
Thanks in advance.
--Sridevi (snanubala@gmail.com)
For that you have to perform a custom installation rather than typical installation(second screen - check custom installation & change the default path to whatever you ant say c:/mysql). Let me know if you need any assistance regarding this.
The tutorial is great!!!
No problem i have installed mysql
Thanks ushastry
Regards,
akiles
hi umesh,
i am trying to install mysql 5.5 & have tried everything mentioned in ur blogs...but i got stuck on the last window, tick mark comes on first 2 points n after that nothing happens...
please suggest something..
Thanks
Arun
Hi Arun, Is it a fresh installation of MySQL5.5 or you are trying to upgrade from existing? if you are upgrading then please remove the MySQL service and then retry the installation.
Please let me know how it goes otherwise would send you the you exact step on Monday/Tuesday once I'm back to work.
http://bugs.mysql.com/bug.php?id=60518
your solution didn't work Umesh.
Adding port manually to firewall, can't start the mysql service from 'services'.
Once installed, mysql is stuck on reinstall, uninstaller doesn't uninstall properly.
Hi Umesh,
I am trying to install MySql for the first time from "mysql.com > downloads > 5.0 > Windows (x86, 32-bit), ZIP Archive". I can't locate the "setup.exe" or ".msi" file to start installation. can you help please?
Thanks
Shakil
Yes, looks like only *.zip available for 5.0.x, suggest you to go for GA of 5.1.x series or 5.5.x instead of 5.0. Latest GA would have all the bug fixed compared to 5.0 series.
http://dev.mysql.com/downloads/mysql/5.1.html
http://dev.mysql.com/downloads/mysql/5.5.html
If you still want to go ahead with 5.0, better check MySQL mirror sites or Google..
Hello Umesh,
Thank you so much for your prompt response. I will go home and try your suggestion.
I will follow up with you tonight.
Thanks a lot again.
Shakil.
THANK YOU VERY MUCH SIR !!! THE TUTORIAL IS BRILLIANT I INSTALLED IT :)
Sir can you please let me know the steps for mysql upgradation on window server in details..
Hello Sarang,
Please follow the steps outlined in the manual for your specific version:
http://dev.mysql.com/doc/refman/5.0/en/windows-upgrading.html
http://dev.mysql.com/doc/refman/5.1/en/windows-upgrading.html
http://dev.mysql.com/doc/refman/5.5/en/windows-upgrading.html
http://dev.mysql.com/doc/refman/5.6/en/windows-upgrading.html
Thankyou Umesh,your steps guidance helped me a lot.........
I installed my sql for windows xp. but i can not connect my sql database via command prompt. After that i use mysql work bench. Do you know how to connect my sql database in to mysql work bench.
--
Tx
very informative.. Thanks.
Have a look at this link http://www.etechpulse.com/2012/10/qick-reference-guide-for-my-sql.html
mysql 5.6.14 win32 good post nice work admin..keep it up:)
Good Work brother thanks a lot for sharing with us...
bdiya
Thank you very much...with this tutorial the installation was very easy.
Thank you very much...with this tutorial the installation was very easy.
I have installed it, and i think it got installed properly. But i am very new to SQL i am not getting GUI, where should i write the queries ????
Download MySQL Workbench from here http://dev.mysql.com/downloads/workbench/
Follow the steps outlined in the MySQL WB manual - http://dev.mysql.com/doc/workbench/en/index.html
or just with MySQL CLI
http://dev.mysql.com/doc/refman/5.5/en/connecting.html
after clicking the execute button..later not responding is shown on top of window..can u plzz suggest me what to do?
Thanks Umesh..its really helpful...
crossmark dsnt come on apply security settings..it is shown..security settings could not be applied
Error number 1045
Access denied for user 'root'@'localhost'(using password:YES)
PLLZ HELP ME
HELP......! there is this Error: 1045 that won't let me proceed and I'm seriously clueless.... I tried reinstalling it but eventually the same thing pops out at the end.
No Setup file in mysql-5.6.20-winx64. What to do now?
Great effort !!! Your information related to software is much helpful. I must say that it's an appreciated effort. Checkout the latest software: Full Version Software | Download Free Software
thank u i followed and installed successfully..........
mantap dah artikelnya kawan
Hi Umesh, i want to install mysql on windows server2012. can u plz tell the steps to download and install.iam very new to mysql and even windows server2012..
thank u umesh sir....u r brilliant....gd blss u
thank you for sharing best information
website designing company in india
this post is valuable..thanks!
cracked software download
Valuable and useful information...Thanks!
Software Crack
Nice post...I look forward to reading more, and getting a more active part in the talks here, whilst picking up some knowledge as well..
very deeply and step by step information.thanks
Magix Photo Premium 2015
Thanku!!
Very informative blog.Thanks for sharing such great valuable blog.Really it will be very useful for those people looking for installing mysql on windows.
Website Development Company
how to connect from mysql to eclipse iam trying a lot but it is showing error unkown database can anyone give step by step procedure for the above
Very Nice and Very informative information for me..am got the exact information in your article thank you for giving the best information...Website Designing Services in Bangalore | Website Development Services in Bangalore
Impressive blog,thanks for the share.Gone through your post,really it's quite amazing and worth to read.
Web Design Company India|SEO Companies India
This is very complete information about windows. Many people are used the linux window which also very friendlily.Linux Dedicated Hosting server India
Sipp ,saya suka info nya bagus
This is really good information thanks for sharing this article,i expect your next article thank you...
Best
web development company in Bangalore |
website
company in Bangalore
Thanks for sharing this great stuff. Keep more updating.
windows migration
Hello
I have installed mysql 5.5.9 on my laptop but when I m trying to create a database it giving me the error like this
Access denied for user ''@'localhost' to database 'databasename'
So what is the problem plz give me a solution
Thanks for sharing the great info with stepwise. It will be very helpful for those looking for installing MySQL on winows.
Web Design Company Bangalore | Web Development Company in Bangalore
Yeah, It was good technical information, thanks for sharing
Web Design Company Bangalore | Website Development Company Bangalore
hi..
i am using windows server 2012 r2 for my project.i installed sql 5.0. but i am unable to dump .sql file by using heidi sql.how to solve this?
Thanks for this kind of article!
Ecommerce Development Bangalore | Magento Development Bangalore
Great Post , Thanks for sharing Great Post microsoft office 365 UK
very awesome error.Since i admired your errors so much Thank you author for the fabulous errors been posted.
http://www.wikitechy.com/fix-error/fix-unable-to-connect-to-local-instance-of-SQL-Server
Both are really good.
Cheers,
Venkat
thank you for tutorial it really helped me
this is simply great information...i have one doubt can i use dedicated machine having mysql server installed as database server and it can be accessible by java client program located at different place??..if you have any other suggestion then tell me...please help me out from this confusion...thank you in advance..
this is great & helpfull information...i have one query that...i want a dedicated database server located at one place and is accessible by one or more java desktop applications placed at different location so should i go as per above tutorial making one machine as server??
advanced windows tips and tricks
Awesome post and thanks for sharing it.
Jewellery chain making machine
Thanks for sharing this useful information. Its really useful for us.
sccm migration
windows migrations
Excellent ! I have enjoyed reading your articles. It is well written. Thanks for your help. I am appreciating your effort. You can visit my site.
Website designers in Bangalore | Website developers in Bangalore
Thank you for sharing such a usefull information
Bitcoin for Web Design | Pay Bitcoin for Web Design | companies that accept bitcoin for web design
Your blog has given me that thing which I never expect to get from all over the websites. Nice post guys!
Thank you for sharing such an informative news with us. Keep on sharing Contents like this. You can also share this content on various sites like the Automation Associates LLC site.
Thank you for clearly explaining how to install mysql on windows. very useful. Excellent article. I have understood much clearer now.
Web Design Company | Web Development Company | Mobile App Development Company
nice write up. Fix path too long error while extracting a ZIP file.
Thanks for sharing this. I am not too good with these things so I have been researching online for a good performance monitoring software to monitor everything for my small business. I have to find what's easiest for me
Than sir
Nice article
Web Development Company Bangalore
Thanks For Your valuable posting, it was very informative
office 2010 kaufen
I found a lot of interesting information here. Really good post
office 2010 professional download
Your website content nice nice and interesting to observe.
jobbörse Neunkirchen
This article is very informative and helpful. Thank you for sharing!
This is an awesome rousing article.I am essentially satisfied with your great work.You put truly extremely accommodating data. Keep it up. Continue blogging. Hoping to perusing your next post.
obat sakit perut bagian atas
Thank you very much...with this tutorial the installation was very easy.
dussehra festival essay
independence day essay
republic day essay
dog essay
peacock essay
Thanks for sharing the great information
Android App Development Company in Saudi Arabia
App Development Company in Riyadh
Mobile App Development Company in Riyadh
Web Development Company in Riyadh
Web Design Company in Riyadh
Thanks for sharing this valuable information with us keep blogging
Spa in Vizag
Best Salon in Vizag
Best Beauty parlours in vizag
Thanks for sharing this valuable information with us keep blogging
Spa in Vizag
Best Salon in Vizag
Best Beauty parlours in vizag
Really nice post. Thanks for sharing valuable information.
Web Design Company in Delhi
Awesome blog. Thanks for sharing.
web design company in bangalore
web development company in bangalore
digital marketing company in bangalore
thanks for sharing the valuable post...keep updating..
Website Designing Company in Delhi
Really nice post. Thanks for sharing valuable information.
Website Designing Company in Delhi
Thank you so much ,great post
amazing post you shared here
bulk sms white label reseller Coimbatore
dnd promotional sms
promotional dnd bulk sms
promotional sms to dnd numbers
Post a Comment