About MYSQL?

[ericfjchen]

This is HP-UX 11.00. There is a third-party tool running on this box. It is using MYSQL. How can I know which process belongs to MYSQL? How to connect to MYSQL?

Thanks for any advice.

FJ

[Florian Heigl (new acc)]

usually, the binaries should reside in /usr/local/mysql/bin which ought to be a symlink to /usr/local/mysql-platform-version.

to connect You'd type /usr/local/mysql/bin/mysql and the processes might be found using
ps -ef | grep mys

(it should be called mysqld-safe)

I'll to add some examples in a moment.

[Yogeeraj_1]

hi,

have a look at the following URL too:
http://www.cs.nott.ac.uk/TSG/manuals/databases/mysql/standard/


regards
yogeeraj

[Geoff Wild]

A lot of info on mysql:

http://dev.mysql.com/

Rgds...Geoff

[Wilfred Chau_1]

export UNIX95=true
ps -efH

The above will show you a hierarchy of processes running on your system.

Check for mysql. Under which are its child processes.

To connect to mysql,
use mysql or mysqladmin commands.

[Paul Cross_1]

To find the mysql process:
-ps -ef |grep mysql

To connect to mysql:
-find mysql root (this can be ANYWHERE, depending on how it was built). You may be able to discern this from the above ps command.
-under $MYSQLROOT/bin, run mysql -u -p
-it will ask for a passwd.

-Paul