Thread: Need basic help

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    4
    Rep Power
    0
    I just had mySQL installed by the webhosting company on my dedicated server.

    I need some basic help.

    First of all, how do I create a new database and how do I set user name and password for it?

    Do I need to telnet as root in order to setup new table or just as any user? I read that it is not a good idea to setup database as root because it will then run with the root ID and root privileges.

    Any help is appreciated.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    73
    Rep Power
    15
    set you password this is done with:
    /usr/bin/mysqladmin -u root password 'new-password'
    See the manual for more instructions.

    Create Database

    CREATE DATABASE fred;

    will create a database named fred

    to use this databas type u fred

    then create tables (CREATE TABLE name etc.. using SQL commands - best to connect to you database using user instead of root.

    you can do all of this without being root
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    73
    Rep Power
    15
    create table name;

Similar Threads

  1. Replies: 3
    Last Post: April 14th, 2004, 11:29 AM
  2. New - basic text question
    By Teenytoona in forum Visual Basic Programming
    Replies: 4
    Last Post: January 5th, 2004, 07:07 PM
  3. basic script trouble
    By jrod in forum HTML Programming
    Replies: 5
    Last Post: January 21st, 2003, 08:32 PM
  4. Split the PHP board?
    By ZeUs in forum PHP Development
    Replies: 26
    Last Post: August 13th, 2002, 11:19 AM

IMN logo majestic logo threadwatch logo seochat tools logo