Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)
I figured it out. Actualy silly me forgot to add the password() function how embarising. :) -- Jerry M. Howell II -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)
> now allowing clients to login but I'm not sure what would cuse it not to > allow root to change the password, I dubble and triple checked my entry > but still nothing happens. Once I login to root I do the following > > mysql> use mysql > mysql> UPDATE user SET Password= ('x') > -> WHERE user='root'; > > Here is the response I get > > Query OK, 0 rows affected (0.01 sec) > Rows matched: 4 Changed: 0 Warnings: 0 > > Not sure why nothing is changed? Anyideas. Might root not have the > privlage? if so, how might I be able to change the password? > -- > Jerry M. Howell II > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > Just disregard that last post. I tried to change the password to the same password. Still, it's not letting root login with a set password. -- Jerry M. Howell II -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: question about lock tables and unlock table
Hi Steven, Just one UNLOCK TABLES. :-) From http://www.mysql.com/doc/en/LOCK_TABLES.html "LOCK TABLES locks tables for the current thread. UNLOCK TABLES releases any locks held by the current thread. All tables that are locked by the current thread are implicitly unlocked when the thread issues another LOCK TABLES, or when the connection to the server is closed." BTW, you can't do INSERTs when the table(s) are locked with a READ lock. ;-) Need a WRITE lock for that. Hope that helps. Matt - Original Message - From: "Steven Wu" Sent: Friday, September 05, 2003 4:57 PM Subject: question about lock tables and unlock table > Hi Need some help here: > > if I have two tables, alertLog, videoLog needed to lock during some > processing as: > > mysql> LOCK TABLE alertLog READ, videoLog READ > > after two tables are lock and do some INSERT, > > mysql> INSERT INTO alertLog(alert); > mysql> INSERT INTO videoLog(video); > > > My question is DO I NEED ONE OR TWO "UNLOCK TABLES" to > release the locking ? so > >Is the answer ? > mysql>UNLOCK TABLES > mysql>UNLOCK TABLES > > or just > > mysql>UNLOCK TABLES > > > thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)
On Fri, Sep 05, 2003 at 01:34:01PM -0400, Fortuno, Adam wrote: > Jerry, > > Don't forget that MySQL authenticates an entity, which is based on the user > name and host. For example, on my MySQL boxes root can only login from the > localhost. If I attempt to login with root from another host, I am denied > access. > True, by default it does, I ssh'ed into the mysql server and did it that way. Actualy it apears that now it's not changeing the password. It's now allowing clients to login but I'm not sure what would cuse it not to allow root to change the password, I dubble and triple checked my entry but still nothing happens. Once I login to root I do the following mysql> use mysql mysql> UPDATE user SET Password= ('x') -> WHERE user='root'; Here is the response I get Query OK, 0 rows affected (0.01 sec) Rows matched: 4 Changed: 0 Warnings: 0 Not sure why nothing is changed? Anyideas. Might root not have the privlage? if so, how might I be able to change the password? -- Jerry M. Howell II -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 2-Questions: Starting MySQL and Shutting Down on OS X
On 9/5/03 7:47 AM, "Fortuno, Adam" <[EMAIL PROTECTED]> wrote: > All: > > (1) I've got "/user/local/mysql/data" in my path, but when I attempt to run > "mysqld_safe" I get a message reading: > > "Please do a cd to the mysql installation directory and restart this script > from there as follows: ./bin/mysqld_safe" > > Do I really need to be in the installation directory to kick-off the MySQL > server? If so, why? > > (2) Anyone running OS X have a good way to automatically shut MySQL server > before shutdown. Currently, I've got to do it manually. If someone else sits > at my workstation, they may or may not restart/shutdown without shutting > down the server. Before I invest time in trying to resolve, let me know if > there is something quick and easy out there. > > Regards, > Adam > > <> > Adam, Take a look at the message I just sent to the mysql forum [Script] applescript_launch_mysqld_osx (launches & shuts down mysqld) Best regards, Bill Hernandez Plano, Texas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Script] applescript_launch_mysqld_osx (launches & shuts down mysqld)
OSX - OSX Here's some new OSX AppleScript application... This script that I wrote allows you to launch and shutdown the mysql server on osx... If you are using Explorer 5.2 or better, or Netscape 7.1 or thereabouts http://mac-specialist.com/r/ascript_launch_mysqld_osx.html Or if you are using safari (has problems with javascript redirects) http://mac-specialist.com/test/applescript/mysql/ Hope it's useful... Bill Hernandez Plano, Texas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Anyone using MySQL with kernel 2.6 / RedHat 9.0?
Chris Nolan wrote: Hi all! Is anyone running MySQL on Linux kernel 2.6 or the kernel shipped with RedHat 9.0? I am curious as to the impact of the new thread implementation on MySQL's stellar performance (I like picking on the Oracle, MS SQL Server and Foxpro admins that I have to work with. What exactly is a Foxpro admin anyway? Do they reindex things and nothing else?). Regards, Chris I've just installed MySQL-4.0.14 on an Athlon XP 2000 ( running a fresh Gentoo installation with a 2.6-test4 kernel ). I haven't noticed any performance issues. I haven't done any benchmarking either. At least there are no obvious problems anyway. It's been very well behaved :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Link error when using prepared statements in mysql 4.1.0 alph a
Thank you Mike. I would like to continue development on this version, so I will try out the BK. I got the linking errors fixed. Those were from the definitions missing in the export file. Is there a release date planned for 4.1.1? Thanks! AMit > -Original Message- > From: Mark Matthews [mailto:[EMAIL PROTECTED] > Sent: Friday, September 05, 2003 4:55 PM > To: Amit Jindal > Cc: '[EMAIL PROTECTED]' > Subject: Re: Link error when using prepared statements in mysql 4.1.0 > alpha > > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Amit Jindal wrote: > > > Hi, I am trying to use mysql 4.1.0 C client (libmysql.lib) and I am > getting > > link errors. > > I checked the libmysql.lib and it doesn't seems to have > these symbols. > > > > > > Linking... > > SimpleInsertSelect.obj : error LNK2001: unresolved external symbol > > [EMAIL PROTECTED] > > SimpleInsertSelect.obj : error LNK2001: unresolved external symbol > > [EMAIL PROTECTED] > > SimpleInsertSelect.obj : error LNK2001: unresolved external symbol > > [EMAIL PROTECTED] > > SimpleInsertSelect.obj : error LNK2001: unresolved external symbol > > [EMAIL PROTECTED] > > SimpleInsertSelect.obj : error LNK2001: unresolved external symbol > > [EMAIL PROTECTED] > > Debug/SimpleTest.exe : fatal error LNK1120: 5 unresolved externals > > Error executing link.exe. > > > > > > This is from a pre-built version that I downloaded from mysql.com > > Do I need to get the sources and recompile the library with > some setting? > > I tried using the provided MSVC project file and got this error: > > ctype-latin1_de.c > > fatal error C1083: Cannot open source file: > > > 'D:\WorkDownloads\MySQL\mysql-4.1.0-alpha-src\mysql-4.1.0-alph > a\strings\ctyp > > e-latin1_de.c': No such file or directory > > ctype-mb.c > > > > Do I need to do some steps before compiling this? > > > > > > I will appreciate help on this. > > - AMit > > > > > > These are all known issues that have been solved in the current source > tree for quite some time, which you can compile yourself (from BK), or > you can wait until MySQL-4.1.1 is released (which is a better option). > > Regards, > > -Mark > > - -- > Mr. Mark Matthews > MySQL AB, Software Development Manager, J2EE and Windows Platforms > Office: +1 708 557 2388 > www.mysql.com > > Are you MySQL Certified? > http://www.mysql.com/certification/ > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.2.3 (MingW32) > Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org > > iD8DBQE/WRRFtvXNTca6JD8RAknNAJ491xSUgFAfLHGeMTeEn+gH2BxCVQCfSlrh > sh7Lr+pRAfNN0mNh6wK1+n0= > =syw9 > -END PGP SIGNATURE- > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Link error when using prepared statements in mysql 4.1.0 alpha
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Amit Jindal wrote: > Hi, I am trying to use mysql 4.1.0 C client (libmysql.lib) and I am getting > link errors. > I checked the libmysql.lib and it doesn't seems to have these symbols. > > > Linking... > SimpleInsertSelect.obj : error LNK2001: unresolved external symbol > [EMAIL PROTECTED] > SimpleInsertSelect.obj : error LNK2001: unresolved external symbol > [EMAIL PROTECTED] > SimpleInsertSelect.obj : error LNK2001: unresolved external symbol > [EMAIL PROTECTED] > SimpleInsertSelect.obj : error LNK2001: unresolved external symbol > [EMAIL PROTECTED] > SimpleInsertSelect.obj : error LNK2001: unresolved external symbol > [EMAIL PROTECTED] > Debug/SimpleTest.exe : fatal error LNK1120: 5 unresolved externals > Error executing link.exe. > > > This is from a pre-built version that I downloaded from mysql.com > Do I need to get the sources and recompile the library with some setting? > I tried using the provided MSVC project file and got this error: > ctype-latin1_de.c > fatal error C1083: Cannot open source file: > 'D:\WorkDownloads\MySQL\mysql-4.1.0-alpha-src\mysql-4.1.0-alpha\strings\ctyp > e-latin1_de.c': No such file or directory > ctype-mb.c > > Do I need to do some steps before compiling this? > > > I will appreciate help on this. > - AMit > > These are all known issues that have been solved in the current source tree for quite some time, which you can compile yourself (from BK), or you can wait until MySQL-4.1.1 is released (which is a better option). Regards, -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 557 2388 www.mysql.com Are you MySQL Certified? http://www.mysql.com/certification/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQE/WRRFtvXNTca6JD8RAknNAJ491xSUgFAfLHGeMTeEn+gH2BxCVQCfSlrh sh7Lr+pRAfNN0mNh6wK1+n0= =syw9 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Testing again
Sorry for the waste of bandwidth. I need to make sure my autoreply doesn't send to the list. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Testing
Testing my autoreply. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
question about lock tables and unlock table
Hi Need some help here: if I have two tables, alertLog, videoLog needed to lock during some processing as: mysql> LOCK TABLE alertLog READ, videoLog READ after two tables are lock and do some INSERT, mysql> INSERT INTO alertLog(alert); mysql> INSERT INTO videoLog(video); My question is DO I NEED ONE OR TWO "UNLOCK TABLES" to release the locking ? so Is the answer ? mysql>UNLOCK TABLES mysql>UNLOCK TABLES or just mysql>UNLOCK TABLES thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems with make test for 4.0.14
Hi, I'm trying to compile MySQL 4.0.14 on a server which was previously using RPMs, and although the ./configure (with no arguments) and make steps went fine, make test does not want to work. The error I am getting is : "/home/programs/mysql/4.0.14/mysql-4.0.14/mysql-test/var/run/master.pid was not created in 30 seconds; Aborting" (full make test output at the bottom of this message). What's wrong, and what should I do to correct this? Thanks! Pierre-Luc Soucy Full make test output: [EMAIL PROTECTED] mysql-4.0.14]# make test cd mysql-test ; ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/master-data --skip-innodb --skip-bdb --language=../sql/share/english/ 030905 22:18:12 ../sql/mysqld: Shutdown Complete Installing Slave Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/slave-data --skip-innodb --skip-bdb --language=../sql/share/english/ 030905 22:18:12 ../sql/mysqld: Shutdown Complete Manager disabled, skipping manager start. Loading Standard Test Databases Starting Tests TEST RESULT -- alias [ pass ] alter_table[ pass ] analyse[ pass ] ansi [ pass ] auto_increment [ pass ] backup [ pass ] bdb-alter-table-1 [ skipped ] bdb-alter-table-2 [ skipped ] bdb-crash [ skipped ] bdb-deadlock [ skipped ] bdb[ skipped ] bdb_cache [ skipped ] bench_count_distinct [ pass ] bigint [ pass ] binary [ pass ] bool [ pass ] bulk_replace [ pass ] case [ pass ] cast [ pass ] check [ pass ] comments [ pass ] compare[ pass ] constraints[ pass ] convert[ pass ] count_distinct [ pass ] count_distinct2[ pass ] create [ pass ] ctype_cp1251 [ pass ] ERROR: /home/programs/mysql/4.0.14/mysql-4.0.14/mysql-test/var/run/master.pid was not created in 30 seconds; Aborting make: *** [test] Error 1 [EMAIL PROTECTED] mysql-4.0.14]# -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Command not found
Here is another strange question: When I use "show databases", it shows me that I only have one database called "test", and no database called "mysql" show up. However, I go back to the shell, under the "/usr/local/mysql/data/", it shows me that I Do have a database called "mysql" including host, user, tables_priv, func, db, colummns_priv. Any suggestions? Thanks, Hon > On Friday, Sep 5, 2003, at 15:02 US/Eastern, hongbin liu wrote: > > Thank you so much. I changed the profile according to what you guys > > told me, > > and add "/usr/local/mysql/bin" to the profile. Guess what? It works > > great! > > > > But I am not sure if I did the right thing: my computer uses bash, I > > could > > not find either .bash_profile. There is only one file named "profile" > > under > > the "/etc/" directory. So I just put the "/usr/local/mysql/bin" into > > the > > directory, and it works! > > Adding that to the /etc/profile file will add it to the $PATH for all > users, while adding it to a .profile or .bash_profile file will add it > only for the particular user. Just so you have your permissions set > correctly on the mysql binaries. > > Glad it works... > > pjm > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Round Question
If the ceil function won't do it you can truncate it and add 1. Ty... -Original Message- From: Dan Greene [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 2:12 PM To: Fabio Bernardo; Mysql (E-mail) Subject: RE: Round Question what I've done is select ceil(value) (not sure if ceil is the function on MySQL, but there is a ceiling function, I'm sure...) > -Original Message- > From: Fabio Bernardo [mailto:[EMAIL PROTECTED] > Sent: Friday, September 05, 2003 2:59 PM > To: Mysql (E-mail) > Subject: Round Question > > > I write this command: > > Select round(1.1) > and obtain 1 as answer > Is there a round command to obtain 2 as answer. I mean, in Excel this > command is knwon as RoundUp! > > thanks a lot > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Encrypt/protect Database
This may be a weird question, but we were wondering if there was some sort of way to encrypt or protect the database just in case of someone hacking into the server it resides on. Since there might be some sensitive info in the database, we'd like to go to as great a lengths as possible (only usernames, etc., but still...). We already plan on just reading and writing to those fields when necessary with an SSL, but would there be any other options other than hoping my host runs all the updates when they need to and have a good firewall? Any help is greatly appreciated. Thanks in advance. -Bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Round Question
Hi, I tried: Select ceiling(1.2) It worked and returned "2". HTH Allen > -Original Message- > From: Dan Greene [mailto:[EMAIL PROTECTED] > Sent: Friday, September 05, 2003 12:12 PM > To: Fabio Bernardo; Mysql (E-mail) > Subject: RE: Round Question > > > > what I've done is > > select ceil(value) > > (not sure if ceil is the function on MySQL, but there is a > ceiling function, I'm sure...) > > > -Original Message- > > From: Fabio Bernardo [mailto:[EMAIL PROTECTED] > > Sent: Friday, September 05, 2003 2:59 PM > > To: Mysql (E-mail) > > Subject: Round Question > > > > > > I write this command: > > > > Select round(1.1) > > and obtain 1 as answer > > Is there a round command to obtain 2 as answer. I mean, in Excel this > > command is knwon as RoundUp! > > > > thanks a lot > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1, derived tables, and privileges
Michael Johnson <[EMAIL PROTECTED]> wrote: > I hope someone can help me on this. I've searched the mailing list > archives and the manual and can't find anything, except for user comments > in the manual that confirm what I'm finding. > > I'm using derived tables users with restricted privileges. The only way I > can get the derived tables to work though is to give the user global > SELECT privileges. I don't want to do this. Am I missing something? If > not, is there a way around this problem? > > The error I get is: > >#1142 - select command denied to user: '[EMAIL PROTECTED]' >for table '/tmp/#sql_135_0' > > > My select looks something like: > > SELECT t1id as "Key", IFNULL(k2, dfltValue) as "Value" > FROM t1 > NATURAL JOIN > (SELECT t1id, k2 > FROM t2 WHERE k3=1) as derived; > > My tables have the columns: > > t1: t1id, dfltValue > 1 a > 2 b > > t2: t1id, k2, k3 > 1c 1 > 1d 2 > 2e 2 > > Note that not all values of t1id exist in t2 for a given k3. Hence, this > select gets all t1id keys with a default value if it doesn't exist in t2. > > > Desired result: > > Key Value >1c >2b > > > The privileges for [EMAIL PROTECTED] are: > > No global priveleges (setting Create_tmp_table_priv makes no difference) > t1: SELECT, REFERENCES > t2: SELECT, INSERT, UPDATE, REFERENCES > > > If I grant global SELECT it works as expected. Again, > create_tmp_table_priv is irrelevant at this point. > > Any thoughts on why this is working like this? > > Thanks, > Michael > > PS If there is a better way to do this query, I'd like to know that, too, > but I've run into this problem at other places where I *know* I have to > use derived tables, so the problem is still pertinent to my use. Thanks for bug report! It was added to the bug database: http://bugs.mysql.com/bug.php?id=1199 > -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Command not found
On Friday, Sep 5, 2003, at 15:02 US/Eastern, hongbin liu wrote: Thank you so much. I changed the profile according to what you guys told me, and add "/usr/local/mysql/bin" to the profile. Guess what? It works great! But I am not sure if I did the right thing: my computer uses bash, I could not find either .bash_profile. There is only one file named "profile" under the "/etc/" directory. So I just put the "/usr/local/mysql/bin" into the directory, and it works! Adding that to the /etc/profile file will add it to the $PATH for all users, while adding it to a .profile or .bash_profile file will add it only for the particular user. Just so you have your permissions set correctly on the mysql binaries. Glad it works... pjm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Round Question
what I've done is select ceil(value) (not sure if ceil is the function on MySQL, but there is a ceiling function, I'm sure...) > -Original Message- > From: Fabio Bernardo [mailto:[EMAIL PROTECTED] > Sent: Friday, September 05, 2003 2:59 PM > To: Mysql (E-mail) > Subject: Round Question > > > I write this command: > > Select round(1.1) > and obtain 1 as answer > Is there a round command to obtain 2 as answer. I mean, in Excel this > command is knwon as RoundUp! > > thanks a lot > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Link error when using prepared statements in mysql 4.1.0 alpha
Hi, I am trying to use mysql 4.1.0 C client (libmysql.lib) and I am getting link errors. I checked the libmysql.lib and it doesn't seems to have these symbols. Linking... SimpleInsertSelect.obj : error LNK2001: unresolved external symbol [EMAIL PROTECTED] SimpleInsertSelect.obj : error LNK2001: unresolved external symbol [EMAIL PROTECTED] SimpleInsertSelect.obj : error LNK2001: unresolved external symbol [EMAIL PROTECTED] SimpleInsertSelect.obj : error LNK2001: unresolved external symbol [EMAIL PROTECTED] SimpleInsertSelect.obj : error LNK2001: unresolved external symbol [EMAIL PROTECTED] Debug/SimpleTest.exe : fatal error LNK1120: 5 unresolved externals Error executing link.exe. This is from a pre-built version that I downloaded from mysql.com Do I need to get the sources and recompile the library with some setting? I tried using the provided MSVC project file and got this error: ctype-latin1_de.c fatal error C1083: Cannot open source file: 'D:\WorkDownloads\MySQL\mysql-4.1.0-alpha-src\mysql-4.1.0-alpha\strings\ctyp e-latin1_de.c': No such file or directory ctype-mb.c Do I need to do some steps before compiling this? I will appreciate help on this. - AMit -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems adding native functions
Hi! On Sep 05, Gustavo Castro wrote: > Hello, i?m running the Mysql 3.23.57 version in Suse 7.1 and i can?t > add new functions to it. I?ve tried with native functions but just > in the first step, as it appears in the tutorial, > when addding my line in the lex.h file, like this > > {"GET_UPDATE", SYM(FUN_ARG1),0,CREATE_FUNC(create_func_get_update)} you should define the function create_func_get_update() see item_create.cc, item_create.h > i get this compilation error > "In file included from lex_hash.h: 19 > from sql_lex.cc: 76 > was not declared in this scope". > sql_lex.cc line 76 is the #include "lex_hash.h" and > lex_hash.h line 19 is #include "lex.h". > > And still with the tutorial, how do i do the third step? > Thank you very much! Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FULLTEXT search
At 10:09 PM 9/5/2003, Chris Nolan wrote: Mike, What a brilliant idea! Seriously, setting up a community fund to sponsor this (and perhaps in future other things) might be something to consider. The only questions that come to mind are: 1. Which would be more effective, setting up a fund for this sort of thing or just going out and buying licences for MySQL/InnoDB and/or InnoDB hot backup? I think you're on the right track. MySQL & Innodb could add a check box on their order form that says something like "Please donate $50 towards the InnoDb FullText search project". (MySQL AB can use any dollar amount that they're comfortable with. I only used $50 as an example) This will help MySQL AB get more licenses and InnoDb could sell more Hot Backups. When the donations reach a specific level, InnoDb starts work on the FullText search feature. 2. What sort of amount would be required to sponsor it? Only Heikki can answer that. It is definitely a feature that is long overdue. If people like me are staying with MyISAM tables because InnoDb lacks FullText support, then it's also impacting InnoDb's Hot Backup sales. So it is in their own best interest to get started on the project. :) Mike On Fri, 2003-09-05 at 14:36, mos wrote: > At 08:56 PM 9/4/2003, you wrote: > >Hi all, > > > >At the moment, we all know that InnoDB does not yet have FULLTEXT > >indexes. This is not another message asking as to when we will have that > >functionality. > > > >This message is different. On the mailing list for DBMail, we've been > >discussing MySQL table types, with everyone highlighting the fact that > >MyISAM does not support transactions while InnoDB does (in addition to > >foreign keys). Then, I raised the point that MyISAM may not have > >transactions, but it does have FULLTEXT indexes, which could be a > >massive source of speed for MyISAM-based tables. > > > >My question is this: Obviously, if you throw SQL statements enclosed in > >BEGIN/COMMIT and issue ROLLBACK statements on MyISAM tables, MyISAM does > >the right thing and ignores it (personally, I think it would be better > >if it alerted the nearest admin, so that they could come and deal with > >any person touching their finely tuned database server). > > > >Is the converse-ish statement true? Is there any way that FULLTEXT > >searches could be executed on InnoDB (and other type) tables currently > >or with a quick patch that uses a full table scan? I'd be willing to get > >together with a few people to write such a thing, as it would speed > >development while FULLTEXT is a MyISAM exclusive while still allowing > >testing against all MySQL tables in the immediate future. > > > >Regards, > > > >Chris > > Chris, > I agree with you, FullText in InnoDb would be nice. It is one > reason why I'm sticking with MyISAM tables. I suppose you could modify > MySQL to implement FullText on InnoDb tables but then who would support it? > It would be a variant of MySQL. It would be better if InnoDb implements it > so they would support it in all future MySQL versions. > > Heikki did mention a year ago that he would consider implementing > FullText searching if a client was willing to fund it. Unfortunately he > didn't say how much $ it would take. I would be willing to kick in $100 to > see it happen. If enough people got together, perhaps we can encourage him > to do it. I suspect not having FullText in InnoDb is a major hurdle that > is forcing people to stay with MyISAM tables. > > Mike > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: reserved words and column titles
Shawn McGinn <[EMAIL PROTECTED]> wrote: > I am trying to install a sourceforge application and in one of the > tables in the db, there is a column whose name is 'default'. When > installed on MySql version 4.1.0-alpha-standard, this works fine, but I > really need it to run on version 3.22.27. Is there a workaround? I > really don't want to edit the code. > 3.22.27 is too old version. If you use reserved word in database/table/column names, you should quote names with backticks (`). But it's supported only since v3.23.6. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Round Question
I write this command: Select round(1.1) and obtain 1 as answer Is there a round command to obtain 2 as answer. I mean, in Excel this command is knwon as RoundUp! thanks a lot
Auto Create Reports?
Does anyone know how to set up a function to automatically generate reports from a MySQL database? For example, I have a table that gets populated with users when they register. I want to be able to have it automaticaly create a report every 12 hours (or however long) that will generate specific information. I'm sure there is some way of doing this, but I have no clue. Any info would be greatly appreciated. Thanks in advance. -Bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Command not found
Parker & Mike: Thank you so much. I changed the profile according to what you guys told me, and add "/usr/local/mysql/bin" to the profile. Guess what? It works great! But I am not sure if I did the right thing: my computer uses bash, I could not find either .bash_profile. There is only one file named "profile" under the "/etc/" directory. So I just put the "/usr/local/mysql/bin" into the directory, and it works! Thank you a bunch! Regards, Hon -Original Message- On Friday, Sep 5, 2003, at 10:24 US/Eastern, Parker Morse wrote: > You'll need to edit the .bashrc file in your home directory to add the > /usr/local/mysql/bin directory to the search path if you want to avoid > typing the full path. Another alternative is to place links to the > binaries in one of the directories already in the path, like > /usr/bin/. I should correct myself - the file to look at is .bash_profile, not .bashrc, at least in RH 9.0. Or .tcsh_profile (or .tcshrc) if you use tcsh - I don't, so I'm not certain which file it would be in. And, as Mike suggests, check to make sure the MySQL client is there at /usr/local/mysql/bin/mysql. It might be that simple. pjm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 10:30 AM To: Parker Morse Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Command not found Also make sure you installed both the server and the client for MySQL. And of course if you're not running bash, put the path to the MySQL directory in the correct shell file. For example, I prefer the tsch shell, so I would put it in the .tcshrc file in my home directory. If you're not familiar with Linux, take a look at some of the commands at http://www.reallylinux.com/docs/consult.shtml. If you want a book, http://www.amazon.com/exec/obidos/ASIN/0972679006/qid%3D1041438546/sr%3D11-1 /ref%3Dsr%5F11%5F1/103-4038995-5196662 will get you a quick start. Parker Morse <[EMAIL PROTECTED]To: [EMAIL PROTECTED] m> cc: [EMAIL PROTECTED] Subject: Re: Command not found 09/05/2003 09:24 AM On Friday, Sep 5, 2003, at 00:51 US/Eastern, [EMAIL PROTECTED] wrote: > I installed the MySQL 4.0 on my Linxus machine (red hat 7.3). The > installation > shows no problem, and I can see that the 'mysqld' server is actually > runing > through a command like "./bin/mysqladmin version". However, it just > does not > allow me to switch to the mysql client program from my login shell. > Whenever I > try to do so, it also says that "bash: mysql: command not found". > > I don't know how to deal with it. Could some MySQL experts please > kindly help > me with this? It's not a MySQL issue, it's a Linux issue. If your MySQL binaries are installed in a directory like /usr/local/mysql/bin/, they're not in one of the directories your shell (probably bash) looks in for commands. (To see which directories are being searched, type "echo $PATH" at the shell prompt.) You'll need to edit the .bashrc file in your home directory to add the /usr/local/mysql/bin directory to the search path if you want to avoid typing the full path. Another alternative is to place links to the binaries in one of the directories already in the path, like /usr/bin/. pjm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fulltext Index and Unicode (MySQL 4.1)
Andreas Schwarz <[EMAIL PROTECTED]> wrote: > > is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2) > fields in 4.1? > Nope. Fulltext search doesn't work with multi-byte character sets. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems adding native functions
Hello, i´m running the Mysql 3.23.57 version in Suse 7.1 and i can´t add new functions to it. I´ve tried with native functions but just in the first step, as it appears in the tutorial, when addding my line in the lex.h file, like this {"GET_UPDATE", SYM(FUN_ARG1),0,CREATE_FUNC(create_func_get_update)} i get this compilation error "In file included from lex_hash.h: 19 from sql_lex.cc: 76 was not declared in this scope". sql_lex.cc line 76 is the #include "lex_hash.h" and lex_hash.h line 19 is #include "lex.h". And still with the tutorial, how do i do the third step? Thank you very much!
Problem with UDF
Hello, i´m running the Mysql 3.23.57 version with Suse 7.1, and i´m getting problems trying to add UDFs to my MySQL - In /mysql/sql/tipo.h i´ve declared this data type: typedef struct st_del { int empty; char *table; List keys; }BUFFER_DEL; where List is included from the sql_list.h, also in this directory. - In /mysql/client/get_update.cc, which is the file with the functionality i wanna add i do a #include and declare a variable (BUFFER_DEL buf_del;), and then compile it like this g++ -shared -I/mysql/sql -o get_update.so get_update.cc but it gives me a compilation problem in the List line referring to the first function in the sql_list.cc which i didn´t modify. Can anyone help me, please?
Re: 2-Questions: Starting MySQL and Shutting Down on OS X
http://www.serverlogistics.com/mysql.php has a link to a Preference Pane item that can be used to start and stop MySQL. You will need to modify the /Library/StartupItems/MySQL/MySQL file to point to the correct location. -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ > From: Santino <[EMAIL PROTECTED]> > Date: Fri, 5 Sep 2003 19:22:12 +0200 > To: [EMAIL PROTECTED] > Subject: Re: 2-Questions: Starting MySQL and Shutting Down on OS X > > You have to make a script and put it in a folder (sorry I don't > remember the name but it is on /System/startup) Try to locate a shell > script like cron in a cron directory and modify it creating a script > mysql in a mysql directory. > To start: > cd /user/local/mysql/data > ./bin/mysqld_safe & > > To stop > mysqladmin shutdown > > Santino > > At 8:47 -0400 5-09-2003, Fortuno, Adam wrote: >> All: >> >> (1) I've got "/user/local/mysql/data" in my path, but when I attempt to run >> "mysqld_safe" I get a message reading: >> >> "Please do a cd to the mysql installation directory and restart this script >> from there as follows: ./bin/mysqld_safe" >> >> Do I really need to be in the installation directory to kick-off the MySQL >> server? If so, why? >> >> (2) Anyone running OS X have a good way to automatically shut MySQL server >> before shutdown. Currently, I've got to do it manually. If someone else sits >> at my workstation, they may or may not restart/shutdown without shutting >> down the server. Before I invest time in trying to resolve, let me know if >> there is something quick and easy out there. >> >> Regards, >> Adam >> >> <> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fulltext Index and Unicode (MySQL 4.1)
Hello, is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2) fields in 4.1? Andreas -- AVR-Tutorial, über 350 Links Forum für AVRGCC und MSPGCC -> http://www.mikrocontroller.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SOLVED Re: MySQL 4.0.14 stops responding to PHP 4.3.2
On Friday, Sep 5, 2003, at 13:41 US/Eastern, Thierno Cissé wrote: Finally you seem to say that you 've setting max_connections with a limit. Can you tell how many 100 or 200 ? No. It turns out that setting max_connections to 0 is the same as setting no limit at all. This was my initial misunderstanding. The server is not currently in danger of overload, and I am sysadmin, DBA and primary web developer (small company), so I am free to work with no restrictions until I feel they're necessary. Also you say : Here's the configuration: MySQL Ver 12.21 Distrib 4.0.14, for pc-linux (i686) PHP 4.3.2 Red Hat 9.0 Have you enable QUERY CACHE feature with MySQL 4.0.14 ? Not that I'm aware of. As I said in my first post, I'm familiar with MySQL from the web developer's standpoint, but this is my first experience running and tuning the server. I'm sure there's a lot of things I could be doing to configure it better, but it's not clear to me yet what they are. It's pretty much a default configuration now, with my_large.cnf with a few tweaks as the my.cnf file. pjm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to correct error code 1006
Thanks, that helped me find the solution. -Original Message- From: Diana Soares [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 12:27 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: How to correct error code 1006 # perror 13 Error code 13: Permission denied Check the ownership (and permissions) of your . Maybe your is owned by user "mysql" and not "mysqladmin" and then "mysqladmin" can't write to . You may find what your datadir is with: # mysqladmin var | grep datadir Hope this helps, On Fri, 2003-09-05 at 17:42, Jonathan Villa wrote: > I installed MySQL 4.0.14-standard from binary onto a Red Hat 8.0 system. > I always follow the steps described in INSTALL-BINARY as well as review > what shows up when I type ./configure. > > The only thing I did this time around was that I changed the user's name > from mysql to mysqladmin. I get the follow error when trying to create > a new database: > > #1006 - Can't create database 'demo'. (errno: 13) > > Does anyone know the fix to this? -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: php version
On Friday, September 05, 2003 6:22 PM CET, Cory Lamle wrote: > Your best bet is to grab 4.3.1 or greater > > Windows version even has gui installer... > http://us2.php.net/get/php-4.3.3-installer.exe/from/a/mirror actually it's all the same which version you take (from 4.1 on). but for win32, you'll only find the latest version on the php.net site anyway. -- Yves Goergen [EMAIL PROTECTED] Please don't CC me (causes double mails) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: SOLVED Re: MySQL 4.0.14 stops responding to PHP 4.3.2
Hi, Finally you seem to say that you 've setting max_connections with a limit. Can you tell how many 100 or 200 ? Also you say : > Here's the configuration: > MySQL Ver 12.21 Distrib 4.0.14, for pc-linux (i686) > PHP 4.3.2 > Red Hat 9.0 Have you enable QUERY CACHE feature with MySQL 4.0.14 ? Regards Thierno6C -Original Message- From: Parker Morse [mailto:[EMAIL PROTECTED] Sent: vendredi 5 septembre 2003 15:01 To: [EMAIL PROTECTED] Subject: SOLVED Re: MySQL 4.0.14 stops responding to PHP 4.3.2 On Thursday, Sep 4, 2003, at 12:47 US/Eastern, Parker Morse wrote: > No, it turns out this is not the key. With mysql_connect() I'm > actually failing MORE often than with mysql_pconnect - so far it > hasn't stayed up 15 minutes without error. (Fortunately, I have a cron > job checking on it and restarting.) However, this did put me on to the problem. I was tripping resource limits. When I was first setting up the server and getting the individual sites/users working in the mysql.user table, I saw the max_connections column set to 0 and thought that was a problem; I didn't realize that 0 meant "no limit". So I set a limit. I was running up on the connection limits, which meant mysqld was refusing further connections until my server restart reset the counts to 0. With mysql_connect I had more connections, and thus reached the limit faster. Now I have reset the max_connections numbers to 0, and I haven't had a failure in twenty hours, so I think I can call this problem solved. Thanks for your help. In the course of sorting it out, I also learned a good deal about debugging mysql errors gracefully in PHP. pjm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)
Jerry, Don't forget that MySQL authenticates an entity, which is based on the user name and host. For example, on my MySQL boxes root can only login from the localhost. If I attempt to login with root from another host, I am denied access. Regards, Adam -Original Message- From: Jerry M. Howell II [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 1:24 PM To: [EMAIL PROTECTED] Subject: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Hey there all, Here is the problem I am haveing and was wondering if anyone can help me here. I was getting the following error when loging into mysql ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) After searching for an answer I found the answer was to re-start using --skip-grant-tables and change the password then restart mysql useing the normal startup script. This worked well. The next step is where I run into problems. After I log into mysql in the normal mode and reset the password I go back to ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:YES). Also, other users are reporting that they can't access thier databases. Based on what I am seeing here I am able to login to mysql as root as long as there is no password. Once I set a password it wont let me connect. Also found that users can't login to the databases. Does anyone have any idea whats going on and how I might be able to resove this problem? Thanks, -- Jerry M. Howell II -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to correct error code 1006
# perror 13 Error code 13: Permission denied Check the ownership (and permissions) of your . Maybe your is owned by user "mysql" and not "mysqladmin" and then "mysqladmin" can't write to . You may find what your datadir is with: # mysqladmin var | grep datadir Hope this helps, On Fri, 2003-09-05 at 17:42, Jonathan Villa wrote: > I installed MySQL 4.0.14-standard from binary onto a Red Hat 8.0 system. > I always follow the steps described in INSTALL-BINARY as well as review > what shows up when I type ./configure. > > The only thing I did this time around was that I changed the user's name > from mysql to mysqladmin. I get the follow error when trying to create > a new database: > > #1006 - Can't create database 'demo'. (errno: 13) > > Does anyone know the fix to this? -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Link error when using prepared statements in mysql 4.1.0 alpha
Hi, I am trying to use mysql 4.1.0 C client (libmysql.lib) and I am getting link errors. I checked the libmysql.lib and it doesn't seems to have these symbols. Linking... SimpleInsertSelect.obj : error LNK2001: unresolved external symbol [EMAIL PROTECTED] SimpleInsertSelect.obj : error LNK2001: unresolved external symbol [EMAIL PROTECTED] SimpleInsertSelect.obj : error LNK2001: unresolved external symbol [EMAIL PROTECTED] SimpleInsertSelect.obj : error LNK2001: unresolved external symbol [EMAIL PROTECTED] SimpleInsertSelect.obj : error LNK2001: unresolved external symbol [EMAIL PROTECTED] Debug/SimpleTest.exe : fatal error LNK1120: 5 unresolved externals Error executing link.exe. This is from a pre-built version that I downloaded from mysql.com Do I need to get the sources and recompile the library with some setting? I tried using the provided MSVC project file and got this error: ctype-latin1_de.c fatal error C1083: Cannot open source file: 'D:\WorkDownloads\MySQL\mysql-4.1.0-alpha-src\mysql-4.1.0-alpha\strings\ctyp e-latin1_de.c': No such file or directory ctype-mb.c Do I need to do some steps before compiling this? I will appreciate help on this. - AMit -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 2-Questions: Starting MySQL and Shutting Down on OS X
You have to make a script and put it in a folder (sorry I don't remember the name but it is on /System/startup) Try to locate a shell script like cron in a cron directory and modify it creating a script mysql in a mysql directory. To start: cd /user/local/mysql/data ./bin/mysqld_safe & To stop mysqladmin shutdown Santino At 8:47 -0400 5-09-2003, Fortuno, Adam wrote: All: (1) I've got "/user/local/mysql/data" in my path, but when I attempt to run "mysqld_safe" I get a message reading: "Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe" Do I really need to be in the installation directory to kick-off the MySQL server? If so, why? (2) Anyone running OS X have a good way to automatically shut MySQL server before shutdown. Currently, I've got to do it manually. If someone else sits at my workstation, they may or may not restart/shutdown without shutting down the server. Before I invest time in trying to resolve, let me know if there is something quick and easy out there. Regards, Adam <> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
Hey there all, Here is the problem I am haveing and was wondering if anyone can help me here. I was getting the following error when loging into mysql ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) After searching for an answer I found the answer was to re-start using --skip-grant-tables and change the password then restart mysql useing the normal startup script. This worked well. The next step is where I run into problems. After I log into mysql in the normal mode and reset the password I go back to ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:YES). Also, other users are reporting that they can't access thier databases. Based on what I am seeing here I am able to login to mysql as root as long as there is no password. Once I set a password it wont let me connect. Also found that users can't login to the databases. Does anyone have any idea whats going on and how I might be able to resove this problem? Thanks, -- Jerry M. Howell II -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Very slow connexion
Hi, This problem is specific to the WAN connexion, not to the LAN connexion. I've a Sun Fire 880, 8 Go RAM, Solaris 8 and MySQL 4.0.13 64 bits. The first connexion to the database is about 15s to 30s (too slow). Is there a known problem about MySQL connexion (paramaters, bugs ;-) ) or is it a network problem ? Best regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FULLTEXT search
Mike, What a brilliant idea! Seriously, setting up a community fund to sponsor this (and perhaps in future other things) might be something to consider. The only questions that come to mind are: 1. Which would be more effective, setting up a fund for this sort of thing or just going out and buying licences for MySQL/InnoDB and/or InnoDB hot backup? 2. What sort of amount would be required to sponsor it? Regards, Chris On Fri, 2003-09-05 at 14:36, mos wrote: > At 08:56 PM 9/4/2003, you wrote: > >Hi all, > > > >At the moment, we all know that InnoDB does not yet have FULLTEXT > >indexes. This is not another message asking as to when we will have that > >functionality. > > > >This message is different. On the mailing list for DBMail, we've been > >discussing MySQL table types, with everyone highlighting the fact that > >MyISAM does not support transactions while InnoDB does (in addition to > >foreign keys). Then, I raised the point that MyISAM may not have > >transactions, but it does have FULLTEXT indexes, which could be a > >massive source of speed for MyISAM-based tables. > > > >My question is this: Obviously, if you throw SQL statements enclosed in > >BEGIN/COMMIT and issue ROLLBACK statements on MyISAM tables, MyISAM does > >the right thing and ignores it (personally, I think it would be better > >if it alerted the nearest admin, so that they could come and deal with > >any person touching their finely tuned database server). > > > >Is the converse-ish statement true? Is there any way that FULLTEXT > >searches could be executed on InnoDB (and other type) tables currently > >or with a quick patch that uses a full table scan? I'd be willing to get > >together with a few people to write such a thing, as it would speed > >development while FULLTEXT is a MyISAM exclusive while still allowing > >testing against all MySQL tables in the immediate future. > > > >Regards, > > > >Chris > > Chris, > I agree with you, FullText in InnoDb would be nice. It is one > reason why I'm sticking with MyISAM tables. I suppose you could modify > MySQL to implement FullText on InnoDb tables but then who would support it? > It would be a variant of MySQL. It would be better if InnoDb implements it > so they would support it in all future MySQL versions. > > Heikki did mention a year ago that he would consider implementing > FullText searching if a client was willing to fund it. Unfortunately he > didn't say how much $ it would take. I would be willing to kick in $100 to > see it happen. If enough people got together, perhaps we can encourage him > to do it. I suspect not having FullText in InnoDb is a major hurdle that > is forcing people to stay with MyISAM tables. > > Mike > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: web hosting/PHP MyAdmin
Matt, Hey. I use www.powweb.com they have a plan for $7.77 a month, 650MB storage, blah blah blah give them a look... The important thing is that they have PHP and I believe command line access, you'll have to use a MySQL client to connect (seperate MySQL server). I hate to sound like I'm promoting but if you decide to go with them, they have a referal program and they'll give me a month free when I re-up, if you could tell them that I sent you my site is www.mapleave.net I would appreciate it! HTH, Ryan --- "Matthew K. Gold" <[EMAIL PROTECTED]> wrote: > Hi, > > I need to move my site to a host that supports PHP and MySQL. I found a > nice deal that provides a lot of good stuff for an affordable price > (sitelutions.com is offering 5 MySQL databases, PHP support, cgi, etc etc > for $9.95/month). > > There's only one problem--they don't allow you to edit the MySQL databases > through a shell--you have to use a web-based control panel and phpMyAdmin. > > My problem is that I'm used to editing my MySQL databases through the shell, > and I find the phpMyAdmin admin kind of confusing. > > I have two questions: > > 1. Was anyone out there in my position before, but then once you tried > phpMyAdmin, you found that you liked it a lot? > > 2. Does anyone know of any better, or equal deals out there that also allow > shell access? > > Thanks very much in advance for your help. > > best, > > Matthew Gold > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: Help with #1111 - Invalid use of group function
Hi, >SELECT TD.project_id, P.project_manager >FROM time_daily TD >INNER JOIN projects P ON P.project_id = TD.time_project_id >WHERE TD.time_user_id = 'xpt' AND ( >SUM( TD.time_hours_worked ) <> '0.00' an Paul Dibois said: You cannot use aggregate functions like SUM() in the WHERE clause. And He is right (of curse). But you can use an alias of a formarly selected SUM() in a HAVING clause. If i understood your query, this migth help: SELECT TD.project_id, P.project_manager, SUM( TD.time_hours_worked ) as a_sum FROM time_daily TD INNER JOIN projects P ON P.project_id = TD.time_project_id WHERE TD.time_user_id = 'xpt' GROUP BY TD.project_id , P.project_manager HAVING a_sum <> '0.00' I hope I understood the query the right way. prosit Klaus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: How can I select the column names?
Hi, >I am trying to select the column names from a table to be displayed in a >web page. Is there anyway to select column names without desc? I don't now, if it makes a difference to 'DESCRIBE' but you can do: SHOW COLUMNS FROM [LIKE ...]; prosit Klaus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems with UDFs
Hello, i´m running the Mysql 3.23.57 version with Suse 7.1, and i´m getting problems trying to add UDFs to my MySQL - In /mysql/sql/tipo.h i´ve declared this data type: typedef struct st_del { int empty; char *table; List keys; }BUFFER_DEL; where List is included from the sql_list.h, also in this directory. - In /mysql/client/get_update.cc, which is the file with the functionality i wanna add i do a #include and declare a variable (BUFFER_DEL buf_del;), and then compile it like this g++ -shared -I/mysql/sql -o get_update.so get_update.cc but it gives me a compilation problem in the List line referring to the first function in the sql_list.cc which i didn´t modify. Can anyone help me, please?
How to correct error code 1006
I installed MySQL 4.0.14-standard from binary onto a Red Hat 8.0 system. I always follow the steps described in INSTALL-BINARY as well as review what shows up when I type ./configure. The only thing I did this time around was that I changed the user's name from mysql to mysqladmin. I get the follow error when trying to create a new database: #1006 - Can't create database 'demo'. (errno: 13) Does anyone know the fix to this?
RE: php version
Contents are Direct Alliance Corporation CONFIDENTIAL - Your best bet is to grab 4.3.1 or greater Windows version even has gui installer... http://us2.php.net/get/php-4.3.3-installer.exe/from/a/mirror This message is for the designated recipient(s) only and contains Direct Alliance Corporation privileged and confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this email is prohibited.
RE: Query hung up in "Copying to tmp table"
Matt, Thanks for your response. It's going to take a bit for me to get the actual SQL available. I don't yet have permission to show that off. In the mean time, I can tell you that there are 10 table in the query, with 4 being references to the same table. I've been able to make an improvement that greatly improves the speed... by over-joining some records. That is, I'm joining 3 tables such that A joins to B, B joins to C, and C joins to A, basically. That was enough to let mySQL sort out a better plan. Interestingly though, the result of the query (and it appears to be proper) is 0 rows. I believe it's the intermediate row set that may be huge. But I've never seen mysql spit out a temporary file while processing. Again, I'd really like someone's reference to a tuning guide, if there's a superior one available. Thanks again, Kevin > -Original Message- > From: Matt W [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 04, 2003 1:37 PM > To: [EMAIL PROTECTED] > Subject: Re: Query hung up in "Copying to tmp table" > > > Hi Kevin, > > I imagine the query is examining/returning so many rows that > it's going to take a long time to create the needed temporary > table (how long have you it go?). To start with, show us the > EXPLAIN output for the problem SELECT, along with the SELECT. > Also the size of the involved tables (rows and MB). > > > Matt > > > - Original Message - > From: "Kevin Fries" > Sent: Wednesday, September 03, 2003 6:51 PM > Subject: Query hung up in "Copying to tmp table" > > > > I'm having a problem where a complex SELECT query begins eating up > lots > > of CPU and never returns. In "show processlist", it > > reports "Copying to tmp table". Other queries seem to get locked > > waiting for this query, as well. > > > > This is on version 3.23.36 of mySQL, and I'm considering > upgrading to > > the latest 3.23.57, to see if that improves the > performance. I can't > > find any matching references in the Changes web pages that indicate > > this, though. Can anyone verify this? > > > > Alternately, I'm trying to find ways to possibly improve the step of > > "copying to tmp table". According to my "show variables" > output, the > > "tmpdir" is /tmp, and /tmp has plenty of room (85 megs or so). But > > while the query is running, I don't even see a corresponding file > there. > > The CPU is spiking with top reporting mysql as eating 85% > CPU. So I > > then assume that the 'problem' is happening before the file is > created? > > Does that sound right? > > > > If someone has a better reference for tracking down the source of a > > problem like this, other than > > http://www.mysql.com/doc/en/MySQL_Optimisation.html, I'd be very > > appreciative. > > > > thanks, > > Kevin Fries > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
php version
What is the best version of PHP to use with MySQL on Win32 to interact with the MySQL database in web-enabled forms with submit button? Thank you for your help. Albert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table is full error
try this link http://jeremy.zawodny.com/blog/archives/000796.html setting avg_row_length at 50 worked for me I tested and got mytable up to 9GB, (large table with variable size records ) the only reason I could see that it would matter to have an accurate value for the avg_row_length would be if mysqld uses that value to make reads and writes faster. I too would like to know more, mysqld is fast, I would hate to slow it down in any way if it could be prevented. > On Thu, 2003-09-04 at 17:02, [EMAIL PROTECTED] wrote: > > > > I'm not too familiar with this.. someone else today used the value 50, > > when in fact based on their avg_row_length being reported as: > > > > Avg_row_length: 2257832 > > > > Your average row length is reported as: > > > > Avg_row_length = 20564 > > > > From: http://www.mysql.com/doc/en/CREATE_TABLE.html > > > > AVG_ROW_LENGTH An approximation of the average row length for your table. > > You only need to set this for large tables with variable size records. > > > > So if you are using a fixed length records, you don't need this.. > > otherwise. my best guess is use say: 22000 ?? > > > > If someone else has more experience with this issue, please toll in and > > make a suggestion based on the above values... > > > > > > On Thu, 4 Sep 2003, Keith Bussey wrote: > > > > > Thanks I will make new tables and transfer the data over =) > > > > > > Just wodnering though, any advice on how to tell what to set AVG_ROW_LENGTH to ? > > > > > > -- > > > Keith Bussey > > > > > > Wisol, Inc. > > > Chief Technology Manager > > > (514) 398-9994 ext.225 > > > > > > > > > Quoting [EMAIL PROTECTED]: > > > > > > > > > > > On Thu, 4 Sep 2003, Keith Bussey wrote: > > > > > Running that shows me the following: > > > > > > > > > > mysql> SHOW TABLE STATUS FROM email_tracking LIKE 'email_body_old'; > > > > > > > > > > > > ++++++-+-+--+---++-+-+-++-+ > > > > > | Name | Type | Row_format | Rows | Avg_row_length | > > > > Data_length | > > > > > Max_data_length | Index_length | Data_free > > > > > | Auto_increment | Create_time | Update_time | Check_time > > > > >| Create_options | Comment | > > > > > > > > > > > > ++++++-+-+--+---++-+-+-++-+ > > > > > | email_body_old | MyISAM | Dynamic| 208853 | 20564 | > > > > 4294967292 | > > > > > 4294967295 | 1820672 | 0 > > > > > | 450438 | 2002-10-21 11:58:24 | 2003-08-31 01:01:41 | 2002-11-30 > > > > > 01:41:00 || | > > > > > > > > > > > > ++++++-+-+--+---++-+-+-++-+ > > > > > 1 row in set (0.00 sec) > > > > > > > > > > > > There's your problem... your 3 bytes off your max_data_length .. which > > > > is giving the table full error > > > > > > > > Check: http://www.mysql.com/doc/en/Full_table.html at the bottom for > > > > help to alter table to keep growing > > > > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
reserved words and column titles
I am trying to install a sourceforge application and in one of the tables in the db, there is a column whose name is 'default'. When installed on MySql version 4.1.0-alpha-standard, this works fine, but I really need it to run on version 3.22.27. Is there a workaround? I really don't want to edit the code. Shawn McGinn Web & Media Services University of New Brunswick email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb and fulltext
I remember that some weeks ago Heikki announced it is on his todo list but in the far future unless someone is funding the project. Thomas Spahni On Thu, 4 Sep 2003, electroteque wrote: > Hi i was wondering if there was ever going to be a time when Innodb can also > be fulltext indexable ? Being that i just started to work with Innodb and > cant believe how proper it feels of a relationional database over Myisam. > Like with Myisiam you cant set relationships up or is that going to change ? > As there has been a few projects which needs fulltext but would be good > setting up innodb aswell. > > Also when setting up relationships if i setup on delete to use cascade it > will delete all records from the other table joined to that row, this is a > wicked feature although, how can i still stop it from being deleted > accidently then ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
2-Questions: Starting MySQL and Shutting Down on OS X
All: (1) I've got "/user/local/mysql/data" in my path, but when I attempt to run "mysqld_safe" I get a message reading: "Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe" Do I really need to be in the installation directory to kick-off the MySQL server? If so, why? (2) Anyone running OS X have a good way to automatically shut MySQL server before shutdown. Currently, I've got to do it manually. If someone else sits at my workstation, they may or may not restart/shutdown without shutting down the server. Before I invest time in trying to resolve, let me know if there is something quick and easy out there. Regards, Adam <> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FULLTEXT search
At 08:56 PM 9/4/2003, you wrote: Hi all, At the moment, we all know that InnoDB does not yet have FULLTEXT indexes. This is not another message asking as to when we will have that functionality. This message is different. On the mailing list for DBMail, we've been discussing MySQL table types, with everyone highlighting the fact that MyISAM does not support transactions while InnoDB does (in addition to foreign keys). Then, I raised the point that MyISAM may not have transactions, but it does have FULLTEXT indexes, which could be a massive source of speed for MyISAM-based tables. My question is this: Obviously, if you throw SQL statements enclosed in BEGIN/COMMIT and issue ROLLBACK statements on MyISAM tables, MyISAM does the right thing and ignores it (personally, I think it would be better if it alerted the nearest admin, so that they could come and deal with any person touching their finely tuned database server). Is the converse-ish statement true? Is there any way that FULLTEXT searches could be executed on InnoDB (and other type) tables currently or with a quick patch that uses a full table scan? I'd be willing to get together with a few people to write such a thing, as it would speed development while FULLTEXT is a MyISAM exclusive while still allowing testing against all MySQL tables in the immediate future. Regards, Chris Chris, I agree with you, FullText in InnoDb would be nice. It is one reason why I'm sticking with MyISAM tables. I suppose you could modify MySQL to implement FullText on InnoDb tables but then who would support it? It would be a variant of MySQL. It would be better if InnoDb implements it so they would support it in all future MySQL versions. Heikki did mention a year ago that he would consider implementing FullText searching if a client was willing to fund it. Unfortunately he didn't say how much $ it would take. I would be willing to kick in $100 to see it happen. If enough people got together, perhaps we can encourage him to do it. I suspect not having FullText in InnoDb is a major hurdle that is forcing people to stay with MyISAM tables. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Command not found
On Friday, Sep 5, 2003, at 10:24 US/Eastern, Parker Morse wrote: You'll need to edit the .bashrc file in your home directory to add the /usr/local/mysql/bin directory to the search path if you want to avoid typing the full path. Another alternative is to place links to the binaries in one of the directories already in the path, like > /usr/bin/. I should correct myself - the file to look at is .bash_profile, not .bashrc, at least in RH 9.0. Or .tcsh_profile (or .tcshrc) if you use tcsh - I don't, so I'm not certain which file it would be in. And, as Mike suggests, check to make sure the MySQL client is there at /usr/local/mysql/bin/mysql. It might be that simple. pjm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: key constraints
here is part of the create table CREATE TABLE `assets` ( `assetID` int(11) NOT NULL auto_increment, `barcode_number` varchar(20) NOT NULL default '', `asset_code` varchar(20) NOT NULL default '', `serial_number` varchar(100) NOT NULL default '', `asset_user` varchar(100) NOT NULL default '', `purchase_price` double NOT NULL default '0', `rental_amount` double NOT NULL default '0', `start_date` date NOT NULL default '-00-00', `asset_typeID` tinyint(4) NOT NULL default '0', `manufacturerID` int(11) NOT NULL default '0', `departmentID` int(11) NOT NULL default '0', `asset_modelID` tinyint(4) NOT NULL default '0', `rental_gst` double NOT NULL default '0', `peripherals` text NOT NULL, `asset_description` text NOT NULL, `end_dateID` tinyint(4) NOT NULL default '0', PRIMARY KEY (`assetID`), KEY `barcode_number` (`barcode_number`), KEY `serial_number` (`serial_number`), KEY `asset_user` (`asset_user`), KEY `asset_typeID` (`asset_typeID`), KEY `manufacturerID` (`manufacturerID`), KEY `departmentID` (`departmentID`), KEY `modelID` (`asset_modelID`), KEY `end_dateID` (`end_dateID`), FOREIGN KEY (`end_dateID`) REFERENCES `end_dates` (`end_dateID`) ON DELETE CASCADE ON UPDATE NO ACTION ) TYPE=InnoDB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: key constraints
Really sorry about this i just worked out if i dont select the foreign key in an insert statement it will return this error i have to include this into the query, i have also noticed i usually dont add auto inc fields in the insert query but my departments table has a foriegn key join and is returning error unless i add it into the query, is there a way around this ? > Hi there i am having another issue with key constraints now, i emptied > the tables and made the foreign keys fine although now when i try and > insert a row into the table i get this > > ERROR 1216: Cannot add or update a child row: a foreign key constraint > fails > > What could be the problem ? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL GUI
"Ligaya Turmelle" <[EMAIL PROTECTED]> wrote: > there is no acknowledgement when a table is created. You don't find out > about it until you turn off the gui and restart it. Choose "Refresh all caches" in the "Manage" manu item. BTW MySQLGUI is no longer under development. Use MySQL Control Center instead. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Command not found
Also make sure you installed both the server and the client for MySQL. And of course if you're not running bash, put the path to the MySQL directory in the correct shell file. For example, I prefer the tsch shell, so I would put it in the .tcshrc file in my home directory. If you're not familiar with Linux, take a look at some of the commands at http://www.reallylinux.com/docs/consult.shtml. If you want a book, http://www.amazon.com/exec/obidos/ASIN/0972679006/qid%3D1041438546/sr%3D11-1/ref%3Dsr%5F11%5F1/103-4038995-5196662 will get you a quick start. Parker Morse <[EMAIL PROTECTED]To: [EMAIL PROTECTED] m> cc: [EMAIL PROTECTED] Subject: Re: Command not found 09/05/2003 09:24 AM On Friday, Sep 5, 2003, at 00:51 US/Eastern, [EMAIL PROTECTED] wrote: > I installed the MySQL 4.0 on my Linxus machine (red hat 7.3). The > installation > shows no problem, and I can see that the 'mysqld' server is actually > runing > through a command like "./bin/mysqladmin version". However, it just > does not > allow me to switch to the mysql client program from my login shell. > Whenever I > try to do so, it also says that "bash: mysql: command not found". > > I don't know how to deal with it. Could some MySQL experts please > kindly help > me with this? It's not a MySQL issue, it's a Linux issue. If your MySQL binaries are installed in a directory like /usr/local/mysql/bin/, they're not in one of the directories your shell (probably bash) looks in for commands. (To see which directories are being searched, type "echo $PATH" at the shell prompt.) You'll need to edit the .bashrc file in your home directory to add the /usr/local/mysql/bin directory to the search path if you want to avoid typing the full path. Another alternative is to place links to the binaries in one of the directories already in the path, like /usr/bin/. pjm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: key constraints
Daniel Rossi <[EMAIL PROTECTED]> wrote: > Hi there i am having another issue with key constraints now, i emptied the tables > and made the foreign keys fine although now when i try and insert a row into the > table i get this > > ERROR 1216: Cannot add or update a child row: a foreign key constraint fails > > What could be the problem ? What is the structure of your tables? What is your INSERT statement? -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SOLVED Re: MySQL 4.0.14 stops responding to PHP 4.3.2
On Thursday, Sep 4, 2003, at 12:47 US/Eastern, Parker Morse wrote: No, it turns out this is not the key. With mysql_connect() I'm actually failing MORE often than with mysql_pconnect - so far it hasn't stayed up 15 minutes without error. (Fortunately, I have a cron job checking on it and restarting.) However, this did put me on to the problem. I was tripping resource limits. When I was first setting up the server and getting the individual sites/users working in the mysql.user table, I saw the max_connections column set to 0 and thought that was a problem; I didn't realize that 0 meant "no limit". So I set a limit. I was running up on the connection limits, which meant mysqld was refusing further connections until my server restart reset the counts to 0. With mysql_connect I had more connections, and thus reached the limit faster. Now I have reset the max_connections numbers to 0, and I haven't had a failure in twenty hours, so I think I can call this problem solved. Thanks for your help. In the course of sorting it out, I also learned a good deal about debugging mysql errors gracefully in PHP. pjm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Command not found
On Friday, Sep 5, 2003, at 00:51 US/Eastern, [EMAIL PROTECTED] wrote: I installed the MySQL 4.0 on my Linxus machine (red hat 7.3). The installation shows no problem, and I can see that the 'mysqld' server is actually runing through a command like "./bin/mysqladmin version". However, it just does not allow me to switch to the mysql client program from my login shell. Whenever I try to do so, it also says that "bash: mysql: command not found". I don't know how to deal with it. Could some MySQL experts please kindly help me with this? It's not a MySQL issue, it's a Linux issue. If your MySQL binaries are installed in a directory like /usr/local/mysql/bin/, they're not in one of the directories your shell (probably bash) looks in for commands. (To see which directories are being searched, type "echo $PATH" at the shell prompt.) You'll need to edit the .bashrc file in your home directory to add the /usr/local/mysql/bin directory to the search path if you want to avoid typing the full path. Another alternative is to place links to the binaries in one of the directories already in the path, like /usr/bin/. pjm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL does not release locks
Teemu, the standard Perl stress test perl run-all-tests --create-options=type=innodb in the sql-bench directory does a lot of ADD COLUMN operations. But it does not produce the warning you have seen. How big are the tables you ALTER? What does a typical CREATE TABLE look like? It would be valuable if you can write a script which repeats the warning. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ - Original Message - From: "Teemu Kuulasmaa" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, September 05, 2003 12:53 AM Subject: Re: MySQL does not release locks > Heikki, > > There is not concunrrently running ANY queries on the table I am > ALTERing. In some cases I am the only person connected to the server. > Unfortunately I am not able to provide you with the proper test case > because this problem is not repeatable. Yes, I encounter this problem > very frequently but sometimes I am geting error messages and sometimes I > am not. > > There is two kind of queries that cause my problems: > 1) I add new columns to the table "ALTER TABLE tblName ADD COLUMN ... " > 2) I make updates "UPDATE TABLE tblName SET field1='something' WHERE > field2=" > > These queries are executed succesfully but following queries are > blocked. Maybe UPDATE/ALTER queries are still hanging around and > database engine thinks that operation has not been completed!? ( I do > not know database engine internals ;=) This was a wild guess). > > I am looking forward your reply, > > Teemy > > > > Teemu, > > > > what kind of queries, if any, you are concurrently running on the tables you > > are ALTERing? > > > > " > > 030904 10:22:14 InnoDB: Warning: MySQL is trying to drop table > > research/#sql2-4a4-1a8 > > InnoDB: though there are still open handles to it. > > InnoDB: Adding the table to the background drop queue. > > 030904 10:32:54 InnoDB: Dropped table research/#sql2-4a4-1a8 in > > background drop queue. > > " > > > > This warning means that there may still be queries running on the table > > MySQL is trying to drop. InnoDB must delay the actual drop operation. It > > would be valuable if you could provide a repeatable test case which > > generates this warning. This should have been fixed in some MySQL-4.0.xx, > > but the bug seems to persist. > > > > Best regards, > > > > Heikki > > Innobase Oy > > http://www.innodb.com > > InnoDB - transactions, row level locking, and foreign keys for MySQL > > InnoDB Hot Backup - a hot backup tool for MySQL > > Order MySQL support from http://www.mysql.com/support/index.html > > > > > > > > ... > > Subject: Re: MySQL does not release locks > > From: Teemu Kuulasmaa > > Date: Thu, 04 Sep 2003 14:54:56 +0300 > > > > > > > > Hi, > > > > Unfortunately, nobody responded my mail. I am still trying to solve the > > problem I described in my earlier mail (quoted below). > > > > I am mailing again because I have some new information about the issue. > > I converted all my tables to InnoDB (MyISAM -> InnoDB) and this solved > > the problem. With InnoDB tables I have not encountered any table locks > > BUT database engine is continuously reporting a new kind of warnings. A > > section from the server ".err" log file: > > <> > > 030904 10:22:14 InnoDB: Warning: MySQL is trying to drop table > > research/#sql2-4a4-1a8 > > InnoDB: though there are still open handles to it. > > InnoDB: Adding the table to the background drop queue. > > 030904 10:32:54 InnoDB: Dropped table research/#sql2-4a4-1a8 in > > background drop queue. > > <> > > > > MySQL database engine is still behaving badly but InnoDB engine is able > > to overcome or prevent this. > > > > Has anyone any ideas?!?! Maybe Heikki Tuuri could explain behavior of > > the InnoDB engine. > > > > Sincerely, > > > > Teemu > > > > Teemu wrote: > >> Hi > >> > >> I have problems with mysql (4.0.6-4.0.14b) on windows 2000 SP3. MySQL > >> locks tables when I alter table structure or execute update queries. I > >> know that this is the exactly what database engine is supposed to do but > >> the engine doesn't release the locks at all. This happens frequently but > >> not allways. Approximately every third alter/update query locks table > >> "permanently". Recently I found out that by executing "FLUSH TABLES" > >> release locks and I am able to keep on working with the table. I have > >> been useing only MyISAM table types. > >> > >> Table locking is annoying because there might be concurrent users useing > >> the same table. They are not able to access the table at all or SELECT > >> queries returns wrong number of records. > >> > >> I use different clients to execute queries phpMyAdmin, mysqlcc, mysql, >