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
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)
Install myodbc-3.51.11-2-win.msi and
Start >setting>control panel> administrative tools>data source>userdsn
Accessing and administration from client side
Install mysql-gui-tools-5.0-r-11a-win32.msi to the client system and configure