[Moderator]

Near the bottom of the installation procedure found hereweb page, there is the following:

---------------------------------------------------------------------------------------
Important: You should at least run this command in order to secure the open master account in the default installation:

mysqladmin -u root password new_password_here

------------------------------------------------------------------------------------------
But when I type that command into the terminal mysql tells me I have a syntax error.

What am I doing wrong? Any ideas?

[philzilla]

say you're going to use "banana" as your password, you'd type:

mysqladmin -u root password banana

[Moderator]

Originally posted by philzilla:
<STRONG>say you're going to use "banana" as your password, you'd type:

mysqladmin -u root password banana</STRONG>

can I use numbers?

[Moderator]

Originally posted by Moderator:
<STRONG>

can I use numbers?</STRONG>

alright...problem solved..much thanks again

[Moderator]

How can I test to make sure its running?
Do you use a graphic front end for it?

[Mr Heliums]

Originally posted by Moderator:
<STRONG>How can I test to make sure its running?
Do you use a graphic front end for it?</STRONG>

You mean check that mySQL is running?
open Terminal,
type:
mysql -u root -p;
(and then enter the password that you just created at the prompt)

Mysql should now load.
There should be a test database, called "test" unsurprisingly, that you can use.

type:
use test

to use it.

HTH

[Michael A. Peters]

For those interested- here is a shell script that will compile MySQL on your system for you-
http://12.233.82.128/seti/build_mysql.sh

If using IE then command click link to save, don't view it first- as IE will give it mac line breaks if you view it in your browser first (sh*tty browser)

You still will need to set the MySQL passwd though

[Raman]

Originally posted by Moderator:
<STRONG>How can I test to make sure its running?
Do you use a graphic front end for it?</STRONG>

i like phpmyAdmin

[Michael A. Peters]

How to tell if mysql is running-

[osx:~] michael% ps -waux |grep mysqld
root 283 0.0 0.2 1732 424 ?? S 0:00.05 sh /usr/local/bin/safe_mysqld
mysql 302 0.0 0.1 11152 332 ?? S 0:00.59 /usr/local/sbin/mysqld
[osx:~] michael%

here's a way to do it remotely-

[root@12-233-82-128 nmap-2.54BETA34]# nmap 192.168.3.72

Starting nmap V. 2.54BETA34 ( www.insecure.org/nmap/ )
WARNING! The following files exist and are readable: /usr/local/share/nmap/nmap-services and ./nmap-services. I am choosing /usr/local/share/nmap/nmap-services for security reasons. set NMAPDIR=. to give priority to files in your local directory
Interesting ports on osx.petershomenetwork.org (192.168.3.72):
(The 1553 ports scanned but not shown below are in state: closed)
Port State Service
22/tcp open ssh
3306/tcp open mysql
8081/tcp open blackice-icecap

Nmap run completed -- 1 IP address (1 host up) scanned in 2 seconds
[root@12-233-82-128 nmap-2.54BETA34]#