Why does safe_mysqld runs as root?

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

RE: Why does safe_mysqld runs as root?

;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

RE: Why does safe_mysqld runs as root?

[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

Mysql starts under XFS on boot up???

] 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

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

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,

Looking for sample my.cnf

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

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]

my.cnf settings and running admin commands such as mysqldump or mysqladmin

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

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

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

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.

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

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

RE: removing duplicate records

-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

RE: Odd Question on automatic start of Mysql upon boot

, 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

Odd Question on automatic start of Mysql upon boot

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

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

RE: Can access DBs when started w/ safe_mysql but not with mysqld????

: 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

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:

Cant start server after reboot - Please Help!

. 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

RE: Cant start server after reboot - Please Help!

- 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

RE: Cant start server after reboot - Please Help!

/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

RE: MySQL install on Linux 7.1

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

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

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

NEWBIE - trouble creating Databases Acess Denied...

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