mysqld_safe process
Hi all, is it ok, that the mysqld_safe process runs under the root account! Shouldn´t that be the mysql account, too? 10317 root 9 0 1060 1060 876 S 0.0 0.0 0:00 mysqld_safe 10359 mysql 9 0 1436 1436 1044 S 0.0 0.0 0:00 mysqld 10361 mysql 8 0 1436 1436 1044 S 0.0 0.0 0:00 mysqld 10362 mysql 9 0 1436 1436 1044 S 0.0 0.0 0:00 mysqld Greetings Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: AW: mysql linux user
Hi, ok, now I understand! I was just a little bit confused, because I got a preinstalled virtual server with MySQL already installed on it! The user 'mysql' was a shell user: mysql:x:27:27:MySQL Server:/var/lib/mysql:/bin/bash Thanks for your help!! Regards Andy > -Ursprungliche Nachricht- > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Gesendet: Samstag, 7. Juni 2003 18:48 > Cc: [EMAIL PROTECTED] > Betreff: Re: AW: mysql linux user > > > Dingfelder Andy schrieb: > > >Hi, > > > >I?ve forgot to say, that i?m a newbie to linux. > >So, what do you want to say, with these lines? > >That the 'mysql' user is not a shell user? > > > yes > > i am no expert too > > a daemon should run as a unprivileged user, if possible > > # ps auxw | less > > > for this you need an account > this account need *no* shell > > eg > man useradd > -s /sbin/nologin > > > > # grep "false\|nologin\|null" /etc/passwd > > bin:x:1:1:bin:/bin:/sbin/nologin > daemon:x:2:2:daemon:/sbin:/sbin/nologin > adm:x:3:4:adm:/var/adm:/sbin/nologin > lp:x:4:7:lp:/var/spool/lpd:/sbin/nologin > mail:x:8:12:mail:/var/spool/mail:/sbin/nologin > uucp:x:10:14:uucp:/var/spool/uucp:/sbin/nologin > operator:x:11:0:operator:/root:/sbin/nologin > games:x:12:100:games:/usr/games:/sbin/nologin > gopher:x:13:30:gopher:/var/gopher:/sbin/nologin > ftp:x:14:50:FTP User:/var/ftp:/sbin/nologin > nobody:x:99:99:Nobody:/:/sbin/nologin > ntp:x:38:38::/etc/ntp:/sbin/nologin > rpc:x:32:32:Portmapper RPC user:/:/sbin/nologin > vcsa:x:69:69:virtual console memory owner:/dev:/sbin/nologin > nscd:x:28:28:NSCD Daemon:/:/sbin/nologin > sshd:x:74:74:Privilege-separated SSH:/var/empty/sshd:/sbin/nologin > mailnull:x:47:47::/var/spool/mqueue:/sbin/nologin > smmsp:x:51:51::/var/spool/mqueue:/sbin/nologin > rpcuser:x:29:29:RPC Service User:/var/lib/nfs:/sbin/nologin > nfsnobody:x:65534:65534:Anonymous NFS User:/var/lib/nfs:/sbin/nologin > pcap:x:77:77::/var/arpwatch:/sbin/nologin > xfs:x:43:43:X Font Server:/etc/X11/fs:/sbin/nologin > named:x:25:25:Named:/var/named:/sbin/nologin > gdm:x:42:42::/var/gdm:/sbin/nologin > apache:x:48:48:Apache:/var/www:/sbin/nologin > postfix:x:89:89::/var/spool/postfix:/sbin/nologin > squid:x:23:23::/var/spool/squid:/dev/null > webalizer:x:67:67:Webalizer:/var/www/html/usage:/sbin/nologin > desktop:x:80:80:desktop:/var/lib/menu/kde:/sbin/nologin > mailman:x:41:41:GNU Mailing List Manager:/var/mailman:/bin/false > mysql:x:27:27:MySQL Server:/var/lib/mysql:/sbin/nologin > radvd:x:75:75:radvd user:/:/bin/false > fax:x:78:78:mgetty fax spool user:/var/spool/fax:/sbin/nologin > > > -- > shrek-m > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: mysql linux user
Hi, I?ve forgot to say, that i?m a newbie to linux. So, what do you want to say, with these lines? That the 'mysql' user is not a shell user? Greetz Andy > -Ursprungliche Nachricht- > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Gesendet: Freitag, 6. Juni 2003 17:01 > An: [EMAIL PROTECTED] > Betreff: Re: mysql linux user > > > Dingfelder Andy schrieb: > > Hello, > > > > if I install mysql under linux, there is a user created calld 'mysql'. > > My question is, whether this user has a default password, which > should be > > changed > > to avoid security problems? > > > # grep mysql /etc/passwd > mysql:x:27:27:MySQL Server:/var/lib/mysql:/sbin/nologin > > # service mysqld restart > > # mysql -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 3 to server version: 4.0.13 > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > mysql> > > # su mysql > This account is currently not available. > > > > > > # grep mysql /etc/passwd > mysql:x:27:27:MySQL Server:/var/lib/mysql:/bin/false > > # service mysqld restart > > # mysql -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 1 to server version: 4.0.13 > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > mysql> > > # whoami > root > # su mysql > # whoami > root > > > hope this helps > > -- > shrek-m > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql linux user
Hello, if I install mysql under linux, there is a user created calld 'mysql'. My question is, whether this user has a default password, which should be changed to avoid security problems? Regards Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: Hi,
Hello Murrat, is it possible, that someone deletes your mysql-database or the host table? Maybe yourself? The server needs this table for the "authorization rules", and a deletion should be avoided! Hope that helps. Regards Andy > -Ursprüngliche Nachricht- > Von: Murat YESILDAL [mailto:[EMAIL PROTECTED]] > Gesendet: Samstag, 10. Februar 2001 18:08 > An: [EMAIL PROTECTED] > Betreff: Hi, > > > Hi, > > I have a problem i was using mysql and it was very well but yesterday > it didn't work then i removed it and reinstalled it , it worked 2 times > and then again it doesn't work, when i run mysqld it doesn't run in the > background of windows, and in the error file it says > > 13:05:14 C:\MYSQL\BIN\MYSQLD.EXE: Table 'mysql.host' doesn't exist > > when i remove it and reinstall it i am able to run it a few times and > after a few times, it gives that error, that could be the problem ? > > thanks, > > murat, > > \\\I/// > ( o o ) > ( n ) > ( - ) > o0o-o0o > | | > | Mehmet Murat Yesildal | > |BILKENT UNIVERSITY | > | Dept : Computer Engineering & Information Science | > | E-mail : [EMAIL PROTECTED] | > | Homepage : http://www.ug.bcc.bilkent.edu.tr/~yesildal | > --- > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: С API help
Hello Konstantin, this code is buggy, because 'new' is not a valid C operator. And MYSQL is a struct not an object. The 'new' operator allocates memory for objects (C++). In C you?ve to use the malloc function. Take a look at the libmysqltest example, which comes with your distribution. Regards Andy > -Ursprungliche Nachricht- > Von: Konstantin Osipov [mailto:[EMAIL PROTECTED]] > Gesendet: Donnerstag, 8. Februar 2001 10:30 > An: [EMAIL PROTECTED] > Betreff: ó API help > > > Hi All! > > Is this code buggy? > -- > MYSQL* mysql = new MYSQL; > > mysql_init(mysql); > > mysql_real_connect(mysql, "localhost"); > /* some work*/ > mysql_close(mysql); > mysql_real_connect(mysql, "otherhost"); > /* some work*/ > mysql_close(mysql); > > delete mysql; > -- > In other words, if struct MYSQL allocated manually, should i call > mysql_init(mysql) after mysql_close(mysql) if i want to connect using this > struct to other database? > > > WBW, Konstantin > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [CGI] Gas Prices
Germany: 0,99 US$ per litre - That´s expensive, too. gOoD rIdE! Andy Dingfelder > -Ursprüngliche Nachricht- > Von: Fábio Ottolini [mailto:[EMAIL PROTECTED]] > Gesendet: Freitag, 2. Februar 2001 23:00 > An: [EMAIL PROTECTED] > Betreff: Re: [CGI] Gas Prices > > > Brazil: US$0,825/litre - That's really expensive!!! > > BR, > > Fábio Ottolini > > - Original Message - > From: "Solomon Sokolovsky" <[EMAIL PROTECTED]> > To: "Marko Sarunac" <[EMAIL PROTECTED]>; "Redvers Davies" > <[EMAIL PROTECTED]> > Cc: "mySQL Mailing List" <[EMAIL PROTECTED]> > Sent: Thursday, February 01, 2001 10:19 PM > Subject: RE: [CGI] Gas Prices > > > > Here in Australia 90 cents (AUSD)per litre thats about 58 cents USD. We > > consider this very expensive! > > > > -Original Message- > > From: Marko Sarunac [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 02, 2001 4:55 AM > > To: Redvers Davies > > Cc: mySQL Mailing List > > Subject: Re: [CGI] Gas Prices > > > > > > > > > > And i thought 72.9 Cents (Canadian) per litre was expensive :( > > > > > > > > > > > > > > Redvers Davies <[EMAIL PROTECTED]> on 02/01/2001 09:03:19 AM > > > > To: [EMAIL PROTECTED] > > cc: [EMAIL PROTECTED] (Ray Ray), [EMAIL PROTECTED] > (mySQL Mailing > > List), > > [EMAIL PROTECTED] (Jeff Hunt), [EMAIL PROTECTED] (Ed Holmes), > > [EMAIL PROTECTED] (Chris Goehrig), [EMAIL PROTECTED] > (CGI Mailing > > List), > > [EMAIL PROTECTED] (Bill Turay), [EMAIL PROTECTED], > > [EMAIL PROTECTED], > > [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] (bcc: Marko > > Sarunac/ISM-BC) > > Subject: Re: [CGI] Gas Prices > > > > > > > > > > By now you're probably thinking gasoline priced at about $1.49 is > cheap. > > > > Me too! As it is now $1.58 for regular unleaded. Now that the oil > > > > Just an off topic observation. $1.58 is cheap. Here, (in the UK) our > > Gas price is > $6 a gallon. (Yes, six US dollars a gallon). > > > > Its kinda annoying to hear people complaining about gas being > > $1.50 as "high" ;) > > > > Red > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php