RE: Max Packet for MySQL?

[Mike At Spy]

Dand, sorry, I forgot to cut and paste the error in there.  :\

It was something to the point of 'exceeded max_allowed_packet', though.

I can't find any sort of file in my system called 'my.cnf'.  Is there
another name or place this would be on a linux box?  I have a Cobalt RAQ4 if
you or anyone else knows anything about that specifically.

Thanks for the help!

:)

-Mike







 Could you include the error you receive?

 You can check the current value of your max_allowed_packet using the
 following command,

 mysql show variables like 'max_allowed_packet';

 max_allowed_packet determines the maximum packet length that the server
 can send and receive.

 You can set this value to something other than the default using,

 mysql set max_allowed_packet=1048576;

 To make the change more permanent you can add a line to /etc/my.cnf in
 the [mysqld] section of that config file and restart the server.

 Regards
 Mark.

 -Original Message-
 From: Mike At Spy [mailto:[EMAIL PROTECTED]
 Sent: 31 October 2003 15:04
 To: [EMAIL PROTECTED]
 Subject: Max Packet for MySQL?


 I'm getting the error:

 When uploading a file in my PHP code to a mysql table.

 From what I've read, this has to do with the max_allowed_packet variable
 in
 mysql.  How can I tell what that packet variable is set to?

 Do I have to re-compile mysql to change it?  Or is there a config file
 (linux OS) I can change it in and restart the server?

 Thanks For Any Help,

 -Mike



 --
 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]

Max Packet for MySQL?

[Mike At Spy]

I'm getting the error:

When uploading a file in my PHP code to a mysql table.

From what I've read, this has to do with the max_allowed_packet variable in
mysql.  How can I tell what that packet variable is set to?

Do I have to re-compile mysql to change it?  Or is there a config file
(linux OS) I can change it in and restart the server?

Thanks For Any Help,

-Mike



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

OR in MySQL statement?

[Mike At Spy]

How could I write a statement that uses something like 'OR' as a case.  Like
this:

SELECT * FROM list WHERE name = '$this1' OR name = '$this2' OR name =
'$that1'

?

Thanks for any help,

-Mike



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysql LOAD DATA INFILE

[Mike At Spy]

uhhh.there are only two fields in the table, but I'll give it a whirl.
:)

As for Donald's advice: it gave me access denied for user.  :\

-Mike



 -Original Message-
 From: Jay Blanchard [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 4:08 PM
 To: Mike At Spy; Donald Tyler; [EMAIL PROTECTED]
 Subject: RE: mysql LOAD DATA INFILE


 [snip]
 70050;451
 70322;451

  LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
  TERMINATED BY ';' LINES TERMINATED BY '\r\n'
  [/snip]
 [/snip]

 I am going to recommend that you specify which columns the data goes
 into

  LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one`(foo,
 bar) FIELDS
  TERMINATED BY ';' LINES TERMINATED BY '\r\n'





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql LOAD DATA INFILE

[Mike At Spy]

When I come across this error:

The used command is not allowed with this MySQL version

Does this mean that I need a whole different verison of MySQL, or just a
different compile?  The command was 'LOAD DATA INFILE' and I was doing it
through phpMyAdmin.

Thanks,

-Mike



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysql LOAD DATA INFILE

[Mike At Spy]

Sorry, that is the error - my mistake.  I am getting this:

LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
TERMINATED BY ';' LINES TERMINATED BY '\r\n'

I am using phpMyAdmin 2.3.3 - would an upgrade to the latest version remedy
the issue?

Thanks,

-Mike



 -Original Message-
 From: Donald Tyler [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 3:42 PM
 To: [EMAIL PROTECTED]
 Subject: RE: mysql LOAD DATA INFILE


 PHPMyAdmin uses the LOAD DATA LOCAL INFILE command. Just remove the word
 LOCAL and it should work fine.

 -Original Message-
 From: Mike At Spy [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 2:35 PM
 To: [EMAIL PROTECTED]
 Subject: mysql LOAD DATA INFILE


 When I come across this error:

 The used command is not allowed with this MySQL version

 Does this mean that I need a whole different verison of MySQL, or just a
 different compile?  The command was 'LOAD DATA INFILE' and I was doing it
 through phpMyAdmin.

 Thanks,

 -Mike



 --
 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: mysql LOAD DATA INFILE

[Mike At Spy]

Ah.  No wonder it dinna work.  Neither did specifying the columns as Jay
suggested.

I also have no choice but to do it through the browser - I don't have
command line access on the server. :\

-Mike


 -Original Message-
 From: Donald Tyler [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 4:08 PM
 To: [EMAIL PROTECTED]
 Subject: RE: mysql LOAD DATA INFILE


 Oh and just a note. This solution won't work if you are uploading the file
 to the server through the browser. You will need to put the file on the
 server and adjust the commands PATH accordingly.

 -Original Message-
 From: Donald Tyler [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 3:07 PM
 To: '[EMAIL PROTECTED]'
 Subject: FW: mysql LOAD DATA INFILE

 I see you still have the word LOCAL in there. Did you try and remove it?

 To do that in PHPMyAdmin you will need to run the import so you get the
 error message and then copy and paste it into the SQL section of the
 PHPMyadmin tool. Delete the world LOCAL and then run the query. It should
 work.

 -Original Message-
 From: Mike At Spy [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 2:59 PM
 To: Donald Tyler; [EMAIL PROTECTED]
 Subject: RE: mysql LOAD DATA INFILE


 Sorry, that is the error - my mistake.  I am getting this:

 LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
 TERMINATED BY ';' LINES TERMINATED BY '\r\n'

 I am using phpMyAdmin 2.3.3 - would an upgrade to the latest
 version remedy
 the issue?

 Thanks,

 -Mike



  -Original Message-
  From: Donald Tyler [mailto:[EMAIL PROTECTED]
  Sent: Friday, August 08, 2003 3:42 PM
  To: [EMAIL PROTECTED]
  Subject: RE: mysql LOAD DATA INFILE
 
 
  PHPMyAdmin uses the LOAD DATA LOCAL INFILE command. Just
 remove the word
  LOCAL and it should work fine.
 
  -Original Message-
  From: Mike At Spy [mailto:[EMAIL PROTECTED]
  Sent: Friday, August 08, 2003 2:35 PM
  To: [EMAIL PROTECTED]
  Subject: mysql LOAD DATA INFILE
 
 
  When I come across this error:
 
  The used command is not allowed with this MySQL version
 
  Does this mean that I need a whole different verison of MySQL, or just a
  different compile?  The command was 'LOAD DATA INFILE' and I
 was doing it
  through phpMyAdmin.
 
  Thanks,
 
  -Mike
 
 
 
  --
  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: mysql LOAD DATA INFILE

[Mike At Spy]

It's just a standard text file; here is a piece of it:

70321;451
70050;451
70322;451
70323;451
70051;451
67026;451
70053;451
67420;451
67419;451
70451;451
70452;451
67820;451
72080;451
72081;451
72082;451
72083;451
20148;452
39761;452
20147;452
20112;452

Just lines like this: a little over 15,000 of them.  :)

-Mike



 -Original Message-
 From: Jay Blanchard [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 3:58 PM
 To: Mike At Spy; Donald Tyler; [EMAIL PROTECTED]
 Subject: RE: mysql LOAD DATA INFILE
 
 
 [snip]
 Sorry, that is the error - my mistake.  I am getting this:
 
 LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
 TERMINATED BY ';' LINES TERMINATED BY '\r\n'
 [/snip]
 
 Mike, could we see just a bit of the php9GOwvw file...just out of
 curiosity
 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysql LOAD DATA INFILE

[Mike At Spy]

That is messy, but you are right.

I have FTP access and such - that's why I was wondering that with the new
version of MySQL out, is this a change in MySQL?  Or can the people who do
have command line access re-compile it or something to give me permission to
do what I need to do?

Thanks,

-Mike


 -Original Message-
 From: Donald Tyler [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 4:30 PM
 To: [EMAIL PROTECTED]
 Subject: FW: mysql LOAD DATA INFILE


 Then the only way you can do it that I can think of is to write a
 PHP script
 to do basically what PHPMyAdmin is trying to do but without the LOCAL in
 there.

 However to do that you would need to be able to place the PHP file on the
 server, and I guess you probably can't do that either. Talk about catch
 22...

 The only other way I can think of is to install MySQL on a machine you
 control, then import the data there using the method I suggested earlier.

 Once you have done that, you can use PHPMyAdmin to export the
 database from
 your machine. It should give you a SQL command that will create
 the data on
 another machine. Just copy and paste that into the SQL window on the main
 server and that will insert it.

 It's a little messy but that's the only other way I can think of doing it.
 Sorry.

 -Original Message-
 From: Mike At Spy [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 08, 2003 3:24 PM
 To: Donald Tyler; [EMAIL PROTECTED];
 [EMAIL PROTECTED]
 Subject: RE: mysql LOAD DATA INFILE


 Ah.  No wonder it dinna work.  Neither did specifying the columns as Jay
 suggested.

 I also have no choice but to do it through the browser - I don't have
 command line access on the server. :\

 -Mike


  -Original Message-
  From: Donald Tyler [mailto:[EMAIL PROTECTED]
  Sent: Friday, August 08, 2003 4:08 PM
  To: [EMAIL PROTECTED]
  Subject: RE: mysql LOAD DATA INFILE
 
 
  Oh and just a note. This solution won't work if you are
 uploading the file
  to the server through the browser. You will need to put the file on the
  server and adjust the commands PATH accordingly.
 
  -Original Message-
  From: Donald Tyler [mailto:[EMAIL PROTECTED]
  Sent: Friday, August 08, 2003 3:07 PM
  To: '[EMAIL PROTECTED]'
  Subject: FW: mysql LOAD DATA INFILE
 
  I see you still have the word LOCAL in there. Did you try and remove it?
 
  To do that in PHPMyAdmin you will need to run the import so you get the
  error message and then copy and paste it into the SQL section of the
  PHPMyadmin tool. Delete the world LOCAL and then run the query.
 It should
  work.
 
  -Original Message-
  From: Mike At Spy [mailto:[EMAIL PROTECTED]
  Sent: Friday, August 08, 2003 2:59 PM
  To: Donald Tyler; [EMAIL PROTECTED]
  Subject: RE: mysql LOAD DATA INFILE
 
 
  Sorry, that is the error - my mistake.  I am getting this:
 
  LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
  TERMINATED BY ';' LINES TERMINATED BY '\r\n'
 
  I am using phpMyAdmin 2.3.3 - would an upgrade to the latest
  version remedy
  the issue?
 
  Thanks,
 
  -Mike
 
 
 
   -Original Message-
   From: Donald Tyler [mailto:[EMAIL PROTECTED]
   Sent: Friday, August 08, 2003 3:42 PM
   To: [EMAIL PROTECTED]
   Subject: RE: mysql LOAD DATA INFILE
  
  
   PHPMyAdmin uses the LOAD DATA LOCAL INFILE command. Just
  remove the word
   LOCAL and it should work fine.
  
   -Original Message-
   From: Mike At Spy [mailto:[EMAIL PROTECTED]
   Sent: Friday, August 08, 2003 2:35 PM
   To: [EMAIL PROTECTED]
   Subject: mysql LOAD DATA INFILE
  
  
   When I come across this error:
  
   The used command is not allowed with this MySQL version
  
   Does this mean that I need a whole different verison of
 MySQL, or just a
   different compile?  The command was 'LOAD DATA INFILE' and I
  was doing it
   through phpMyAdmin.
  
   Thanks,
  
   -Mike
  
  
  
   --
   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]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ORDER BY with Date Format

[Mike At Spy]

I am trying to create an order by in a select statement that takes a
standard 'date' column in a table and sorts the returned data by the month
of that date.

Off hand, I tried

ORDER BY start_date(m)

And I know that is wrong.  Anyone have any suggestions?

Thanks,

-Mike



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Revoking Privs

[Mike At Spy]

I am trying to clear up our msyql by revoking privileges for users who no
longer exist on a particular server.

If I delete the users in the appropriate tables in the mysql database, will
that revoke their privileges?

I found in the user table in the mysql a few 'users' with no username or
password (the fields are completely blank) under generic hosts (localhost,
etc).  Should I delete these?

Thanks,

-Mike



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysql port number

[Mike At Spy]

Actually, I do google searches first before asking on any list - and it
didn't turn up a darn thing.

-Mike


 -Original Message-
 From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 04, 2002 6:19 PM
 To: Mike At Spy
 Cc: [EMAIL PROTECTED]
 Subject: Re: mysql port number


 On Wed, Dec 04, 2002 at 12:04:52PM -0500, Mike At Spy wrote:
 
  How can I tell what port number mysql is running on?  I need it
 for a chat
  program.  :)

 3306

 A google search would have found the answer in no time.
 --
 Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
 [EMAIL PROTECTED]  |  http://jeremy.zawodny.com/

 MySQL 3.23.51: up 14 days, processed 434,170,735 queries (344/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: mysql port number

[Mike At Spy]

That, of course, isn't even getting into the point that you didn't answer my
question.  I asked how I could tell, not what the default port was!

Thank you to the others that did.  :)

-Mike



 -Original Message-
 From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 04, 2002 6:19 PM
 To: Mike At Spy
 Cc: [EMAIL PROTECTED]
 Subject: Re: mysql port number


 On Wed, Dec 04, 2002 at 12:04:52PM -0500, Mike At Spy wrote:
 
  How can I tell what port number mysql is running on?  I need it
 for a chat
  program.  :)

 3306

 A google search would have found the answer in no time.
 --
 Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
 [EMAIL PROTECTED]  |  http://jeremy.zawodny.com/

 MySQL 3.23.51: up 14 days, processed 434,170,735 queries (344/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

mysql port number

[Mike At Spy]

How can I tell what port number mysql is running on?  I need it for a chat
program.  :)

Thanks,

-Mike



-
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

LIMIT in MySQL

[Mike At Spy]

I must not be awake yet.  Why is this query sending me back 60 records?
Shouldn't it only send back records 30 through 60 (i.e. 30 records)?

SELECT * FROM table ORDER BY somefield LIMIT 30,60

Thanks,

-Mike



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL - version to install?

[Mike At Spy]

I've got to do a fresh install of mysql on a webserver (a new server, so it
isn't overwriting anything).  Does anyone have any info as whether I should
use just MySQL or MySQL-MAX?  What is the difference?

Thanks! :)

-Mike



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: MySQL statement problem

[Mike At Spy]

 Hi.

 On Mon, May 20, 2002 at 01:58:25PM -0400,
 [EMAIL PROTECTED] wrote:
 
  Shouldn't this come up with a list of names from each table
 that matches?
 
  SELECT * FROM table1,table2 WHERE table1.name = table2.name;
 
  Does anyone see anything wrong with this query?

 No.

  It keeps giving me an empty set - but there definitely matches.  I
  even did a LIKE instead of =, takes longer, but comes out the same.
  I triple checked the data, and it is *exactly* the same!

 If you have indexes defined on the table, try CHECK TABLE to assure
 that the indexes are working as expected.

Everything seems fine with CHECK TABLE.

 Else, try to create a test case. I.e. try to create a minimal set of
 SQL commands which will produce the strange behaviour in order to
 enable us to verify the behaviour.

 Creating a test case will also help, if it should be an usage error,
 as you will learn better what happens.

I'm not sure what you mean; do you mean running more basic commands?  I did
a generic SELECT * from each table, and they come out just fine.

Thanks for answering!  :)

-Mike



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL Problem

[Mike At Spy]

am having some trouble with MySQL.  Seems I cannot add users.  Well, I can
add them (through phpMyAdmin, but they are still not able to get into the
datasbases.  I flushed the tables, too.

Current users are not affected.

This started, rather suddenly, the day after I was able to do this.

Anyone have any ideas?

Thanks,

-Mike



-
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

Weird MySQL thing

[Mike At Spy]

I am having some trouble with MySQL.  Seems I cannot add users.  Well, I can
add them (through phpMyAdmin, but they are still not able to get into the
datasbases.  I flushed the tables, too.

Current users are not affected.

This started, rather suddenly, the day after I was able to do this.

Anyone have any ideas?

Thanks,

-Mike




-
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: Weird MySQL thing

[Mike At Spy]

Well, I know how to do it manually, but it is annoying compared to using an
interface like phpMyAdmin.

But it begs the question as to why adding people to the mysql tables worked
fine one day, and not the next.

I've restarted/reloaded mysql, restarted my server, looked at permission,
etc.

Since I didn't mention this earlier, I should also mention that I am on a
linux box (Cobalt RAQ4).

Thanks,

-Mike


 -Original Message-
 From: Petre Agenbag [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 17, 2002 2:48 PM
 To: Mike At Spy
 Subject: Re: Weird MySQL thing


 Yes, I'd also like to see the exact way to manually add users etc,
 specially to allow specific users access to specific tables from
 specific host.
 The best way I found to do this ( and the only one that works for me),
 is to use the mysql_setpermission executable. It's a menu driven util
 allowing you to do this amongst other things. Only thing is, you need to
 have perl DBI, MsSql-MySQL and Data Dumper installed to use it ( all are
 on the download page on mysql.com)

 Mike At Spy wrote:

 I am having some trouble with MySQL.  Seems I cannot add users.
 Well, I can
 add them (through phpMyAdmin, but they are still not able to get into the
 datasbases.  I flushed the tables, too.
 
 Current users are not affected.
 
 This started, rather suddenly, the day after I was able to do this.
 
 Anyone have any ideas?
 
 Thanks,
 
 -Mike
 
 
 
 
 -
 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