RE: Disable case sensitivity
Jerry: Can you specify the hardware/software your MySQL 3.23.41-max is running on? Kam -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 9:07 AM To: Fernando Monteiro Duarte Cc: [EMAIL PROTECTED] Subject: Re: Disable case sensitivity On Thu, Jan 10, 2002 at 11:52:34AM -0300, Fernando Monteiro Duarte wrote: > Hi, > > Does anybody knows if is possible to disable case sensitivity in > Linux MySQL?? Case sensitivity in what part? Table names? Values in columns? -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 189,274,654 queries (287/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: command mysql -u $user without typing it ????
Matt: Can you check and see if you have more than 1 entry for user in your user table? I wonder if there were more than 1 entry in the user table for user, MySQL might pick the first one which do not allow you to connect using user user. Kam -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 7:31 AM To: Carl Troein; [EMAIL PROTECTED] Subject: RE: command mysql -u $user without typing it Carl, great attempt, but that would be far to easy, I have removed the localhost entry and the jordan.no-dns.co.uk entry, the only place this remains is for root. dba and matt only have 1 entry, which is % so keep I am still in the dark -Original Message- From: Carl Troein [mailto:[EMAIL PROTECTED]] Sent: 10 January 2002 07:37 To: [EMAIL PROTECTED] Subject: Re: command mysql -u $user without typing it Matthew Darcy writes: > I was aware of the user table as a standard table. > > I did a select on it and it all looked fine. Loads of Y's and % for host > Yet this user still cannot connect. The only explaination is corruption. It sounds to me like you haven't removed the @localhost entry, but you want user@% to be matched when you connect from localhost. Could that be it? If so, section 4.2.8 is your (rather dull) friend. //C -- Carl Troein - Crdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: command mysql -u $user without typing it ????
Matt: Try the following: Use mysql select * from user (take a note on users that you're granting rights to) run the grant command select * from user (see if there is any differences) OR try grant all privileges to *.* to matt@"ipaddress" (where ipaddress == 999.999.999.999 your real ip address) -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 2:26 PM To: Ho Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it query ok I would expect to see, but "no rows affected" ??? this must mean it has not altered the database at all ?? I created a 2 new users, dba and matt I did grant all privileges to *.* to dba@"%" I cannot conntect from anything host as dba. I then did grant all privileges to *.* to matt@"jaguar.no-dns.co.uk" (my laptop) I got the no rows affected message and I cannot connect from the machine jaguar. something must be wrong. I used stand the pricinpals of the grant command but I cannot understand why no rows are affected. It does not surprise me that I cannot connect when no rows are affected. any other suggestions. Thanks for going into detail on this I am learning. Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:57 To: '[EMAIL PROTECTED]'; Ho, Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it The "Query OK, 0 rows affected" indicate that the user table is updated so test2 on localhost can access the mysql databases. Do you still get the "access is denyed for user @localhostto database mysql" message? -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:51 AM To: Ho Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it tired that but I am getting Query OK, 0 rows affected (0.00 sec) don't understand why it is not granting to the user ? Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:10 To: '[EMAIL PROTECTED]'; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it Try this: mysql> grant all privileges on *.* to test2@"localhost" also read manual about the grant command. -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:04 AM To: Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it I read similar notes on this in the manual, saying that invoking mysql without the username will try to take the unix username if it exists in the database. I tried this with test2, it opened an mysql session no problem, but when I did a connect mysql it said "access is denyed for user @localhostto database mysql" to me this looks like it is trying to connect with no user instead of test2@localhost can you explain this ? Thanks, Matt. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 15:56 To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: command mysql -u $user without typing it Matthew Darcy wrote: > >I have 3 UNIX users on my server. > >test1, test2, and test3. > >I have created 3 users for mysql test1, test2, and test3 (shock horror) > >If I want to connect to the database as root then I understand I must do >mysql -u root -p > >but I would like test1 2 and 3 to be able to type mysql and be either logged >in as their unix username, ie test2 types mysql and connects to the database >as test2 (mysql account) >or at least be prompted for the password for test2. > >The only way I can think of doing this is by setting up an alias ie > >alias mysql_connect=`mysql -u $username -p` > >there must be some sort of autologin from username like in oracle. > >Thanks, > >Matt. > The user defaults to the unix user. You can put a .my.cnf file in their home directory with [client] password=whatever to make it even easier. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --
Help! Undefined symbols while building c++ program using libmysqlclient.a in solaris
Hi All: I have problem linking my c++ program in solaris. The same program link correctly in Redhat linux. I'm using mysql 3.23.47 source build using gcc 2.95.3 (source build on solaris using Sun pre-build gcc 2.95.3) Here's the output from gcc: Undefined first referenced symbol in file socket /usr/local/lib/mysql/libmysqlclient.a(libmysql.o) getpeername /usr/local/lib/mysql/libmysqlclient.a(violite.o) gethostbyname /usr/local/lib/mysql/libmysqlclient.a(libmysql.o) setsockopt /usr/local/lib/mysql/libmysqlclient.a(violite.o) getservbyname /usr/local/lib/mysql/libmysqlclient.a(libmysql.o) floor /usr/local/lib/mysql/libmysqlclient.a(password.o) getsockopt /usr/local/lib/mysql/libmysqlclient.a(libmysql.o) inet_addr /usr/local/lib/mysql/libmysqlclient.a(libmysql.o) inet_ntoa /usr/local/lib/mysql/libmysqlclient.a(my_net.o) shutdown /usr/local/lib/mysql/libmysqlclient.a(violite.o) connect /usr/local/lib/mysql/libmysqlclient.a(libmysql.o) Thanks in advance Kam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: command mysql -u $user without typing it ????
The "Query OK, 0 rows affected" indicate that the user table is updated so test2 on localhost can access the mysql databases. Do you still get the "access is denyed for user @localhostto database mysql" message? -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:51 AM To: Ho Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it tired that but I am getting Query OK, 0 rows affected (0.00 sec) don't understand why it is not granting to the user ? Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:10 To: '[EMAIL PROTECTED]'; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it Try this: mysql> grant all privileges on *.* to test2@"localhost" also read manual about the grant command. -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:04 AM To: Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it I read similar notes on this in the manual, saying that invoking mysql without the username will try to take the unix username if it exists in the database. I tried this with test2, it opened an mysql session no problem, but when I did a connect mysql it said "access is denyed for user @localhostto database mysql" to me this looks like it is trying to connect with no user instead of test2@localhost can you explain this ? Thanks, Matt. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 15:56 To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: command mysql -u $user without typing it Matthew Darcy wrote: > >I have 3 UNIX users on my server. > >test1, test2, and test3. > >I have created 3 users for mysql test1, test2, and test3 (shock horror) > >If I want to connect to the database as root then I understand I must do >mysql -u root -p > >but I would like test1 2 and 3 to be able to type mysql and be either logged >in as their unix username, ie test2 types mysql and connects to the database >as test2 (mysql account) >or at least be prompted for the password for test2. > >The only way I can think of doing this is by setting up an alias ie > >alias mysql_connect=`mysql -u $username -p` > >there must be some sort of autologin from username like in oracle. > >Thanks, > >Matt. > The user defaults to the unix user. You can put a .my.cnf file in their home directory with [client] password=whatever to make it even easier. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php