topic About MYSQL? in Operating System - HP-UX

About MYSQL?

ericfjchen — Fri, 25 Mar 2005 02:07:47 GMT

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

Re: About MYSQL?

Florian Heigl (new acc) — Fri, 25 Mar 2005 17:43:41 GMT

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.

Re: About MYSQL?

Yogeeraj_1 — Mon, 28 Mar 2005 05:57:24 GMT

hi,

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

regards
yogeeraj

Re: About MYSQL?

Geoff Wild — Mon, 28 Mar 2005 10:31:13 GMT

A lot of info on mysql:

http://dev.mysql.com/

Rgds...Geoff

Re: About MYSQL?

Wilfred Chau_1 — Mon, 28 Mar 2005 12:41:49 GMT

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.

Re: About MYSQL?

Paul Cross_1 — Mon, 28 Mar 2005 15:03:30 GMT

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