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
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
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