Re: Comparing bug in 4.1.7
Hello Vlad, The reason is: If one or both arguments are NULL, the result of the comparison is NULL, except for the NULL-safe = equality comparison operator. Thereore, or NULL in your select statement will always returned NULL. You can find all the rules for comparaison at URL: http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html Regards, Bernard On Thursday 02 December 2004 06:48, Vlad Shalnev wrote: Hi, All It's happen after upgrade from 3.23.46. Just look at this set of queries mysql select 1 or null; +---+ | 1 or null | +---+ | 1 | - Ok +---+ 1 row in set (0.00 sec) mysql create table a ( a int not null ); Query OK, 0 rows affected (0.00 sec) mysql select min( a ) is null from a; +--+ | min( a ) is null | +--+ |1 | - Ok +--+ 1 row in set (0.00 sec) mysql select min( a ) is null or null from a; +--+ | min( a ) is null or null | +--+ | NULL | - Why ??? +--+ 1 row in set (0.00 sec) It is very important for me to solve this problem. Thanks for any help Info from mysqlbug script Server version 4.1.7 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/.mysql.sock Uptime: 23 hours 43 min 34 sec Threads: 2 Questions: 53 Slow queries: 0 Opens: 20 Flush tables: 1 Open tables: 6 Queries per second avg: 0.001 C compiler:2.95.3 C++ compiler: 2.95.3 Environment: machine, os, target, libraries (multiple lines) System: SunOS asv 5.8 Generic_108529-23 i86pc i386 i86pc Architecture: i86pc Some paths: /usr/local/bin/perl /usr/ccs/bin/make /opt/sfw/bin/gmake /opt/sfw/bin/gcc /usr/local/bin/cc GCC: Reading specs from /opt/sfw/lib/gcc-lib/i386-pc-solaris2.8/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: -rw-r--r-- 1 root bin 1608268 Jul 30 2003 /lib/libc.a lrwxrwxrwx 1 root root 11 Mar 3 2004 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 956112 Jul 30 2003 /lib/libc.so.1 -rw-r--r-- 1 root bin 1608268 Jul 30 2003 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Mar 3 2004 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 956112 Jul 30 2003 /usr/lib/libc.so.1 Configure command: ./configure '--prefix=/usr/local/mysql-4.1.7' '--exec-prefix=/usr/local/mysql-4.1.7' '--libexecdir=/usr/local/mysql-4.1.7/bin' '--localstatedir=/main/MysqlDB' '--enable-thread-safe-client' '--with-unix-socket-path=/tmp/.mysql.sock' '--with-mysqld-user=mysql' '--without-debug' '--without-bench' '--with-charset=koi8r' Perl: This is perl, version 5.005_03 built for i86pc-solaris -- --- - Vlad A. Shalnev E-mail: [EMAIL PROTECTED] Gravity can't be blamed for someone falling in love ( Albert Einstein ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Question on date calculation +
You will get your answers by reading carefully the Date Time Functions in the MySQL Reference Manual. Look at the URL: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html Bernard On Wednesday 17 November 2004 16:40, Stuart Felenstein wrote: While I'm figuring this needs to be addressed via my scripting language wanted to ask here. Customers will buy a block of time to use my service. Time meaning number of days. 90, 45, 60, etc. Here are the fields relevant to this question: PostStart [Date] LenChoice [int] DaysLeft [int] When they register , the current date is input automagically into PostStart. LenChoice is chosen by the user and is the length of days they want this block. DaysLeft is where the calculation would be done to hold the difference between the current date, date posted and how many days were paid for. This is where I'm not entirely sure what to do. I'm probably inhaling gasoline or something but how would I get the field to the numbers of DaysLeft ? i.e. DaysLeft[today]= 3, DaysLeft[tomorrow]=2..etc Thank you , Stuart p.s. I'm on 4.0.22 , so no stored procedures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Question on date calculation +
No, but it will tell you how to compute the field or, maybe, change your design! You definitely need an update statement, something like: update table name set DaysLeft=wathever your figure out from your reading. Now how to run this automatically? Well I do not know if you are using MS WIndows or Linux. For MS WIndows I cannot really help you! Probably using the at command. Under Linux you can use cron to automatically start mysql with your update statement. You can run it as often as you wish. The command might look like: mysql -uuser -ppassword -e update ... Bernard On Wednesday 17 November 2004 16:58, Stuart Felenstein wrote: --- Bernard Clement [EMAIL PROTECTED] wrote: You will get your answers by reading carefully the Date Time Functions in the MySQL Reference Manual. This will tell me how to automatically update the column in question ? Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What's MYSQL equivalent to Oracle's TRUNC(date_time_var)?
Look at the DATE() fucntion you can find in the REF Manual of MySQL at URL: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html Regards, Bernard On Friday 12 November 2004 12:14, sol beach wrote: In Oracle TRUNC(data_time_var) returns only the date portion of a date_time data type. What's the easiest way in MYSQL to accomplish the same thing? I tried to RTFM (Paul DuBios' MYSQL tome; 2nd Ed.), but no clean solution lept out at me. It is a GREAT book, but it did not help me in this case. TIA! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
Did you tried without the : between web-server2 and 3306? i.e. put a space insted of : B On Thursday 14 October 2004 19:58, Steve Grosz wrote: I have tried telnet web-server2:3306 Didn't work Dwalu Z. Khasu wrote: On Thu, 14 Oct 2004, Steve Grosz wrote: =If that's the case, its not working, I type a telnet 192.168.x.x:3306 =and get a could not open a connection to the host even though =Mysql-nt shows as running on the Win2003 server. = =Steve = Try 'telnet host port'. - Dwalu .peace -- I am an important person in this world - Now is the most important time in my life - My mistakes are my best teachers - So I will be fearless. - Student Creed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: (might be off list) MySQL AB
Hello MC, The following is extracted from URL: http://dev.mysql.com/doc/mysql/en/What_is_MySQL_AB.html which answers your questions. By the way, the ``AB'' part of the company name is the acronym for the Swedish ``aktiebolag,'' or ``stock company.'' It translates to ``MySQL, Inc.'' In fact, MySQL, Inc. and MySQL GmbH are examples of MySQL AB subsidiaries. They are located in the US and Germany, respectively. Bernard On Thursday 10 June 2004 05:03, mc wrote: Hi, I would like to know what does the 'AB' in MySQL AB stand for? Is it something like limited or incorporated? If yes, is this something related to the origin of MySQL? I am a subscriber from Hong Kong. Thanks. mc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Stupid Newbie Query Help with AND and OR logical operators
You need parenthesis around cond1 OR cond2 OR cond3 otherwise effectively you are going to get all records matching the following: last d AND choice1=2 + choice2=2 + choice3=2 Therefore, you select statement should be written: SELECT * FROM name WHERE last LIKE d AND (choice1=2 OR choice2=2 OR choice3=2); Bernard On Friday 07 May 2004 13:51, Bob Cohen wrote: Here's my question. I wrote this query: Select * FROM name WHERE last LIKE d AND choice1=2 OR choice2=2 OR choice3=2; What I'm looking for are records that satisfy the LIKE d condition But then, Only one of the three other conditions need be true: choice1=2 choice2=2 choice3=2 I want to cover the possibilities, e.g., choice1=2 choice2=1 choice3=1 choice1=1 choice2=2 choice3=whatever Or choice1=1 choice2=1 choice3=2 Does this make sense? The query I've written doesn't seem quite right. Because of the AND following the LIKE d condition, it seems like all the records will have to have choice2 equaling 2. Some help clarifying this issue would be appreciated. Thanks. Bob Cohen b.p.e.Creative http://www.bpecreative.com Design and production services for the web Put creative minds to work for you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump command error
Hello Joe, mysqldump is a seperate programto be execute at the system prompt. Therefore it is not to be run under the mysql prompt. Bernard On Friday 26 March 2004 06:09, joe collins wrote: I have read the documentation on the MySQLDump, but have been unable to launch a mysql dump. Is the dump performed while logged on to the database that you want to dump, or do you log onto the machine where the database is and specify which database you want to dump?. I have looked at and applied some of the sample mysqldump commands given in the documentation, but all have resulted in syntax errors. See below Any advice or pointers would be greatly appreciated. many thanks for your patience Joe nuatech_1 is the name of my database nuatech is my password set up for the root user I want to dump it to a file called dump1.txt My database is set up on localhost Opted to use the database upon which I want to perform mysqldump: mysql use nuatech_1 Database changed Tried a mysqldump: mysql mysqldump -u root -p nuatech nuatech_1 dump1.txt; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp onds to your MySQL server version for the right syntax to use near 'mysqldump -u root -p nuatech nuatech_1 dump.txt' at line 1 Tried again removing spaces before parameters mysql mysqldump -uroot -pnuatech nuatech_1 dump1.txt; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp onds to your MySQL server version for the right syntax to use near 'mysqldump -u root -pnuatech nuatech_1 dump1.txt' at line 1 logged out of mysql: mysql quit Bye Logged back in ( not to a particular database) C:\mysql\binmysql -u root -p mysql Enter password: *** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.0.18-max-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. Tried the mysqldump again: mysql mysqldump -uroot -pnuatech nuatech_1 dump1.txt; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp onds to your MySQL server version for the right syntax to use near 'mysqldump -u root -pnuatech nuatech_1 dump1.txt' at line 1 Tried again with spaces before the parameters: mysql mysqldump -u root -p nuatech nuatech_1 dump1.txt; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp onds to your MySQL server version for the right syntax to use near 'mysqldump -u root -p nuatech nuatech_1 dump1.txt' at line 1 mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: installation de mysql
Bonjour, For the benefit of the group I will translate the French part of my text :-) Le tarball que vous avez telecharge est en fait le binaire executable de MySQL pas les sources. Donc vous n'avez pas a executer configure sur celui-ci. The tarball that you have downloaded is in fact the eexcutable binary of MySQL not the sources. Therefore, you do not have to execute configure on it. Si vous avez acces au CD de distribution de RedHat je vous recommanderais d'installer MySQL a partir du RPM. Si vous n'avez pas acces a ceux-ci telecharger le RPM pour RedHat 9. Il est en effet beaucoup plus facile d'installer MySQL a partir des RPM. If you have access to the distribution CDs of RedHat I recommend you to install MySQL from the RPM. If you do not have access to those, you should download the RPM for RedHat 9. In effect it is a lot more easier to install MySQL from the RPM. Salutations, Bernard On Wednesday 24 March 2004 05:01, sanaâ Aitouchen wrote: j'ai le red hat 9 et j'ai télécharger mysql-3.23.58-pc-linux-i686.tar.gz j'ai crée le repertoir /usr/local/src et j'ai fais gunzip mysql-3.23.58-pc-linux-i686.tar.gz tar xvf mysql-3.23.58-pc-linux-i686.tar.gz cd mysql-3.23.58-pc-linux-i686 ./configure --prefix=/usr/local/mysql mais ca donnée l'erreur suivante: NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databasesand start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Installing all prepared tables 040324 9:51:43 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.serverto the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h iamintrusion password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should runthe ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version [EMAIL PROTECTED] mysql-3.23.58-pc-linux-i686]# Starting mysqld daemon with databases from /usr/local/src/mysql-3.23.58-pc-linux-i686/data 040324 09:51:44 mysqld ended j'aimerais bien savoir ou se trouve l'erreur et comment je peux le régler merci d'avance _ MSN Messenger : discutez en direct avec vos amis ! http://www.msn.fr/msger/default.asp -- Bernard Clement Info-Electronics Systems Inc. Technical Director phone: 514-421-0767 ext: 231 fax: 514-421-0769 email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Commercial Licence
Dear Pierre, I would suggest you to contact directly MySQL AB for such a question at [EMAIL PROTECTED] My guess is that you will need to buy a license for the master and the slaves. Regards, Bernard On Wednesday 10 March 2004 03:19, Pierre Luguern wrote: I want to run a commercial product based on MySQL. I have one centralized server running MySQL in replication mode (master server). I have five clients running MySQL (each slave is running one MySQL daemon). Do I have to acquire only one commercial licence for my master server or do I have do get commercail licence for master and slave. Thanks in advance. mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL C API license
To my knowledge it is GPL. Bernard On Friday 05 March 2004 17:52, Ronald J. Yacketta wrote: Folks, What license does the MySQL C API fall under? I am looking to add client support to a game that I am creating, but need to know the terms of the license etc. -Ron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The very first day of march :-) (select (curdate()-1);)
Your select works fine within the month to the exception of the first day because curdate()-1 is treated as a numeric field (see curdate in http://www.mysql.com/doc/en/Date_and_time_functions.html) The following seems to be what you want to do: mysql select date_format(curdate()- interval 1 day,'%Y%m%d'); +-+ | date_format(curdate()- interval 1 day,'%Y%m%d') | +-+ | 20040229| +-+ 1 row in set (0.00 sec) or, if you want the '-' mysql select date_format(curdate()- interval 1 day,'%Y-%m-%d'); +---+ | date_format(curdate()- interval 1 day,'%Y-%m-%d') | +---+ | 2004-02-29| +---+ 1 row in set (0.00 sec) Bernard On Monday 01 March 2004 05:15, Campanella Danilo wrote: Hi, Look at what happened today : mysql select curdate(); ++ | curdate() | ++ | 2004-03-01 | ++ 1 row in set (0.00 sec) mysql select (curdate()-1); +---+ | (curdate()-1) | +---+ | 20040300 | +---+ 1 row in set (0.00 sec) mysql Until yesterday select (curdate()-1); worked fine. I use MySQL version 4.0.12. Does anybody know something about? Ciao Danilo CONFIDENTIALITY NOTICE This message and its attachments are addressed solely to the persons above and may contain confidential information. If you have received the message in error, be informed that any use of the content hereof is prohibited. Please return it immediately to the sender and delete the message. Should you have any questions, please contact us by replying to [EMAIL PROTECTED] Thank you www.telecomitalia.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: API C
Hi Volnei,
Under Linux you do not need the -lsocket. (If I recall correctly that is for
SUN Solaris but I might be wrong)
As for your run-time error, the DLL libmysqlclient.so is not in the library
path.
Either modify /etc/ld.so.conf to include where is that library (it seems to
be /usr/local/mysql/lib/mysql from your gcc command line). In which case do
not forget to run ldconfig -n
OR
Set the environment variable LD_LIBRARY_PATH to where the library is installed
(again from your gcc command line it seems to be /usr/local/mysql/lib/mysql).
Regards,
Bernard
On Wednesday 25 February 2004 09:37, Galbino wrote:
Hello,
I made a compilation test, to see how it works, and already the first
beginner problems came.
#include sys/time.h
#include stdio.h
#include mysql.h
int main(int argc, char *argv[]){
MYSQL_RES *result;
MYSQL_ROW row;
MYSQL *connection, mysql;
int state;
/* Conectando com MySQL */
printf(Iniciando o MySQL!!!);
mysql_init(mysql);
connection =
mysql_real_connect(mysql,localhost,root,mysql,banco,0,NULL,0);
if (connection == NULL){
printf(Não conectado!!!);
printf(mysql_error(mysql));
return 1;
}
/* Close connection */
mysql_close(connection);
printf(\nSaindo! \n);
}
When I try to compile, with the command below, he says that cannot find
the - lsocket.
Is the command correct?
Which the problem?
[EMAIL PROTECTED] teste]# gcc -L/usr/local/mysql/lib/mysql
-I/usr/local/mysql/include/mysql -o teste teste.c -lmysqlclient -lnsl
-lsocket
/usr/bin/ld: cannot find -lsocket
collect2: ld returned 1 exit status
[EMAIL PROTECTED] teste]#
Removing the command - lsocket, the compilation is executed, however
when I will execute, appears the message, as shown below.
[EMAIL PROTECTED] teste]# gcc -L/usr/local/mysql/lib/mysql
-I/usr/local/mysql/include/mysql -o teste teste.c -lmysqlclient -lnsl
[EMAIL PROTECTED] teste]#
[EMAIL PROTECTED] teste]# ./teste
./teste: error while loading shared libraries: libmysqlclient.so.14:
cannot open shared object file: No such file or directory
[EMAIL PROTECTED] teste]#
what this happening?
Volnei Galbino.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Did I mess up MySQL?
You also need to install the rpm for mysql-client. Bernard On Tuesday 24 February 2004 16:37, Database Administrator wrote: I had MySQL 3.23.52-3 installed on RH Linux 8.0 (default that comes with it). I decied to install 4.0 and used this command to install it: rpm -Uvh --nodeps MySQL-server-4.0.18-0.i386.rpm I didn't see any obvious errors thereafter. After rebooting noticed that looks like the mysql daemon is running: $ ps -ef|grep mysql root 1620 1 0 15:52 pts/000:00:00 /bin/sh /usr/bin/mysqld_safe --d mysql 1655 1620 0 15:52 pts/000:00:00 /usr/sbin/mysqld --basedir=/ --d However the file /usr/bin/mysql no longer exists so how do I actually get a command line interface to MySQL? Or is there something else I need to install that I have neglected? Or am I just hosed? :) Thanks, lk www.theNewAgeSite.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie question
Dear Brad, Your problem is too much experiences not the lack of skills. I am in the same situation...it is very frustating. Regards, Bernard On Monday 23 February 2004 11:14, Brad Eacker wrote: Donny Simonton [EMAIL PROTECTED] writes: But as a manager, the first thing I do is ask for code examples, as well as table structures. I don't even need to see a resume once I look at somebody's code and table structures. Unfortunately I will have to disagree with you on this one. Having been searching for solid employment for the last year, I'm finding that the managers seek only to place someone who has done the exact job they are trying to fill. And this is with 22 years of relevant experience on my part. 8 years of web-back integration, 13 years inside the unix kernel, coupled with 9 years of RDBMS experience don't seem to hold much weight anymore. You mention examples, I have a pair I use having fully developed both sets http://www.misc.com/costumes/Dickens_0312/index.php http://66.134.203.2/~beacker/genbank/gbf_extract.cgi?LOCUS=AF158101 The first being a photographic PHP based mechanism that I use in at least a dozen pages without change. The second being a 30 million record data set I utilize for selecting GenBank info. I'm finding it very frustrating that my knowledge and capabilities are not found to be compelling. I have utilized C for over 21 years, and perl for 20 years. Yet these don't appear to be enough to get a position in Silicon Valley. Brad Eacker ([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 Write This SQL Statement
Assuming that the address field is of type char or varchar, Assuming that the address field has a NULL default value the following should do it select ... from ... wehre address is null; In case that the address field has no default value the following should do it: select ... from ... where address=''; If one or more of my assumptions are wrong PLS provide us with the structure of your table with describe tables ... Bernard On Tuesday 17 February 2004 14:16, Caroline Jen wrote: Please help. What is the syntax of idenfying those who do not have addresses (in the address field) in the database? __ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: WHERE Clause
You can use having instead of where with an alias. Bernard On Thursday 12 February 2004 14:46, Ian O'Rourke wrote: Is it possible to have a 'worked out value' in the WHERE clause. The problem I have is what I need to check for in the WHERE Clause is not a column: SELECT CONCAT_WS(-,DATE_FORMAT(EntryDate,'%c'),DATE_FORMAT(EntryDate,'%Y')) As mthyr From Blogs WHERE mthyr=1-2003 This does not work as it seems to want a valid column in the WHERE clause. Anyway around it? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: creating users
Hello Daniel, Try with: revoke show databases on mysql.* from [EMAIL PROTECTED]; If the user [EMAIL PROTECTED] issue show databases il will not see anymore the databases mysql. The revoke you were trying was not only on showing the database mysql but revoke all the privilege, is is really what you want to do? BTW, nex time also supply the error text. Regards, Bernard On Sunday 08 February 2004 08:49, Daniel Audette wrote: Hello I am new to mysql. What I want to do is give a user a right to create databases with all rights but I do not want them to see the mysql database I have tried the following GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] DENTIFIED BY 'some_pass' WITH GRANT OPTION; then tried to revoke revoke all privileges on mysql from [EMAIL PROTECTED]; just got an error. Any suggestions on how to do this. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: select on set yields exponential notation
If you are using 4.0.2 and above you can use cast. mysql select var1,cast(var2 as unsigned) from test1; +--++ | var1 | cast(var2 as unsigned) | +--++ |1 |562949953421312 | |1 | 1 | |1 | 32768 | +--++ 3 rows in set (0.00 sec) Note I add a row with 1 and another with 16. Bernard On Friday 06 February 2004 16:22, Greg Vines wrote: With sets if you select the set, you get a comma delimited list, but if you add zero, you get the number value of the entire set (which is what I want). The response is not always in exponential notation - just when a high order bit is set. This seems to be a problem with the output formatting. Do you know if there is a way to set the number of characters in a numeric response? On Fri, 2004-02-06 at 12:54, Michael Stassen wrote: Why are you adding 0? Try this: SELECT var1, var2 FROM test1; Michael Greg Vines wrote: I'm trying to select all the fields from a set but when the number is large, it is returned in exponential notation. Is there a way to keep the returned number an integer? Example: create simple table: create table test1( var1 int, var2 set(1,2,3,4,5,6,7,8,9,10, 11,12,13,14,15,16,17,18,19,20, 21,22,23,24,25,26,27,28,29,30, 31,32,33,34,35,36,37,38,39,30, 41,42,43,44,45,46,47,48,49,40, 51,52,53,54,55,56,57,58,59,60) ); Add a row: insert into test1 values (1, 40); Then select oops: select var1,var2+0 from test1; +--+-+ | var1 | var2+0 | +--+-+ |1 | 5.6294995342131e+14 | +--+-+ How can I get this output as an integer? I've tried both MySQL 3.23 and 4.0.17 with the same result. I'm running on linux (RHL 8.0) Thanks - Greg -- Greg Vines mailto:[EMAIL PROTECTED] Manzanita Systems http://www.manzanitasystems.com 14400 Midland Road Voice: (858) 679-8990 x104 Poway, CA 92064 Fax: (858) 679-8991 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: New to MySQL
Some answers within your message. I would suggest you to browse the reference manual. Bernard On Thursday 05 February 2004 17:27, /dev/null wrote: wow, nice product. Pretty easy to use and install - I like it. I know enough about SQL and databases to just about break any flavor of them I put my hand on ;-). A couple of pointers would be great. I'm creating a handfull of tables that will inter-depend on eachother, using it within php. I have three basic questions: 1. Some of the tables have a unique ID, each new record should get the next number available. Is there an easy data type that will do this for me, or do I need to get a record count myself and use record count + 1 when I insert a new row? You can use an AUTO_INCREMENT column See URL: http://www.mysql.com/doc/en/CREATE_TABLE.html for an explaination 2. Some of the tables will need a timestamp of the exact date/time the record was added. Does timestamp do this, or again do I need to get time( ) and use that value on the insert myself? I would suggest a DATETIME type and use now() when inserting new record. 3. Some of the IDs from one table are used in another table, for example I have an accounts table and a sites table. Each account can have several sites, and each site entry has an account field that has the account ID (from question 1) to tell who the account owner is. Isn't there a joint query that I can run that is like 'SELECT * FROM `sites` WHERE `AccountID` = ( SELECT `ID` FROM `accounts` WHERE `Name` = 'First Last' )'??? Or do I need to run the inner select and get the ID myself, then run the outer select? I admit, I know just enough SQL to wipe the database and drop all the tables ;-), so any help would be greatly apreciate. You want to establish a REFERENCE. Look at the same URL as above for information. Thanks! /dev/null -- Bernard Clement Info-Electronics Systems Inc. Technical Director phone: 514-421-0767 ext: 231 fax: 514-421-0769 email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: HELP! Select queries for tables that has fields with # characters
Hello Howell, See URL: http://www.mysql.com/doc/en/Legal_names.html for the solution. Basically enclose FILE# with `, e.g. where `FILE#` = 1332 Bernard On Thursday 29 January 2004 12:55, Howell, Scott wrote: I am trying to query a table that has field names with # characters in them. For example a table emp_earn has a field called FILE# I need to do a query where FILE# = 1332, but anything I try errors out. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: HELP! Select queries for tables that has fields with # characters
Which version of MySQL are you using? It works for me with version 4.0.15 as shown below: mysql select version(); +---+ | version() | +---+ | 4.0.15| +---+ 1 row in set (0.00 sec) mysql create table temp (`FILE#` integer); Query OK, 0 rows affected (0.00 sec) mysql select * from temp where `FILE#`=1332; Empty set (0.00 sec) Bernard On Thursday 29 January 2004 13:44, Howell, Scott wrote: select * from emp where `file#` = 1332; returns ERROR 1054: Unknown column 'file' in 'where clause' -Original Message- From: Bernard Clement [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 1:19 PM To: Howell, Scott; Mysql (E-mail) Subject: Re: HELP! Select queries for tables that has fields with # characters Hello Howell, See URL: http://www.mysql.com/doc/en/Legal_names.html for the solution. Basically enclose FILE# with `, e.g. where `FILE#` = 1332 Bernard On Thursday 29 January 2004 12:55, Howell, Scott wrote: I am trying to query a table that has field names with # characters in them. For example a table emp_earn has a field called FILE# I need to do a query where FILE# = 1332, but anything I try errors out. -- Bernard Clement Info-Electronics Systems Inc. Technical Director phone: 514-421-0767 ext: 231 fax: 514-421-0769 email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Application using mysql, perl, Excel
Hello, It might be possible to do what you want to do but...I think it will take too much time and, therefore, will be expensive. As stated by somebody else OpenOffice with ODBC is effectively an interesting solution. I have done it for fun and it works quite well (after the small nightmare of the installation). Therefore I would suggest that you take a look at the product MySQL Manager (URL: http://ems-hitech.com/mymanager/) It is a commercial product, although not too expensive, but one of the bundle seems to be your solution. There is also a 30 days trial version. Note that I never used the product myself but it seems to be a good part of your solution. Bernard PS I am not associated with the company making MySQL Manager, i.e. I am not paid for marketing or selling it. On Wednesday 28 January 2004 16:27, Annie Law wrote: Hi, I would appreciate help on the following. I would like to create a small application that would involve Excel XP on Windows 2000, and perl and mysql on RedHat linux 9.0 The front end of the application will be Excel since it has a lot of useful functions. Columns from the Excel sheet will be used to update the mysql database. Data from the mysql database will also be used to update the Excel sheet. I am trying to map things out and see if all of the parts in my application will fit together prior to doing too much developing. Basically my main concern now is to create the flow of information. There is the Excel workbook part and then there is the UNIX mysql database part. Writing a shell or perl script in the linux environment that will ftp files from an external source that will be used to update the mysql database. They will be flat files. I will use perl to parse the data. Then use perl DBI to insert to information Also using perl DBI to upload information from the Excel sheet (user's personal annotation) Into the database. The part that I'm not too sure about is how to send the information from the Excel sheet to the database And how to grab the information from the database and update the Excel sheet. On top of that I am using two different operating systems. Are there some tools in VBA or in perl that I could use to build this bridge? Is this a practical solution? Thanks for your help, - Post your free ad now! Yahoo! Canada Personals -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Require greater than 255 in varchar?
Either a BLOB or TEXT field should be your solution. See http://www.mysql.com/doc/en/BLOB.html for the description. Bernard On Tuesday 27 January 2004 22:29, Eve Atley wrote: I have a large chunk of text I've attempted to put into a varchar field, and it chopped off a chunk of it. If I need to enter text that is greater than the default 255, what choice should I use instead? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL Query
My guess will be that the where clause is misplaced. Try SELECT * From articles WHERE SectionID=1 ORDER BY EntryDate DESC LIMIT 1,10 PLS read URL: http://www.mysql.com/doc/en/SELECT.html On that page it is stated that: All clauses used must be given in exactly the order shown in the syntax description. For example, a HAVING clause must come after any GROUP BY clause and before any ORDER BY clause. Bernard On Sunday 18 January 2004 06:21, Ian O'Rourke wrote: Any idea what is wrong with the following: SELECT * From articles ORDER BY EntryDate DESC LIMIT 1,10 WHERE SectionID=1 I want to return all articles with a particular SectionID, ordered by EntryDate and then I want to pick the start point and list the next 10 from that. Obviously in the final version the start point and the SectionID will be dynamic. I have tried removing the LIMIT part. I've tried changing the SectionID to a different field it always gives me an uninformative error? . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Certification Question
Hello Aman, For instructions on taking the exam in India goto the URL: http://www.vue.com/mysql/ and click on test center of To register for exams in India, please contact the test center directly. This will bring you a window containing all the Pearson VUE Test Center in India. Good luck! Bernard On Friday 09 January 2004 22:29, Amanullah wrote: I'm also interested to take up the certification exam on Mysql, pl. guide me how to proceed to get certification on the same, I'm in India (chennai). -aman. Arjun Subramanian wrote: I took the MySQL core certification exam on the 2nd of January and Passed. I was just wondering when MySQL actually sends out the Certificate and other stuff they said they would send out? Does anyone here have any experience with this ? Thanks in advance. Arjun Subramanian Georgia Tech Station 32003 Atlanta GA 30332 Cell: +404.429.5513 http://www.arjunweb.com -Original Message- From: Amanullah [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:03 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: New INstall of MySQL Hi, make sure the existing directories has been removed fully, then continue with new installation, after installation is over, pl. restart the system, if mysql daemon has not started, pl. go to ..\mysql\bin\ directory run winmysqladmin.exe. mysql service will be strated to work.. -Aman. Chris L. White wrote: Ok I have a question. This is the first time any of us here in our office have installed MySQL or for that fact worked with MySQL. So I got stuck with trying to figure it out. Ok here is the problem. I completely removed the previous MYSQL installation attempt. I started new to install MYSQL. I go to setup and run the setup and the status bar does not move much and the installation takes about 5 seconds and then it is done. I get to the finished installing screen, but there are no options to choose from like the test in the screen says there should. Also I have a my.cnf and ny.ini file in the proper places and I still have nothing going. I am confused and the manual I am finding is not clear enough on this. I included what the my.cnf and my.ini file looks like. And also included the error I am getting after installation. Also after MYSQL is installed should there not be some icons for things related to it, because I don't even have them. I am trying to install this on 2003 Server Standard Edition and have IIS 6 and TCP/IP installed. Please help. [mysqld] # set basedir to your installation path # basedir=C:/mysql # set datadir to the location of your data directory #datadir=C:/SQLData # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M server-id = 1 # Uncomment the following if you want to log updates log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir = c:/mysql/ datadir = c:/SQLData # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:400M #innodb_data_home_dir = c:\ibdata #innodb_log_group_home_dir = c:\iblogs #innodb_log_arch_dir = c:\iblogs #set-variable = innodb_mirrored_log_groups=1 #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=20M set-variable =
Re: Countries, cities, states database
Hello Augusto, You might be able to use the list of weather stations available from WMO at URL: http://www.wmo.ch/index-en.html Among other thing it contains the country and station name (or city name). I know that NWS/NOAA also have that list but it seems that the list is not available right now. Good luck, Bernard On Thursday 18 December 2003 09:32, Augusto Cesar Castoldi wrote: Hi, I searching for a database, with the 'complete' world Countries, cities, states Just like http://www.datingplace.com/servlet/NewRegistration I need for an academic study. Thanks, Augusto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL installation with SuSE Linux 9.0 and YaST
Hello Franz, On Sunday 07 December 2003 12:42, Franz Edler wrote: I do not have specific experiences with SuSE 9.0 (stiil waiting for it from my distributor) but I do with previous versions of SuSE (7.x and 8.x), I am not very experienced with Linux, but SuSE Linux 9.0 and YaST makes it very comfortable for me to install various SW-packages. Therefore I try to install also MySQL with YaST. There are MySQL packages (Version 4.0.15) included in SuSE Linux 9.0 distribution and I try to install the server and the client with YaST. But after installation of these packages with YaST - which is the easy part - one has to configure various parameters for MySQL to work properly e.g. create the database files, define group and user, grant access ... Unfortunately the MySQL-manual (which is a big document) does not give any guidelines for installing with YaST. Unfortunately you cannot use YaST to confiture MySQL. Although your may want the server to start at boot time and that is done in the System-Run Level Editor in YaST. After several times re- and de-installing mysql and also SuSE-Linux itself I still have troubles to get the server running. What kind of troubles? Probably this is the place this group can start to help you. Has anyone already done a MySQL-installation with SuSE Linux 9.0 and YaST? Is there any quick installation guide for this task? I think you have done all it could be done using YaST. You need now to jump into the documentation of MySQL. I will suggest that you read the tutorial in section 3 of MySQL's documentation. (URL: http://www.mysql.com/doc/en/Tutorial.html). I would be very happy to get some help. Hope I have been usefull. Franz Bernard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Backup question.
rsynch will do the job correctly only and only if the mysql server on both sides are not running. Rsynch does not deal with files opened for writing and my guess is that MySQL is opening the database (i.e. files) for writing. As for LVM (AKA Logical Volume Manager) I really do not see how it could be used to take a snapshot in MySQL. However, I could be wrong here. Bernard On Tuesday 18 November 2003 05:12, Simon Green wrote: Has any one use LVM to take a snapshot in MySQL and use this to back up data? Simon -Original Message- From: Paco Martinez [mailto:[EMAIL PROTECTED] Sent: 18 November 2003 10:00 To: Christensen, Dave; 'Richard Reina'; [EMAIL PROTECTED] Subject: Re: Backup question. Is there any problem executing rsync /var/lib/mysql/data/ from one host to another host and therefore having same file in obth machines?? Is it unsafe this method ?? Could be crashed meanwhile transferring ?? Thanks !!! - Original Message - From: Christensen, Dave [EMAIL PROTECTED] To: 'Richard Reina' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:20 PM Subject: RE: Backup question. Yes, you can do it like this: Prompt mysqldump --add-drop-table --host=source.IP.addr.spec -uuser -ppassword databasename | mysql -uuser -ppassword I've found that it helps things if you add --no-data to the source side on the first pass, then remove that clause and run it again. Dave -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:54 PM To: [EMAIL PROTECTED] Subject: Backup question. I would like to backup databases from a linux MySQL server to another linux machine on the same private network but I don' see in the docs how I can do this with mysqlhotcopy or mysqldump. Is there any way to do this besides using ftp. Any help would be appreicated. Richard -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Backup question.
I think that it is more than backing up the database you want to do. If I am right you want to synchronize the 2 databases in which case the answer is replication. Replication is described in the reference manual of MySQL. Bernard On Tuesday 18 November 2003 04:59, Paco Martinez wrote: Is there any problem executing rsync /var/lib/mysql/data/ from one host to another host and therefore having same file in obth machines?? Is it unsafe this method ?? Could be crashed meanwhile transferring ?? Thanks !!! - Original Message - From: Christensen, Dave [EMAIL PROTECTED] To: 'Richard Reina' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:20 PM Subject: RE: Backup question. Yes, you can do it like this: Prompt mysqldump --add-drop-table --host=source.IP.addr.spec -uuser -ppassword databasename | mysql -uuser -ppassword I've found that it helps things if you add --no-data to the source side on the first pass, then remove that clause and run it again. Dave -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:54 PM To: [EMAIL PROTECTED] Subject: Backup question. I would like to backup databases from a linux MySQL server to another linux machine on the same private network but I don' see in the docs how I can do this with mysqlhotcopy or mysqldump. Is there any way to do this besides using ftp. Any help would be appreicated. Richard -- 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]
Re: Saving a table to a text file
mysqldump is a program like mysql not a command within mysql. Bernard On Monday 17 November 2003 21:46, Lay Hoon Tan wrote: I keep on getting errors for saving table to an external file. I think there is something wrong with the syntax. Could someone help me to correct it ? mysql mysqldump -r database table1; Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cronjob / rights problem - 2:nd try.
Hello Anders, NOTE: I am actually using SuSE 8.2 Pro Edition. However, those CRON jobs seem to be at the same place irrelevant of the distro (RedHat or SuSE). Therefore, I doubt that SuSE Linux Standard Server 8 has changed that. If the problem occurs once a day then it is within the script /etc/cron.daily/logrotate That script is used to rotate the various log files in order that they do not fill up the hard disk. The script logrotate will activate all the scripts in /etc/logrotate.d and one of them is called mysql. You will find within that script the activation of mysqladmin that generate the error. I cannot really tell what you have to do to have mysqladmin to work correctly. Probably you will have to specify a user with some kind of root permission. I hope that I have been helpful. Regards, Bernard On Friday 07 November 2003 14:47, Anders Norrbring wrote: [Second try, the first one rendered a few hints that didn't help] I've set up a new MySQL server on a box with multiple IP addresses, and the SQL server only binds to ONE of these addresses. Also, I've been changing some user rights in the SQL setup, and now I get a cronjob error, related to user rights... My big problem is that I don't even know where I should start looking for it. The system and MySQL setup is in all other aspects the distributed versions from the SuSE Linux Standard Server 8 distribution, based on United Linux 1.0. The cronjob error mailed to me is the following: SCRIPT: clean_catman, OK. SCRIPT: clean_core, OK. SCRIPT: do_mandb, OK. SCRIPT: logrotate exited with RETURNCODE = 1. SCRIPT: ouput (stdout stderr) follows /usr/bin/mysqladmin: refresh failed; error: 'Access denied for user: '@localhost' (Using password: NO)' error running postrotate script Reload syslog service..done SCRIPT: logrotate --- END OF OUTPUT SCRIPT: slots, OK. SCRIPT: ouput (stdout stderr) follows psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket /tmp/.s.PGSQL.5432? SCRIPT: slots --- END OF OUTPUT Can somebody please help me out here? If the /usr/bin/mysqladmin tries to use a user from localhost (any) then it fails, because localhost doesn't have access to the SQL server... What user should be granted access (and from where) to make this job work correctly? Anders Norrbring Norrbring Consulting Halmvägen 42 SE-691 48 Karlskoga SWEDEN -- 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: Cronjob / rights problem - 2:nd try.
Hello Anders, Sorry, I did not go through the end of your message. You also have a problem with psql which is, I think, the equivalent of mysql for PostgreSQL. Do you need PostgreSQL? If not, you should deactivate it. For your problem with mysqladmin, most probably specifying the switch --host with the hostname associated with your binding will fix the problem. Regards, Bernard On Friday 07 November 2003 15:15, Bernard Clement wrote: Hello Anders, NOTE: I am actually using SuSE 8.2 Pro Edition. However, those CRON jobs seem to be at the same place irrelevant of the distro (RedHat or SuSE). Therefore, I doubt that SuSE Linux Standard Server 8 has changed that. If the problem occurs once a day then it is within the script /etc/cron.daily/logrotate That script is used to rotate the various log files in order that they do not fill up the hard disk. The script logrotate will activate all the scripts in /etc/logrotate.d and one of them is called mysql. You will find within that script the activation of mysqladmin that generate the error. I cannot really tell what you have to do to have mysqladmin to work correctly. Probably you will have to specify a user with some kind of root permission. I hope that I have been helpful. Regards, Bernard On Friday 07 November 2003 14:47, Anders Norrbring wrote: [Second try, the first one rendered a few hints that didn't help] I've set up a new MySQL server on a box with multiple IP addresses, and the SQL server only binds to ONE of these addresses. Also, I've been changing some user rights in the SQL setup, and now I get a cronjob error, related to user rights... My big problem is that I don't even know where I should start looking for it. The system and MySQL setup is in all other aspects the distributed versions from the SuSE Linux Standard Server 8 distribution, based on United Linux 1.0. The cronjob error mailed to me is the following: SCRIPT: clean_catman, OK. SCRIPT: clean_core, OK. SCRIPT: do_mandb, OK. SCRIPT: logrotate exited with RETURNCODE = 1. SCRIPT: ouput (stdout stderr) follows /usr/bin/mysqladmin: refresh failed; error: 'Access denied for user: '@localhost' (Using password: NO)' error running postrotate script Reload syslog service..done SCRIPT: logrotate --- END OF OUTPUT SCRIPT: slots, OK. SCRIPT: ouput (stdout stderr) follows psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket /tmp/.s.PGSQL.5432? SCRIPT: slots --- END OF OUTPUT Can somebody please help me out here? If the /usr/bin/mysqladmin tries to use a user from localhost (any) then it fails, because localhost doesn't have access to the SQL server... What user should be granted access (and from where) to make this job work correctly? Anders Norrbring Norrbring Consulting Halmvägen 42 SE-691 48 Karlskoga SWEDEN -- 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: [jp] connection from MSSQL
Hi Jorge, Hum! you should use MySQL Control Center (AKA mysqlcc)? You will not have to worry about configuring (I do not think it is feasible) openrowset fo connect to MySQL. Regards, Bernard On Thursday 06 November 2003 13:43, Jorge Paiva (f2) wrote: Hi everybody.! can i use openrowset from MS-SQL SERVER to connect to mysql server ??? how can i doing it? pls. thank you. pta: my english is poor... sorry. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
