LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 07-07-2004, 11:39 AM   #1
noahzenzen
LQ Newbie
 
Registered: Jul 2004
Posts: 12

Rep: Reputation: 0
Basic mysql configuration


I am running Red Hat Linux Fedora Core 2. I am trying to get in and work with mysql but am running into difficulty.

I know that it is installed and I know that the default password for root is blank. But I can't seem to get into either the command line mysql configuration or the gui configuration to make any user or database adjustments.

I am a complete newbie to linux and don't know command line but want to learn. All the documentation that I have been reading at mysql.com isn't going over the initial configuration of mysql. I did see some generic commands on connecting to the the host but I am not getting anywhere with that. The error message that I am receiving is "Cannot connect to local mysql server through socket '/var/lib/mysql/mysql.sock' (2)"

I really don't know where to go from there. If anyone has some very basic intro pointers or a good place I could read up I would much appreciate it.

Thanks for all your help!

Noah
 
Old 07-07-2004, 12:45 PM   #2
ID10T_error
LQ Newbie
 
Registered: Jun 2004
Location: Minnesota
Distribution: fc2, rh8
Posts: 18

Rep: Reputation: 0
Here is a decent starter tutorial, http://support.forsite.net/mysql_tutorial.htm, as for the error you are getting, I remember getting the error myself before but I think mine was a shared module problem with php, mysql and apache. The tutorial should be able to get you past that. Also if you are going to configure apache and php to work with it, there are a ton of excellent LAMP (linux, apache, mysql, php) tutuorials. You may want to have a look at phpMyAdmin.net too, they make an excellent web-based mysql administration tool.
 
Old 07-07-2004, 12:49 PM   #3
kevkev
LQ Newbie
 
Registered: Jul 2004
Posts: 6

Rep: Reputation: 0
try making sure mysql is running ( service mysqld status) if it's not then use "service mysqld start" to start it up
 
Old 07-07-2004, 11:09 PM   #4
noahzenzen
LQ Newbie
 
Registered: Jul 2004
Posts: 12

Original Poster
Rep: Reputation: 0
mysql is up

Just wanted to thank you two for responding to my question. It turns out that mysqld was not running, so I started the service. After that I was able to find where it was living and get to the prompt that I was looking for. I will check out those tutorials so I can get an idea of how to add users, groups, permissions etc....

Is there a graphical interface that I can use? The only thing that I have found for Linux fedora core two has been the command line. That is fine, but I like to know all my options. I don't like the feeling that I am missing something.

Thanks again!

Noah
 
Old 07-08-2004, 09:15 AM   #5
ID10T_error
LQ Newbie
 
Registered: Jun 2004
Location: Minnesota
Distribution: fc2, rh8
Posts: 18

Rep: Reputation: 0
Check out phpMyAdmin at www.phpMyAdmin.net. It is web-based and therefore needs Apache installed and running, but it is an excellent tool.
 
Old 07-08-2004, 10:37 AM   #6
kevkev
LQ Newbie
 
Registered: Jul 2004
Posts: 6

Rep: Reputation: 0
Quote:
Originally posted by ID10T_error
Check out phpMyAdmin at www.phpMyAdmin.net. It is web-based and therefore needs Apache installed and running, but it is an excellent tool.
I second this phpMyAdmin is an excelent tool!
 
Old 07-08-2004, 12:05 PM   #7
noahzenzen
LQ Newbie
 
Registered: Jul 2004
Posts: 12

Original Poster
Rep: Reputation: 0
Thank you very much!
 
  


Reply


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
Basic configuration check knoxlinuxuser Linux - Newbie 3 02-25-2005 08:07 AM
Enlightenment basic configuration jdier Linux - Software 0 12-27-2004 12:10 PM
Need help with basic sendmail configuration aznluvsmc Linux - Networking 1 12-03-2004 11:55 AM
Postfix basic configuration Swift&Smart Linux - Software 21 09-05-2004 06:38 PM
proftpd configuration ...not so basic... zavajon Linux - Software 3 09-14-2003 06:48 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 03:38 AM.

Main Menu
Advertisement
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
Open Source Consulting | Domain Registration