LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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 03-10-2006, 07:43 PM   #1
shanu_technical
LQ Newbie
 
Registered: Mar 2006
Posts: 9

Rep: Reputation: 0
Question mySQL configuration


Hi,

I have installed mySQL on my Red Hat ES-3 by the add/remove programs option.

But I am not able to get it running.

When I type ./mysql it is not able to find the file only.
Also there is no service for the mySQL server in the services.

Any ideas on how to get it running?

~Shanu
 
Old 03-10-2006, 08:08 PM   #2
tuxrules
Senior Member
 
Registered: Jun 2004
Location: Chicago
Distribution: Slackware64 -current
Posts: 1,144

Rep: Reputation: 56
Quote:
Originally Posted by shanu_technical
Hi,

I have installed mySQL on my Red Hat ES-3 by the add/remove programs option.

But I am not able to get it running.

When I type ./mysql it is not able to find the file only.
Also there is no service for the mySQL server in the services.

Any ideas on how to get it running?

~Shanu
Refer the official documentation to learn how to administer the server.

-Tux
 
Old 03-10-2006, 10:18 PM   #3
shanu_technical
LQ Newbie
 
Registered: Mar 2006
Posts: 9

Original Poster
Rep: Reputation: 0
Unhappy

Hi,

I was able to run the command after reading some documents.

But I am getting the following error after typing "mysql".

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

Some docuemtns said that I should try to add the mysql.sock file as an empty file.
So, I went and added the empty file "mysql.sock" under the directory "/var/lib/mysql/".

But still I am getting the same error, i.e.
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


Then I tried searching for "mysqld" thru find command but could not find it anywhere.
I cannot understand what is the issue.

Can you help me?

~shanu
 
Old 03-11-2006, 12:49 PM   #4
tuxrules
Senior Member
 
Registered: Jun 2004
Location: Chicago
Distribution: Slackware64 -current
Posts: 1,144

Rep: Reputation: 56
First you have to change the user to mysql
Code:
su - mysql
then start the mysql server...the preferred way to start is using the mysqld_safe command. Search for this command and its various options to start the command.

Code:
mysqld_safe
see man page for mysqld_safe for various options. After starting mysql server, you can use the mysql comamnd line utility to connect to the server and administer it.

Tux,
 
Old 03-13-2006, 10:26 PM   #5
shanu_technical
LQ Newbie
 
Registered: Mar 2006
Posts: 9

Original Poster
Rep: Reputation: 0
Smile Problem still there in mySql

Hi,

I could not find the file mysqld anywhere on my computer.

[root@TRIO sbin]# find -name "mysqld*" -print
[root@TRIO sbin]# cd /
[root@TRIO /]# find ./ -name "mysqld*" -print
./usr/share/doc/mysql-3.23.58/mysqld_error.txt
./usr/share/man/man1/mysqld_multi.1.gz
./usr/share/man/man1/mysqld.1.gz
./usr/share/man/man1/mysqldump.1.gz

./usr/bin/mysqld_multi

./usr/bin/mysqldumpslow
./usr/bin/mysqldump
./usr/include/mysql/mysqld_error.h
[root@TRIO /]# mysqld_safe
bash: mysqld_safe: command not found

[root@TRIO /]# su mysql

[mysql@TRIO /]$ mysqld_safe
bash: mysqld_safe: command not found
[mysql@TRIO /]$ mysqld safe
bash: mysqld: command not found
[mysql@TRIO /]$ mysqld -safe
bash: mysqld: command not found
[mysql@TRIO /]$ mysqld --safe
bash: mysqld: command not found


But I found mysqld_multi in /usr/bin.
When I tried to run this file it gave the following error...


[mysql@TRIO /]$ mysqld_multi

Couldn't find the mysqld binary! Tried: /usr/libexec/mysqld
Couldn't find the mysqladmin binary! Tried: /usr/bin/mysqladmin
Error with an option, see mysqld_multi --help for more info!

[mysql@TRIO /]$

Can anyone tell me what could be the error..... or am I doing something wrong...
I am new to this so excuse any silly mistakes on my part....


Regards,
Shantnu
 
Old 03-14-2006, 02:58 AM   #6
timmeke
Senior Member
 
Registered: Nov 2005
Location: Belgium
Distribution: Red Hat, Fedora
Posts: 1,515

Rep: Reputation: 61
Judging from the error messages you've provided, I'm thinking that your MySql installation is incomplete.
I recommend that you re-install it.

You'll definitely need the mysqld binary to run the server. And without the server, the client ("mysql") won't
work either.
 
Old 03-14-2006, 03:52 AM   #7
asif2k
Member
 
Registered: Mar 2006
Location: Texas
Distribution: Fedora Project
Posts: 79

Rep: Reputation: 15
Talking mysql installation

remove mysql from server.

re-install mysql
run these commands as root:

#yum install mysql-server mysql

#/etc/init.d/mysqld start

#mysql

If you don't have yum installed then run this command:

#yum install yumex

Last edited by asif2k; 03-14-2006 at 04:00 AM.
 
  


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
Mysql configuration klemen *BSD 3 08-19-2005 01:00 AM
Basic mysql configuration noahzenzen Linux - Newbie 6 07-08-2004 12:05 PM
MySQL 4.0.13-0 Configuration Help Please Nick2k3 Linux - Software 6 07-02-2003 11:00 PM
MySQL configuration... needamiracle Linux - Software 0 07-22-2002 02:07 PM
MySQL configuration oulevon Linux - General 14 06-27-2001 12:55 AM


All times are GMT -5. The time now is 04:59 PM.

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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration