Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 11-02-2007, 03:17 PM   #1
Registered: Sep 2007
Posts: 84

Rep: Reputation: 15
Newbie trying verify his own mySQL config

Hi, all,

I just reinstalled Fedora Core 7 with as many add-ons as I thought I'd need for a Web host. Just as I'd wanted, it looks as though Apache, php, and mySQL are present on the machine.

Here's the problem:

Since I didn't do the install manually, I have not the slightest clue where things are installed or what the default values are. I think I've managed to locate all the pieces of Apache and php that I need (although if somebody can tell me how to verify what version I have of these, I'd appreciate it very much). But I haven't figured out where mySQL lives, what the default database name is, what the administrator name is, what the admin password is, or anything of that nature.

If I simply type "mysql" at the command prompt, I get

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I imagine that tells me mysql isn't running...

Does anybody know how I can find these things? is there something I need to do in order to establish these things? or do I need to uninstall mySQL, then download it and install it manually? Honestly, I wished I'd installed without it, 'cause I would have controlled where things went and I wouldn't be here asking this.


Phil W.
Old 11-02-2007, 05:10 PM   #2
Registered: Oct 2007
Distribution: rhel, fedora, gentoo, ubuntu, freebsd
Posts: 104

Rep: Reputation: 16
apache: httpd -v (may be in /usr/sbin, /usr/libexec, other locations ... you might have to look around for it)
php: php -v (if the cli support is enabled).
mysql: mysql --version

IIRC, fedora and redhat break mysql into mysql-client and mysql-server. mysql-server will pull in mysql-client (and a couple other libs), but the converse is not true. IE: you may have to go and install mysql-server if you just said "yum install mysql".

Assuming you've been using your package manager, that is. yum search mysql, yum search php, yum search apache should all have interesting results.

To check if any given thing is actually running, I recommend the command "ps -ef" or "ps aux".

If you've got an installed, running mysqld, you might just need to change the my.cnf "socket" declarations for the [mysql] and [mysqld] sections to match each other. I'd recommend, in that case, changing just the client one, else you'll have to restart mysqld.
Old 11-02-2007, 11:05 PM   #3
Registered: Sep 2007
Posts: 84

Original Poster
Rep: Reputation: 15
Thanks for the version commands.

You were spot-on with the mysql-server comment; yum install mysql-server got me what I was missing.

I appreciate the help very much.

Phil W.


fedora, install, mysql

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
how to config the mysql my.cnf? treotan Linux - General 1 09-14-2005 12:05 PM
help with apache php mysql config slinky2004 Linux - General 3 03-22-2005 08:36 PM
PHP MYSQL config files dmedici Linux - Software 1 06-09-2004 07:31 PM
another newbie trying to config mysql jholl Slackware 0 03-24-2003 07:59 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:43 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration