Why does safe_mysqld runs as root?
Im curious as to why safe_mysqld runs as root? I have changed the owenership and group to mysql and my my.cnf file looks like: [mysqld] user=mysql port=3306 socket=/var/lib/mysql/mysql.sock [mysql_server] user=mysql port=3306 socket=/var/lib/mysql/mysql.sock Any thoughts are welcome. Thanks much, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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: Why does safe_mysqld runs as root?
Thats what stumps me, I guess I am, but I have changed the ownership of all mysql files to mysql and set the user to mysql in my my.cnf file. By your comment below I guess I need to change it somewhere else? where? Thanks, DK -Original Message- From: Jeremy Zawodny [mailto:Jeremy;Zawodny.com] Sent: Tuesday, November 12, 2002 12:06 PM To: David Kramer Cc: [EMAIL PROTECTED] Subject: Re: Why does safe_mysqld runs as root? On Tue, Nov 12, 2002 at 12:06:36PM -0800, David Kramer wrote: Im curious as to why safe_mysqld runs as root? I have changed the owenership and group to mysql and my my.cnf file looks like: Because you start it as root, maybe? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 98 days, processed 2,067,789,644 queries (242/sec. avg) - 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: Why does safe_mysqld runs as root?
By boot sequence Im guessing you mean my different run levels? rcX.d? Im guessing that I need to set the user value within the start-up script it self rather than my.cnf??? I thought my.cnf was the config file that the start-up scripts reference, by me setting a the attribute user=mysql under [mysqld], mysql should start under the user mysql? Thanks much, DK -Original Message- From: Michael T. Babcock [mailto:mbabcock;fibrespeed.net] Sent: Tuesday, November 12, 2002 12:58 PM To: David Kramer Cc: '[EMAIL PROTECTED]' Subject: Re: Why does safe_mysqld runs as root? David Kramer wrote: Thats what stumps me, I guess I am, but I have changed the ownership of all mysql files to mysql and set the user to mysql in my my.cnf file. By your comment below I guess I need to change it somewhere else? where? Where is mysql being started from? Are you familiar with your computer's boot sequence? If not, don't touch it. The my.cnf file doesn't change how your platform launches safe_mysqld. Wherever your computer runs safe_mysqld, make sure it does it as the user you want it to run as. Again, if you're unsure how to do this, consider buying someone's time (or a book) for how to do it. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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
Mysql starts under XFS on boot up???
I noticed that Mysql starts up under XFS, Im not even sure what XFS is? Im running RH 7.3 and mysql 3.23.40. I performed the install based on RPM packages not from the Packaged OS install. Jsut curious why this is happening. Also I noticed that my safe_mysqld daemon is running under root: root 976 1 0 Nov10 ?00:00:00 /bin/sh /usr/bin/safe_mysqld --d I have changed all of my binaries and other various mysql files over to mysql own and grp. I have set [mysqld] in my my.cnf file to use user=mysql. Do I need to possibly create a setting in my.cnf file for [safe_mysqld] user=mysql??? Any thoughts would be greatly appreciated. Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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: Mysql starts under XFS on boot up???
Can you tell me why during bootup I see XFS starting Mysql Daemon then? Any thoughts on the safe_mysqld question? Thanks much, DK -Original Message- From: Black, Kelly W [PCS] [mailto:kblack05;sprintspectrum.com] Sent: Monday, November 11, 2002 2:36 PM To: 'David Kramer'; [EMAIL PROTECTED] Subject: RE: Mysql starts under XFS on boot up??? XFS is X server Font Server, and is unrelated. ~Kelly W. Black -Original Message- From: David Kramer [mailto:DKramer;reflect.com] Sent: Monday, November 11, 2002 1:51 PM To: [EMAIL PROTECTED] Subject: Mysql starts under XFS on boot up??? I noticed that Mysql starts up under XFS, Im not even sure what XFS is? Im running RH 7.3 and mysql 3.23.40. I performed the install based on RPM packages not from the Packaged OS install. Jsut curious why this is happening. Also I noticed that my safe_mysqld daemon is running under root: root 976 1 0 Nov10 ?00:00:00 /bin/sh /usr/bin/safe_mysqld --d I have changed all of my binaries and other various mysql files over to mysql own and grp. I have set [mysqld] in my my.cnf file to use user=mysql. Do I need to possibly create a setting in my.cnf file for [safe_mysqld] user=mysql??? Any thoughts would be greatly appreciated. Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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 - 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: my.cnf settings and running admin commands such as mysqldump or m
Is it a save assumption that I need to create a section for every admin command that I want to use? i.e., create another section for mysqladmin and so on??? Thx, dK -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko;ensita.net] Sent: Wednesday, October 23, 2002 5:28 AM To: [EMAIL PROTECTED] Subject: re: my.cnf settings and running admin commands such as mysqldump or m David, Wednesday, October 23, 2002, 12:23:36 AM, you wrote: DK I was wondering if someone could shed some light on setting parameters in DK my.cnf. When I set params such as user and password in my my.cnf file I DK dont need to then pass these parameters to commands such as mysqldump or DK mysqladmin? Is this True? Can someone please send me an example of their DK my.cnf file, Im just curious what a real example would look like. I have DK already read through the my.cnf documentation on the website, but if someone DK has a better place for online doc on the config file please let me know. DK Any other insight is more than welcome and appreciated. For mysqldump you create a section [mysqldump] in the my.cnf where you can specify mysqldump options like [mysqld] . [mysqldump] user=Victoria password=mypassword -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Looking for sample my.cnf
Im looking for an example of my.cnf. Just want to see what some of the basic parameters and admin tools(mysqldump, mysqlimport, mysqlshow,mysqladmin) settings should look like in my.cnf. I have searched all over the web and havent found much, if someone has a site they recommend outside of mysql.com I would greatly appreciate it. Other than that could someone just send me a copy of their my.cnf, please feel free to X out any secure info. Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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: Great news mysql , your $8000 per month income
To the crackers out there on this list, Can someone send Greg a virus for this spam [EMAIL PROTECTED] sincerely, a concerned MySql citizen!! -Original Message- From: The Certain Way [mailto:freedom4u3233118;aol.com] Sent: Wednesday, October 23, 2002 4:21 PM To: [EMAIL PROTECTED] Subject: Great news mysql , your $8000 per month income Greetings mysql , My name is Greg. I know you have to be tired of get-rich-quick promises. I know I am. It seems that the Internet is full of opportunities that promise you don't have to do anything in order to get everything you ever wanted. READ ON and discover. I was involved for 6 years in Network Marketing. Although I believe that MLM is a viable means of distribution and it can help people to fulfill their dreams, the sad fact is that 9 out of 10 people just will not make it work. That is not a guess folksthat is a fact based on 40 years of data. The truth is though that nobody knows who the 10% are that will make it. BUT... for me the odds were just too high against it. I just could not comfortably approach anyone anymore and offer them a network marketing opportunity. For me I knew in my heart that whoever I spoke to probably was not going to make it. I had to find another means of putting myself in a position to receive my dreams. HERE'S AN AMAZING OPPORTUNITY!! I could say it costs nothing -- not true. There is an investment. I could say you don't have to do anything -- again, not true. It does require some time, a computer, a phone, a willingness to listen, and some desire. It basically follows along the law which states that you get back what you give out. If you give a little you will get a little. If you give a lot.you get MORE than a lot back. I am in a position to help anyone in the United States or Canada who has the desire to change their lives, even if it is just a little change, and is willing to make a commitment. There is one key ingredient besides commitment--desire. How am I so sure I can help YOU if you have some desire and are willing to make a commitment?? : I and my associates have a marketing system which kicks the pants off anything I have seen in the last 10 years. We provide you with software alone which retails for well over $1200...but we GIVE it to you. (This is not a gimmick, we actually do give it to you for FREE) We market a product which everyone can benefit from. Now, that does not mean everyone wants it. :-), but most are open to it. That's all we really need. The product can be marketed over the internet or to your next door neighbor. We prefer the internet, but you always have an option. You do not have to approach your friends or relatives...EVER. With our system you will generate between 15 and 50 high-quality prospects every day without having to prospect. (I personally hate prospecting). We provide you with full one-on-one support and a 130-page tutorial to help make our job easier and yours too in getting started. You need no sales experience!! Our system is designed to attract those who are ready to get involved. What you really do is take calls and emails from those who need questions answered and who want to verify that this is for real. And...you support those who you help get started. (Sounds like MLM...right?..NOT) You are not alone in this at any time. This could change your life for the better as it has mine!! If you're ready to turn your life around, to stop wasting your time and start making a lot of money...to start REALLY living among the ranks of the rich... send an email with SEND INFO in the subject line to: [EMAIL PROTECTED] (USA and Canada only please), Sincerely, Greg ** (USA and Canada only please), If you would like to know more please send an email with SEND INFO in the subject line to: [EMAIL PROTECTED] * For those of you who are not interested in knowing more or for whom the timing is just not right please send an email with no more in the subject line to: [EMAIL PROTECTED] - 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
my.cnf settings and running admin commands such as mysqldump or mysqladmin
I was wondering if someone could shed some light on setting parameters in my.cnf. When I set params such as user and password in my my.cnf file I dont need to then pass these parameters to commands such as mysqldump or mysqladmin? Is this True? Can someone please send me an example of their my.cnf file, Im just curious what a real example would look like. I have already read through the my.cnf documentation on the website, but if someone has a better place for online doc on the config file please let me know. Any other insight is more than welcome and appreciated. Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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
Looking for Doc on using XML with Mysql, Xml-Aware.
Can anyone point me in the direction of using XML with MySql, any doc will do. Looking for info on the concept of Mysql being xml-aware. Im new with using xml in a DB Environment. Hopefully Im asking the right questions here. Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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
Someone has to know something on MySQLGUI?? - PLZ HLP!
Can anyone point me in the direction of some good doc on MYSQLGUI for Win2K? Looking for Install/Setup notes.. Also is the Flash Light Tool Kit needed to run the GUI? Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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: Count and group by problems
Im not sure I understand what it is that you are trying to do here??? Im assuming your using PERL/SomeScriptingLang on something on NT to connect to mysql using the ADO object... Within your Count(*) Group by are you trying to return a result set that contains a duplicate row count, i.e. Column=Booger, Count(*)=2??? If you provide a little more info I might be able to help here, if what I said above is true then maybe do something like this select foo, count(*) CNT from Table group by foo having CNT 1; Not sure on the syntax though, but something along those lines... DK -Original Message- From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 3:10 PM To: [EMAIL PROTECTED] Subject: Count and group by problems Evening I think I'm losing my mind. I have a very simple query that works fine in MySQLFront but will not work when I connect using ADO: select booger, count(*) from nose group by booger If I try the above query with one record It works fine. Once I try it with more records, nothing returns. If I try: select booger from nose group by booger It returns results with one or more records. Thanks for all of your help! Jake - 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
Mysql's equivalent of SQL Loader or BCP/DTS??
Im looking for info on Mysql's Bulk Data Loading Utility? Does it even have one? Does it just use Perl's DBI? Any syntax would be greatly appreciated... Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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: removing duplicate records
You could always use an insert statement into a second table, when performing the insert use a GROUP BY clause to consalidate your records something along these lines but this isnt 100% accurate, I would need the table DDL and business rules behind the DEDUP Insert into tableB ( column names, ... ) (select column a, column b, max(column c), --or you could use MIN from table A group by column a, column b); **JUST make sure your Identifing column, i.e. the column you use to tell which is a duplicate record or not is included in the group by. Also what are the business rules behind the DEDUP(Deduplication)? Are the other values contained in the other columns necessary? If you tell me more about what your trying to do and provide some Table DDL I can help you write this query. Just let me know! Thanks, DK group by statement -Original Message- From: walt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 12:43 PM To: [EMAIL PROTECTED] Subject: removing duplicate records Does anyone know a good way find and remove duplicate records from a table? I can create an identical table structure and use a script to pull records from the existing table and insert them into the new table if they are not duplicates, but I'd rather not do it that way. Here is an example of an sql script I use for Oracle databases delete from employee a whererowid ( select max(rowid) fromemployee b where b.COL1 = a.COL1 and b.COL2 = a.COL2 and b.COL# = a.COL#); sql, query Thanks in advance! -- Walter Anthony System Administrator National Electronic Attachment Atlanta, Georgia 1-800-782-5150 ext. 1608 If it's not broketweak it - 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: removing duplicate records
Vivian - Im just curious as to why I shouldnt trust group by? Is there a bug or something within Mysql regarding the group by clause? Walt - you could also create a compound primary key that consists of all columns, then create a unique constraint on the Primary key. I've used this many times in the past, and it works quite well. The only caveat is the SQL will puke when it tries to load the duplicate records into the table, I personally would use the DEDUP process of Insert/select with a group by... But you might want to see what Vivian's response is on the group by issue. DK -Original Message- From: Vivian Wang [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 2:37 PM To: walt; David Kramer; [EMAIL PROTECTED] Subject: Re: removing duplicate records Walt, Don't trust group by. I am using mysqldump and sort -u on *nix for duplicate. Try both ways, let me know your result. Thanks At 04:11 PM 7/30/2002 -0400, walt wrote: Thanks David! The entire row, not just one or two columns, is a duplicate which makes life fun.. :-) I can key or unique index only a few columns once the data is cleaned up to prevent this problem. If I create an identical table and include either a key or unique index (innodb seems to like the index better) on all the columns and do a insert into new_table using select * from old_table will mysql quit inserting once a duplicate is hit, or will it keep going and skip over the duplicates? walt On Tuesday 30 July 2002 03:57 pm, David Kramer wrote: You could always use an insert statement into a second table, when performing the insert use a GROUP BY clause to consalidate your records something along these lines but this isnt 100% accurate, I would need the table DDL and business rules behind the DEDUP Insert into tableB ( column names, ... ) (select column a, column b, max(column c), --or you could use MIN from table A group by column a, column b); **JUST make sure your Identifing column, i.e. the column you use to tell which is a duplicate record or not is included in the group by. Also what are the business rules behind the DEDUP(Deduplication)? Are the other values contained in the other columns necessary? If you tell me more about what your trying to do and provide some Table DDL I can help you write this query. Just let me know! Thanks, DK group by statement -Original Message- From: walt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 12:43 PM To: [EMAIL PROTECTED] Subject: removing duplicate records Does anyone know a good way find and remove duplicate records from a table? I can create an identical table structure and use a script to pull records from the existing table and insert them into the new table if they are not duplicates, but I'd rather not do it that way. Here is an example of an sql script I use for Oracle databases delete from employee a whererowid ( select max(rowid) fromemployee b where b.COL1 = a.COL1 and b.COL2 = a.COL2 and b.COL# = a.COL#); sql, query Thanks in advance! - 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: Odd Question on automatic start of Mysql upon boot
The setup command, at the command prompt type setup this will bring up a configuration tool (Im running RH7.2), one of the choices is System Services, under that you can adjust services to start/stop automatically upon boot. This is done after an RPM install or installation upon OS install. This was how I automated the starting and stopping of the MYSQL service. As for the safe_mysqld concern, I was just wondering if there were any caveats to running mysql under safe_mysqld? Is this the normal process name that mysql runs under? I was expecting mysqld or mysql.server to be the process found when running the command ps -ef. I guess Im just reading into the safe_mysql naming convention. From what Im interpretting your statements below as is this: safe_mysql is the normal process that mysql runs under and there is no security issues with this process. Thanks for the help, hopefully above clears up what I was trying to say. ~dK -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 5:38 PM To: David Kramer; [EMAIL PROTECTED] Subject: Re: Odd Question on automatic start of Mysql upon boot At 10:24 -0700 7/26/02, David Kramer wrote: I automated the MYSQL start up process using the setup command. the setup command? Everything works fine except that I noticed safe_mysql is the daemon running, shouldnt this be mysqld or mysql.server? I suppose it depends on what the setup command does... If it installs mysql.server, what you observe wouldn't be unusual, because mysql.server starts safe_mysqld, which starts mysqld. Im completely lost here, and I feel running Safe_mysql is a major security issue? Why? What problems do you think this causes? Anyone's thoughts on this? Thx, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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
Odd Question on automatic start of Mysql upon boot
I automated the MYSQL start up process using the setup command. Everything works fine except that I noticed safe_mysql is the daemon running, shouldnt this be mysqld or mysql.server? Im completely lost here, and I feel running Safe_mysql is a major security issue? Anyone's thoughts on this? Thx, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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
Can access DBs when started w/ safe_mysql but not with mysqld????
I am able to access all of the database instances that I have created when starting Mysql with safe_mysql(as root user). As soon as I start mysql any other way, I keep getting the Access Denied Error. Can root only access DBs under safe_mysql? Im completely lost here Thanks, DK David Kramer Reflect.com - 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: Can access DBs when started w/ safe_mysql but not with mysqld????
Ok thats what I was guessing, so I need to create a new user for the DB seperate from the root. Do I chown the binaries and database files to my new user? Or Do the binaries always stay to root? Thanks much! DK -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 11:08 AM To: David Kramer Cc: [EMAIL PROTECTED] Subject: Re: Can access DBs when started w/ safe_mysql but not with mysqld The mysql user should own the databases and files, not root. David Kramer wrote: I am able to access all of the database instances that I have created when starting Mysql with safe_mysql(as root user). As soon as I start mysql any other way, I keep getting the Access Denied Error. Can root only access DBs under safe_mysql? Im completely lost here Thanks, DK David Kramer Reflect.com - 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: Using Inner Join in MySQL
It depends on the size of the tables that you are joining together. Can you index any of the columns that you are joining? If you post the query that you are trying to execute I might be able to help you more. DK -Original Message- From: Carlos Rovetto [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 12:32 PM To: [EMAIL PROTECTED] Subject: Using Inner Join in MySQL Hi. I want know why the time of response is slowly when i make a Join between two tables using sql query in MySQL. I don't have more experience in MySQL Carlos _ MSN. Más Útil cada Día. http://www.msn.es/intmap/ - 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
Cant start server after reboot - Please Help!
I tried to automate the starting and stopping of the mysql service upon reboot. I created the two links for mysql.server to the associated rc.d directories(rc0.d and rc3.d). I rebooted my RH 7.2 box and nothing happened. The real kicker is that I cant even manually start mysqld mysqld start. Im completely lost here, please help! Thanks, dK David Kramer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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: Cant start server after reboot - Please Help!
Just to clarify, I should always boot mysql using safe_mysqld, I thought this was used only for setting up your initial database and setting the root password. Most Documenation I found said to use it mysql.server as the start up process.. Thanks for the Help!!! DK -Original Message- From: Chaitanya Diwadkar [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 10:44 AM To: 'David Kramer'; [EMAIL PROTECTED] Subject: RE: Cant start server after reboot - Please Help! You should be using 'safe_mysqld ' (v3.2) or 'mysqld_safe ' for v4.0. Did you look at the hostname.err file to see what the problem was? This file should be in the same location as hostname.pid file. -Chait -Original Message- From: David Kramer [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 9:46 AM To: [EMAIL PROTECTED] Subject: Cant start server after reboot - Please Help! I tried to automate the starting and stopping of the mysql service upon reboot. I created the two links for mysql.server to the associated rc.d directories(rc0.d and rc3.d). I rebooted my RH 7.2 box and nothing happened. The real kicker is that I cant even manually start mysqld mysqld start. Im completely lost here, please help! Thanks, dK David Kramer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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 - 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: Cant start server after reboot - Please Help!
Matt, I tried this and still no cigar. The only difference that I could see was that the mysql.server file location was different, i.e. /usr/local/share/mysql/mysql.server, mine exists in /usr/share/mysql/mysql.server. I altered the script to reflect this but still the process does not start. Also I noticed that there was already a mysqld script in /etc/rc.d/init.d, I renamed and then created yours. Thoughts/Ideas? Thanks for the help! DK -Original Message- From: Matthew Scarrow [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 12:32 PM To: [EMAIL PROTECTED]; David Kramer Subject: Re: Cant start server after reboot - Please Help! Here's a small script to use for automaticly starting the mysqld demaon. Cut and Past it into a file and call it mysqld then save it in the /etc/rc.d/init.d directory. Upon reboot you should see that you mysql server is up and running ( use ps -A as root and look for the mysqld pid's). As for using mysqld start to start the server manualy won't work use safe_mysqld . #!/bin/sh # description: mysql # chkconfig: 2345 99 00 case $1 in 'start') /usr/local/share/mysql/mysql.server start touch /var/lock/subsys/mysqld ;; 'stop') /usr/local/share/mysql/mysql.server stop ;; *) echo Usage: $0 { start | stop } ;; esac exit 0 -- Original Message -- From: David Kramer [EMAIL PROTECTED] Date: Thu, 11 Jul 2002 09:45:51 -0700 I tried to automate the starting and stopping of the mysql service upon reboot. I created the two links for mysql.server to the associated rc.d directories(rc0.d and rc3.d). I rebooted my RH 7.2 box and nothing happened. The real kicker is that I cant even manually start mysqld mysqld start. Im completely lost here, please help! Thanks, dK David Kramer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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 - 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: MySQL install on Linux 7.1
Are you using RPM or installing from source, i.e. running make? Also if you need to find where files are located change to root directy cd / then type find -name mysql that will get you started as to where your mysql files are located. The find command is very helpful when searching for files, its very similar to windows start menu search utility. Just make sure you change to the most parent directory to run the search, as find traverses from the Present Working Directory PWD forward. Also the best doc I have found is on the mysql.com site itself: http://www.mysql.com/doc/ You will find everything you need there... Good Luck and Welcome to Linux. David Kramer -Original Message- From: Marvin Cummings [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 9:13 AM To: [EMAIL PROTECTED] Subject: MySQL install on Linux 7.1 Hey can someone provide me some help in installing and configuring mysql ver3.23.51 on my Linux server? I downloaded the file from mysql.com to my servers hard drive and now want to install it. I right-clicked the installation file and clicked install. It appears to have installed something, but I can't find it. I looked in the /var/lib directories and don't see anything. Though the installation steps are covered somewhat on mysql.com, I'm still having problems as I'm totally new to linux. Any documented steps from a newbie's perspective or something simple would be really helpful. Any help is appreciated. - 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
NEWBIE: Access Denied Errors after Rebooting
I was able to login and generate a database instance, but then got a little crazy and tried to automate the starting and stopping of the mysql service. I copied the mysql.server file to my /etc/init.d directory and then created the necessary links to the rc0.d and rc3.d directories. When I rebooted the mysql were not started, plus when I tried to manually start the services, trying both mysqld and mysql.server, I get an unable to located the mysql socket file. Can anyone explain to my what Im doing wrong here? Even though I didnt setup the automation piece correctly shouldnt I still be able to start the service manually? Also what is the difference between mysqld and mysql.server? Are they the same? Within the my.cnf I noticed the user assignment is equal to mysql, currently Im logging in as root, could the problem be that I need to generate a user called mysql? Sorry for the 20 questions, just trying help someone help me trouble shoot! Thanks much, DK PS Im running Redhat 7.2 - 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: NEWBIE - trouble creating Databases Acess Denied...
Victoria thanks for the response but I was able to solve my issue already. Yes I needed to run mysql_install_db then I started the safe_mysql --skip-grant, logged on as root without password and updated the root user's password on the user table. Thanks for the help!!! DK David -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 9:23 AM To: [EMAIL PROTECTED] Subject: Re: NEWBIE - trouble creating Databases Acess Denied... David, Tuesday, July 09, 2002, 12:04:52 AM, you wrote: DK I keep getting Access Denied Errors when I try to login to MySql after DK running mysql_install_db script. I ran the mysql_install_db script, made DK suer the mysql process is running(checked it using netstat -a), changed the DK ownership on the binaries and then tried to gain access using the command: DK mysql -u root mysql, which didnt work and, I also tried using the command: DK mysqladmin -u root password new_password which didnt work. Both commands DK still prompt me for a password, when I try to enter a password, I then get DK the Access Denied Error. Can someone point me in the direction please? Any DK insight would be GREATLY appreciate as I have been stuck on this for over a DK week now! Did you have installed MySQL server before or you run mysql_install_db after installation? mysql_install_db doesn't re-create grant tables if they exist. In this case use your old password. If you install MySQL at the first time user 'root' doesn't have a password. Check also the following link, it may help you: http://www.mysql.com/doc/A/c/Access_denied.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
NEWBIE - trouble creating Databases Acess Denied...
I keep getting Access Denied Errors when I try to login to MySql after running mysql_install_db script. I ran the mysql_install_db script, made suer the mysql process is running(checked it using netstat -a), changed the ownership on the binaries and then tried to gain access using the command: mysql -u root mysql, which didnt work and, I also tried using the command: mysqladmin -u root password new_password which didnt work. Both commands still prompt me for a password, when I try to enter a password, I then get the Access Denied Error. Can someone point me in the direction please? Any insight would be GREATLY appreciate as I have been stuck on this for over a week now! Thanks, DK David Kramer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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