www.PHPBuddy.com
 PHP Function Lookup:
 
Categories
PHP Quick Start
PHP Installation
PHP Articles
PHP Scripts

Top Rated Articles 

Site Related
Submit Articles/Code
Contact Us
Home

   Home                   Article Added on: March 28, 2002
Installing MySQL Database

Overview: Configuring Mysql on your web server and commands to create databases, adding users creating password.

you can find the latest release of MySQL database here.

Download the appropriate version and install MySQL on your computer.

If you are going to install MySQL on windows machine then you will also need to download the MySQL ODBC drivers I downloaded the ODBC 3.51 ver and installed it on my Windows machine and it works great.


If are using Windows N.T / 2000 / XP then you should install MySQL as a service, follow these steps to install MySQL as service.

1) First go to command prompt (Dos Prompt) then Go to c:\mysql\bin

2) Enter this command mysqld-nt --install this will install MySQL as a service and it will load automatically with windows the next time you boot.

* You can also use these commands (First go to c:\mysql\bin)
NET START mysql To start Mysql
NET STOP mysql To Stop Mysql


Creating a New Database in MySQL

1) First go to c:\mysql\bin

2) Enter the command mysql

3) Enter this command create database mybuddy;

4) The above command will create the database mybuddy
The syntax for creating the database is create database database_name;


Creating a New User on (mybuddy) Database in MySQL

1) First go to c:\mysql\bin

2) Enter the command mysql

3) Enter use mybuddy (This will change the current database to mybuddy)

4) Enter the command exactly as show below this will create a use called buddy_user with password mypass on the mybuddy database. GRANT ALL PRIVILEGES ON mybuddy TO [email protected] IDENTIFIED BY 'mypass' with GRANT OPTION;

5) quit;

Editor: You can download phpMyAdmin to maintain MySQL databases, you can create table, manage databases and do a host of other database realated stuff using phpMyAdmin. Download phpMyAdmin
(Windows users need to configure the MySQL ODBC drivers please refer the other related article sections below for more info.)
 
Rate this article:  Current Rating: 3.50
  Poor    Excellent     
          1     2    3    4    5

 

Other Related articles:

Home | Privacy Policy | Contact Us | Terms of Service
(c) 2002 - 2018 www.PHPbuddy.com Unauthorized reproduction/replication of any part of this site is prohibited.