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
___________________
Downloadmysql-5.0.37-win32.zip
Install it c:\programfiles
Start configuration wizard
Detailed configuration/standard configuration – I selected detail
Next
Developer /server/dedicated server – I selected developer
Next
Multifunctional/Transactional/Non-transactional database – I selected multifunctional
Next
Decision support/online transaction/manual settings – I selected decision support
Next
Enable TCP/IP and port 3306
Next
Standard character set
Next
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’@’client.domain.com’ IDENTIFIED BY ‘password’;
(Means create a database test and grand permission to user-myuser with password-password from client.domain.com system)

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

Configure:
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

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: