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 08-07-2012, 05:05 AM   #1
figure20012
Member
 
Registered: Apr 2012
Posts: 75

Rep: Reputation: Disabled
cannot su in mysql account


i cant su in an account
i want to su in the mysql account
why cant i do that?
entry for mysql in /etc/passwd
mysql:x:493:514::/home/databases/mysql/mysql:/bin/bash

the error is
su: /bin/bash: Permission denied

Can someone please help?
 
Old 08-07-2012, 06:06 AM   #2
jschiwal
Guru
 
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 654Reputation: 654Reputation: 654Reputation: 654Reputation: 654Reputation: 654
Mysql is a system account , and should not have logins disabled in /etc/shadow. There shouldn't be a password to enter when using `su'.

Why do you want to?
 
1 members found this post helpful.
Old 08-13-2012, 12:44 AM   #3
figure20012
Member
 
Registered: Apr 2012
Posts: 75

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by jschiwal View Post
Mysql is a system account , and should not have logins disabled in /etc/shadow. There shouldn't be a password to enter when using `su'.

Why do you want to?
i have a script to start my mysql server only when i am the mysql user
i still guet the permission denied when i try to su in as mysql


su: warning: cannot change directory
su: /bin/bash: Permission denied
 
Old 08-13-2012, 01:24 AM   #4
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
What are the permissions on mysql's home directory
Code:
ls -ld /home/databases
ls -ld /home/databases/mysql
ls -ld /home/databases/mysql/mysql
And show us your script, please.
 
1 members found this post helpful.
Old 08-13-2012, 01:40 AM   #5
figure20012
Member
 
Registered: Apr 2012
Posts: 75

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by Wim Sturkenboom View Post
What are the permissions on mysql's home directory
Code:
ls -ld /home/databases
ls -ld /home/databases/mysql
ls -ld /home/databases/mysql/mysql
And show us your script, please.
i cant su in any other account
i am trying to su in my account
su toto
permission denied
su - toto
also permission denied
i have tried to add a new user as well and su in the user
but also the permission is denied
 
Old 08-13-2012, 01:47 AM   #6
figure20012
Member
 
Registered: Apr 2012
Posts: 75

Original Poster
Rep: Reputation: Disabled
i have also tried to ssh to another account
ssh toto@toto.com
ssh error permission denied
but
ssh root@toto.com i can login to the machine toto.com
 
  


Reply

Tags
mysql, su


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
about using mysql (in root account) in linuxmint12 shanmugamvel Linux - Software 1 07-13-2012 04:14 PM
MySql and a simple Bank Account DB air4time Programming 16 10-27-2010 03:25 AM
MySQL - Script to create account wegadnie Linux - Server 2 02-22-2010 08:02 AM
Help in getting my account some mysql priveledges mobo Ubuntu 1 09-17-2005 06:20 AM
MySQl account login, PHP agallant Programming 2 07-16-2004 11:01 AM


All times are GMT -5. The time now is 06:45 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration