MySQL Help Please!
 

I am running Fedora Core 4 and:

phpinfo(); on my web server says mysql is enabled..
the mysql.sock file doesn't exist... nor does anything in the mysql directory...
when i type in mysql in the command line i get this: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I tried downloading mysql and installing again, but I'm a linux newb and don't know how.. i didn't see anything for fedora, so i tried Linux(x86 or wahtver) Server and RedHat enterpraise RPMs hoping they would work, but I don't know how to do this stuff... usually rpms install themselves... :P i don't know where they go to in the first place, I can never find where they installed or how to run them(i'd be happy if someone could clear that up for me) but anywho, how do I install mysql on fedora core 4? ... and get it working at the same time(wow :D)

Thanks a lot!

-- RedHatCore the linux newbie who doesn't deserve his screen name :P

First off, when you type "mysql" at the prompt that's simply the client you're starting. You need to have the server running as well (when the server starts it creates the sock file). It has been years since I used an rpm based distribution, but I think that the command rpm -qa | grep mysql will list all the mysql-related packages installed. You should probably be looking for "mysql-server-...".

RedHat has its own tools for starting and stopping services and defining what services to launch at boot and so on. If you search the RedHat/Fedora section of this site I am sure you will find hints on starting and stopping it.

Oh, and if you really are running RedHat 8 you should upgrade as soon as possible. Running an old non-supported distribution is a sure way of getting into security related problems quickly. A distribution very popular among Linux newbies and veterans alike is Ubuntu, a Debian derivative, you might want to check that out if you're not comfortable with Fedora Core.


Håkan

I know where that is! But even If I get it started(I'm on windows right now :( ) I still need to know how to change the password for 'root' so I can get phpmyadmin working kuz I duno the password...

If it is on local machine, the use config and user "root" with no password.. Or?

mysqladmin -u root password new-password is the command to set root's password when none is set. Then enter the mysql client (mysql -u root -p) and create a new user for everyday use (root should only do maintenance). Look up the GRANT and REVOKE options in the MySQL manual.


Håkan