compiling libwrap support fails - why?

o use to optimize this build for my platform, i intend to use this mysql as a backend for a mail server...so it will have a high insert/query load. thanks, shon -- "power off einstein" - moe syzlak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

mysql monitoring?

is there an snmp mib or something available for snmp to monitor mysql server? or, does anyone have a script that they would like to share that they use to monitor and gather statistics about mysql? thanks, shon - Before posting

RE: Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

ot@cofr3 mysql]# ./bin/mysqld -L /mysql/share/mysql/english Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! 021122 16:00:58 Aborting 021122 16:00:58 ./bin/mysqld: Shutdown Complete Regards, Ken Illingsworth >>> Shon Stephen

RE: Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

you say you chown -R mysql /usr/local/mysql/data, yet the error shows mysql trying to start with databases from /var/lib/mysql. check your startup script for basedir and datadir settings. -Original Message- From: Kenneth Illingsworth [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 20

RE: mysql permissions

thank you victoria! -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko@;ensita.net] Sent: Friday, November 08, 2002 12:07 PM To: [EMAIL PROTECTED] Subject: re: mysql permissions Shon, Friday, November 08, 2002, 4:46:19 PM, you wrote: SS> i need to create a u

RE: perl dbi and mysql question

yeah, but i was looking for a function. mostly just to see if a matching function to dbh->tables() existed. -Original Message- From: Grigor, Peter [mailto:pgrigor@;aseedge.com] Sent: Friday, November 08, 2002 10:07 AM To: 'Shon Stephens'; '[EMAIL PROTECTED]' Su

RE: perl dbi and mysql question

eureka! i found it! @dbs = $dbh->func('_ListDBs'); -Original Message----- From: Shon Stephens [mailto:sstephens@;corp.goamerica.net] Sent: Friday, November 08, 2002 9:45 AM To: '[EMAIL PROTECTED]' Subject: perl dbi and mysql question i am using perl dbi with dbd::m

mysql permissions

i need to create a user (besides root) that can show databases, show tables from every database, lock all tables, and flush all tables. what permissions should i grant to this user? thanks, shon [don't bounce me as spam] mysql sql

perl dbi and mysql question

i am using perl dbi with dbd::mysql. i know that using the dbi function, $dbh->tables (), will list all the tables in a database. is there a function that will show all the databases on a server? thanks, shon - Before post

mysql backup user permissions?

i want to add a user to my system that has permissions to backup all the databases using mysqlhotcopy. i don't want to use the root user. so what permissions (minium set) should i give the user in order to accomplish this. thanks in advance,

RE: using load_file...problems

i also figured out that load_file only works on the local server, not from clients...duh! thanks! -Original Message- From: Egor Egorov [mailto:egor.egorov@;ensita.net] Sent: Tuesday, October 29, 2002 12:19 PM To: [EMAIL PROTECTED] Subject: re: using load_file...problems Shon, Tuesday

using load_file...problems

grant file on db.tablename to user; ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual which privileges can be used. in the above case "user" already exists. thanks, shon - Before posting, please

RE: safe_mysqld - my.cnf weird foo

thanks victoria. now that is cleared up for me. -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 8:41 AM To: [EMAIL PROTECTED] Subject: Re: safe_mysqld - my.cnf weird foo Shon, Tuesday, July 16, 2002, 10:45:19 PM, you wrote: SS>

my.cnf - pulled out all my hair

can anyone tell me how to make mysql read my.cnf from /usr/local/etc instead of /etc? i tried configuring with --sysconfdir=/usr/local/etc at compile time. that is not working. thanks, shon - Before posting, please check

more weird my.cnf foo???

to be the case, but now i am not so sure. thanks, shon - 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 &l

safe_mysqld - my.cnf weird foo

. why? i changed the sysconfdir during configuration. thanks, shon -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQA/AwUBPTR5NBerBYVUKJeKEQJT4QCg4ArpWivNyS7NcFDH7ZzvwxeOBNMAnRmz s7PW6dmrp8CiS1VmksYtTPQx =iJNl -END PGP SIG

relocatable mysql?? - off topic??

once, and use relocatable packages. is this possible? second, i have other programs, such as perl dbi, which use the mysql libs. how can i compile once, create a relocatable package, and still have my supported programs function properly? thanks, shon ste

what permissions do i need to set

user so that it can properly select,update,insert records into existing tables, and create new tables as it needs to? thanks, shon -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQA/AwUBPRivpBerBYVUKJeKEQLNsgCg19LSGf9BrgqodVjACoeAZJVo3g

RE: Need help

check that the file exists. also check that the user that mysql is running as has the appropriate permissions to read/write that file. run the "perror" command. -Original Message- From: Bertrand TACHAGO [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 09:16 To: [EMAIL PROTECTED] Sub

mysql 3.22.32 table checking

i am running mysql version 3.22.32. yes i am planning an upgrade. in the meantime, i need to check (and possibly) repair my tables without bringing down the mysql daemon. thanks, Shon Stephens 540.942.7292 office 540.649.3508 mobile shon8work aim

Re: perl mysql DBI::db question

Message - From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]> To: "Shon Stephens" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, February 27, 2002 11:32 AM Subject: Re: perl mysql DBI::db question Try moving your $dbh->disconnect call afte

perl mysql DBI::db question

below die statement, it should exit gracefully. $sql_check->execute or die "Can't connect to users table : $dbh-errstr"; my ($t_user,$t_password,$t_prefs) = $sql_check->fetchrow_array(); $dbh->disconnect; if($debug_state) { print

Re: what type of key is this?

thanks, that did the trick just fine. shon - Original Message - From: "Rick Emery" <[EMAIL PROTECTED]> To: "'Shon Stephens'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, February 01, 2002 11:55 AM Subject: RE: what type of key

what type of key is this?

i have been asked to create an sql table with a certain structure. i was sent a description of the table. the first column is desribed as having a "MUL" key. i don't now what that is or how to create it. can someone please help

MySQL +VCS?

for MySQL, I am struggling. If anyone (even those who haven't attempted this) has any ideas for software agents, please respond. Thanks Shon Stephens [EMAIL PROTECTED] - Before posting, please check: http://www.mysq

MySQL Log Management

I am looking for some suggestions for MySQL log management. Just some people to respond to this message with their log rotation, and archival methods. I am just curious to see what others are doing, and to possibly suggest a method for myself to use. Thanks, Shon Stephens

MySQL determination of hostname?

? Does it use the hostname function? Thanks, Shon - 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 <[EM

MySQL General Questions

oking for more information from an SA point of view. Thanks, Shon - 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 &l

Re: Mysql and tmp dir problem

Have you checked that /tmp isn't full? If /tmp is its own filesystem, and its full, then no matter what the permissions you won't be able to write to it. At 10:24 PM 10/2/01 +0200, you wrote: >When execcuting some queries in MySQL (3.23.42) on Redhat 7.1 i'v got >error: >ERROR 1: Can't create/w

Change options during MySQL compile???

option "--sysconfdir" would do this. It did not. Does anyone know how to do this? Also, I know how to compile mysqld with extra character sets, is there anyway to limit the character sets that are built? I don't want support for all of the character sets, just a few. Thanks, Shon

Re: mysqlbinlog

perl script At 08:50 AM 8/9/01 -0400, Michael T. Babcock wrote: >I would like to dump all sql transactions from a binary transaction log >for a specific table after a specific timestamp. I can run mysqlbinlog >and delete all the queries up to the point of the correct timestamp, then >try to filt

Re: Remote MySQL Console?

Setup a user account that can access your databases from the remote hosts you wish to use. Do this using GRANT. Then install the mysql client on those systems and use mysql -h hostname -u user -p password to connect. Shon Stephens At 01:38 PM 8/5/01 -0400, Chris wrote: >Is there a metho

MySQL vs. Oracle

rt in MySQL for something akin to Oracle's Parallel Server? Can I use MySQL with Veritas? Thanks, Shon Stephens - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: HA Setup for MySQL

to know if an update to server A updates server B will server A ignore the update when it comes in from server B? Thanks, Shon Stephens At 01:44 PM 7/13/01 -0500, Gerald Clark wrote: >I don't believe NFS locking is reliable enough to allow two >servers to serve the same databases.

HA Setup for MySQL

-> B -> A. I want to be able to put both system behind a load-balancing switch. If an insert is done on server A, then server B is updated, then server B sends an update to server A, will server A know to ignore it since it originated from server A? Thank