Showing posts with label MySQL. Show all posts
Showing posts with label MySQL. Show all posts

Wednesday 19 February 2014

where does mysql store databases on windows 7


1) Locate the my.ini, which store in the MySQL installation folder.

For Example,

C:\Program Files\MySQL\MySQL Server 5.1\my.ini

2) Open the “my.ini” with our favor text editor.

#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.1/"

#Path to the database root
datadir="C:\ProgramData\MySQL\MySQL Server 5.1\data"

Find the “datadir”, this is the where does MySQL stored the data in Windows

now check
 C:\ProgramData\MySQL\MySQL Server 5.1\data 

This is Hidden file so go to view >> show hidden folder.

Wednesday 12 June 2013

how to install MySQL

This tutorial will show you how to install MySQL on Windows XP. So, go to the MySQL website and download the MySQL Community Server you must register on the site to download the file.
File to download: Windows (x86, 32-bit), MSI Installer Essentials - Recommended if your operating system is a windows XP 64bit version use the Windows (x86, 64-bit), MSI Installer
I will not list all the steps but the most important.
On the downloaded MySQL double click and this will start the installation of MySQL and follow the instructions.
Select "I accept terms in the licence agreement" and click next: -

select the "custom" icon to change the path of the installation.
Now browse or navigate to the folder C:\server\mysql we want to install the files in this folder.
After the change press ok.
Step 5
Press install.
Select a standerd configuration press next.
To install the mysql service, press next.
We need a password for MySQL database please enter a password, please remember the login name in most cases is root and the password your choosing, in my case I choose admin471.
It will execute all the commands we enter so press "execute"
Now MySql database is finally installed.
The final and last step is you need to do is to open php.ini file located in C:\server\php and uncomment the line.
by removing semicolon ; at the beginning. Save the file and close it.
Restart the apache server by clicking on the apache icon in your taskbar.
Useful tool is MySQL administrator and system tray monitor from MySQL GUI and you can download it from there website.
Setup Mysql GUI:-
Go to programs menu (MySQL) click on "MySQL Administrator" Login into your database as localhost - username and password go to "service control" and click on the tab "configure service" and change the path of the my.ini file to the correct location:
C:\server\mysql\my.ini and click apply.
Running MySQL in command prompt:
All commands are run from the command line and directory - "C:\server\mysql\bin\
To stop MySQL Running:
To start MySQL Running:
Uninstall the MySQL Service:
"C:\server\mysql\bin\mysqld" --remove


refer from