cancel
Showing results for 
Search instead for 
Did you mean: 

About MYSQL?

ericfjchen
Regular Advisor

About MYSQL?

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
5 REPLIES
Florian Heigl (new acc)
Honored Contributor

Re: About MYSQL?

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.
yesterday I stood at the edge. Today I'm one step ahead.
Yogeeraj_1
Honored Contributor

Re: About MYSQL?

hi,

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


regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Geoff Wild
Honored Contributor

Re: About MYSQL?

A lot of info on mysql:

http://dev.mysql.com/

Rgds...Geoff
Proverbs 3:5,6 Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make all your paths straight.
Wilfred Chau_1
Respected Contributor

Re: About MYSQL?

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

Re: About MYSQL?

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