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 08-04-2009, 08:09 AM   #16
linuxlover.chaitanya
Senior Member
 
Registered: Apr 2008
Location: Nagpur, India
Distribution: Cent OS 5/6, Ubuntu Server 10.04
Posts: 4,629

Rep: Reputation: Disabled

So do it as root and see if it solves your problem. Error 13 is usually associated with either permission issue or else if mysql is not running.
 
Old 08-04-2009, 08:15 AM   #17
onebuck
Moderator
 
Registered: Jan 2005
Location: Midwest USA, Central Illinois
Distribution: SlackwareŽ
Posts: 12,831
Blog Entries: 27

Rep: Reputation: 2129Reputation: 2129Reputation: 2129Reputation: 2129Reputation: 2129Reputation: 2129Reputation: 2129Reputation: 2129Reputation: 2129Reputation: 2129Reputation: 2129
Hi,

Try to keep within one post. You are getting answers to solve your problems in another post.

This has been reported.
 
Old 08-04-2009, 08:36 AM   #18
pixellany
LQ Veteran
 
Registered: Nov 2005
Location: Annapolis, MD
Distribution: Arch/XFCE
Posts: 17,802

Rep: Reputation: 738Reputation: 738Reputation: 738Reputation: 738Reputation: 738Reputation: 738Reputation: 738
Here's your last post in your previous thread:
Quote:
Thank u very much for ur each n every expalnation.
It is running but not connecting to mysql.what shall i do?
This was posted only about ten minutes before this latest thread.

If you don't want any more help installing or configuring something, then it is better to say so in the same thread---As it is, people are still trying to help you while you are starting a new thread which implies you no longer care.

I'll merge this into the other thread.
 
Old 08-04-2009, 09:22 AM   #19
Wim Sturkenboom
Senior Member
 
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Slackware 10.1/10.2/12, Ubuntu 12.04, Crunchbang Statler
Posts: 3,786

Rep: Reputation: 282Reputation: 282Reputation: 282
You should run su mysql while being root as root can change to any user without being prompted for a password.

The only time I have seen su mysql being used is when you want to create the default databases as this should be done as the mysql user so the mysql server can access them afterwards. This is only required once and depends on the way you installed mysql (it might be part of the installation procedure in some distro's). After that there is no longer a need to be the mysql user.

Last edited by Wim Sturkenboom; 08-04-2009 at 09:25 AM. Reason: fixed typo
 
Old 08-04-2009, 02:38 PM   #20
pixellany
LQ Veteran
 
Registered: Nov 2005
Location: Annapolis, MD
Distribution: Arch/XFCE
Posts: 17,802

Rep: Reputation: 738Reputation: 738Reputation: 738Reputation: 738Reputation: 738Reputation: 738Reputation: 738
Just a quick note to clarify something----

This thread is now a merger of 3 threads by the OP-----In the last one he requests help in REMOVING MySQL. My reply to this comes out of sequence because of the merging.

Unless the OP checks in soon, we may be all spinning our wheels.......
 
Old 08-04-2009, 11:18 PM   #21
mythiliram
LQ Newbie
 
Registered: Aug 2009
Posts: 16

Original Poster
Rep: Reputation: 0
The output for the command ps afxwww | grep mysql is
2739 pts/1 s+ 0:00 \_grep mysql
When running mysql,i'm logging as normal user.
 
Old 08-04-2009, 11:22 PM   #22
mythiliram
LQ Newbie
 
Registered: Aug 2009
Posts: 16

Original Poster
Rep: Reputation: 0
When i log in as root and give the command su mysql,
it is giving erroe msg..."bash -3.2$". from this point of view no command is working or command prompt is not coming.
 
Old 08-04-2009, 11:57 PM   #23
tanveer
Member
 
Registered: Feb 2004
Location: e@rth
Distribution: RHEL-3/4/5,Gloria,opensolaris
Posts: 525

Rep: Reputation: 37
Quote:
The output for the command ps afxwww | grep mysql is
2739 pts/1 s+ 0:00 \_grep mysql
When running mysql,i'm logging as normal user.
This means that MySQL server is not running even if you login as normal user it should show you the process of mysql.


Now first you need to start mysql.
If RPM based installation then start mysql as 'root' user using:
# service mysqld start

if compiled then go to the bin directory of compiled location and use
# ./mysqld-safe --user=mysql &

After running the server then try to connect with
if RPM : # mysql -u root
if compiled: /usr/local/mysql/bin/mysql -u root // Generally compile location of mysql is /usr/local/mysql
 
Old 08-05-2009, 12:04 AM   #24
mythiliram
LQ Newbie
 
Registered: Aug 2009
Posts: 16

Original Poster
Rep: Reputation: 0
Thank u very much for helping me...
The same errors are occuring.
Please give me the whole document for installing mysql properly.
 
Old 08-05-2009, 03:17 AM   #25
zhjim
Senior Member
 
Registered: Oct 2004
Distribution: Debian Squeeze x86_64
Posts: 1,748
Blog Entries: 11

Rep: Reputation: 233Reputation: 233Reputation: 233
Rather dull to read but should answer every question.

http://dev.mysql.com/doc/refman/5.0/en/installing.html

If you don't have the time to read most of it. We need the name of the distribution (a.k.a. the name of the linux you isntalled) your using.
 
Old 08-05-2009, 06:00 AM   #26
Wim Sturkenboom
Senior Member
 
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Slackware 10.1/10.2/12, Ubuntu 12.04, Crunchbang Statler
Posts: 3,786

Rep: Reputation: 282Reputation: 282Reputation: 282
Quote:
Originally Posted by mythiliram View Post
When i log in as root and give the command su mysql,
it is giving erroe msg..."bash -3.2$". from this point of view no command is working or command prompt is not coming.
Which error message?
Code:
wim@btd-techweb01:~$ su - root
Password:

QOTD:
On a scale of 1 to 10 I'd say...  oh, somewhere in there.

root@btd-techweb01:~# su - mysql
/dev/pts/0: Operation not permitted

A diplomat is a man who can convince his
wife she'd look stout in a fur coat.

mysql@btd-techweb01:~$
Taken from my Slackware 10.1 box. You can ignore the error message that is in italic.

The $ indictes that you're a normal user and the # indicates that you're root. So in your case, you basically became the mysql user and there are no (real) problems at that stage.


PS http://www.linuxquestions.org/questi...mitted-436734/ explains the reason of the error message.

Last edited by Wim Sturkenboom; 08-05-2009 at 06:09 AM. Reason: added PS
 
  


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
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL serve vinnyband Linux - Software 3 10-30-2008 02:53 PM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. suziecorbett Linux - Software 8 10-09-2008 01:52 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 03:35 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM

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

All times are GMT -5. The time now is 05:25 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration