alixerie - Aug 17, 2005 - 6:20 am

great brian...just read your last reply....thanks

macbri - Aug 17, 2005 - 4:40 pm

Hi Alix -

Ok here's an annotated walk-through of installing MySQL on Mac OS X. I cut out the extraneous stuff and I hope it's not too lenghty. Admittedly it's still pretty long, and it's pretty dry reading but such is tech documentation In this document all terminal input/output is indented for clarity. Also, my machine is called "powerbook" so you'll have to replace that with your system name (you can get that with the "uname -n" command). Also lines beginning with "[powerbook:/usr/local/mysql] user%" are lines I input, and whatever they come out looking like in this document, there is NO line break, in other words everything should be input on one line even if it looks here like it's on 2 lines. Phew.

If you want to follow this along yourself, I'd recommend removing *all* your previous installations of MySQL. Also make sure it's not running, and finally remove the /tmp/mysql.sock if it still exists, all as I described earlier. With that said, here we go. If you have questions about it just let me know and we can work through it.

Installing MySQL 4.1 on Mac OS X 10.4

This document follows the process for installing MySQL 4.1 (at time of
writing version 4.1.13) on Mac OS X 10.4.2 (Tiger). It uses the tarfile
downloaded from www.mysql.com, although you may prefer to use the pre-packaged installer files (see the note in step 1 below). The reason I used the tarfile is to show where the files are installed, what permissions they get and so on.

(1) The MySQL 4.1.13 tarfile was downloaded to my desktop. It's to be
installed in /usr/local so we'll make sure that directory exists before we continue:

[powerbook:~] user% sudo mkdir /usr/local
mkdir: /usr/local: File exists

In my case the directory already existed, but no harm done. Note that the "[powerbook:/usr/local/mysql] user%" is the shell prompt I have, you don't enter that text. So to enter the above command is simply:

sudo mkdir /usr/local

This convention will be maintained throughout this document.

NOTE: If you use the pre-packaged Mac OS X Installer files from www.mysql.com (see setp 15 for more information), installing it will automatically place all the files in /usr/local for you *and* run the 'mysql_install_db' command. If you go this route, you can run the installer and then skip along to step 8 in this document. If you have problems later on finding the 'mysql' command in your terminal, have a look at
step 5.

(2) Now we can unpack the MySQL tarfile:

[powerbook:~] user% cd /usr/local
[powerbook:/usr/local] user% sudo tar xvf ~/Desktop/mysql-standard-4.1.13-apple-darwin7.9.0-powerpc.tar
mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/
mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/bin/
mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/bin/comp_err
.
.
.
mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/tests/table_types.pl
mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/tests/test_delayed_insert.pl
mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/tests/udf_test.res


(3) It's all unpacked, but the directory name is pretty unwieldy, so we
make a link to it with a nice short name:

[powerbook:/usr/local] user% sudo ln -s mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/ mysql

(4) Let's see what files we have:

[powerbook:/usr/local] user% cd mysql
[powerbook:/usr/local/mysql] user% ls
COPYING configure man support-files
EXCEPTIONS-CLIENT data mysql-test tests
INSTALL-BINARY docs scripts
README include share
bin lib sql-bench

(5) Now we want to add the path to the MySQL commands to our environment so that we can type the commands at any time without having to supply the full path each time. The setup depends on which shell we're using. To determine this all you have to do is:

[powerbook:/usr/local/mysql] user% echo $SHELL
/bin/tcsh

In my case I'm using the C-shell so I do the following:

[powerbook:/usr/local/mysql] user% touch ~/.cshrc
[powerbook:/usr/local/mysql] user% echo 'set path = ($path /usr/local/mysql/bin)' >> ~/.cshrc
[powerbook:/usr/local/mysql] user% source ~/.cshrc
[powerbook:/usr/local/mysql] user% which mysql
/usr/local/mysql/bin/mysql

On the other hand if you're using the Bourne Shell (/bin/bash) you would do:

[powerbook:/usr/local/mysql] user% touch ~/.profile
[powerbook:/usr/local/mysql] user% echo 'export PATH=$PATH:/usr/local/mysql/bin' >> ~/.profile
[powerbook:/usr/local/mysql] user% . ~/.profile
[powerbook:/usr/local/mysql] user% which mysql
/usr/local/mysql/bin/mysql

(6) Post-installation - we need to set up default grant tables, and there's a
script included to do this for us. (Note that I'm including all the output
of the script below for comparison):

[powerbook:/usr/local/mysql] user% sudo scripts/mysql_install_db --user=mysql
Installing all prepared tables
050817 4:30:10 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/data/ is case insensitive
Fill help tables
050817 4:30:12 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/data/ is case insensitive

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h powerbook.local password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com


Note that I *don't* run the sql-bench tests, if you want to you'll need to install some extra Perl packages first, and that's beyond the scope of this document. (I can help you with that later on if you wish though)

(7) Next we need to set up some permissions for the files we've extracted.
Everything in the MySQL directory should be owned by user root, group mysql, and the data subdirectory should be owned by user mysql. Once we've run the commands we do an "ls -l" to make sure everything is set up the way we want:

[powerbook:/usr/local/mysql] user% sudo chown -R root .
[powerbook:/usr/local/mysql] user% sudo chown -R mysql data
[powerbook:/usr/local/mysql] user% sudo chgrp -R mysql .
[powerbook:/usr/local/mysql] user% ls -la
total 96
drwxr-xr-x 19 root mysql 646 Jul 15 14:16 .
drwxr-xr-x 5 root wheel 170 Aug 17 04:27 ..
-rw-r--r-- 1 root mysql 19071 Jul 15 03:39 COPYING
-rw-r--r-- 1 root mysql 5303 Jul 15 13:59 EXCEPTIONS-CLIENT
-rw-r--r-- 1 root mysql 8743 Jul 15 13:59 INSTALL-BINARY
-rw-r--r-- 1 root mysql 1937 Jul 15 03:39 README
drwxr-xr-x 54 root mysql 1836 Jul 15 14:16 bin
-rwxr-xr-x 1 root mysql 801 Jul 15 14:16 configure
drwxr-x--- 4 mysql mysql 136 Aug 17 04:30 data
drwxr-xr-x 4 root mysql 136 Jul 15 14:16 docs
drwxr-xr-x 61 root mysql 2074 Jul 15 14:16 include
drwxr-xr-x 10 root mysql 340 Jul 15 14:16 lib
drwxr-xr-x 3 root mysql 102 Jul 15 14:16 man
drwxr-xr-x 12 root mysql 408 Jul 15 14:16 mysql-test
drwxr-xr-x 3 root mysql 102 Jul 15 14:16 scripts
drwxr-xr-x 5 root mysql 170 Jul 15 14:16 share
drwxr-xr-x 31 root mysql 1054 Jul 15 14:16 sql-bench
drwxr-xr-x 14 root mysql 476 Jul 15 14:16 support-files
drwxr-xr-x 21 root mysql 714 Jul 15 14:16 tests

(8) Now let's start up the MySQL server and see if it's working as we expect.
We can check with the 'mysqladmin version' command:

[powerbook:/usr/local/mysql] user% sudo ./bin/mysqld_safe --user=mysql &
[1] 8186
[powerbook:/usr/local/mysql] user% Starting mysqld daemon with databases from /usr/local/mysql/data

[powerbook:/usr/local/mysql] user% mysqladmin version
mysqladmin Ver 8.41 Distrib 4.1.13, for apple-darwin7.9.0 on powerpc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 4.1.13-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 3 min 14 sec

Threads: 1 Questions: 1 Slow queries: 0 Opens: 11 Flush tables: 1 Open tables: 0 Queries per second avg: 0.005


(9) Great - looks like it's working!. Now let's see if we can shut it down
properly:

[powerbook:/usr/local/mysql] user% mysqladmin -u root shutdown
[powerbook:/usr/local/mysql] user% STOPPING server from pid file /usr/local/mysql/data/powerbook.local.pid
050817 04:35:50 mysqld ended

[1] Done sudo ./bin/mysqld_safe --user=mysql


(10) Everything is working fine so far. Now we'll start it up again and set
up the passwords as we should. There are a few ways to set the password,
we'll try two. First, by connecting directly to the database and using the
"SET PASSWORD" MySQL command, which we'll use for the anonymous accounts, and secondly with the quicker command-line "mysqladmin password" commands for the root accounts (just to show both, it doesn't really matter which you use)

[powerbook:/usr/local/mysql] user% sudo ./bin/mysqld_safe --user=mysql &
[1] 8220
[powerbook:/usr/local/mysql] user% Starting mysqld daemon with databases from /usr/local/mysql/data

[powerbook:/usr/local/mysql] user% mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.1.13-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> set password for ''@'localhost' = password('12345');
Query OK, 0 rows affected (0.01 sec)

mysql> set password for ''@'powerbook.local' = password('12345');
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> quit
Bye
[powerbook:/usr/local/mysql] user% mysqladmin -u root password '12345'


Of course I wouldn't use 12345 as a real password, and also don't use the same password for root as for your anonymous (or indeed any other) accounts.

(11) Now we'll add a new user "alix" to the MySQL database, with full privileges including the GRANT ability, which essentially allows this user to grant rights to other users:

[powerbook:/usr/local/mysql] user% mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.1.13-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all privileges on *.* to 'alix'@'%' identified by '54321' with grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'alix'@'localhost' identified by '54321' with grant option;
Query OK, 0 rows affected (0.00 sec)

(12) Now let's test the account we just set up:

[powerbook:/usr/local/mysql] user% mysql -u alix -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11 to server version: 4.1.13-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit
Bye

(13) Everything's working fine. Now let's connect with user 'alix' again and
create a database and add a table with a couple of rows of data:

[powerbook:/usr/local/mysql] user% mysql -u alix -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11 to server version: 4.1.13-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database AmazingDatabase;
Query OK, 1 row affected (0.00 sec)

mysql> use AmazingDatabase;
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql> create table FirstSet (Id INTEGER, Name VARCHAR(40), Result Integer, Date DATE);
Query OK, 0 rows affected (0.03 sec)

mysql> show tables;
+---------------------------+
| Tables_in_amazingdatabase |
+---------------------------+
| FirstSet |
+---------------------------+
1 row in set (0.00 sec)

mysql> insert into FirstSet values(1, 'Sample1', 12, now());
Query OK, 1 row affected (0.00 sec)

mysql> insert into FirstSet values(1, 'Sample15', 912, now());
Query OK, 1 row affected (0.00 sec)

mysql> select * from FirstSet;
+------+----------+--------+------------+
| Id | Name | Result | Date |
+------+----------+--------+------------+
| 1 | Sample1 | 12 | 2005-08-17 |
| 1 | Sample15 | 912 | 2005-08-17 |
+------+----------+--------+------------+
2 rows in set (0.00 sec)

(oops, we set the Id for both table rows to 1. Nothing wrong with that but maybe we should set it to 2. A quick "UPDATE" command will do that for us):

mysql> update FirstSet set ID = 2 where Result=912;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0


(14) Now while still connected to the database let's do a simple "SELECT" on the table and see what we get:

mysql> select * from FirstSet;
+------+----------+--------+------------+
| Id | Name | Result | Date |
+------+----------+--------+------------+
| 1 | Sample1 | 12 | 2005-08-17 |
| 2 | Sample15 | 912 | 2005-08-17 |
+------+----------+--------+------------+
2 rows in set (0.01 sec)

mysql> quit
Bye


(15) That's it! Except, how do we easily have MySQL run automatically every
time we boot our Mac? Although there's several ways to accomplish this, to
me the easiest is to use the MySQLStartupItem and MySQL.prefpane. When you download the Mac OS X installer from www.mysql.com (the .dmg file) you get a MySQLStartupItem.pkg file, which installs the necessary hooks to have MySQL automatically run at system start up, and a MySQL.prefPane file. All you need to do is install the MySQLStartupItems.pkg installer file (double-click and follow along the installer's prompts), and then drag the MySQL.prefPane file to your ~/Library/PreferencePanes/ Folder (look for
/Library/PreferencePanes/ under your home directory). Then open up your "System Preferences" and there at the bottom under the "Other" category you'll see a MySQL control panel. When you open this you get a simple "Start/Stop" button for MySQL and a checkbox which will set up everything to run MySQL automatically at boot time.

(For the curious, this toggles the MYSQLCOM entry in /etc/hostconfig between -YES- and -NO-. When the system boots and looks for services to automatically start, it finds /Library/StartupItems/MySQLCOM and the MySQLCOM script within this directory will run, *if* MYSQLCOM is set to -YES- in /etc/hostconfig)

--------
Brian S.
MacOSX.com Technical Support
brian@macosx.com

alixerie - Aug 17, 2005 - 11:24 pm

ok brian, i am going to try it out now, but i have one reservation...i am not using Tiger. I am using Panther 10.3.9. so i hopw it works. actually, i guess i will wait until i get home from working to try this, i am now on my lunch break, so if you think it will not work, i am not going to start until about 6 am your time.

macbri - Aug 17, 2005 - 11:34 pm

Hi Alix -

Not to worry, everything I described should work just as well on Panther. Just be sure to download the correct version of MySQL from their website. It's version 4.1.13 for Darwin 7.9 (Mac OS X 10.3). I just checked their website and the link for the tarfile version is:

http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-standard-4.1.13-apple-darwin7.9.0-powerpc.tar.gz/from/pick

and for the installer (dmg) version is:

http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-standard-4.1.13-apple-darwin7.9.0-powerpc.dmg/from/pick

Best of luck and I'll check in tomorrow morning to see how it's going, so let me know if there are any problems.

- Brian

--------
Brian S.
MacOSX.com Technical Support
brian@macosx.com

alixerie - Aug 18, 2005 - 7:11 am

Hello Brian,

I tried it using the tar file...I cut and pasted what you wrote in number two (Alix:/usr/local alix$ sudo tar xvf ~/Desktop/mysql-standard-4.1.13-apple-darwin7.9.0-powerpc.tar ...etc, etc.) and It spit out a long list of files to be unpacked folled by these messages:

mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/tests/udf_test.res
Alix:/usr/local alix$ mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/
bash: mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/: is a directory
Alix:/usr/local alix$ mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/bin/
bash: mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/bin/: is a directory
Alix:/usr/local alix$ mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/bin/comp_err
Usage: mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/bin/comp_err [-?] [-I] [-V] fromfile[s] tofile
Alix:/usr/local alix$ .
bash: .: filename argument required
.: usage: . filename
Alix:/usr/local alix$ .
bash: .: filename argument required
.: usage: . filename
Alix:/usr/local alix$ .
bash: .: filename argument required
.: usage: . filename
Alix:/usr/local alix$ mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/tests/table_types.pl
Can't locate DBI.pm in @INC (@INC contains: /System/Library/Perl/5.8.1/darwin-thread-multi-2level /System/Library/Perl/5.8.1 /Library/Perl/5.8.1/darwin-thread-multi-2level /Library/Perl/5.8.1 /Library/Perl /Network/Library/Perl/5.8.1/darwin-thread-multi-2level /Network/Library/Perl/5.8.1 /Network/Library/Perl .) at mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/tests/table_types.pl line 4.
BEGIN failed--compilation aborted at mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/tests/table_types.pl line 4.
Alix:/usr/local alix$ mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/tests/test_delayed_insert.pl
Can't locate DBI.pm in @INC (@INC contains: /System/Library/Perl/5.8.1/darwin-thread-multi-2level /System/Library/Perl/5.8.1 /Library/Perl/5.8.1/darwin-thread-multi-2level /Library/Perl/5.8.1 /Library/Perl /Network/Library/Perl/5.8.1/darwin-thread-multi-2level /Network/Library/Perl/5.8.1 /Network/Library/Perl .) at mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/tests/test_delayed_insert.pl line 10.
BEGIN failed--compilation aborted at mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/tests/test_delayed_insert.pl line 10.
Alix:/usr/local alix$ mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/tests/test_delayed_insert.pl


i searched to make sure that the files were not unstuffed, which they weren't, so i am now going to attempt the standard installation package....

however, i can remember once before seeing the message that DBI.pm could not be located...

alixerie - Aug 18, 2005 - 8:40 am

ok great, well i have gotten through part 15 and i have gone back to part 8. i have now been able to locate the mysql file witht he long darwin name and i have even gone through the steps to rename it just as you wrote. when i list the files within the directory it shows both the long name and the short name as existing....well here, see for yourself

Alix:/usr/local alix$ ls
mysql
mysql-standard-4.1.13-apple-darwin7.9.0-powerpc
Alix:/usr/local alix$ sudo ln -s mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/ mysql
ln: mysql: File exists
Alix:/usr/local alix$ cd mysql-standard-4.1.13-apple-darwin7.9.0-powerpc
Alix:/usr/local/mysql-standard-4.1.13-apple-darwin7.9.0-powerpc alix$ ls
COPYING data scripts
EXCEPTIONS-CLIENT docs share
INSTALL-BINARY include sql-bench
README lib support-files
bin man tests
configure mysql-test
Alix:/usr/local/mysql-standard-4.1.13-apple-darwin7.9.0-powerpc alix$


so, i guess this is not a big problem, but i just wanted to let you know that it didnt work exactly as expected....also, i am working on an iBook G4

alixerie - Aug 18, 2005 - 8:40 am

ok great, well i have gotten through part 15 and i have gone back to part 8. i have now been able to locate the mysql file witht he long darwin name and i have even gone through the steps to rename it just as you wrote. when i list the files within the directory it shows both the long name and the short name as existing....well here, see for yourself

Alix:/usr/local alix$ ls
mysql
mysql-standard-4.1.13-apple-darwin7.9.0-powerpc
Alix:/usr/local alix$ sudo ln -s mysql-standard-4.1.13-apple-darwin7.9.0-powerpc/ mysql
ln: mysql: File exists
Alix:/usr/local alix$ cd mysql-standard-4.1.13-apple-darwin7.9.0-powerpc
Alix:/usr/local/mysql-standard-4.1.13-apple-darwin7.9.0-powerpc alix$ ls
COPYING data scripts
EXCEPTIONS-CLIENT docs share
INSTALL-BINARY include sql-bench
README lib support-files
bin man tests
configure mysql-test
Alix:/usr/local/mysql-standard-4.1.13-apple-darwin7.9.0-powerpc alix$


so, i guess this is not a big problem, but i just wanted to let you know that it didnt work exactly as expected....also, i am working on an iBook G4

alixerie - Aug 18, 2005 - 9:12 am

ok great disregard the last message...im now on to part 9!!!!

alixerie - Aug 18, 2005 - 9:39 am

i really have to go to bed...anyway there is a problem with my access to the mysqladmin or the bin.....

although the /usr/local/mysql-standard-4.1.13-apple-darwin7.9.0-powerpc shows up in bash, the file is invisible when i try and scope it from outside the terminal. furthermore, i havent been able to renameit a short name...and finally, i guess mysqld_install_db ran but without asking me for the password.

if you actually did explain this in your tech document, i am sorry for overlooking it...i am seriously sleep-deprived..

just wanted to let you know what progress i had made before i went to sleep

macbri - Aug 19, 2005 - 12:56 am

Hi Alix -

Ok sounds like progress! You've gotten most of the way there, I'll answer the issues you've noticed (well as much as I can anyway).

The first set of errors you got after extracting the tarfile is simple - in my instructions I gave you the command to type "tar xvf..." but I also showed the output of that command trimmed down to a few lines. But I never identified them as such, so that's my fault. The first few errors you got therefore were simply the shell telling you were were entering directory names without any commands. So these you can safely ignore. As regards the "DBI" error you've noticed, again that came about because one of the lines I listed (as an output to the tar command) was a Perl test script. This failed because youdon't have the DBI Perl package on your system (this is the "extra Perl packages" note I made at the end of step 6).

You next posting said that you had both a "mysql" and "mysql-standard-4.1.13-blah-blah-blah" directory in /usr/local. I think this is (and I'm making a possibly gross assumption here) that after you tried unpacking the tarfile and got all those errors, you then installed from the installer packages and therefore ended up with two versions of MySQL installed. Or perhaps you had another version from a previous install attempt left over? In any case, removing /usr/local/mysql entirely and then trying the "ln -s" command from step 3 again. Or, remove *ALL* mysql related directories in /usr/local and install from the installer again. On the command line you can do this with:

rm -rf /usr/local/mysql
rm -rf /usr/local/mysql-standard-4.1.13-apple-darwin7.9.0-powerpc

In your final post you talked about how the directories showed up in the terminal but not in the Finder. This is a trick Apple uses to "hide" most of the UNIX underpinnings from the Finder. This includes the /usr directory tree which is why you don't see it. You *can* make everything visible but I usually recommend against this, since if the Finder can't "see" the essential UNIX systems directories, it can't accidentally disturb them (have you ever went to open a folder and instead it disappeared into another folder? - I have!)

Last thing - you said the mysql_install_db had run without asking for a password? That's normal, if you use the installer to install MySQL, that script is run automatically for you.

So it seems as though you're just about there - well done!

- Brian

--------
Brian S.
MacOSX.com Technical Support
brian@macosx.com

alixerie - Aug 28, 2005 - 7:36 pm

Hello again!

I have worked all the way through step 8 and when I run the mysqladmin command it works. But when i go on to step 9 to shut down I get this:

Alix:/usr/local/mysql alix$ mysqladmin -u root shutdown
Alix:/usr/local/mysql alix$ STOPPING server from pid file /usr/local/mysql/data/powerbook.local.pid
bash: STOPPING: command not found
Alix:/usr/local/mysql alix$


I am going to try and figure out what is wrong...but i will wait for your reply.

alixerie - Aug 28, 2005 - 7:40 pm

OK and I guess I could have just messed something up, because I typed in "mysqladmin" again and it carried out a different fuction this time:

Alix:/usr/local/mysql alix$ mysqladmin
mysqladmin Ver 8.41 Distrib 5.0.11-beta, for apple-darwin6.8 on powerpc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Administration program for the mysqld daemon.
Usage: mysqladmin [OPTIONS] command command....
-c, --count=# Number of iterations to make. This works with -i
(--sleep) only.
-#, --debug[=name] Output debug log. Often this is 'd:t,filename'.
-f, --force Don't ask for confirmation on drop database; with
multiple commands, continue even if an error occurs.
-C, --compress Use compression in server/client protocol.
--character-sets-dir=name
Directory where character sets are.
--default-character-set=name
Set the default character set.
-?, --help Display this help and exit.
-h, --host=name Connect to host.
-p, --password[=name]
Password to use when connecting to server. If password is
not given it's asked from the tty.
-P, --port=# Port number to use for connection.
--protocol=name The protocol of connection (tcp,socket,pipe,memory).
-r, --relative Show difference between current and previous values when
used with -i. Currently works only with extended-status.
-O, --set-variable=name
Change the value of a variable. Please note that this
option is deprecated; you can set variables directly with
--variable-name=value.
-s, --silent Silently exit if one can't connect to server.
-S, --socket=name Socket file to use for connection.
-i, --sleep=# Execute commands again and again with a sleep between.
-u, --user=name User for login if not current user.
-v, --verbose Write more information.
-V, --version Output version information and exit.
-E, --vertical Print output vertically. Is similar to --relative, but
prints output vertically.
-w, --wait[=#] Wait and retry if connection is down.
--connect_timeout=#
--shutdown_timeout=#

Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- -----------------------------
count 0
force FALSE
compress FALSE
character-sets-dir (No default value)
default-character-set (No default value)
host (No default value)
port 3306
relative FALSE
socket (No default value)
sleep 0
user (No default value)
verbose FALSE
vertical FALSE
connect_timeout 43200
shutdown_timeout 3600

Default options are read from the following files in the given order:
/etc/my.cnf ~/.my.cnf
The following groups are read: mysqladmin client
The following options may be given as the first argument:
--print-defaults Print the program argument list and exit
--no-defaults Don't read default options from any options file
--defaults-file=# Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read

Where command is a one or more of: (Commands may be shortened)
create databasename Create a new database
debug Instruct server to write debug information to log
drop databasename Delete a database and all its tables
extended-status Gives an extended status message from the server
flush-hosts Flush all cached hosts
flush-logs Flush all logs
flush-status Clear status variables
flush-tables Flush all tables
flush-threads Flush the thread cache
flush-privileges Reload grant tables (same as reload)
kill id,id,... Kill mysql threads
password new-password Change old password to new-password, MySQL 4.1 hashing.
old-password new-password Change old password to new-password in old format.

ping Check if mysqld is alive
processlist Show list of active threads in server
reload Reload grant tables
refresh Flush all tables and close and open logfiles
shutdown Take server down
status Gives a short status message from the server
start-slave Start slave
stop-slave Stop slave
variables Prints variables available
version Get version info from server
Alix:/usr/local/mysql alix$

macbri - Aug 29, 2005 - 1:55 am

Hi Alix -

If you run 'mysqladmin' without additional arguments you do normally see what you report in your last message. So that's no problem. As for the "command not found" in the message before that, this looks like an environment issue still. Have you made sure you followed step 5? If you open a new shell in the terminal app and type the following commands:

echo $SHELL
echo $PATH
which mysqladmin
which mysql

What do you get? Also do you have one pieces of one or more old installations of MySQL hanging around?

- Brian


--------
Brian S.
MacOSX.com Technical Support
brian@macosx.com

alixerie - Oct 3, 2005 - 2:51 am

hi!

i finally have the time to work with this again. i am trying to start mysql using the command:

sudo ./bin/mysqld_safe --user=mysql &
[1] 540


but all i am getting is that a mysqld process already exists. so, i checked my /usr/local folder and i find that actually there are 4 existing files of mysql:

Alix:/usr/local alix$ ls
mysql
mysql-standard-4.1.13-apple-darwin7.9.0-powerpc
mysql-standard-4.1.14-apple-darwin7.9.0-powerpc
mysql-standard-5.0.11-beta-osx10.2-powerpc
Alix:/usr/local alix$ rm mysql-standard-5.0.11-beta-osx10.2-powerpc
rm: mysql-standard-5.0.11-beta-osx10.2-powerpc: is a directory

________________


so i tried many different ways to remove the directories but i can seem to get the command right.

furthermore, when i installed mysql this time i did remember to remove the socket, so i am guessinbg that the reason that i cant start the server is

alixerie - Oct 3, 2005 - 2:51 am

hi!

i finally have the time to work with this again. i am trying to start mysql using the command:

sudo ./bin/mysqld_safe --user=mysql &
[1] 540


but all i am getting is that a mysqld process already exists. so, i checked my /usr/local folder and i find that actually there are 4 existing files of mysql:

Alix:/usr/local alix$ ls
mysql
mysql-standard-4.1.13-apple-darwin7.9.0-powerpc
mysql-standard-4.1.14-apple-darwin7.9.0-powerpc
mysql-standard-5.0.11-beta-osx10.2-powerpc
Alix:/usr/local alix$ rm mysql-standard-5.0.11-beta-osx10.2-powerpc
rm: mysql-standard-5.0.11-beta-osx10.2-powerpc: is a directory

________________


so i tried many different ways to remove the directories but i can seem to get the command right.

furthermore, when i installed mysql this time i did remember to remove the socket, so i am guessinbg that the reason that i cant start the server is

macbri - Oct 3, 2005 - 4:27 am

Hi Alix -

Welcome back!

Anyway, as mentioned before I think your safest course of action is to remove ALL versions of MySQL on your system. The way to do this is:

cd /usr/local
sudo rm -rf ./mysql*

Be careful to not make any mistakes in the above command, especially NO SPACES in the last argument: ./mysql*

This is because "rm -rf" will remove *anything* you tell it to when combined with "sudo", and thus could trash a lot more than the intended target!

Now, again check that the socket files are removed. Finally, reboot your machine to make sure there's no vestiges of MySQL left.

At this stage if you open a terminal and type "mysqladmin" you should get a "command not found" error or similar, and of course /usr/local should not contain anything related to MySQL.

Now, quickly run through the install again, using the standalone installer if you want to skip a few steps, and then pick it up at step 8 and see how you go....

- Brian

--------
Brian S.
MacOSX.com Technical Support
brian@macosx.com

alixerie - Oct 3, 2005 - 6:13 am

okie dokie, so at step 8 this is what happens:

Alix:/usr/local/mysql alix$ sudo ./bin/mysqld_safe --user=mysql &
[1] 396
Alix:/usr/local/mysql alix$ [1] 8186Password:
bash: [1]: command not found
Alix:/usr/local/mysql alix$

______

for the password, i just used my main password that i use with my computer (which is just set to be the key)

i also tried :

Alix:/usr/local/mysql alix$ mysqladmin version
bash: mysqladmin: command not found

______

and this is what i have inside:

Alix:~ alix$ cd /usr/local/mysql
Alix:/usr/local/mysql alix$ ls
COPYING data scripts
EXCEPTIONS-CLIENT docs share
INSTALL-BINARY include sql-bench
README lib support-files
bin man tests
configure mysql-test

macbri - Oct 4, 2005 - 3:14 am

Hi Alix -

Ok, so have you made sure your path is set up correctly? You're using /bin/bash as I recall, so you should edit ~/.profile and add:

export PATH=$PATH:/usr/local/mysql/bin

Then open a new terminal window and go back to step 8 again. let me know what happens from there!

Incidentally, if you're tired of doing this over again, there is a new feature of macosx.com called "Help!" which is a program you can download and then allow me (or another tech) to remotely "drive" your computer. If you are interested in this (of course we both need to be sitting down at our macs at the same time) then check out http://www.macosx.com/apps/help.htm

--------
Brian S.
MacOSX.com Technical Support
brian@macosx.com

alixerie - Oct 4, 2005 - 11:27 am

I followed directions from number five...here goes.


alix:~ alix$ cd /usr/local/mysql
alix:/usr/local/mysql alix$ echo $shell
/bin/bash
alix:/usr/local/mysql alix$ touch ~/.profile
alix:/usr/local/mysql alix$ echo 'export path=$path:/usr/local/mysql/bin' >> ~/.profile
alix:/usr/local/mysql alix$ . ~/.profile
declare -x home="/users/alix"
declare -x oldpwd="/users/alix"
declare -x path="/usr/bin:/bin:/usr/sbin:/sbin:/users/alix:/usr/local/mysql/bin"
declare -x pwd="/usr/local/mysql"
declare -x securitysessionid="212eb0"
declare -x shell="/bin/bash"
declare -x shlvl="1"
declare -x term="xterm-color"
declare -x term_program="apple_terminal"
declare -x term_program_version="100.1.8"
declare -x user="alix"
declare -x __cf_user_text_encoding="0x1f5:0:0"
declare -x home="/users/alix"
declare -x oldpwd="/users/alix"
declare -x path="/usr/bin:/bin:/usr/sbin:/sbin:/users/alix:/usr/local/mysql/bin:/usr/local/mysql/bin"
declare -x pwd="/usr/local/mysql"
declare -x securitysessionid="212eb0"
declare -x shell="/bin/bash"
declare -x shlvl="1"
declare -x term="xterm-color"
declare -x term_program="apple_terminal"
declare -x term_program_version="100.1.8"
declare -x user="alix"
declare -x __cf_user_text_encoding="0x1f5:0:0"
declare -x home="/users/alix"
declare -x oldpwd="/users/alix"
declare -x path="/usr/bin:/bin:/usr/sbin:/sbin:/users/alix:/usr/local/mysql/bin:/usr/local/mysql/bin:/usr/local/mysql/bin"
declare -x pwd="/usr/local/mysql"
declare -x securitysessionid="212eb0"
declare -x shell="/bin/bash"
declare -x shlvl="1"
declare -x term="xterm-color"
declare -x term_program="apple_terminal"
declare -x term_program_version="100.1.8"
declare -x user="alix"
declare -x __cf_user_text_encoding="0x1f5:0:0"
declare -x home="/users/alix"
declare -x oldpwd="/users/alix"
declare -x path="/usr/bin:/bin:/usr/sbin:/sbin:/users/alix:/usr/local/mysql/bin:/usr/local/mysql/bin:/usr/local/mysql/bin:/usr/local/mysql/bin:/usr/local/mysql/bin"
declare -x pwd="/usr/local/mysql"
declare -x securitysessionid="212eb0"
declare -x shell="/bin/bash"
declare -x shlvl="1"
declare -x term="xterm-color"
declare -x term_program="apple_terminal"
declare -x term_program_version="100.1.8"
declare -x user="alix"
declare -x __cf_user_text_encoding="0x1f5:0:0"
alix:/usr/local/mysql alix$

alixerie - Oct 4, 2005 - 11:39 am

Well everything in step five worked, but I have realized where my problem is (I think). When I get to step 8 I am prompted for a password:

Alix:~ alix$ cd /usr/local/mysql
Alix:/usr/local/mysql alix$ sudo ./bin/mysqld_safe --user=mysql &
[1] 569
Alix:/usr/local/mysql alix$ [1] 8186Password:
bash: [1]: command not found
Alix:/usr/local/mysql alix$

________

I have tried my computer password (which is just ) and I have also tried entering the folder path (as that is how it appears with the feedback from step 5: declare -x pwd="/usr/local/mysql").

I never set a password.

macbri - Oct 5, 2005 - 5:16 am

Hi Alix -

Ok, there's 2 things going on there which I didn't spot yesterday. First, in step 8 I wrote the following:

[powerbook:/usr/local/mysql] user% sudo ./bin/mysqld_safe --user=mysql &
[1] 8186

I probably didn't make this clear enough, but the first line (minus the prompt) is the only bit you should type in. The "[1] 8186" is the output I got (it means job number 1 running in the background, with a process ID of 8186). In your last entry you got a similar result: with a diff. number: [1] 569.

Second, it's a bit confusing but the password you're being prompted for is your own password, and mysql isn't asking for a password at all. This is because "sudo" wants your password so that it can run mysql with elevated priviliges. After you enter your password you're getting the "[1] 8186 command not found" probably because of the extra stuff you entered on the comand line (the [1] 8186). So, bascially, just do:

cd /usr/local/mysql
sudo ./bin/mysqld_safe --user=mysql &

I hope that clears things up a little!
- Brian

--------
Brian S.
MacOSX.com Technical Support
brian@macosx.com

alixerie - Oct 12, 2005 - 2:23 am

brian i have now downloaded the Help! application. so now we should be online at the same time.

i will have open my AIM (screenname: acetgsw), MSN (a_erie), and Yahoo (a_erie1). i dont know if you need this but i will also check back to see if you have replied.

macbri - Oct 12, 2005 - 3:25 am

Hi Alix -

Ok great. I've added you to my Yahoo! list and when we're both online we'll see what we can do. Meantime, I'll also check into the "Chat" here on macosx.com to see if you're on there.

- Brian

--------
Brian S.
MacOSX.com Technical Support
brian@macosx.com

alixerie - Oct 16, 2005 - 12:39 pm

ok brian...now that i have up my mysql...i am having trouble with my apache server. when i enter localhost i get a page that says that i have apache installed but that i need to add content to my directory. if i type in localhost/path i can see a directroy, but then if i want to test a default page i can only view source code. these pages work when uploaded to the internet, but not on my localhost. from some research that i did, i found that if i am seeing this "Apache Installation Worked" then it means that it did not work and that it is from a server on the net that i have visited before and has Apache installed.

I hope you can believe me when i say that i dont want you to build my page for me!!!! HAHAHA! I guess i just need to work out the kinks.

TTFN!

alixerie - Oct 16, 2005 - 1:22 pm

ok so i downloaded the apache tar file and tried to unpack it:

Alix:~ alix$ cd /usr/local
Alix:/usr/local alix$ sudo tar xvf ~/Desktop/httpd-2.0.55.tar
Password:
tar: This does not look like a tar archive
tar: Skipping to next header
tar: Archive contains obsolescent base-64 headers
tar: Error exit delayed from previous errors
Alix:/usr/local alix$


also...i have not yet deleted all other instances of apache...although there are not any installed into /usr/local

macbri - Oct 16, 2005 - 4:34 pm

Hi Alix -

The fact that you're seeing the page that says you have apache installed is good - in fact you wouldn't see that if it wasn't running. By default web pages go in /Library/WebServer/Documents/. however, For testing etc. I usually put files in ~/Sites (remember, ~ is your home directory) and then you can access them from Safari as http://localhost/~yourusername. For example my username is 'brian' so my stuff is at http://localhost/~brian

Tell you what. Since the original MySQL issue is resolved, can we close out this ticket and have you start a new one for "Apache not working on Mac OS X". I'll pick it up as soon as I see it, and I'll be happy to continue helping you.

- Brian

--------
Brian S.
MacOSX.com Technical Support
brian@macosx.com

alixerie - Oct 17, 2005 - 2:09 am

I want to ask you one more time, since I forgot to save the terminal window

How do I do the grep command to see in MySQL is running? I did:

Alix:~ alix$ sudo ./bin/mysqld_safe --user=mysql &
[1] 464
Alix:~ alix$ Password:
Alix:~ alix$ mysqladmin version

and I got the long output. But it just gave me the same prompt instead of "mysql>"

I did:

Alix:~ alix$ echo $PATH
/usr/bin:/bin:/usr/sbin:/sbin:/Users/alix:/usr/local/mysql/bin


So that is good.

alixerie - Oct 17, 2005 - 2:30 am

nevermind! I was able to do it all by myself!!! Yippeeee!