LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices

Reply
 
Search this Thread
Old 11-02-2007, 02:17 PM   #1
philwynk
Member
 
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.

Thanks.

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

Rep: Reputation: 15
Versions:
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, 10:05 PM   #3
philwynk
Member
 
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.
 
  


Reply

Tags
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 11:05 AM
help with apache php mysql config slinky2004 Linux - General 3 03-22-2005 07:36 PM
PHP MYSQL config files dmedici Linux - Software 1 06-09-2004 06:31 PM
another newbie trying to config mysql jholl Slackware 0 03-24-2003 06:59 PM


All times are GMT -5. The time now is 01:33 AM.

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