MySQL for windows

MySQL also commonly My Sequel is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases.

MySQL is a popular choice of database for use in web applications,widely used LAMP(Linux, Apache, MySQL, PHP) web application software stack.
MySQL is also used in many high-profile, large-scale World Wide Web products, including Wikipedia, Google and Facebook.

Here will shows how to install mysql on a windows based system.

Installations and configurations

This is an old installations file and now the version is updated.

For server install
Install it c:\programfiles
Start configuration wizard
Detailed configuration/standard configuration – I selected detail
Developer /server/dedicated server – I selected developer
Multifunctional/Transactional/Non-transactional database – I selected multifunctional
Decision support/online transaction/manual settings – I selected decision support
Enable TCP/IP and port 3306
Standard character set
Install as windows service and select command line option

ODBC connection setup

Server Side:
Start mysql cli and type
Mysql>GRAND ALL ON test .* to ‘myuser’@’’ IDENTIFIED BY ‘password’;
(Means create a database test and grand permission to user-myuser with password-password from system)

Client Side:
Install myodbc-3.51.11-2-win.msi and
Start >setting>control panel> administrative tools>data source>userdsn

Data source: any name (I used remote-test)
Server: IP or hostname
User: myuser
Password: password
Data source: test and in connect option port: 3306

Accessing and administration from client side
Install mysql-gui-tools-5.0-r-11a-win32.msi to the client system and configure


Posted on April 30, 2011, in General, Uncategorized, Windows. Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: