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

Top Rated Articles 
  • Simple Ad Rotator
  • PHP and Cookies
  • Getting Screen resolution using JavaScripts & PHP
  • Using Functions in PHP
  • PHP Sessions

  • 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 buddy_user@localhost 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 - 2017 PHPbuddy.com Unauthorized reproduction/replication of any part of this site is prohibited.