SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jun 2004
    Location
    Aiken, SC
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    mysql for dummies poster child...help

    Hi all,

    I'm very glad that I found this forum. I'm an absolute newbie at MySQL...been doing web design for a while now, but want to expand my horizons a bit by learing mysql. I'm using Mac OS X (10.2) and am trying to install MySQL...actually, I've already installed it, but am just trying to figure out how in heck to access it and begin to tinker with it. I'm reading the official MySQL tutorial and am stuck at the installation/setup phase....sad, I know. Anyway, I'm following the procedure to start the MySQL server and here's what I get:

    "Last login: Mon Jun 14 17:59:13 on ttyp1
    Welcome to Darwin!
    [Alan-Joness-Computer:~] alanjones% sudo /Library/StartupItems/MySQL start
    Password:
    sudo: /Library/StartupItems/MySQL: command not found
    [Alan-Joness-Computer:~] alanjones% cd /usr/local/mysql
    [Alan-Joness-Computer:/usr/local/mysql] alanjones% sudo ./bin/mysqld_safe
    chown: mysql: invalid user name
    Starting mysqld daemon with databases from /usr/local/mysql/data
    040614 20:25:31 mysqld ended"

    The password I'm using is the one that I setup for my OSX account, then one used when I need to install software. Is that right. I've researched about every article on the web I can find and still no dice.

    Any idea what's going on...what I'm doing wrong? thanks

    alan

  2. #2
    SitePoint Member
    Join Date
    Jun 2004
    Location
    us of a
    Posts
    10
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Not an answer to your problem but a suggestion: If you are doing this just for learning and stuff then use the newer versions of MySql...either version 4.1 or 5.x as the previous versions are not truely RDBMS and if you work on the previous version you won't learn much.
    Or better go for Firebird (firebird.sourceforge.org)

    I use mysqlFront too and it does the job. Noticed one gotcha long ago that when you copy and paste table using mysqlfront, it fails to copy/add 'autoincrement' in new tables field defination. Hope they fixed it

    - slamdunkinpoolJAMyahooDOTcom ( remove 'JAM' )


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •