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, 2002 3:30 PM To: Subject: Fatal error: Please read Security section of the manual to find out how to run mysqld as root! This happens when I try to start the mysql daemon. I have checked the manual, but cannot fathom what else I am supposed to do. Here is what has been done so far: ./scripts//mysql_install_db seemed to initialize the MySQL db's ok. I also executed the following statements without issue: chown -R root /usr/local/mysql chown -R mysql /usr/local/mysql/data chgrp -R mysql /usr/local/mysql ./bin/mysqladmin --version dows return the version of MySQL ok. ./bin/safe_mysqld --user=mysql and got the following: [root@cofr3 mysql]# ./bin/safe_mysqld --user=mysql Starting mysqld daemon with databases from /var/lib/mysql 021122 12:31:41 mysqld ended Regards, Ken Illingsworth - 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: Fatal error: Please read Security section of the manual to find out how to run mysqld as root!
i see. there is an option in my.cnf which says which user to run mysqld as. change this to mysql. make sure that mysql is a real user on your system. also, be sure to set the full path to the basedir and datadir in the my.cnf user = mysql basedir = /usr/local/mysql datadir = /usr/local/mysql/data or whatever your paths are. -Original Message- From: Kenneth Illingsworth [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 4:06 PM To: [EMAIL PROTECTED] Subject: RE: Fatal error: Please read Security section of the manual to find out how to run mysqld as root! Thank you for pointing that our. I never edited the my.cnf file, and those two variables were way off. I edited them to their correct values and here is the result: [root@cofr3 mysql]# ./bin/safe_mysqld --user=mysql [1] 4774 [root@cofr3 mysql]# Starting mysqld daemon with databases from /mysql/data 021122 15:57:25 mysqld ended [1]+ Done./bin/safe_mysqld --user=mysql -- I believe that this change is certainly a step in the right direction. However, the original error is quite persistant: [root@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 Stephens [EMAIL PROTECTED] 11/22/02 03:40PM 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, 2002 3:30 PM To: Subject: Fatal error: Please read Security section of the manual to find out how to run mysqld as root! This happens when I try to start the mysql daemon. I have checked the manual, but cannot fathom what else I am supposed to do. Here is what has been done so far: ./scripts//mysql_install_db seemed to initialize the MySQL db's ok. I also executed the following statements without issue: chown -R root /usr/local/mysql chown -R mysql /usr/local/mysql/data chgrp -R mysql /usr/local/mysql ./bin/mysqladmin --version dows return the version of MySQL ok. ./bin/safe_mysqld --user=mysql and got the following: [root@cofr3 mysql]# ./bin/safe_mysqld --user=mysql Starting mysqld daemon with databases from /var/lib/mysql 021122 12:31:41 mysqld ended Regards, Ken Illingsworth - 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
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 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 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 query - 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: 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::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 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: 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]' Subject: RE: perl dbi and mysql question Of course, you could have also used: $stmt = $db-prepare(show databases); Peter ^_^ -Original Message- From: Shon Stephens [mailto:sstephens;corp.goamerica.net] Sent: Friday, November 08, 2002 9:50 AM To: Shon Stephens; '[EMAIL PROTECTED]' Subject: 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::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 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 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 user (besides root) that can show databases, Use Show_db_priv after 4.0.2, before 4.0.2 user can see all databases if mysqld is running without --skip-show-database option. SS show tables SS from every database, User can't see tables if he doesn't have any rights on them. SS lock all tables, There is Lock_tables_priv since 4.0.2, before 4.0.2 user must have SELECT, UPDATE, DELETE, INSERT to lock tables. SS and flush all tables. You need RELOAD_priv. SS what permissions SS should i grant to this user? -- 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
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, 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
using load_file...problems
sql/mysql i am trying to insert data into a blob column. its not working. i have tried setting --local-infile=1. i tried granting file to my user and got an error. i have read the manaul (for all you smarties who like to rtfm everyone) and still don't get it. here is what i did for grant 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 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 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, October 29, 2002, 7:01:47 PM, you wrote: SS i am trying to insert data into a blob column. its not working. i have tried SS setting --local-infile=1. i tried granting file to my user and got an error. SS i have read the manaul (for all you smarties who like to rtfm everyone) and SS still don't get it. here is what i did for grant SS grant file on db.tablename to user; SS ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual which SS privileges can be used. SS in the above case user already exists. FILE is a global level privilege, you can give FILE_priv on a table. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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
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: 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: 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 i configure/make/make install mysql-3.23.51 on sparc solaris using SS gcc-2.95.2. i used the configure option --sysconfdir=/usr/local/etc. SS i ran the mysql_install_db script, i performed all the chown/chgrp SS operations, i copied mysql.server to /etc/rc3.d/S99mysql. i copied SS my-huge.cnf to /usr/local/etc/my.cnf and edited this to add some SS different options. when i start mysql, the my.cnf file was not SS loading. i could tell because some of the options i specified were SS not being run. i copied my.cnf to /etc/my.cnf and tried again. SS everything worked. why? i changed the sysconfdir during SS configuration. option --sysconfdir is supported by configure, not by MySQL. You can't specify another location for my.cnf than /etc/my.cnf DATADIR/my.cnf ~/.my.cnf -- 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
more weird my.cnf foo???
i recompiled/reinstalled 3.23.51. i copied mysql.server /etc/rc3.d/S99mysql. i edited /usr/local/etc/my.cnf. i started mysql and it read the my.cnf file from that location and everything worked great. i created a solaris package and installed it on another system. the system the package was installed on is a clone (exact except ip address) of the system that it was compiled on. so i start mysql on the second system, and it doesn't see (load) /usr/local/etc/my.cnf. now why is that? yesterday when i posted, i figured that i must not have properly configured when i compiled. that seemed 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
safe_mysqld - my.cnf weird foo
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 i configure/make/make install mysql-3.23.51 on sparc solaris using gcc-2.95.2. i used the configure option --sysconfdir=/usr/local/etc. i ran the mysql_install_db script, i performed all the chown/chgrp operations, i copied mysql.server to /etc/rc3.d/S99mysql. i copied my-huge.cnf to /usr/local/etc/my.cnf and edited this to add some different options. when i start mysql, the my.cnf file was not loading. i could tell because some of the options i specified were not being run. i copied my.cnf to /etc/my.cnf and tried again. everything worked. 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 SIGNATURE- - 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
relocatable mysql?? - off topic??
i use mysql on a number of different systems, all of which are sun hardware running solaris. i compile mysql from source myself, and create software packages using sun's utilities. i now have need on some systems to put mysql in /usr/local and in /opt on others. i only want to compile mysql 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 stephens - 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
what permissions do i need to set
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 i have an application that will allow me to rotate mysql table using date variable substition. in other words table=tblname.%m%d%Y if i am using a remote system to host the application, what permissions to i need to give the remote application 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/AwUBPRivpBerBYVUKJeKEQLNsgCg19LSGf9BrgqodVjACoeAZJVo3gIAoN/v z6I9zjzmbCZWpKZlGiJ0yQU2 =Gxyx -END PGP SIGNATURE- - 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 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 - 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
perl mysql DBI::db question
i am trying to write a program in perl and am getting a mysql error from my module. here is the error: DBI::db=HASH(0x294738)-disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at ./pop.pl line 124, GEN1 line 2. i think a finish statement is what i need, but i don't know how to exec it properly. here is the code loop that generates this message my $sql_check = $dbh-prepare(select user,password,prefs from users where username='$LNAME'); # I dont like the 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 S: $t_user,$t_password,$t_prefs\n; } 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: perl mysql DBI::db question
i am using the older v1.19 DBI. i looked at that line and it should not cause a problem. the values are stored, even after the handle is destroyed or the connection closed. the error is complaining that i should destroy statement handles or call finish. thanks for the respones. - Original 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 after it prints out the fetchrow_array() my ($t_user,$t_password,$t_prefs) = $sql_check-fetchrow_array(); if($debug_state) { print S: $t_user,$t_password,$t_prefs\n; } $dbh-disconnect(); If your using an older version of DBI, like 1.13 or .14 you may need to call the finish() after you execute() your statement handle. sql,database,mysql On Wed, 27 Feb 2002 11:07:51 -0500, Shon Stephens [EMAIL PROTECTED] wrote: i am trying to write a program in perl and am getting a mysql error from my module. here is the error: DBI::db=HASH(0x294738)-disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at ./pop.pl line 124, GEN1 line 2. i think a finish statement is what i need, but i don't know how to exec it properly. here is the code loop that generates this message my $sql_check = $dbh-prepare(select user,password,prefs from users where username='$LNAME'); # I dont like the 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 S: $t_user,$t_password,$t_prefs\n; } Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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
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. 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 is this? It's created when that field is the first field in a multi-field index. For example: mysql describe mytable; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | id| int(11) | YES | | NULL| | | val | char(5) | YES | | NULL| | +---+-+--+-+-+---+ 2 rows in set (0.38 sec) mysql alter table mytable add index qq(id,val); mysql describe mytable; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | id| int(11) | YES | MUL | NULL| | | val | char(5) | YES | | NULL| | +---+-+--+-+-+---+ 2 rows in set (0.00 sec) -Original Message- From: Shon Stephens [mailto:[EMAIL PROTECTED]] Sent: Friday, February 01, 2002 10:24 AM To: [EMAIL PROTECTED] Subject: 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. 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 [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 +VCS?
Has anyone on this list used Veritas Cluster Server to build an HA MySQL solution? If so, please email me. I am in the process of attempting to do this. So far, I have been able to deal well with the hardware agents (network, disk, nfs, cpu). However, when it comes to creating software agents 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.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 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 - 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 determination of hostname?
How does MySQL determine hostnames when checking access permissions? I assume it uses whatever methods are available to the system (/etc/hosts, NIS, DNS, etc...). Will it use those services in the order they are listed in nsswitch.conf (Solaris)? What about for determining its local 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL General Questions
I have read the documentation thoroughly, however there are still some things unclear to me, and others that I want opinions on. I am dismayed at what I see as a fundamental lack of server administration documentation. Much of the docs focus on the SQL aspects of MySQL. There is only a minor portion dealing with server administration. Most of which deals with installation, starting/stopping MySQL, and minor database administration. I would like to see more from a true System Administrators point of view. I am still unclear as to how MySQL utilizes memory. I believe that for each client thread, there is a portion of memory only for that client, and then there is some memory that is shared between all clients. Is this correct? How can I tell how much memory is being used by a single client? What is the difference, if any, in MySQL parlance between a thread, and a connection? I want to be able to look at my server and see if the physical system is giving good performance, or if I need to provide more resources. I don't really know how to do this for MySQL though. I have written some applications to use data from various MySQL databases on my server. However, I am trying to find the best way to write these applications. If a client has a (thread/connection) to the MySQL server, can that thread support multiple simultaneous queries? Obviously this question is loaded, but lets say I am using Sendmail tied to MySQL. Would it be better to write a sendmail that for each daemon running, has a persistent connection to the MySQL database, and uses that connection to query for each piece of mail it delivers. Or would it be better for my Sendmail to open a new connection for each piece of mail? I have seen the max_connections variable, and have adjusted this at least once. However, what does MySQL consider a connection? Backups, backups, backups? What is the best way to do a backup? What about table maintennance? If I use myisamchk or another command line tool, do those lock the tables? If so, what kind of lock? If I run a CHECK table from using the interactive mysql, do I need to lock the tables first? I know these are a lot of questions, if you have an answer to all or any part, email me directly please. Also, if you would like to include additional information please do so. I am not really a DBA, and am looking 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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/write to file '/tmp/root-tmp.03a811f23b28d045/files/#sql61ba_d_0.MYI' (Errcode: 2) /tmp dir permission is 777 so there shouldn't be problem. When i create dir which mysql wants to write to everything is ok. MySQL server, works as mysql user. What's wrong? By the way, should mysql create tmpdir as root-tmp, not mysql-tmp ? - 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
Change options during MySQL compile???
I understand that mysqld will normally look in /etc for the my.cnf file when it starts. I would like to change this behavior so that it will look in /usr/local/etc. I know that I can do this with a command line option, but I want this to be the default behavior. I thought the the configure 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 Stephens [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
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 filter out the lines for other databases and tables, but a more automatic version of this would be nice. Any pointers? -- Michael T. Babcock CTO, FibreSpeed - 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: 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 method I can use to log into a remote mysql server through something such as telnet to pass queries on my database? - 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 vs. Oracle
I am currently trying to examine the benefits of continuing to use MySQL over Oracle. I need to know what MySQL's features are vs. those of Oracle. Also I am looking for performance data. What kind of scalability does MySQL have vs. that of Oracle. Is there (or will there be) any support 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/ (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
HA Setup for MySQL
I recently started experimenting with a way to setup MySQL to be load-balanced. I installed 2 servers with MySQL, NFS mounted the /mysql/var directory, then moved the grant tables to /mysql/grant, and created a symbolic link from /mysql/var/mysql to /mysql/grant. This appeared to work correctly, however, my tables soon began to show corruptions, and sometimes when an insert was made, and then immediately following a select statement was made against that data, it would not be found. I figured this was due to memory cache not being flushed to disk before the select statement. So the other server would have no record of the data. I adjusted the server settings so that data was always written to disk. This solved that problem 99.99% of the time. However, I was wondering if perhaps the server doesn't always try and select from the table on disk, but rather the table in memory. So that if server 1 inserts data into the table and writes it to disk, then server 2 selects data but only from the table it has loaded into memory it won't be able to select the new data? Has anyone ever tried something like this? Also, I want to try setting up replication such as A - 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? Thanks, Shon Stephens - 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: HA Setup for MySQL
I'm not sure if that was a problem or not. I am actually very interested in the second part of my query regarding replication. An earlier post mentioned that if I am using A - B - A replication behind a load-balancer, that I may lose performance. I am only slightly concerned with update performance, and am more concerned with select performance. I believe that if the tables between the 2 systems can be kept syncronized reliably, that I will can a performance increse for selects by using the load-balancer. This is good because the majority of my apps do selects. I want 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. Shon Stephens wrote: I recently started experimenting with a way to setup MySQL to be load-balanced. I installed 2 servers with MySQL, NFS mounted the /mysql/var directory, then moved the grant tables to /mysql/grant, and created a symbolic link from /mysql/var/mysql to /mysql/grant. This appeared to work correctly, however, my tables soon began to show corruptions, and sometimes when an insert was made, and then immediately following a select statement was made against that data, it would not be found. I figured this was due to memory cache not being flushed to disk before the select statement. So the other server would have no record of the data. I adjusted the server settings so that data was always written to disk. This solved that problem 99.99% of the time. However, I was wondering if perhaps the server doesn't always try and select from the table on disk, but rather the table in memory. So that if server 1 inserts data into the table and writes it to disk, then server 2 selects data but only from the table it has loaded into memory it won't be able to select the new data? Has anyone ever tried something like this? Also, I want to try setting up replication such as A - 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? Thanks, Shon Stephens - 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 -- Gerald L. Clark [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