Friday 15 February 2013

MySQL 5.4 installation images and 5.4 server

follow the procedure if u have any doubts see images


1.Click on the downloaded "mysql.msi" 

if you dont have one download from here https://docs.google.com/file/click on download

1(i). after completion of download click on downloaded file😍🍬(i.e., on mysql.msi file)

2.it will open a window like above now click on Next

3.Now Select Custom and click on Next

4.Now if u want to change destination folder click on change and type the address where u want to install and 

proceed with Next

5.Now click on Next to start installation

6.after completion of installation

click on Next(i.e., its an add)
Now click on Next(i.e., its an add)


7. after that u will see a window like
in that Deselect 2nd option
while selecting first option imp:- To configure mysql server


proceed with finish and next


8. now it will open a window showing 2 options to configure mysql  like
Select Detailed Configuration
and Click on Next

9.Now select Developer machine and click on Next like

10.now select multifunctional database and click on next

11.now click on Next as shown

12.Now select Decision support(DSS)/OLAP
13.Now select both options like
and port number=3306 or 3307 or 3308

and click on next

14.now select standard character set 
and click on next

15. now select both the options like
and service name=mysql or select any one from the list

16.Now a window will appear asking u to create a password for mysql(while opening mysql  these password is required)

enter New root password=tiger      (or anyname which u can rememeber easily)
                 confirm           =tiger

and click on next

17.now Click EXECUTE

it starts configuring my sql

18 after completing 

you can create a shortcut to open directly from Desktop for mysql like

=>Start
=>All programs
=>My SQL
=>my sql 5.4
=> Right Click on my sql command line
=>Send to
=>Desktop(create shortcut)

NOTE.1:-

after creating shortcut and opening mysql
you have to 
create a database and use like 


Create DATABASE programs;
Use  programs;



NOTE.2.
if u get any error or stopped showing like these means
do like without closing errored window


Cannot create Windows Service for MySQL.Error:0
It was my first time getting this message as I have been setting up MySQL for lots of Windows server without any issues on the past. Here’s what I did to get it resolve:
1. Start > All Programs >MySQL > MySQL Server 5.x > MySQL Server Instance Config Wizard.
2. Hit the Next and select the options “Remove Instance” and complete the process.
3. GO back in error window and come again next...
(i.e.,Fire up the MySQL Server Instance Config again, this time select the Configure Instance with Standard Configuration and go through the setup again. It should get your MySQL configured again.
The possible cause of the error is due to the MySQL Services has been installed and started on your server’s prior to the configuration by MySQL. Removing the installed instances and reset it up will help to resolve this.)

No comments :

Post a Comment