How can we use --log-warnings

[Marois, David]

We are with mysql 4.0.17-log and we want to use --log-warnings to see aborted 
connections in our errorlog.
 
We put log_warnings = 2 in our my.cnf and restarted mysql but we did not see 
aborted connections in our errorlog.
 
We tried --log-warnings = 2 on the command line when we started mysql and 
again, we did not see aborted connections in our errorlog.
 
We tried --log-warnings on the command line when we started mysql and again, we 
did not see aborted connections in our errorlog.
 
When I do a mysqladmin variables, I saw log_warnings = ON.
 
So, how can we set this parameter to be able to see something in our errorlog ?
 
 
David Marois
  [EMAIL PROTECTED]
 

ms sql server to mysql migration

[sirisha gnvg]

hello,

The platform we are working is Mysql 4.1.8 version
and Windows XP os.

In ms sql server the space used and free space
available for each database is obtained through
'sp_spaceused'procedure( built in ).

Primary memory used by ms sql server and related
services like query browser is obtained by
"sysprocesses" table.It gives primary memory used in
terms of pages in cache.

The cpu used by ms sql server is obtained through 
"spt_monitor" table.

similarly my friends who are working on oracle
obtained  all the above values from system tables for
oracle.
so both of them that is those working on ms sql server
and oracle could use them directly in java programs.

 Are there any system tables in mysql that give
info. about the above issues.If so please suggest
them.

 If not please suggest us a way to get info. about
above issues so that we can use them in our java
programs.

  Thanks in advance.



Yahoo! India Matrimony: Find your life partner online
Go to: http://yahoo.shaadi.com/india-matrimony

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

RE: Indexing Questions (Problem?)

[Tom Crimmins]

> >>Do I need to make a special index to index time on HOUR?  
> Is it even  
> >>possible?
> > 
> > I believe the index on time will work for this.
> 
> No, it won't.  At least, not with the query as is:
> 
>SELECT * FROM logs
>WHERE host IN ('10.20.254.5')
>  AND date='2005-02-03'
>  AND HOUR(time) BETWEEN '16' AND '17'
>ORDER BY seq  DESC;
> 
> Once you feed a column through a function, you prevent use of 
> its index. 

Yep my fault, meant to explain that the query should be changed. I thought I
did that above when I suggested adding the index for the first query, but I
obviously did not.

---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa

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

Re: Indexing Questions (Problem?)

[Michael Stassen]

Tom Crimmins wrote:
-Original Message-
From: Brad Guillory
Sent: Thursday, February 03, 2005 18:15

mysql> EXPLAIN SELECT * FROM logs WHERE  host   in 
('10.20.254.5')  and  
 date='2005-02-03'  and  HOUR(time) between '16' and '17'  
ORDER BY seq DESC;
ALTER TABLE logs ADD unique (host,date,time,seq);
You may have to run myisamchk -a, or ANALYZE TABLE after this. 
http://dev.mysql.com/doc/mysql/en/myisamchk-syntax.html
http://dev.mysql.com/doc/mysql/en/myisamchk-other-options.html
This index will function as an index on host, as well, so the current 
single-column index on host will be redundant and should be dropped.

  ALTER TABLE logs DROP INDEX host;
Unnecessary indexes slow you down.  In that vein, you should drop any other 
indexes that are unlikely to be used.  For example, unless you will be 
running queries in which you select rows by time *without* regard to date, 
the single-column index on time seems unlikely to be used and should also be 
dropped.

This should help the performance of this query.

+---+--+---+--+-+--+ 
+-+
| table | type | possible_keys | key  | key_len | ref  | rows 
 | Extra  
  |
+---+--+---+--+-+--+ 
+-+
| logs  | ALL  | host,date | NULL |NULL | NULL | 
139817 | Using  
where; Using filesort |
+---+--+---+--+-+--+ 
+-+
1 row in set (0.00 sec)

mysql> EXPLAIN SELECT * FROM logs WHERE  priority="warning"  
ORDER BY  
seq DESC;
+---+--+---+--+-+--+ 
+-+
| table | type | possible_keys | key  | key_len | ref  | rows 
 | Extra  
  |
+---+--+---+--+-+--+ 
+-+
| logs  | ALL  | priority  | NULL |NULL | NULL | 
139817 | Using  
where; Using filesort |
+---+--+---+--+-+--+ 
+-+
1 row in set (0.00 sec)

mysql> EXPLAIN SELECT * FROM logs WHERE  priority="notice"  ORDER BY  
seq DESC;
+---+--+---+--+-+---+-- 
+-+
| table | type | possible_keys | key  | key_len | ref   | rows |  
Extra   |
+---+--+---+--+-+---+-- 
+-+
| logs  | ref  | priority  | priority |  11 | const | 4003 |  
Using where; Using filesort |
+---+--+---+--+-+---+-- 
+-+
1 row in set (0.00 sec)

It doesn't look like it is helping at all for any but the 
last SELECT.   
There are several things that I don't understand.

Why does the second query not benefit from the index but the 
third does?

My guess is that most of your rows have priority="warning". Due to the
cardinality of the index, the optimizer knows that it will not really
benefit from this index. In the case of priority="notice", the query will
benefit from the index. You could add the following index, but I don't know
how useful these last queries will be since both return a lot of rows.
Yes, SHOW INDEX says priority has a cardinality of 2 (higher is better). 
From the EXPLAIN output, 4003 rows have priority = "notice" and 139817 have 
priority = "warning".  Hence the index on priority is useful for "notice" 
and useless for "warning".  Fast notice retrieval but slow warning retrieval 
doesn't sound very helpful.  You should probaly drop the index on priority.

ALTER TABLE logs ADD UNIQUE (priority,seq);
This might help with the ordering.  You should definitely drop the index on 
priority if you add this.

Why does the select say "Using filesort" but seq is indexed?
The column used to restrict rows is not part of the key, therefore this 
index
will not help. The above index will fix this. You may want to read the
following. It explains how mysql uses indexes with the order by clause.
http://dev.mysql.com/doc/mysql/en/order-by-optimization.html
Do I need to make a special index to index time on HOUR?  Is it even  
possible?
I believe the index on time will work for this.
No, it won't.  At least, not with the query as is:
  SELECT * FROM logs
  WHERE host IN ('10.20.254.5')
AND date='2005-02-03'
AND HOUR(time) BETWEEN '16' AND '17'
  ORDER BY seq  DESC;
Once you feed a column through a function, you prevent use of its index. 
Here, using HOUR() on time prevents use of the index on time (or the 3rd 
part of your multi-column index).  Always write your queries to compare 
columns (not functions of columns) to constants, if at all possible.  This 
query should be

  SELECT * FROM logs
  WHERE host = '10.20.254.5'
AND date='2005-02-03'
AND time BETWEEN '16:00:00' AND '17:00:00'
  ORDER BY seq DESC;
to allow use of the ind

Symchronization problem

[Andre Matos]

Hi List,

A have two MySQL 4.1.9 installed into two Linux servers and synchronized
them, so I have now a master and slave.

My problem is that since I synchronized them, I am receiving comments from
my users that the speed is not good as before the synchronization. Is this
possible? If yes, how and where can I check this?

Thanks for any help.

Andre

--
Andre Matos
[EMAIL PROTECTED] 


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

Re: Force index

[Michael Stassen]

USE INDEX
FORCE INDEX
IGNORE INDEX
See the manual  for details.
Michael
ninjajs wrote:
Hi,
A table have index1 and index2.
A SQL use index1 on Table A.
I'd like to use index2 on Table A.
How can I do for using index2?
ORACLE has SQL hint which is force SQL execution plan.
Thank you for your advice.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Indexing Questions (Problem?)

[Tom Crimmins]

> -Original Message-
> From: Brad Guillory
> Sent: Thursday, February 03, 2005 18:15
> 
> Please be gentle, I have nearly no experience with SQL 
> databases.  I am  
> not subscribed to the list so please cc me on replies.
> 
> Because my email client probably did horrable things to this 
> post you  
> can find the text here also:
> http://nolab.org/scratch/mysql-index-oddness.html
> 
> I use syslog-ng to log syslog events to a mysql database.  
> Retreiving  
> data was taking 5-10 minutes so I decided to try to learn a 
> bit about  
> indexes to try to speed things up.  This is what I ended up 
> setting up.
> Database: syslog  Table: logs  Rows: 186422
> +--+--+--+-+-+
>  
> +-+
> | Field| Type | Null | Key | Default | Extra  
> |  
> Privileges  |
> +--+--+--+-+-+
>  
> +-+
> | host | varchar(32)  | YES  | MUL | |
> |  
> select,insert,update,references |
> | facility | varchar(10)  | YES  | MUL | |
> |  
> select,insert,update,references |
> | priority | varchar(10)  | YES  | MUL | |
> |  
> select,insert,update,references |
> | level| varchar(10)  | YES  | | |
> |  
> select,insert,update,references |
> | tag  | varchar(10)  | YES  | | |
> |  
> select,insert,update,references |
> | date | date | YES  | MUL | |
> |  
> select,insert,update,references |
> | time | time | YES  | MUL | |
> |  
> select,insert,update,references |
> | program  | varchar(15)  | YES  | | |
> |  
> select,insert,update,references |
> | msg  | text | YES  | | |
> |  
> select,insert,update,references |
> | seq  | int(10) unsigned |  | PRI | | 
> auto_increment |  
> select,insert,update,references |
> +--+--+--+-+-+
>  
> +-+
> 
> 
> mysql> SHOW INDEX FROM logs;
> +---++--+--+- 
> +---+-+--++--+ 
> +-+
> | Table | Non_unique | Key_name | Seq_in_index | Column_name |  
> Collation | Cardinality | Sub_part | Packed | Null | Index_type |  
> Comment |
> +---++--+--+- 
> +---+-+--++--+ 
> +-+
> | logs  |  0 | PRIMARY  |1 | seq 
> | A 
>   |  186422 | NULL | NULL   |  | BTREE  | |
> | logs  |  1 | host |1 | host
> | A 
>   |   2 | NULL | NULL   | YES  | BTREE  | |
> | logs  |  1 | time |1 | time
> | A 
>   |2741 | NULL | NULL   | YES  | BTREE  | |
> | logs  |  1 | date |1 | date
> | A 
>   |   1 | NULL | NULL   | YES  | BTREE  | |
> | logs  |  1 | priority |1 | priority
> | A 
>   |   2 | NULL | NULL   | YES  | BTREE  | |
> | logs  |  1 | facility |1 | facility
> | A 
>   |   2 | NULL | NULL   | YES  | BTREE  | |
> +---++--+--+- 
> +---+-+--++--+ 
> +-+
> 6 rows in set (0.00 sec)
> 
> Based on a short tutorial that I found I decided to look at 
> how these  
> new indexes would affect my SELECT using the EXPLAIN command:
> 
> mysql> EXPLAIN SELECT * FROM logs WHERE  host   in 
> ('10.20.254.5')  and  
>   date='2005-02-03'  and  HOUR(time) between '16' and '17'  
> ORDER BY seq  
> DESC;

ALTER TABLE logs ADD unique (host,date,time,seq);

You may have to run myisamchk -a, or ANALYZE TABLE after this. 
http://dev.mysql.com/doc/mysql/en/myisamchk-syntax.html
http://dev.mysql.com/doc/mysql/en/myisamchk-other-options.html

This should help the performance of this query.

> +---+--+---+--+-+--+ 
> +-+
> | table | type | possible_keys | key  | key_len | ref  | rows 
>   | Extra  
>|
> +---+--+---+--+-+--+ 
> +-+
> | logs  | ALL  | host,date | NULL |NULL | NULL | 
> 139817 | Using  
> where; Using filesort |
> +---+--+---+--+-+--+ 
> +-+
> 1 row in set (0.00 sec)
> 
> mysql> EXPLA

Force index

[ninjajs]

Hi,

A table have index1 and index2.

A SQL use index1 on Table A.

I'd like to use index2 on Table A.

How can I do for using index2?

ORACLE has SQL hint which is force SQL execution plan.

Thank you for your advice.

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

Indexing Questions (Problem?)

[Brad Guillory]

Please be gentle, I have nearly no experience with SQL databases.  I am  
not subscribed to the list so please cc me on replies.

Because my email client probably did horrable things to this post you  
can find the text here also:
http://nolab.org/scratch/mysql-index-oddness.html

I use syslog-ng to log syslog events to a mysql database.  Retreiving  
data was taking 5-10 minutes so I decided to try to learn a bit about  
indexes to try to speed things up.  This is what I ended up setting up.
Database: syslog  Table: logs  Rows: 186422
+--+--+--+-+-+ 
+-+
| Field| Type | Null | Key | Default | Extra  |  
Privileges  |
+--+--+--+-+-+ 
+-+
| host | varchar(32)  | YES  | MUL | ||  
select,insert,update,references |
| facility | varchar(10)  | YES  | MUL | ||  
select,insert,update,references |
| priority | varchar(10)  | YES  | MUL | ||  
select,insert,update,references |
| level| varchar(10)  | YES  | | ||  
select,insert,update,references |
| tag  | varchar(10)  | YES  | | ||  
select,insert,update,references |
| date | date | YES  | MUL | ||  
select,insert,update,references |
| time | time | YES  | MUL | ||  
select,insert,update,references |
| program  | varchar(15)  | YES  | | ||  
select,insert,update,references |
| msg  | text | YES  | | ||  
select,insert,update,references |
| seq  | int(10) unsigned |  | PRI | | auto_increment |  
select,insert,update,references |
+--+--+--+-+-+ 
+-+

mysql> SHOW INDEX FROM logs;
+---++--+--+- 
+---+-+--++--+ 
+-+
| Table | Non_unique | Key_name | Seq_in_index | Column_name |  
Collation | Cardinality | Sub_part | Packed | Null | Index_type |  
Comment |
+---++--+--+- 
+---+-+--++--+ 
+-+
| logs  |  0 | PRIMARY  |1 | seq | A 
 |  186422 | NULL | NULL   |  | BTREE  | |
| logs  |  1 | host |1 | host| A 
 |   2 | NULL | NULL   | YES  | BTREE  | |
| logs  |  1 | time |1 | time| A 
 |2741 | NULL | NULL   | YES  | BTREE  | |
| logs  |  1 | date |1 | date| A 
 |   1 | NULL | NULL   | YES  | BTREE  | |
| logs  |  1 | priority |1 | priority| A 
 |   2 | NULL | NULL   | YES  | BTREE  | |
| logs  |  1 | facility |1 | facility| A 
 |   2 | NULL | NULL   | YES  | BTREE  | |
+---++--+--+- 
+---+-+--++--+ 
+-+
6 rows in set (0.00 sec)

Based on a short tutorial that I found I decided to look at how these  
new indexes would affect my SELECT using the EXPLAIN command:

mysql> EXPLAIN SELECT * FROM logs WHERE  host   in ('10.20.254.5')  and  
 date='2005-02-03'  and  HOUR(time) between '16' and '17'  ORDER BY seq  
DESC;
+---+--+---+--+-+--+ 
+-+
| table | type | possible_keys | key  | key_len | ref  | rows   | Extra  
  |
+---+--+---+--+-+--+ 
+-+
| logs  | ALL  | host,date | NULL |NULL | NULL | 139817 | Using  
where; Using filesort |
+---+--+---+--+-+--+ 
+-+
1 row in set (0.00 sec)

mysql> EXPLAIN SELECT * FROM logs WHERE  priority="warning"  ORDER BY  
seq DESC;
+---+--+---+--+-+--+ 
+-+
| table | type | possible_keys | key  | key_len | ref  | rows   | Extra  
  |
+---+--+---+--+-+--+ 
+-+
| logs  | ALL  | priority  | NULL |NULL | NULL | 139817 | Using  
where; Using filesort |
+---+--+---+--+-+--+ 
+-+
1 row in set (0.00 sec)

mysql> EXPLAIN SELECT * FROM logs WHERE  priority="notice"  ORDER BY  

Re: MySQL ODBC 3.51 with alpha5.0.1 on Windows 2003

[Daniel Kasak]

Lily Wei wrote:
Hi:
 I have problem connect to my MySQL alpha5.0.1 server
using MySQL ODBC 3.51. I got this error:
That's some error!
Even though MS Exchange ate your picture, I can guess what your problem 
is: you haven't read the documentation about MySQL-4.1 and 5.0 and the 
new authentication system.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL ODBC 3.51 with alpha5.0.1 on Windows 2003

[Lily Wei]

Hi:

 I have problem connect to my MySQL alpha5.0.1 server

using MySQL ODBC 3.51. I got this error: 



 

 

Please help!

 

Thanks,

lily

register to mail list

[Lily Wei]

REGISTERED MAIL

 

thanks,

lily

Re: MySQL 5.02 on Win2K

[Whil Hentzen]

Elim Qiu wrote:
Here is where i stuck:
I stopped the mysql service, renamed the 5.01 folder(backup), unzip the 5.02
and put it where 5.01 worked.
 

I'm wondering if there are specific folder names that have "5.02" 
instead of "5.01"? Or registry entries?

My version of MySQL doesn't have anything other than "5.0" in the file 
and folder names, but I didn't spelunk through the registry.

I also didn't do an update 'over' or 'next to' like you did.
Whil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Rowcount?

[Peter Brawley]

FOUND_ROWS()
Homam S.A. wrote:
Is there a rowcount global variable or function in
MySQL equivalent to @@rowcount in MS SQL Server that
returns the number of affected rows from the last SQL
statement on the current connection?
Thanks!
		
__ 
Do you Yahoo!? 
All your favorites on one personal page – Try My Yahoo!
http://my.yahoo.com 

 


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 2/3/2005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Rowcount?

[Homam S.A.]

Is there a rowcount global variable or function in
MySQL equivalent to @@rowcount in MS SQL Server that
returns the number of affected rows from the last SQL
statement on the current connection?

Thanks!



__ 
Do you Yahoo!? 
All your favorites on one personal page – Try My Yahoo!
http://my.yahoo.com 

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

Re: MySQL 5 ODBC error on Win2K

[Whil Hentzen]

- SQL command on connect: left empty
Note that I can connect to and manipulate the test database 
interactively (I added a table, inserted records, etc., all as user 
   

'whil')
 

7. Hit "Test Data Source"
8. Error message: [MySQL][ODBC 3.51 Driver] Client does not support 
authentication protocol requested by server; consider upgrading MySQL 
client.

9. I have no idea what this means. I don't even understand some of the 
words, much less the whole durn tootin' sentence.

I tried the same thing with a System DSN (and it filled in 'localhost' 
for the Host/Server instead of 127.0.0.1), and got the same error.

Ideas? Is this a user error or a driver error?  Is this MySQL5 specific?
Thanks,
Whil
   

This is neither a user error nor a driver error. What has happened is that 
the ODBC drivers prior to 3.51.10 do not understand the new user 
authentication that entered MySQL as of v4.1 . There are several ways to 
work around this. They are well documented here:

http://dev.mysql.com/doc/mysql/en/old-client.html
 

Well, then it's actually a user error who didn't read the docs well 
enough /s/

Thanks, Shawn. I've got (most) of it working now! (Inside my app I'm 
still having trouble, but that's not appropriate for this list!)

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

Re: MySQL 5.02 on Win2K

[Elim Qiu]

Here is where i stuck:

I stopped the mysql service, renamed the 5.01 folder(backup), unzip the 5.02
and put it where 5.01 worked.
Delete the data folder shipped with 5.02zip and restart the service. Since
my data location is outside
of the mysql installation location and this is working with my.ini settings
for 5.01, I don't see anything else needed
and just restart the service.

It said the survice started ok and I logged in with mysql client fine.
(version 5.02 alpha shown).
now the real interaction:

mysql> use emailer
Database changed
mysql>show tables;

Now mysql used 100% cpu and the whole system hardly response any commands.

Maybe i need to uninstall the service and reinstall the new one?

- Original Message - 
From: "Whil Hentzen" <[EMAIL PROTECTED]
To: "Elim Qiu" <[EMAIL PROTECTED]
Cc: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 5 ODBC error on Win2K

[SGreen]

Whil Hentzen <[EMAIL PROTECTED]> wrote on 02/03/2005 11:02:48 AM:

> 
> 1. Windows 2K and MySQL 5
> 2. Downloaded the 3.51.9 driver (I've seen a number of issues reported 
> with the .10 driver, so avoided it to begin with) and installed it. It 
> shows up in the ODBC admin nicely.
> 3. Created a new file DSN with the ODBC Admin
> 4. After I entered a name for the dsn ("mysqlf"), I hit Finish and the 
> MySQL DSN Config dialog appeared.
> 5. Trouble ensued.
> 6. The settings I used:
> - Host/Server Name: 127.0.0.1
> - Database Name: test (the test database taht comes with MySQL)
> - User: whil
> - Password: secret (which is whil's password in the MySQL user grant 
table)
> - Port (if not 3306): left empty
> - SQL command on connect: left empty
> 
> Note that I can connect to and manipulate the test database 
> interactively (I added a table, inserted records, etc., all as user 
'whil')
> 
> 7. Hit "Test Data Source"
> 8. Error message: [MySQL][ODBC 3.51 Driver] Client does not support 
> authentication protocol requested by server; consider upgrading MySQL 
> client.
> 
> 9. I have no idea what this means. I don't even understand some of the 
> words, much less the whole durn tootin' sentence.
> 
> I tried the same thing with a System DSN (and it filled in 'localhost' 
> for the Host/Server instead of 127.0.0.1), and got the same error.
> 
> Ideas? Is this a user error or a driver error?  Is this MySQL5 specific?
> 
> Thanks,
> 
> Whil
> 

This is neither a user error nor a driver error. What has happened is that 
the ODBC drivers prior to 3.51.10 do not understand the new user 
authentication that entered MySQL as of v4.1 . There are several ways to 
work around this. They are well documented here:

http://dev.mysql.com/doc/mysql/en/old-client.html

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Re: MySQL 5.02 on Win2K

[Whil Hentzen]

Elim Qiu wrote:
Anyone successfully make MySQL 5.02 working on windows2000?
I'm using 5.01 (work fine with me) , and tried 5.02 serveral times with no
success.

 

I'm running 5.0.2-alpha-net on W2K. Got it running without any problems. 
Getting ODBC to work, on the other hand, was a bit of a chore, but that seems 
to be running now too.
What specific troubles are you having?
Whil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL 5.02 on Win2K

[Elim Qiu]

Anyone successfully make MySQL 5.02 working on windows2000?

I'm using 5.01 (work fine with me) , and tried 5.02 serveral times with no
success.



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 2/3/2005



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

Error on View

[Oropeza Querejeta, Alejandro]

Hi, 
 
I installed the mysql 5.0.2 alpha for linux and i got an error after
created a view and try to select * from the view.
 
ERROR 2013: Lost connection to MySQL server during query
 
Does anyone knows what is happening?
 
Best Regards
 
Alejandro

MySQL 5 ODBC error on Win2K

[Whil Hentzen]

1. Windows 2K and MySQL 5
2. Downloaded the 3.51.9 driver (I've seen a number of issues reported 
with the .10 driver, so avoided it to begin with) and installed it. It 
shows up in the ODBC admin nicely.
3. Created a new file DSN with the ODBC Admin
4. After I entered a name for the dsn ("mysqlf"), I hit Finish and the 
MySQL DSN Config dialog appeared.
5. Trouble ensued.
6. The settings I used:
- Host/Server Name: 127.0.0.1
- Database Name: test (the test database taht comes with MySQL)
- User: whil
- Password: secret (which is whil's password in the MySQL user grant table)
- Port (if not 3306): left empty
- SQL command on connect: left empty

Note that I can connect to and manipulate the test database 
interactively (I added a table, inserted records, etc., all as user 'whil')

7. Hit "Test Data Source"
8. Error message: [MySQL][ODBC 3.51 Driver] Client does not support 
authentication protocol requested by server; consider upgrading MySQL 
client.

9. I have no idea what this means. I don't even understand some of the 
words, much less the whole durn tootin' sentence.

I tried the same thing with a System DSN (and it filled in 'localhost' 
for the Host/Server instead of 127.0.0.1), and got the same error.

Ideas? Is this a user error or a driver error?  Is this MySQL5 specific?
Thanks,
Whil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Syntax Failures with SELECT SUBSTRING - Help!

[Gordon]

Try SELECT SUBSTRING(AnimalName, 1, 1)

MySQL wants the "(" to immediately follow the function i.e. no spaces.

-Original Message-
From: Sue Cram [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 03, 2005 9:28 AM
To: mysql@lists.mysql.com
Subject: Syntax Failures with SELECT SUBSTRING - Help!

Neither my developer nor I can figure out this one!  The package I'm using
is "Animal Shelter Manager" and is written in SQL.  Every other installation
of the product can use the SELECT SUBSTRING command except mine!  I use the
following code:

SELECT SUBSTRING (AnimalName, 1, 1)
FROM Animal

and I get "Syntax error or access violation near "(AnimalName, 1,1) FROM
Animal" at Line 1."   I can use the following with no error, so I know it
has to be in the SUBSTRING option:

SELECT AnimalName
FROM Animal

I also get a syntax error when I use an "IF" statement.  I get the same
error on my home computer (PC) and the PC's at our shelter office.  I also
get a message at startup that says:  "mmtask.exe Unable to locate component.
Application has failed to start because mmvcp70.dll was not found.
Reinstalling application may fix problem."  

Don't know if this is related to the substring error or not.   I have
reinstalled my application and it doesn't help.  I think I"m using the
current release of SQL but don't know how to check for sure.  As you can
probably tell, I'm new to SQL.  Can anyone help me with this problem?  

Thanks,
Sue in Sequim WA



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

Syntax Failures with SELECT SUBSTRING - Help!

[Sue Cram]

Neither my developer nor I can figure out this one!  The package I'm using is 
"Animal Shelter Manager" and is written in SQL.  Every other installation of 
the product can use the SELECT SUBSTRING command except mine!  I use the 
following code:

SELECT SUBSTRING (AnimalName, 1, 1)
FROM Animal

and I get "Syntax error or access violation near "(AnimalName, 1,1) FROM 
Animal" at Line 1."   I can use the following with no error, so I know it has 
to be in the SUBSTRING option:

SELECT AnimalName
FROM Animal

I also get a syntax error when I use an "IF" statement.  I get the same error 
on my home computer (PC) and the PC's at our shelter office.  I also get a 
message at startup that says:  "mmtask.exe Unable to locate component.  
Application has failed to start because mmvcp70.dll was not found.  
Reinstalling application may fix problem."  

Don't know if this is related to the substring error or not.   I have 
reinstalled my application and it doesn't help.  I think I"m using the current 
release of SQL but don't know how to check for sure.  As you can probably tell, 
I'm new to SQL.  Can anyone help me with this problem?  

Thanks,
Sue in Sequim WA

RE : help please : ERROR 2006: MySQL server has gone away

[Marois, David]

Hi Michael,
Yesterday, I restarted the server and the mysql database.
And In the errorlog, I only have 
050203 00:34:14 mysqld started
/u01/mysql/libexec/mysqld: ready for connections.
Version: '4.0.17-log' socket: '/tmp/mysql.sock' port: 3306

Also, I verified and my mysql user have access to write into my errorlog file 
and in my directories.

David

David Marois
-Message d'origine-
De : Michael Dykman [mailto:[EMAIL PROTECTED] 
Envoyé : 3 février, 2005 10:02
À : Marois, David
Cc : "MySQL List"
Objet : Re: help please : ERROR 2006: MySQL server has gone away


So far, you have only showed us the client-view of the problem..  look
in you data directories on the server machine... there is likely an
error file there which should give you some insight (unless permissions
for that directory are seriously messed up).  IF there is no error file,
determine which user MySQL is running as (default: mysql) and confirm
that user has read/write permissions to that directory and
subdirectories.

There are a few misconfigurations which take MySQL a bit of time to fail
on.. I know I had similar results last summer doing a manual
source-install of MySQL 4.1 which was related to the data-directory
permissions.. Having sorted it out, the server has been extremely stable
under heavy load for several continuous months now.

 - michael dykman


On Thu, 2005-02-03 at 08:38, Marois, David wrote:
> We still have the problem...
>  
> In the error log, I have nothing about problem. I only have that:
> 050203 00:34:14  mysqld started
> /u01/mysql/libexec/mysqld: ready for connections.
> Version: '4.0.17-log'  socket: '/tmp/mysql.sock'  port: 3306
>  
> If I do show variables, I have max_allowed_packet = 16776192
>  
> IF I log into mysql with :mysql -uroot --max_allowed_packet=16M  -p
>  
> After I do:show databases; and I receive the answer.
> After I wait 30 sec and launch the command "show databases;" again  and now I 
> have the error:
>  
> ERROR 2006: MySQL server has gone away
> No connection. Trying to reconnect...
>  
> 
> David 
>  
> 
>  
> Hello.
>  
> Does the problem remain? What is in the error log? Please, send
> us information about MySQL and operating system versions. There are
> two variables: max_allowed_packet - one has client, another has server.
> Run mysql with --max_allowed_packet=16M and mysqld with the same value.
> May be you have some ulimits which cause such behaviour? 
> 
>  
> -Message d'origine-
> De : Marois, David 
> Envoyé : 2 février, 2005 09:16
> À : 'mysql@lists.mysql.com'
> Objet : Re: help please : ERROR 2006: MySQL server has gone away
> 
> 
> And 
>  
> max_allowed_packet  = 16776192 
>  
> 
> David
> 
>  
> Hi, 
> my interactive_timeout variable is
>  
> interactive_timeout 3600
>  
> Thanks !
>  
> David
>  
> 
> Hello.
>  
> I've asked you about interactive_timeout, not wait_timeout.
>  
> 
> Mark <[EMAIL PROTECTED]> wrote:
> >> -Original Message-
> >> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> > 
> >> Sent: woensdag 2 februari 2005 12:46
> >> To: [EMAIL PROTECTED]
> >> Subject: Re: help please : ERROR 2006: MySQL server has gone away
> >> 
> >> Hello.
> >> 
> >> What's the value of the interactive_timeout system variable? See:
> >> http://dev.mysql.com/doc/mysql/en/server-system-variables.html
> >> http://dev.mysql.com/doc/mysql/en/gone-away.html
> > 
> > I believe he already answered that in part:
> > 
> >> > Also, my variable wait_timeout = 3600.
> > 
> > 1 hour, that is, instead of the default 8 (28800).
> > 
> > - Mark
> > 
> > 
> 
>  
> David Marois
>   [EMAIL PROTECTED]
>  
-- 
 - michael dykman
 - [EMAIL PROTECTED]





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

Re: performance on query with ORDER BY clause

[Marc Dumontier]

Thanks for your reply,
Just to be clear...performing my query without the order by clause will 
always return the list sorted by the primary identifier?
so that

SELECT SubmitId from BINDSubmit ORDER BY SubmitId == SELECT SubmitId from 
BINDSubmit
in this case

Marc
Dathan Pattishall wrote:
This tells the optimizer to do a table scan. If you used INNODB it's
already sorted by the primary key since INNODB supports clustered
indexes. Doing a table scan on innodb is very slow due to it's MVCC
control.
It's going to take a long time.

DVP

Dathan Vance Pattishall http://www.friendster.com

 

-Original Message-
From: Marc Dumontier [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, February 02, 2005 12:02 PM
To: mysql@lists.mysql.com
Subject: performance on query with ORDER BY clause

Hi,
I have a simple query with an ORDER BY clause, and it's 
taking forever to run on this table. I hope i've included all 
relevent information...it might just be one of the4 server 
variables which need adjustment.

the query is
SELECT SubmitId from BINDSubmit ORDER BY SubmitId
SubmitId is the primary Key, about 150,000 records table type 
is INNODB

mysql> describe BINDSubmit;
+-+-+--+-+
-++
| Field   | Type| Null | Key | 
Default | Extra  |
+-+-+--+-+
-++
| SubmitId| int(10) unsigned|  | PRI | 
NULL| auto_increment |
| BindId  | int(10) unsigned|  | MUL | 
0   ||
| UserId  | int(10) unsigned|  | MUL | 
0   ||
| Delegate| int(10) unsigned|  | MUL | 
0   ||
| Visible | tinyint(1)  |  | | 
1   ||
| Private | tinyint(1)  |  | | 
0   ||
| Compressed  | tinyint(1)  |  | | 
0   ||
| Verified| tinyint(1)  |  | | 
0   ||
| Status  | tinyint(3) unsigned |  | MUL | 
0   ||
| CurationType| tinyint(3) unsigned |  | | 
1   ||
| RecordType  | tinyint(3) unsigned |  | MUL | 
0   ||
| DateCreated | datetime|  | MUL | -00-00 
00:00:00 ||
| DateLastRevised | datetime|  | MUL | -00-00 
00:00:00 ||
| XMLRecord   | longblob|  | 
| ||
+-+-+--+-+
-++
14 rows in set (0.00 sec)

mysql> select count(*) from BINDSubmit;
+--+
| count(*) |
+--+
|   144140 |
+--+
1 row in set (5.09 sec)
mysql> explain select SubmitId from BINDSubmit ORDER BY SubmitId;
++---+---+-+-+
--++-+
| table  | type  | possible_keys | key | key_len | 
ref  | rows   
| Extra   |
++---+---+-+-+
--++-+
| BINDSubmit | index | NULL  | PRIMARY |   4 | 
NULL | 404947 
| Using index |
++---+---+-+-+
--++-+
1 row in set (0.00 sec)


# The MySQL server
[mysqld]
port= 3306
socket  = /tmp/mysql.sock
skip-locking
key_buffer = 128M
max_allowed_packet = 40M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency thread_concurrency = 4
# Uncomment the following if you are using InnoDB tables 
innodb_data_home_dir = /usr/local/mysql/data/ 
innodb_data_file_path = ibdata1:100M:autoextend 
innodb_log_group_home_dir = /usr/local/mysql/data/ 
innodb_log_arch_dir = /usr/local/mysql/data/ # You can set 
.._buffer_pool_size up to 50 - 80 % # of RAM but beware of 
setting memory usage too high innodb_buffer_pool_size = 512M 
innodb_additional_mem_pool_size = 20M # Set .._log_file_size 
to 25 % of buffer pool size innodb_log_file_size = 64M 
innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 
1 innodb_lock_wait_timeout = 50


Any help would be appreciated, so far query has been running 
for 3000 seconds

Marc Dumontier
--
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: help please : ERROR 2006: MySQL server has gone away

[Michael Dykman]

So far, you have only showed us the client-view of the problem..  look
in you data directories on the server machine... there is likely an
error file there which should give you some insight (unless permissions
for that directory are seriously messed up).  IF there is no error file,
determine which user MySQL is running as (default: mysql) and confirm
that user has read/write permissions to that directory and
subdirectories.

There are a few misconfigurations which take MySQL a bit of time to fail
on.. I know I had similar results last summer doing a manual
source-install of MySQL 4.1 which was related to the data-directory
permissions.. Having sorted it out, the server has been extremely stable
under heavy load for several continuous months now.

 - michael dykman


On Thu, 2005-02-03 at 08:38, Marois, David wrote:
> We still have the problem...
>  
> In the error log, I have nothing about problem. I only have that:
> 050203 00:34:14  mysqld started
> /u01/mysql/libexec/mysqld: ready for connections.
> Version: '4.0.17-log'  socket: '/tmp/mysql.sock'  port: 3306
>  
> If I do show variables, I have max_allowed_packet = 16776192
>  
> IF I log into mysql with :mysql -uroot --max_allowed_packet=16M  -p
>  
> After I do:show databases; and I receive the answer.
> After I wait 30 sec and launch the command "show databases;" again  and now I 
> have the error:
>  
> ERROR 2006: MySQL server has gone away
> No connection. Trying to reconnect...
>  
> 
> David 
>  
> 
>  
> Hello.
>  
> Does the problem remain? What is in the error log? Please, send
> us information about MySQL and operating system versions. There are
> two variables: max_allowed_packet - one has client, another has server.
> Run mysql with --max_allowed_packet=16M and mysqld with the same value.
> May be you have some ulimits which cause such behaviour? 
> 
>  
> -Message d'origine-
> De : Marois, David 
> Envoyà : 2 fÃvrier, 2005 09:16
> Ã : 'mysql@lists.mysql.com'
> Objet : Re: help please : ERROR 2006: MySQL server has gone away
> 
> 
> And 
>  
> max_allowed_packet  = 16776192 
>  
> 
> David
> 
>  
> Hi, 
> my interactive_timeout variable is
>  
> interactive_timeout 3600
>  
> Thanks !
>  
> David
>  
> 
> Hello.
>  
> I've asked you about interactive_timeout, not wait_timeout.
>  
> 
> Mark <[EMAIL PROTECTED]> wrote:
> >> -Original Message-
> >> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> > 
> >> Sent: woensdag 2 februari 2005 12:46
> >> To: [EMAIL PROTECTED]
> >> Subject: Re: help please : ERROR 2006: MySQL server has gone away
> >> 
> >> Hello.
> >> 
> >> What's the value of the interactive_timeout system variable? See:
> >> http://dev.mysql.com/doc/mysql/en/server-system-variables.html
> >> http://dev.mysql.com/doc/mysql/en/gone-away.html
> > 
> > I believe he already answered that in part:
> > 
> >> > Also, my variable wait_timeout = 3600.
> > 
> > 1 hour, that is, instead of the default 8 (28800).
> > 
> > - Mark
> > 
> > 
> 
>  
> David Marois
>   [EMAIL PROTECTED]
>  
-- 
 - michael dykman
 - [EMAIL PROTECTED]


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

help please : ERROR 2006: MySQL server has gone away

[Marois, David]

We still have the problem...
 
In the error log, I have nothing about problem. I only have that:
050203 00:34:14  mysqld started
/u01/mysql/libexec/mysqld: ready for connections.
Version: '4.0.17-log'  socket: '/tmp/mysql.sock'  port: 3306
 
If I do show variables, I have max_allowed_packet = 16776192
 
IF I log into mysql with :mysql -uroot --max_allowed_packet=16M  -p
 
After I do:show databases; and I receive the answer.
After I wait 30 sec and launch the command "show databases;" again  and now I 
have the error:
 
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
 
 
David 
 

 
Hello.
 
Does the problem remain? What is in the error log? Please, send
us information about MySQL and operating system versions. There are
two variables: max_allowed_packet - one has client, another has server.
Run mysql with --max_allowed_packet=16M and mysqld with the same value.
May be you have some ulimits which cause such behaviour? 

 
-Message d'origine-
De : Marois, David 
Envoyé : 2 février, 2005 09:16
À : 'mysql@lists.mysql.com'
Objet : Re: help please : ERROR 2006: MySQL server has gone away


And 
 
max_allowed_packet  = 16776192 
 
 
David

 
Hi, 
my interactive_timeout variable is
 
interactive_timeout 3600
 
Thanks !
 
David
 
 
Hello.
 
I've asked you about interactive_timeout, not wait_timeout.
 

Mark <[EMAIL PROTECTED]> wrote:
>> -Original Message-
>> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> 
>> Sent: woensdag 2 februari 2005 12:46
>> To: [EMAIL PROTECTED]
>> Subject: Re: help please : ERROR 2006: MySQL server has gone away
>> 
>> Hello.
>> 
>> What's the value of the interactive_timeout system variable? See:
>> http://dev.mysql.com/doc/mysql/en/server-system-variables.html
>> http://dev.mysql.com/doc/mysql/en/gone-away.html
> 
> I believe he already answered that in part:
> 
>> > Also, my variable wait_timeout = 3600.
> 
> 1 hour, that is, instead of the default 8 (28800).
> 
> - Mark
> 
> 

 
David Marois
  [EMAIL PROTECTED]
 

ssh connecting with a mysql client I get: ERROR 2013

[leegold]

ssh connecting with a mysql client gui I get:  ERROR 2013 Lost
connection to MySQL server during query

I'm using mysqlyog and trying connect via the ssh tunnel. I can connect
with out the ssh w/mysqljog OK. It's a very nice client and would like
to get this working. I have googled it but nothing seems to ring a bell.
I can ssh connect with Putty OK.

Is this a problem on the mysql on server or my desktop? What can it be?
Thanks.

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

Re: mysqldump and Foreign Keys

[Gleb Paharenko]

Hello.



Put SET FOREIGN_KEY_CHECKS=0 at the top of your dump file. In 4.1,

mysqldump puts that automatically to the dump file. See comments at:

  http://dev.mysql.com/doc/mysql/en/mysqldump.html





Michael Satterwhite <[EMAIL PROTECTED]> wrote:

> mysqldump backs all of the tables up in alphabetic order, including the 

> table create statements. The problem is that if foreign keys exist on 

> the tables, the reload will not work unless the backup file is hand 

> edited to insure that tables depended upon are created first. Is there a 

> way around this? If not, shouldn't the tables be created first and the 

> foreign keys created at the end of the backup? I *REALLY don't want to 

> hack mysqldump and am hoping that there's already a way around this - or 

> that a way is being developed.

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [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: err-report help me

[Gleb Paharenko]

Hello.



See:

  http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html

  http://dev.mysql.com/doc/mysql/en/windows-troubleshooting.html





" ???" <[EMAIL PROTECTED]> wrote:

> mysql=A3=AC=C4=FA=BA=C3=A3=A1

> 

> =09 when click mysql.exe on $home\bin ,the report err is

> "D:\Program Files\mysql\bin>mysql

> ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)=

> "

>  

> please help me

> 

> =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2

> =C0=F1=A3=A1

> =09=09=09=09

> 

> =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1 zhanghjun

> [EMAIL PROTECTED]

> =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12005-02-02

> 

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [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: help please : ERROR 2006: MySQL server has gone away

[Gleb Paharenko]

Hello.



Does the problem remain? What is in the error log? Please, send

us information about MySQL and operating system versions. There are

two variables: max_allowed_packet - one has client, another has server.

Run mysql with --max_allowed_packet=16M and mysqld with the same value.

May be you have some ulimits which cause such behaviour? 





[snip]

And 

max_allowed_packet  = 16776192 

David

Hi, 

my interactive_timeout variable is

interactive_timeout 3600

  Thanks !"Marois, David" <[EMAIL PROTECTED]> wrote:

[snip]



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [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: Still can't connect to MySQL 5 on FC3

[Gleb Paharenko]

Hello.



> [EMAIL PROTECTED] ~] /usr/bin/mysqld_safe

> tee: /var/lib/mysql/mybox.err: Permission denied

> -rw-rw   1 mysql root  1844 Feb  2 08:30 mybox.err



It seems that you launch the mysqld_safe script as 'me' instead of root. 





Whil Hentzen <[EMAIL PROTECTED]> wrote:

> Hi folks,

> 

> Been doing a lot of noodlin' and googlin' yesterday and today, and 

> thought I found the problem... but alas!

> 

> To recap:

> 

> I just installed MySQL 5 on a freshly updated FC3 box. I initially was 

> getting this error:

> 

> [EMAIL PROTECTED] ~] /usr/bin/mysqld_safe

> Starting mysqld daemon with databases from /var/lib/mysql

> /usr/bin/mysqld_safe: line 302: /var/lib/mysql/mybox.err: Permission denied

> /usr/bin/mysqld_safe: line 308: /var/lib/mysql/mybox.err: Permission denied

> STOPPING server from pid file /var/lib/mysql/mybox.pid

> tee: /var/lib/mysql/mybox.err: Permission denied

> 050202 09:21:36  mysqld ended

> tee: /var/lib/mysql/mybox.err: Permission denied

> 

> and this one:

> 

> [EMAIL PROTECTED] ~] mysql -u root

> ERROR 2002 (HY000): Can't connect to local MySQL server through socket 

> '/var/lib/mysql/mysql.sock' (2)

> [EMAIL PROTECTED] ~]

> 

> Then I found the notes about selinux interferring with mysql starting up 

> at http://forums.mysql.com/read.php?11,7164,7164

> 

> I tried

>  setenforce 0

> but I'm still getting the same errors.

> 

> Permissions are:

> 

> [EMAIL PROTECTED] /var/lib/mysql] I AM ROOT: ls -al

> total 20572

> drwxr-xr-x   4 mysql root  4096 Feb  2 08:30 .

> drwxr-xr-x  35 root  root  4096 Feb  1 13:45 ..

> -rw-rw   1 mysql root  1844 Feb  2 08:30 mybox.err

> -rw-rw   1 mysql mysql 10485760 Feb  2 08:30 ibdata1

> -rw-rw   1 mysql mysql  5242880 Feb  2 08:30 ib_logfile0

> -rw-rw   1 mysql mysql  5242880 Feb  2 08:30 ib_logfile1

> drwx--x--x   2 mysql root  4096 Feb  1 13:45 mysql

> drwxr-xr-x   2 mysql root  4096 Feb  1 13:45 test

> [EMAIL PROTECTED] /var/lib/mysql]

> 

> And the contents of the err file:

> 

> [EMAIL PROTECTED] /var/lib/mysql] tail mybox.err

> InnoDB: Setting log file ./ib_logfile1 size to 5 MB

> InnoDB: Database physically writes the file full: wait...

> InnoDB: Doublewrite buffer not found: creating new

> InnoDB: Doublewrite buffer created

> InnoDB: Creating foreign key constraint system tables

> InnoDB: Foreign key constraint system tables created

> 050202  8:30:51  InnoDB: Started; log sequence number 0 0

> 050202  8:30:51 [ERROR] Fatal error: Can't open privilege tables: Table 

> 'mysql.host' doesn't exist

> 050202 08:30:51  mysqld ended

> 

> I'm stuck. Suggestions?

> 

> Whil

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [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]