HI,
I am running MySQL 5.5.31 on FreeBSD 9.2. I have a web server with a
miss-configured service that generates faulty connections. After a
while, MySQl blocks any connection from the web server.
At some stage, I had set-up a script that would browse syslog log and
look for a string like Host
Olivier-Wilson; mysql@lists.mysql.com
Subject: RE: MySQL Error#: 2002
Check directory permissions, and check out the 'answers' in here:
http://forums.mysql.com/read.php?10,284776,284936
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: Monday, March 18, 2013 12
Check directory permissions, and check out the 'answers' in here:
http://forums.mysql.com/read.php?10,284776,284936
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: Monday, March 18, 2013 12:05 PM
To: mysql@lists.mysql.com
Subject: MySQL Error#: 2002
Dreamweaver, the error message is: MySQL Error#: 2002
Can't connect to local MySQL server through socket
'/var/lib/myswl/mysql.sock'(111).
I have one site that uses a different IP number that that site is ok. My static
sites, ie, no database inclusion, are ok.
Any ideas what to look for, most
MySQL 5.5.11
Perl 5.14.0
DBI 1.616
DBD::mysql 4.018
Installing the DBD::mysql on OS X Snow Leopard 10.6.6, I ran `perl Makefile.PL`
fine but `make test` produced:
# make test
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp
On Thu, May 5, 2011 at 10:29, Grega Leskovšek legr...@gmail.com wrote:
Can smbd please look at this sentence - I got an error and do not
know how to fix it - I am still very unfamiliar with MYSQL:
CREATE TABLE log ( idlog int auto_increment not null, imepriimek
varchar(50), clock
CREATE TABLE log ( idlog int auto_increment not null, imepriimek
varchar(50), clock timestamp, action varchar(30), onfile
varchar(100), filesize float(6,2),
uniqueid(idlog) ); -- here is your mistake
the syntax for that should be 'unique key(idlog)' if you only wanted
to specify a
Hello,
A few days ago I ran into Error 1045 when attempting to add a new
database user to my development machine. The error only occurred when
trying to connect to the database as a new user which I found a little
odd. After searching Google I discovered that this error is caused by a
Ignore that ... it's amazing how you can solve problems with enough
caffeine and enough time away from a computer screen .
On 9/20/2010 10:58 PM, Tim Thorburn wrote:
Hello,
A few days ago I ran into Error 1045 when attempting to add a new
database user to my development machine. The error
Hi,
On 21-9-2010 5:25, Tim Thorburn wrote:
Ignore that ... it's amazing how you can solve problems with enough
caffeine and enough time away from a computer screen .
It's also amazing how frustrating it is for those who are searching for
the problem you mentioned to only find threads with
Hi!
Machiel Richards wrote:
[[...]]
We received an error on a MySQL database this morning which
caused it to be unavailable for connections.
Error:
ERROR 1135 (0): Can't create a new thread (errno 11); if
you are not out of
of the amount of
connections though.
Machiel Richards
MySQL DBA
Relational Database Consulting
-Original Message-
From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com]
Sent: 30 June 2010 10:53 AM
To: mysql@lists.mysql.com
Cc: Machiel Richards
Subject: Re: Mysql error causing database
Good morning all
Hope everyone is well
We received an error on a MySQL database this morning which
caused it to be unavailable for connections.
Error:
ERROR 1135 (0): Can't create a new thread (errno 11); if
Note that some of the memory settings are per connection, if you have
63 connections, you may have up to 63 copies of the buffers, and you
have pretty huge buffers even with 30GB of memory. Join buffers close to
1 G, tmp_table_size of 2 G, 63 connections could mean upto 63 copies of
these,
@lists.mysql.com
Subject: Re: Mysql error causing database to not accept threads
Note that some of the memory settings are per connection, if you have
63 connections, you may have up to 63 copies of the buffers, and you
have pretty huge buffers even with 30GB of memory. Join buffers close to
1 G
Hi,
From yesterday 2009-08-26 i have an error message when my computer
start. The mysqld.exe crash blablabla
I search on g**gle 006B8853mysqld.exe and i find somebody in this
mailing with this problem!!
I don't change anything in my mysql config file, cause i didn't use
mysql
We are running MySQL 5.0.45 on a Linux machine.
Today, when I tried to go into MySQL via the command line, I got an error
message:
Can't connect to local MySQL server through socket
'/usr/local/mysql/tmp/mysql.sock'
The error log was full of the following messages:
InnoDB: Unable to lock
...@weizmann.ac.il]
Sent: Monday, June 08, 2009 10:02 AM
To: mysql@lists.mysql.com
Cc: shlomit.af...@weizmann.ac.il
Subject: MySQL error
We are running MySQL 5.0.45 on a Linux machine.
Today, when I tried to go into MySQL via the command line, I got an error
message:
Can't connect to local MySQL server
Per Jessen wrote:
It happened agaIn this morning, but slightly different:
[snip]
thd=0x7fe0140c7e00
Attempting backtrace. You can use the following information to find
out where mysqld died. If you see no messages after this, something
went terribly wrong...
Cannot determine thread,
Per Jessen wrote:
I have just discovered that my mysql server was restarted this
morning, which is what gave me the 2013. In the log I found this:
[snip]
It happened agaIn this morning, but slightly different:
[snip]
thd=0x7fe0140c7e00
Attempting backtrace. You can use the following
This weekend we completed migrating a large(ish) mysql server from
5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively
smoothly, until this morning when I noticed an application had choked
on getting Error 2013 Lost connection to MySQL server during query.
The application is running
Per Jessen wrote:
This weekend we completed migrating a large(ish) mysql server from
5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively
smoothly, until this morning when I noticed an application had choked
on getting Error 2013 Lost connection to MySQL server during query.
I
Michael Dykman wrote:
It might be helpful if you could tell us how you affected your data
migration
Sorry, I'm not familiar with reporting problems in/on mysql.
The data migration was done with a full database dump (mysqldump) from
the 32bit system, then a reload on the new 64bit system.
just a thought: Did you run mysql_upgrade after the import?
On Mon, May 25, 2009 at 10:19 AM, Per Jessen p...@computer.org wrote:
Michael Dykman wrote:
It might be helpful if you could tell us how you affected your data
migration
Sorry, I'm not familiar with reporting problems in/on mysql.
Michael Steinfeld wrote:
just a thought: Did you run mysql_upgrade after the import?
No, I didn't - I didn't think of it as I really only moved the data
across.
best regards
Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Per Jessen wrote:
Michael Steinfeld wrote:
just a thought: Did you run mysql_upgrade after the import?
No, I didn't - I didn't think of it as I really only moved the data
across.
Okay, have done a mysqlcheck --check-upgrade - came back all clean. I
don't see a need to run
Have you tried running the offending SQL manually against you new
installation? Does it come back clean in the isolated case? Is there
anything else which runs against this database at night? crons?
Could you post the script that you are running to give some context to
the statement which winds
On Mon, May 25, 2009 at 11:19 AM, Per Jessen p...@computer.org wrote:
Per Jessen wrote:
Michael Steinfeld wrote:
just a thought: Did you run mysql_upgrade after the import?
No, I didn't - I didn't think of it as I really only moved the data
across.
I suspect that will solve your issue.
Michael Dykman wrote:
Have you tried running the offending SQL manually against you new
installation? Does it come back clean in the isolated case?
No, not manually, but the job/the SQL is run several times a day, maybe
2-3 times per hour.
Is there anything else which runs against this
Per Jessen wrote:
Michael Dykman wrote:
Have you tried running the offending SQL manually against you new
installation? Does it come back clean in the isolated case?
No, not manually, but the job/the SQL is run several times a day,
maybe 2-3 times per hour.
I've also just run the query
Given the new hardware, I'm now suspecting the RAID controller. I have
seen misconfigured RAIDs or bad RAID drivers take out a server in just
such a manner. I had a debian server connected to an EMC SAN.. As
debian isn't supported, we had this open-source driver which gave us
no end of problems.
Michael Dykman wrote:
Given the new hardware, I'm now suspecting the RAID controller. I have
seen misconfigured RAIDs or bad RAID drivers take out a server in just
such a manner. I had a debian server connected to an EMC SAN.. As
debian isn't supported, we had this open-source driver which
The issues that we saw only came to light under stress. The
application I am referring to ran under a fair bit of load at the best
of times but it was during sustained spikes that the flaws in our
driver made themselves apparent.
Mind you, we weren't using JFS, so I'm not sure how that would
Hi Per,
Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf
file. Are these queries appearing in your slow query logs?What is your
LOG_QUERY_TIMES set too?
Here are some other settings you may want to play around wtih
CONNECT_TIMEOUT
INTERACTIVE_TIMEOUT
WAIT_TIMEOUT
Darryle Steplight wrote:
Hi Per,
Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf
file. Are these queries appearing in your slow query logs?What is your
LOG_QUERY_TIMES set too?
Here are some other settings you may want to play around wtih
CONNECT_TIMEOUT
GUI. This should solve the problem.
CHAVA
On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney
[EMAIL PROTECTED]wrote:
Hello
I am still getting the MySQL Error Number 1045 Access denied error message
when running the adminstrator gui. I attempted to start mysql from the dos
command line via
16, 2008 at 10:22 PM, AndrewMcHorney
[EMAIL PROTECTED]wrote:
Hello
I am still getting the MySQL Error Number 1045 Access denied error
message when running the adminstrator gui. I attempted to start mysql
from the dos command line via mysql and I am getting the following.
ERROR 1045 (28000
.
CHAVA
On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]wrote:
Hello
I am still getting the MySQL Error Number 1045 Access
denied error message
when running the adminstrator
the problem.
CHAVA
On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]wrote:
Hello
I am still getting the MySQL Error Number 1045 Access
denied error message
]wrote:
Hello
I am still getting the MySQL Error Number 1045 Access denied error message
when running the adminstrator gui. I attempted to start mysql from the dos
command line via mysql and I am getting the following. ERROR 1045 (28000):
Access denied for user 'ODBC'@'localhost' (using
.
CHAVA
On Sat, Aug 16, 2008 at 10:22 PM, AndrewMcHorney
[EMAIL PROTECTED]wrote:
Hello
I am still getting the MySQL Error Number 1045 Access denied error message
when running the adminstrator gui. I attempted to start mysql from the dos
command line via mysql and I am getting the following
Hello
I am still getting the MySQL Error Number 1045 Access denied error
message when running the adminstrator gui. I attempted to start mysql
from the dos command line via mysql and I am getting the following.
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using
password
MySql 5.0.41
SUSE 10.2
Linux dbms-04-r1 2.6.18.2-34-default #1 SMP Mon Nov 27 11:46:27 UTC 2006
x86_64 x86_64 x86_64 GNU/Linux
Dear MySql,
I have an odd item in my error log, I wonder if you can tell me what
this means? Also whether should do anything about it?
(This table once corrupted
in MySql error log
MySql 5.0.41
SUSE 10.2
Linux dbms-04-r1 2.6.18.2-34-default #1 SMP Mon Nov 27 11:46:27 UTC 2006
x86_64 x86_64 x86_64 GNU/Linux
Dear MySql,
I have an odd item in my error log, I wonder if you can tell me what
this means? Also whether should do anything about
stop slave;
change master to master_log_file='Relay_Master_Log_File' ,
master_log_pos=Exec_master_log_pos;
#Get the values for the above command from your show slave status output.
start slave;
The above process should fix your problem.
On 9/4/07, Russell E Glaue [EMAIL PROTECTED] wrote:
I
Ya, I did that.
I read elsewhere that this was recommended for 4.1.9+.
I did
stop slave;
change master to master_log_file='{Relay_Master_Log_File}',
master_log_pos={Exec_master_log_pos};
start slave
And it gave the same error.
That is when I checked the binlogs and saw that it was corrupted at
I had a disk full error on the master MySQL (4.1.22), which was replicating to a
slave (4.1.22).
My question is, how do I recover a slave replica when the master had a disk full
error, space was freed, but the 'disk full' issue left a corrupted master
binlog?
1) Do I have to reinitialize the
Hi there !
Does anyone knows if there is a specific MySQL ERROR (SQLSATE)
for DELETE of a not found key?
I have tried MySQL Error 1032 e 1176 (SQLSTATE HY000) but it
does not seems to work ..
Thanks in advance
Hello all.
I noticed that the last entry in mysql error log was two weeks ago. Can
some one tell me why mysql is not writing to this log
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED
Have you had any errors in the last 2 weeks? Have you restarted your
server in the last 2 weeks? Your problem might just be a symptom of
no problem at all.
- michael
On 8/20/07, Brown, Charles [EMAIL PROTECTED] wrote:
Hello all.
I noticed that the last entry in mysql error log was two
, Brown, Charles [EMAIL PROTECTED] wrote:
Hello all.
I noticed that the last entry in mysql error log was two weeks ago. Can
some one tell me why mysql is not writing to this log
This message is intended only for the use of the Addressee and
may
Hi All,
In my master db, bin-log was not getting generated due to space issue, so i
shut it down using 'mysqladmin shutdown.
I cleared some old bin-logs and when i restart mysql using mysqld_safe, i
am getting below error. I checked for any other mysqld process, but did not
find any. Please help
very wisely taken topic mysql error. ...
Ananda Kumar schrieb:
[...]
I cleared some old bin-logs and when i restart mysql using mysqld_safe
[...]
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock /data/mysql/ibdata1, error: 11
InnoDB: Check that you do not already have
Hi Sebastian,
I did not remove any ibdata files. They are present.
regards
anandkl
On 6/21/07, Sebastian Mendel [EMAIL PROTECTED] wrote:
very wisely taken topic mysql error. ...
Ananda Kumar schrieb:
[...]
I cleared some old bin-logs and when i restart mysql using mysqld_safe
I got an error while entering an BMP image of 1.7MB size in a
mediumblob field through MS Access 2003 with MyODBC 3.51.12
on Windows XP SP2 also with MySQL Query Browser
and Navicat GUI tool. Navicat returned the error as 'Got a packet bigger
than Max_allowed_packet bytes'. What this means?.
max_allowed_packet is the maximum size of a single SQL statement.
It's a setting on the server, as well as for the mysql command line
interface.
See http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
I think 1 MB is the default; the maximum setting for MySQL 5 is 1 GB.
You can adjust
To: mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: MySQL Error for Blobs
I got an error while entering an BMP image of 1.7MB size in a
mediumblob field through MS Access 2003 with MyODBC 3.51.12
on Windows XP SP2 also with MySQL Query Browser
and Navicat GUI tool. Navicat returned the error
the (incorrect) socket?
Thank you.
Regards,
Rich
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 12, 2006 6:00 PM
To: mysql@lists.mysql.com
Subject: Re: MySql Error Number 1130
When you are trying to connect to port 3307, for example
Duzenbury, Rich wrote:
Wow, I found the problem! I think this may be a bug.
In my case, I've got three instances running on ports 3306, 3307, and
3320. On the local machine, I connect to them via
mysql -p --port-3306 --host=localhost
mysql -p --port-3307 --host=localhost
mysql -p
localhost means socket.
Hmm, I don't believe it does. localhost is a DNS shortcut to the IP
address of the local machine.
If that is how mysql wants to treat things, then it should issue an
error message on connect because --host=localhost and --port=anything
would then be mutually
Duzenbury, Rich wrote:
localhost means socket.
Hmm, I don't believe it does. localhost is a DNS shortcut to the IP
address of the local machine.
If that is how mysql wants to treat things, then it should issue an
error message on connect because --host=localhost and --port=anything
would
-Original Message-
From: Barry [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 13, 2006 9:41 AM
To: mysql@lists.mysql.com
Subject: Re: MySql Error Number 1130
Duzenbury, Rich wrote:
localhost means socket.
Hmm, I don't believe it does. localhost is a DNS shortcut
--- Duzenbury, Rich [EMAIL PROTECTED] wrote:
-Original Message-
From: Barry [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 13, 2006 9:41 AM
To: mysql@lists.mysql.com
Subject: Re: MySql Error Number 1130
Duzenbury, Rich wrote:
localhost means socket
Interesting. I have never heard of that option.
LX09:/home/rduz/backup # mysql -p -h. --port=3307
Enter password:
ERROR 2005 (HY000): Unknown MySQL server host '.' (1)
Perhaps it no longer functions?
Thanks.
Regards,
Rich
--
MySQL General Mailing List
For list archives:
=3306
mysql -p --port=3307
mysql -p --port=3320
I have always been able to connect remotely from my workstation to the
base server on 3306.
My problem is that I cannot connect remotely to either of the new
additional instances running on 3307 or 3320. Anytime I attempt to do
so, I receive MySQL
, Duzenbury, Rich wrote:
To: mysql@lists.mysql.com
From: Duzenbury, Rich [EMAIL PROTECTED]
Subject: MySql Error Number 1130
Hi all,
I am setting up two additional instances of mysql on my mysql server,
which is running version 5.0.18-standard-log.
I've got the additional instances set up
to access a local (to my home) message board, I get a
black 'page' on my monitor screen with the above message (MySQL Error)
on the top left of the black page.
Local message board? Ethernet one or really local like 127.0.0.1?
I guess the font color is white because otherwise it would be hard to
read
Hello.
I'm not a MyODBC expert and not completely sure if it is your case, but
it seems that there're several bugs similar to your. See:
http://bugs.mysql.com/bug.php?id=10148
You can find more by searching on the 'SQLDescribeCol' keyword in the
bugs database. Check that you're using the
This call works fine on Oracle, Access, MS SQL. But Not works on MySQL.
MySQL 5.0.15, MySQL ODBC drive 3.51, The OP is Windows 2000/2003, Program in
VC++
In my SQLDescribeCol call on MySQL
I get correct value on:
ColumnName, BufferLength, NameLengthPtr, NullablePtr
I get corect value on
Hello.
MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE)
and (utf8_general_ci,IMPLICIT) for operation 'UNION' -- again
Check the character set of fields in you tables with
'SHOW CREATE TABLE' statement. I recommend you to test if
the problem remains in 4.1.14
Hi list,
I've got a query coming out of sugarCRM that is generating this error:
MySQL error 1267: Illegal mix of collations
(latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for
operation 'UNION'
I recently converted the entire database to utf8 - made sure all the
connections
On Thu, 2005-06-16 at 21:06, Richard Dale wrote:
So we have recently started stress testing Mysql on an Opteron dual
CPU
machine running Ubuntu Hoary. We are using the 64-bit GCC
4.0.24-standard binary from mysql. The stress test that I'm currently
running on it involves inserting a
On Thu, 2005-06-16 at 21:06, Richard Dale wrote:
So we have recently started stress testing Mysql on an Opteron dual
CPU
machine running Ubuntu Hoary. We are using the 64-bit GCC
4.0.24-standard binary from mysql. The stress test that I'm currently
running on it involves inserting a
Hello.
MySQL on 64-bit AMD rises lots of questions. There is an Opteron HOWTO
at:
http://hashmysql.org/index.php?title=Opteron_HOWTO
I can't give any advice except sending to the list the output of SHOW
STATUS and SHOW PROCESSLIST statements performed when MySQL uses a lot
of memory.
So we have recently started stress testing Mysql on an Opteron dual CPU
machine running Ubuntu Hoary. We are using the 64-bit GCC
4.0.24-standard binary from mysql. The stress test that I'm currently
running on it involves inserting a large database (from a mysqldump)
from three
So we have recently started stress testing Mysql on an Opteron dual
CPU
machine running Ubuntu Hoary. We are using the 64-bit GCC
4.0.24-standard binary from mysql. The stress test that I'm currently
running on it involves inserting a large database (from a mysqldump)
...
Which linux
- Original Message -
From: Scott Haneda
on 5/4/05 7:22 PM, Paul DuBois at [EMAIL PROTECTED] wrote:
Error strings do change format sometimes.
And they won't necessarily be in English. :-)
I had a feeling, what is the general method most use to deal with the
above
scenario? I really
I have a unique key on username and email address in mysql. In my
application logic, I want to test for that response on failed insert. Error
number 1062 tells me there is a duplicate key, but no way to tell what key
that is.
The error string returned is more telling, but seems less than ideal
could move to
'contains'.
Anyway, I think you see what my concern is, wonder what the preferred method
to fix is, or if someone can tell me when, if ever, the error string has
ever changed format in mysql.
Error strings do change format sometimes.
And they won't necessarily be in English. :-)
--
Paul
that's covered.
What is not, is that it may not always 'ends with', so I could move to
'contains'.
Anyway, I think you see what my concern is, wonder what the preferred method
to fix is, or if someone can tell me when, if ever, the error string has
ever changed format in mysql.
Error
Using MySQL version 4.0, I am trying to backup my database using MySQL
Administrator. When
executing the backup I get error mysql error nr.0 which doesn't tell me much.
I did a
Google search on the error and it didn't tell me much.
Can anyone shed light on this error message?
Thanks.
Darin
Hi,
I have installed mysql on my system using tar file. But when i start mysql
it generates following error and shuts down.
Plz help me out to run the MySql server as i have important data on it.
[EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# ./bin/safe_mysqld
Starting mysqld daemon
From: S.Yousaf Shah [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: MySql error...
Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT)
Hi,
I have installed mysql on my system using tar file. But when i start mysql
it generates following error and shuts down.
Plz help me
@lists.mysql.com
Subject: MySql error...
Date: Tue, 8 Mar 2005 20:01:06 +0500 (PKT)
Hi,
I have installed mysql on my system using tar file. But when i start mysql
it generates following error and shuts down.
Plz help me out to run the MySql server as i have important data on it.
[EMAIL PROTECTED] mysql
@lists.mysql.com
Subject: RE: MySql error...
Hi,
Have a look in the error file which is in mysql/data and called hostname.err
to have more information on why it is shutting down.
With that info you usually can find more help on the mysql website.
Good luck!
From: S.Yousaf Shah [EMAIL PROTECTED]
Reply
list_php'; [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: RE: MySql error...
Hi,
I don't have an answer for you yet - but I encountered exactly the
same
situation with one of my systems last weekend. Unfortunately, the
error
file
sheds no light at all on the situation. In my case
-Original Message-
From: Kevin Cowley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 9:12 AM
To: mysql@lists.mysql.com
Subject: RE: MySql error...
If you're starting the process as a non-system user then the var
directory and anything under it should be owned/writable by that user
:[EMAIL PROTECTED]
Sent: 08 March 2005 17:40
To: Kevin Cowley; mysql@lists.mysql.com
Subject: RE: MySql error...
True. I forgot to mention, when doing the normal install from the tar,
the
files/databases for mysql and test both refused to create, although I
see
no
error message indicating
:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 9:12 AM
To: mysql@lists.mysql.com
Subject: RE: MySql error...
If you're starting the process as a non-system user then the var
directory and anything under it should be owned/writable by that user.
If you're starting it as root then the var
/Principal
intechgra
Database System Specialists
mailto:[EMAIL PROTECTED]
www.intechgra.com
-Original Message-
From: mel list_php [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 8:10 AM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: RE: MySql error...
Hi,
Have a look
OK I've honestly banged my head against everying, but as far as I can tell
MySQL has *NO* real logging support. You have three options, log
everything as text, log all queries as binary, or nothing.
What I want/NEED is connection logging and some sort of ERROR logging. I'm
getting an
tier
anyway.
Just my $0.02 worth.
-Daniel.
-Original Message-
From: Michael Loftis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 2:45 PM
To: mysql@lists.mysql.com
Subject: mysql error logging
OK I've honestly banged my head against everying, but as far as I can tell
MySQL
I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP
Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8
I am receiving the enclosed error when I attempt to go into
phpMyAdmin and do not know how to solve the issue...
Any assistance would be greatful.
Thank you
Gary
You have mysql 4.1.8, but your php was built with the library for an earlier
version, which, as the error message says, doesn't support the new, more
secure authentication protocol. Your choices are to tell mysql to use the
older, less-secure protocol, or build a copy of php using your current
I am still new to the PHP scene could you tell me how I rebuild the
PHP with the client library...
On Mon, 07 Feb 2005 12:20:26 -0500, Michael Stassen
[EMAIL PROTECTED] wrote:
You have mysql 4.1.8, but your php was built with the library for an earlier
version, which, as the error message
- Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: GH [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 8 February 2005 3:12 AM
To: mysql@lists.mysql.com; php-general; PHP DB
Subject: MySQL Error 1251 / phpMyAdmin
I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP
Version 4.3.10
Hi I've a question I have a delphi program that connects to a mysql
database via obdc, and works perfect in the lan and in the server, I want
to know if I can enter the database if I have the program installed in
another city or place, I know that I have to enter the IP of the server
but I've
First, check your my.cnf file to see if you have a 'bind-address'
entry. Such an entry will constrain you system only responding to
machines on the same network. Failing that, have you checked you
firewall settings? Are you sure that can can even reach port 3306 on
that machine from the outside
Hello.
You can enable logging on the server. See:
http://dev.mysql.com/doc/mysql/en/log-files.html
You need the error log, query log, slow log. But be careful!
Heavy loaded server can produce a lot of messages and your
files will grow quickly. If you use InnoDB, you can enable
the
I have a mysql server running on WIN-XP (in a critical
health area) and it started to give me that error.
At first, the problem ocurred in a machine and then
started to scatter all over the system. On Saturday I
reset the Server Machine and the problem disapeared.
But today applications started
1 - 100 of 312 matches
Mail list logo