MySQL , is it running? is it there?

Raggit · 09-14-2005, 10:02 AM

Hello everyone,

My question pertains to MySQL database which "I THINK" i have installed.
When i do

Code:

rpm -qa | grep MySQL

i get a reply
MySQL-client-4.0.25-0
MySQL-server-4.0.25-0
So i have to assume that I have the 4.0.25 server on my machine.

I then try to determine if it is running or not with

Code:

ps -aux | grep MySQL

which replies with
grep MySQL
so it doesn't appear as if the server is running.

Bottom line here is I have no clue if the thing is on or off, and don't have any idea how to turn it on and off.

What my attempt here is to setup php & mysql to host my phpnuke site off my box at home.

Any MySQL info much appreciated or some excellent links because so far the ones i've dug through via google haven't help my progress.

bunyan · 09-14-2005, 10:16 AM

Try running

/etc/rc.d/init.d/mysql start

Post back what it says

bunyan

Thats how I start my mysql server

Raggit · 09-14-2005, 10:50 AM

it replied with nothing
does that mean it is runnin?
If so how do i check and see if it is running?

bunyan · 09-14-2005, 10:56 AM

/etc/rc.d/init.d/mysql status give you the status

Did yuo get any errors or Oks when you ran the above command? Also, in your /etc/rc.d/init.d directory do you see a program called mysql or something similar to that?

bunyan

Raggit · 09-14-2005, 11:01 AM

No i didn't get any OK's or anythign when I ran the above command it
simply ran and placed me back at shell prompt.

When i got into my init.d directory i do have mysql in there

Raggit · 09-14-2005, 11:15 AM

well it's running, but it's running under my regular user.
Is it possible to change the user it runs under?

bunyan · 09-14-2005, 11:35 AM

When you say its running under your regular user, what exactly do you mean? Also, did you have to install it via RPM or did your distro come with it? If you installed it yourself, depending on how you installed it it may run as you, nobody, or as a user called mysql. When I went with the mysql that came with the distro, I think it ran as the user mysql. When I installed it from source I think in the README it told me what user it would run as. Then I had to make sure I created that user account manually. When I installed from rpm, I think it ran as mysql.

If you installed it yourself that could be why its running as you. If you want to change that you may have to re install it im not sure yet...

bunyan

Raggit · 09-14-2005, 02:02 PM

I may go through a re-install anyway.
I'm confused to where things are that pertain to mysql.
I can't find the my.cnf to configure it and there are other
things I'm unable to find