General :: What Would Be Benefits If Mysql User Has Not Login Permission?
Jul 21, 2011
Since I have never had the need to create one, the first time I encounterd it I asked myself: what is it?I was looking for MySql installation guidelines on mysql.com, when, reading them, I found this command:shell> useradd -r -g mysql mysql.Now, I read the man page of useradd looking for explanation about -r option, but I didn't found it useful.It just says that -r options creates a System account, but it doesn't say anything else.So my question is: what is a system account? Few lines under the command it says:"Because the user is required only for ownership purposes, not login purposes, the useradd command uses the -r option to create a user that does not have login permissions to your server host."What would be the benefits if mysql user has not login permission?
View 6 Replies
ADVERTISEMENT
Feb 8, 2010
I cannot see what the problem is here. I have installed MySQL 5.1.36 via YaST on my openSUSE 11.2 (32-bit) system.I can log in as root. I can "create user MY_user identified by 'my_passwd';" and a new user is created. But I cannot log in to the database using that new user name. I keep getting the message:
Code:
> mysql -b -u MY_user -p
Enter password:
[code]....
View 6 Replies
View Related
Oct 16, 2010
I just have a simple BIOS password when I boot into my machine. Should I also have the standard login password as well? In other words, what benefit does the login at the boot up, (after BIOS) really give and would you recommend a good or better security process?
View 2 Replies
View Related
Aug 7, 2010
How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies
View Related
May 1, 2010
i was trying to execute the following on Kubuntu.
Code:
echo 0 > /proc/sys/vm/vdso_enabled
But it says "permission denied". Probably I need root user rights. How to get it in Kubuntu?
View 3 Replies
View Related
Dec 11, 2009
I am using the sudo command to log on locally as another user by the following command:
sudo -u theotheruser -s
or
sudo -u theotheruser sh
As I see it, this initiates a new shell with the mentioned other user.However, this doesn't load that users profile from his home directory.Is there a way to automatically read the users profile when login in with selected command? I am mostely interested in getting a working prompt when logged in.
View 11 Replies
View Related
Jan 13, 2011
i have created a file (by root user) called test.txt. Then i created a user bob. Now i want only bob to read/write/execute this file and no other user shall have any permission on it.
View 3 Replies
View Related
Apr 19, 2011
i've query regarding, user creation in Linux( RHEL 5), i.e, i've created a user ([root@localhost ~]#useradd slash ) and switched into that user, but am not able to run commands in it......It's displaying a message saying, PERMISSION DENIED. Do we need to provide any permissions while creating a user
View 7 Replies
View Related
Jan 16, 2011
i have the one help. i will creata one samba server.access this samba file windows system. also domain user access this samba folder. but problem is how can set permissions AD User( Windows 2008 Server).
View 2 Replies
View Related
Dec 8, 2010
when i logging with root then i saw message "permission denied" Then i changed root shell directory "usermod -s .usr/ root" but it says "permission denied" again. what is the default shell directory, or what can i do for change permissions.
View 1 Replies
View Related
Jul 26, 2011
We are using ubuntu 10.04 desktop version.ls > /dev/lp0 permission denied in user account we need user can access lp0 /usblp0. Our printing module is lp0 writing technology example dir >prn.
View 3 Replies
View Related
Jan 21, 2010
I'm trying to access a share across the net. the share is a disk "fat32" which I mounted using "vfat users,rw,exec 0 0." However, after I created the samba user "smbpasswd -a user" I'm still unable to access the share across the net. ports are open, and entry has been made in smb.conf for share. But I'm having problems giving permission to smb user. the share it is mounted on /media/share, and I've tried everything from
chmod -R ug+rwx /media/share
chmod -R ugo+rwx /media/share
chown -R user /media/share
and I always get unable to set permission for user
View 1 Replies
View Related
Jan 20, 2011
i want to set permission type "write" on a file to a particular user in a group of users ( not all users in that group). chown is changing a user to root , but i want to set say permission of "write" only to a user 1 in group staff which contains 10 users 1 , user 2 ...user 10.
View 3 Replies
View Related
Sep 29, 2009
I can't seem to give myself audio permission. What is the command that lets me add myself to a group so that I may be able to use alsa?
View 2 Replies
View Related
Jan 9, 2010
I have configured samba server.My requirement was that the path which i have to share was /srv/www/htdocs.With this the shared path for developer user was /srv/www/htdocs/projects.
So in the smb.conf file i made the entries as following:
After that root user was able login to both /srv/www/htdocs and also project folder and developer was only able to login to projects folder.That was according to my requirement but now the problem is that when developer is trying to edit any file in projects folder he is getting error that you dont have permissions to change this file.But developer should be able to edit any files. What changes i need to do now.
View 3 Replies
View Related
Jun 10, 2010
I'm using ubuntu,i have a bin file under my /usr/bin, if i run the command under root user i'm getting no problem an it works fine,if i try it in with differnent user im getting
Code:
semctl:premission denied
so how can i edit my bin file and change it to right permission
View 3 Replies
View Related
May 1, 2011
I am working currently on my server on an issue, I configured the SSH Deamon that only people who have a valid ssh-key can login on to the server, and kicked the password option. Now I've added a user account git. I navigate to his home folder created the folder ".ssh" and created in that folder the file "authorized_keys" I copied my public key in there. Now on my local machine I added that identity (via ssh-add) and I wanted to connect to my server. but when I'm trying to login myself I can't the only message I get is "Permission denied (publickey)."
View 1 Replies
View Related
Aug 2, 2010
I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run
Code:
GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:
[code]...
View 13 Replies
View Related
Oct 11, 2010
I have two machines between which I need to share a folder.On server1, I have the user 'appuser' that needs to access (read/write/delete) on this share.On server2, 'root' accesses this share and writes to it.I have the following in /etc/exports on server1:/home/app-share 999.999.99.99/28(rw,insecure,sync,no_root_squash)where the number is the IP address. How can I change this to allow 'appuser' access?
View 1 Replies
View Related
Feb 4, 2011
allow specific user permission to read/write my folder
I have a folder called /TAR/Sketch
I added a new user, named Snoopy, I want to grant this user the ability to add files & directories to this folder which is under the group Sketches and the owner is me.
How can I accomplish this ?
View 1 Replies
View Related
May 26, 2010
I'm trying to do something like thisi created a group called www and made this group the owner of the directory/var/www/htmlso i can read and write to it.of course I've add my self to this group, but it seems i can't read and write.the syntax i used was something like chown :www /var/www/html.didn't workonly when i used chown samurai:www /var/www/html i could finally could create new file.the reason i don't want to specify the user name is because I'm thinking of a scenario when i need to give permission to a large group of ppl and don't want to do it user by user.
View 5 Replies
View Related
Jul 27, 2010
I have a program(that is written by me) which need super user permission to execute it. But I need to let the normal users to execute it without using 'sudo ./executable' and just './executable'. how i can set the program to execute by the normal users without using 'sudo' or password prompting.
View 2 Replies
View Related
Jun 8, 2011
I am attempting to configure my sudoers file, and have quite a few questions.If you can answer any/all of them, I would be grateful.
-Is there a way to set it up so that root gets notified if a user tries to use a command they are not allowed to?
-If something like this already exists on my system, how do I set it up/use it/ read root's messages?
-I see a lecture=always default exists, but can I customize this lecture?
-Is there an easy way to explicitly deny a user sudo permission?
-I see there is an ALL wildcard. Is there something similar to a NONE wildcard?
View 3 Replies
View Related
Oct 16, 2009
I created a user called gdev.
As root, I made a dir /var/www/html/test
I have done these same steps on numerous machines. However, in this instance, gdev cannot cd into test/
View 2 Replies
View Related
May 5, 2010
I have two computers. One runs unRaid NAS software which is built on Linux. The other is running XBMC media center which is built on Ubuntu. XBMC has a local folder (/home/kevin/.xbmc/userdata/Thumbnails/) that it stores thumbnails in. I am essentially trying to move this folder to my server, but XBMC needs to see it as local. I started by deleting the old Thumbnails folder and it's contents. I then created an empty Thumbnails folder on XBMC and I also created one on my unRaid comp (192.168.1.20/disk7/xbmc_thumbs/Thumbnails). On the XBMC comp I run:
Code:
chmod 777 Thumbnails
mount -t cifs //192.168.1.20/disk7/xbmc_thumbs/Thumbnails Thumbnails
It creates the mount and as long as I'm logged in as root, I can copy files to the XBMC Thumbnails folder and they appear on my unRaid server's Thumbnails folder. The problem is that if I log in as kevin (the user that XBMC runs as) I get permission denied errors. I've tried changing ownership of the XBMC Thumbnails folder to kevin via:
Code:
chown -v kevin Thumbnails
And it says it changed it, but if I check, the ownership and group both still show as root. I'm thinking that may be because now that the mount is made, it's showing the ownership of the Thumbnails folder on the unRaid server? Whatever it's doing I can't seem to change it and XBMC can't write it's thumbnails because of this.
View 14 Replies
View Related
Mar 8, 2011
Unable to open pty: Permission denied while trying to login to vps node.
View 2 Replies
View Related
Feb 2, 2011
created a user but i forgot to change the home directory permission.so after user created when i go to the user and group mangement i cant see that permission filed related to the home permission directory.my purpose is to stop accessing other user to my home directory,how it can be possible??
View 4 Replies
View Related
Jun 13, 2011
I would like to know how can I share a folder in samba with no need of user and password with write permission, with no need of using guest user.
View 3 Replies
View Related
Jan 4, 2011
I am using Ubuntu 10.04.1 LTS x64. I would like to backup my /var/lib/mysql directory as a non-root user.
I have been backing this up using cron as the root user, but another admin in my company insists that we create a separate user to perform this task for security reasons. I have created a user, created a group, added the user to the group, but still cannot access /var/lib/mysql/mysql directory as that user. I would like that user to have +rx access only.
View 5 Replies
View Related
Aug 6, 2010
would this script not work?
Code:
#!/usr/bin/perl
#PERL module
use Mysql;
#CONFIG VARIABLES
[Code].....
I clearly have a lot to learn, but I have done about 10 Google searches trying to find out how to test connectivity b/t mod_perl and mysql.. maybe I'm confused on how this works.
I have this in httpd.conf
Code:
Perlrequire /etc/httpd/conf/perl-startup.pl
PerlWarn On
PerlModule Apache::DBI
I have this in perl-startup.pl
[Code]....
View 4 Replies
View Related