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 |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
 |
07-07-2004, 11:39 AM
|
#1
|
LQ Newbie
Registered: Jul 2004
Posts: 12
Rep:
|
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
|
|
|
07-07-2004, 12:45 PM
|
#2
|
LQ Newbie
Registered: Jun 2004
Location: Minnesota
Distribution: fc2, rh8
Posts: 18
Rep:
|
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.
|
|
|
07-07-2004, 12:49 PM
|
#3
|
LQ Newbie
Registered: Jul 2004
Posts: 6
Rep:
|
try making sure mysql is running ( service mysqld status)  if it's not then use "service mysqld start" to start it up
|
|
|
07-07-2004, 11:09 PM
|
#4
|
LQ Newbie
Registered: Jul 2004
Posts: 12
Original Poster
Rep:
|
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
|
|
|
07-08-2004, 09:15 AM
|
#5
|
LQ Newbie
Registered: Jun 2004
Location: Minnesota
Distribution: fc2, rh8
Posts: 18
Rep:
|
Check out phpMyAdmin at www.phpMyAdmin.net. It is web-based and therefore needs Apache installed and running, but it is an excellent tool.
|
|
|
07-08-2004, 10:37 AM
|
#6
|
LQ Newbie
Registered: Jul 2004
Posts: 6
Rep:
|
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!
|
|
|
07-08-2004, 12:05 PM
|
#7
|
LQ Newbie
Registered: Jul 2004
Posts: 12
Original Poster
Rep:
|
Thank you very much!
|
|
|
All times are GMT -5. The time now is 03:38 AM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|