do i have mySQL in my linux box? 1

[gchen]

i have a redhat 8.2 box and people told me i should have mySQL in it. is there a way to find out whether my linux has it or not?

thanks!

 

[KarveR]

type in
mysql

if you get a cannot connect to ... error, it ay not have been started, so:

service mysqld status
or
service mysqld status

If you get a nt found error, it probable isnt installed, try
whereis mysql

if nothing, you need t install it.






______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[KarveR]

whoops, this should have been:

service mysqld status
or
service mysql status

the second one doesnt have the D.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[gchen]

thanks for the help....

here is what happen on my server...

mysql -> i got below error message
"ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"

service mysqld status -> i got this...
"mysqld is stopped"

service mysql status -> i got this...
"mysql: unrecognized service"

whereis mysql -> i got...
"mysql: /usr/bin/mysql /usr/lib/mysql /usr/include/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz"

so i believe my linux box came with it but it was not "started". so i did below...

/sbin/service mysqld restart

and it is now up and running.

thanks!

 

[KarveR]

in which case :
man chkconfig

read and digest, this will explain how to have mysql start automatically at run time, or if you have webmin installed, point a web broswer at

http://your_linuxbox:10000

under services (i think - haven't used in in years) and startup or boot - something like that, you should be able to set it to start at boot.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[gchen]

Great! now that i have mySQL up and running. my next question is where can i get/create users for mySQL connection.

thanks!

 

[lgarner]

You grant access to some or all databases and tables. Start here:

http://dev.mysql.com/doc/refman/5.0/en/grant.html