mysql

[judhkqkhsd]

hey

so i have a server running and I want to be able to make some mysql databases. It is a fedora core 3 box. I included the mysql package when I installed and all of the mysql directories and executables seem to be on the machine.

Is there something particular I need to do (ie. open ports specific to mysql?). When I ssh into the server and run mysql in the terminal an error comes up saying:

error 2002: cant connect to mysql through socket "/var/lib/mysql/mysql.sock" (2)

Anyone ever have similar problems or know what it is I need to do?

thanks!

[Giro]

Have you started it? try "/etc/init.d/mysqld start"

[judhkqkhsd]

o dear.

i attempted to start the daemon with /etc/init.d/mysqld start but it says the file aint found.

Is it possible it resides somewhere different? Apparently I do not have it setup. blast. I the /usr/bin directory though the mysql mysql_installdb and other programs exist.

where would the mysqld be? It does not appear in the services portion of my server config either.

any suggestions?

[Giro]

Use slocate to find it since it could be somewhere else.

updatedb;
locate mysql

[swemic]

i attempted to start the daemon with /etc/init.d/mysqld start but it says the file aint found.

Did you try to start it as root or su? If not, you'll have to be root to start it.
Another thought, I believe that in Fedora, mysql start script is
/etc/init.d/mysql
and NOT /etc/init.d/mysqld

[judhkqkhsd]

ok.

thanks for the help.

I was logged in as root when I ran /etc/init.d/mysql and mysqld. Neither are there. I did a search for mysqld and it does not appear to be anywhere on my system. its strange because the mysql executable is on the system it just wont connect properly. strange.

i really dont know what is going wrong. ill have to check the mysql help pages. if anyone has any other hints though it would be greatly appreciated.

[Giro]

Have you tried using yum to install it?

yum install mysql

or

yum install mysql-server