LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (http://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   Basic mysql configuration (http://www.linuxquestions.org/questions/linux-newbie-8/basic-mysql-configuration-202186/)

noahzenzen 07-07-2004 10:39 AM

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

ID10T_error 07-07-2004 11:45 AM

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.

kevkev 07-07-2004 11:49 AM

try making sure mysql is running ( service mysqld status) :) if it's not then use "service mysqld start" to start it up

noahzenzen 07-07-2004 10:09 PM

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

ID10T_error 07-08-2004 08:15 AM

Check out phpMyAdmin at www.phpMyAdmin.net. It is web-based and therefore needs Apache installed and running, but it is an excellent tool.

kevkev 07-08-2004 09:37 AM

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!

noahzenzen 07-08-2004 11:05 AM

Thank you very much!


All times are GMT -5. The time now is 07:46 AM.