;>>> 2012/01/31 10:52 +0100, Johan De Meersman
Not *entirely* accurate: MySQL does include a CSV engine that you can use in
the same way you would use InnoDB or any other engine.
If you create a table a with engine=CSV and then go look at the data
dictionary, you'll find the files a.frm and
On 1/20/2012 5:54 AM, bruce wrote:
Hi.
Got a major pain that I'm trying to solve using mysql.
Trying to handle a hierarchical tree structure, where I have a
parent/child structure that grows as data is added to the system.
The process needs to continuously determine if the overall tree, and
al
On 20/01/12 11:54, bruce wrote:
> Hi.
>
> Got a major pain that I'm trying to solve using mysql.
>
> Trying to handle a hierarchical tree structure, where I have a
> parent/child structure that grows as data is added to the system.
>
> The process needs to continuously determine if the overall t
On Fri, Jan 20, 2012 at 5:08 AM, Walter Heck - OlinData.com
wrote:
> Relational databases are not very suitable for representing
> graph-style data. You might want to look into graph databases, or the
> OQGraph engine for MySQL: http://openquery.com/products/graph-engine
Or take a look at Gremlin
Relational databases are not very suitable for representing
graph-style data. You might want to look into graph databases, or the
OQGraph engine for MySQL: http://openquery.com/products/graph-engine
good luck!
Walter
On Fri, Jan 20, 2012 at 13:54, bruce wrote:
> Hi.
>
> Got a major pain that I'
Sheesh... I knew it had to be something simple. Opened up phpMyAdmin as
mysql/root and changed the privileges for the ijdb user to allow connecting from
any host, not just localhost.
Problem solved.
Thanks!
Monte
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Original Message -
> From: "Monte Milanuk"
>
> Again, I *don't* want to connect to 192.168.56.1 - I want to connect
> to 192.168.56.20 - so why the heck is mysql refusing to do that.
Yes. Now take a deep breath and read what I said again.
You can perfectly connect to .20 - as proven b
On 01/11/2012 09:45 AM, Johan De Meersman wrote:
> The connector is not trying to connect to the host address; it's connecting
*from* the host address - in your MySQL, the old grant for ijdb@localhost will
no longer work; you need to grant privileges to ijdb@192.168.56.1.
I don't *want* to connec
- Original Message -
> From: "Monte Milanuk"
> 'Connection Failed: [HY000][MySQL][ODBC 5.1 Driver] Access denied for
> user 'ijdb'@'192.168.56.1' (using password: YES)'
The connector is not trying to connect to the host address; it's connecting
*from* the host address - in your MySQL,
At first blush, your problem would appear to concern the lack of index-use.
That's where I would begin my investigation. It might be painstaking, but
I would do something like this:
For each view
Look at the Join(s) and see what columns are being joined
Look at the tables and see what col
- Original Message -
> From: "Adam Lanier"
>
> What is the recommended course of action to keep data synchronized
> between the two platforms?
Not an easy one, I think :-)
For simple one-shot copies the MySQL Connector for ODBC should do fine. I'm not
sure if you can set up a continuou
Even more stuff inline there
>
> Actually, the gas tank is a good analogy.
>
> There is limited volume in a vehicle which must contain the tank. In this
> analogy, the vehicle must have space for not just fuel but passengers, cargo,
> engine, transmission, etc. The fact that the tank may
Hello all,
On 11/30/2011 16:46, Reindl Harald wrote:
Am 30.11.2011 19:13, schrieb Karen Abgarian:
Hi inline there.
On 30.11.2011, at 0:16, Reindl Harald wrote:
Most people do not expect a gas tank to shrink once the
gas is consumed...right?
WHO THE FUCK is comparing computers with
Am 30.11.2011 19:13, schrieb Karen Abgarian:
> Hi inline there.
>
> On 30.11.2011, at 0:16, Reindl Harald wrote:
>
>>
>>> Most people do not expect a gas tank to shrink once the
>>> gas is consumed...right?
>>
>> WHO THE FUCK is comparing computers with a gas tank?
> Well, I do. I even
Hi inline there.
On 30.11.2011, at 0:16, Reindl Harald wrote:
>
>> Most people do not expect a gas tank to shrink once the
>> gas is consumed...right?
>
> WHO THE FUCK is comparing computers with a gas tank?
Well, I do. I even managed to do it without using foul language.
Forgot to
Allright, that will do, I think?
This is a MySQL mailinglist, let's not have it devolve into vendor rants.
The defaults may or may not be sensible, but they're documented, and there's as
much to say for sensible defaults as there is for not changing defaults between
releases.
Let's leave it at
thanks
On 11/18/11, Karen Langford wrote:
> Dear MySQL users,
>
> MySQL Server 5.1.60, a new version of the popular Open Source
> Database Management System, has been released. MySQL 5.1.60 is
> recommended for use on production systems.
>
> For an overview of what's new in MySQL 5.1, please see
You showed us a link which explains how you uninstalled MySQL.
Perhaps you could tell us how you installed it? IT would certainly
shed some light on the subject. If you are using a pre-built package
for OS/X, the issue is likely with the package. If you are installing
from source, there is an in
On 27/10/2011 16:54, Néstor wrote:
Is 26K Euros enought money to live in Europe?
On Thu, Oct 27, 2011 at 8:14 AM, Garcia, Monicawrote:
They say 40k which I would assume is in Euros already.
€ 26k is considerably more than minimum wage. I live in Spain when not
working and there are plenty of
Is 26K Euros enought money to live in Europe?
On Thu, Oct 27, 2011 at 8:14 AM, Garcia, Monica wrote:
> Hello people,
>
> We are looking for a MySQL DBA, based in Malaga (Spain). If you have
> 5+ years experience administering MySQL and you are interested in join
> an international company, plea
Am 19.10.2011 17:45, schrieb Tim Johnson:
> * Reindl Harald [111018 23:24]:
>> Am 19.10.2011 01:36, schrieb Tim Johnson:
try "mysql -u tim -p"
>>> Same error:
>>> ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using
>>> password: NO)
> and enter yur password in the fol
* Reindl Harald [111018 23:24]:
> Am 19.10.2011 01:36, schrieb Tim Johnson:
> >> try "mysql -u tim -p"
> > Same error:
> > ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using
> > password: NO)
> >> > and enter yur password in the followed dialog
> > Doesn't even ask for the pwd
Am 19.10.2011 01:36, schrieb Tim Johnson:
>> try "mysql -u tim -p"
> Same error:
> ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using
> password: NO)
>> > and enter yur password in the followed dialog
> Doesn't even ask for the pwd..
then your mysql CLIENT is broken or somehow
the prompt. If that works,
> there's a problem in the parameter parsing.
>
> Random thought: could you have a .my.cnf file in your home directory?
>
> - Original Message -
> > From: "Johnny Withers"
> > To: "Tim Johnson"
> > Cc: my
t;
> Cc: mysql@lists.mysql.com
> Sent: Wednesday, 19 October, 2011 3:53:23 AM
> Subject: Re: mysql server does not recognize user password
>
> Why does mysql say "using password: no"? Seems to me the password is
> not
> being sent.
>
> On Oct 18, 2011 8:37
Why does mysql say "using password: no"? Seems to me the password is not
being sent.
On Oct 18, 2011 8:37 PM, "Tim Johnson" wrote:
* Claudio Nanni [111018 17:02]:
> FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER
> etc,
>
> Usually this ...
linus:~ tim$ sudo mysql
Pas
* Tim Johnson [111018 17:47]:
Got this...
mysql> select host,user,password from user;
+-+--+---+
| host| user | password |
+-+--+---+
| localho
* Claudio Nanni [111018 17:02]:
> FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER
> etc,
>
> Usually this problem comes when you have the anonymous user in the grant
> tables (''),
> MySQL has a tricky way of processing the grant tables.
>
> Sometimes you can be surprise
FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER
etc,
Usually this problem comes when you have the anonymous user in the grant
tables (''),
MySQL has a tricky way of processing the grant tables.
Sometimes you can be surprised by what you read issuing:
SELECT USER(),CURREN
* Reindl Harald [111018 15:14]:
>
>
> Am 19.10.2011 01:03, schrieb Tim Johnson:
> > Now when I try to log in with host as localhost, user as tim
> > with 'secret' password:
> > linus:~ tim$ mysql --host=localhost --user=tim --password=secret
> > ERROR 1045 (28000): Access denied for user 'tim'@'
* Mark [111018 15:14]:
> Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session?
Not originally, but I repeated the grant then
issued
flush privileges;
quit
and have the same problem
thanks
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebs
Am 19.10.2011 01:03, schrieb Tim Johnson:
> Now when I try to log in with host as localhost, user as tim
> with 'secret' password:
> linus:~ tim$ mysql --host=localhost --user=tim --password=secret
> ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using password:
> NO)
> Huh!
did
Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session?
- Mark
-Original Message-
From: Tim Johnson [mailto:t...@akwebsoft.com]
Sent: woensdag 19 oktober 2011 1:02
To: MySQL ML
Subject: mysql server does not recognize user password
using 5.1.57 on Mac Lion.
I've done t
Hi,
EXISTS function provides a simple way to find intersection between tables
(INTERSECT operator from relational model).
If we have table1 and table2, both having id and value columns, the
intersection could be calculated like this:
SELECT * FROM table1 WHERE EXISTS(SELECT * FROM table2 WHERE t
在 2011-10-13四的 11:25 -0400，Nick Khamis写道：
> Hello Everyone,
>
> I was wondering if the MySQL devel files tar was available for download? I
> was
> only able to find rpm on the mysql site.
>
> Thanks in Advance,
>
> Nick.
download the RPM package,unpack it,then you own it.
BTW,MySQL only provid
On 10/13/2011 14:41, Grega Leskovšek wrote:
What is the usage of connect keyword? I've tried to google what is the
difference between CONNECT and USE but got no explanation. It seems
everybody use USE, but am not clear why is the CONNECT used?
mysql> CONNECT test1pizza
Connection id:9
Curre
I will post the cmake that get's just the devel header files shortly.
Nick.
Am 13.10.2011 19:29, schrieb Nick Khamis:
> That being said, does cmake have a --help friend? I just don't want to
> install the complete MySQL server, just MySQL-devel, as
> mentioned earlier.
no idea
i take the fedora-src.rpm on a own virtual machine for building packages
replace the source-t
That being said, does cmake have a --help friend? I just don't want to
install the complete MySQL server, just MySQL-devel, as
mentioned earlier.
Nick
PLEASE DO NOT POST OFF-LIST
if a problem is solved others hsould know that to prevent other
peopole spending time - if problem is not solved you osuld also
not switch to a private-channel!!
Am 13.10.2011 19:20, schrieb Nick Khamis:Of course! mysql header files are in
the source tar...
Thanks ag
you wrote "but there is no MySQL-devel-5.5.16-1.linux2.6.i386.tar.gz"
this is a bianry and NOT source and yes i am sure it contains the devel files
if you are want to compile from source for whatever reason:
there is only ONE source-tarball
./configure --help is your friend
Am 13.10.2011 19:08, s
Am 13.10.2011 18:16, schrieb Nick Khamis:
> Hello Everyone,
>
> Thank you so much for your response. I don't need the entire MySQL server
> just the
> development libraries. I found "MySQL-devel-5.5.16-1.linux2.
> 6.i386.rpm", but there is
> no MySQL-devel-5.5.16-1.linux2.6.i386.tar.gz.
first:
Hello Everyone,
Thank you so much for your response. I don't need the entire MySQL server
just the
development libraries. I found "MySQL-devel-5.5.16-1.linux2.
6.i386.rpm", but there is
no MySQL-devel-5.5.16-1.linux2.6.i386.tar.gz.
Thanks Again,
Nick.
Hello Everyone,
Thank you so much for your response. I don't need the entire MySQL server
just the
development libraries. I found "MySQL-devel-5.5.16-1.linux2.
6.i386.rpm", but there is
no MySQL-devel-5.5.16-1.linux2.6.i386.tar.gz.
Thanks Again,
Go to: http://dev.mysql.com/downloads/mysql/
and pick "source code" from the "platform" list.
- md
On Thu, Oct 13, 2011 at 11:25 AM, Nick Khamis wrote:
> Hello Everyone,
>
> I was wondering if the MySQL devel files tar was available for download? I
> was
> only able to find rpm on the mysql s
Am 13.10.2011 17:25, schrieb Nick Khamis:
> Hello Everyone,
>
> I was wondering if the MySQL devel files tar was available for download? I
> was
> only able to find rpm on the mysql site.
what exactly are you missing here?
http://www.mysql.com/downloads/mysql/
http://dev.mysql.com/downloads/mys
Somebody feel to jump in and contradict me here, but I have never had any
love from the MySQL GIS stack. For the very few functions it does support,
the performance has been abysmal and I generally find myself hacking
together UDFs against columns of FLOAT and avoiding POINT altogether.
- md
On
At 01:58 PM 10/7/2011, you wrote:
Do you have any good documentation with regards creating indexes.
Also information for explain statement and what would be the desired
result of the explain statement?
This might help:
http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html
http://www.site
The second index you specified '(field_b, field_a)' would be usable when
querying on field_b alone, or both fields in conjunction. This particular
index is of no value should you be querying 'field_a' alone. Then that
first index '(field_a, field_b)' would apply.
- md
On Fri, Oct 7, 2011 at 2:
Do you have any good documentation with regards creating indexes. Also
information for explain statement and what would be the desired result of the
explain statement?
On 7 Oct 2011, at 17:10, Michael Dykman wrote:
> How heavily a given table is queried does not directly affect the index size,
Can you give more information as to why the second index would be of no use ?
On 7 Oct 2011, at 18:24, Michael Dykman wrote:
> No, I don't think it can be called. It is a direct consequence of the
> relational paradigm. Any implementation of an RDBMS has the same
> characteristic.
>
> - md
No, I don't think it can be called. It is a direct consequence of the
relational paradigm. Any implementation of an RDBMS has the same
characteristic.
- md
On Fri, Oct 7, 2011 at 12:20 PM, Reindl Harald wrote:
> but could this not be called a bug?
>
> Am 07.10.2011 18:08, schrieb Michael Dykm
but could this not be called a bug?
Am 07.10.2011 18:08, schrieb Michael Dykman:
> When a query selects on field_a and field_b, that index can be used. If
> querying on field_a alone, the index again is useful. Query on field_b
> alone however, that first index is of no use to you.
>
> On Fri,
How heavily a given table is queried does not directly affect the index
size, only the number and depth of the indexes.
No, it is not that unusual to have the index file bigger. Just make sure
that every index you have is justified by the queries you are making against
the table.
- md
On Fri,
When a query selects on field_a and field_b, that index can be used. If
querying on field_a alone, the index again is useful. Query on field_b
alone however, that first index is of no use to you.
On Fri, Oct 7, 2011 at 10:49 AM, Brandon Phelps wrote:
> This thread has sparked my interest. What
This thread has sparked my interest. What is the difference between an index on
(field_a, field_b) and an index on (field_b, field_a)?
On 10/06/2011 07:43 PM, Nuno Tavares wrote:
Neil, whenever you see multiple fields you'd like to index, you should
consider, at least:
* The frequency of each
Is it normal practice for a heavily queried MYSQL tables to have a index
file bigger than the data file ?
On Fri, Oct 7, 2011 at 12:22 AM, Michael Dykman wrote:
> Only one index at a time can be used per query, so neither strategy is
> optimal. You need at look at the queries you intend to run
Neil, whenever you see multiple fields you'd like to index, you should
consider, at least:
* The frequency of each query;
* The occurrences of the same field in multiple queries;
* The cardinality of each field;
There is a tool "Index Analyzer" that may give you some hints, and I
think it's maatk
Only one index at a time can be used per query, so neither strategy is
optimal. You need at look at the queries you intend to run against the
system and construct indexes which support them.
- md
On Thu, Oct 6, 2011 at 2:35 PM, Neil Tompkins
wrote:
> Maybe that was a bad example. If the query
Maybe that was a bad example. If the query was name = 'Red' what index should
I create ?
Should I create a index of all columns used in each query or have a index on
individual column ?
On 6 Oct 2011, at 17:28, Michael Dykman wrote:
> For the first query, the obvious index on score will give
For the first query, the obvious index on score will give you optimal
results.
The second query is founded on this phrase: "Like '%Red%' " and no index
will help you there. This is an anti-pattern, I am afraid. The only way
your database can satisfy that expression is to test each and every reco
在 2011-09-29四的 21:29 +0100，Tompkins Neil写道：
> Hi
>
> Does anyone know when the production release of MySQL 5.6 will be out ?
>
> Thanks
> Neil
no idea,maybe you could find some useful info from
http://forge.mysql.com/wiki/Development_Cycle.
--
Best regards,
Sharl.Jimh.Tsin (From China **Obviou
45 AM, Rozeboom, Kay [DAS]
wrote:
> Does anyone know if this has been fixed yet?
>
>
> -Original Message-
> From: Jigal van Hemert [mailto:ji...@xs4all.nl]
> Sent: Monday, September 26, 2011 2:02 PM
> To: mysql@lists.mysql.com
> Subject: Re: mysql listed as "attach pa
Does anyone know if this has been fixed yet?
-Original Message-
From: Jigal van Hemert [mailto:ji...@xs4all.nl]
Sent: Monday, September 26, 2011 2:02 PM
To: mysql@lists.mysql.com
Subject: Re: mysql listed as "attach page" by google?
Hi,
On 26-9-2011 20:30, Michael Albert
> I got a request from a client for the rights to kill his queries if
> something goes wrong. Long story short, he doesn't want to have to phone.
>
> I see via the MySQL documentation, that the client would need PROCESS and
> SUPER privileges. Im not happy with that.
>
> Would know of an alternat
On 9/26/2011 1:30 PM, Michael Albert wrote:
I don't suppose I am the first to notice this, but most of
the pages on dev.mysql.com have been listed by google
as "attack pages", e.g http://dev.mysql.com/downloads/.
Has there been a problem, or is google being overzealous?
No. There are problems on
On Mon, Sep 26, 2011 at 11:30 AM, Michael Albert wrote:
> I don't suppose I am the first to notice this, but most of
> the pages on dev.mysql.com have been listed by google
> as "attack pages", e.g http://dev.mysql.com/downloads/.
> Has there been a problem, or is google being overzealous?
See:
On Mon, Sep 26, 2011 at 14:30, Michael Albert wrote:
> I don't suppose I am the first to notice this, but most of
> the pages on dev.mysql.com have been listed by google
> as "attack pages", e.g http://dev.mysql.com/downloads/.
> Has there been a problem, or is google being overzealous?
Here'
Hi,
On 26-9-2011 20:30, Michael Albert wrote:
I don't suppose I am the first to notice this, but most of
the pages on dev.mysql.com have been listed by google
as "attack pages", e.g http://dev.mysql.com/downloads/.
Has there been a problem, or is google being overzealous?
I fear Google is righ
Yeah I noticed that today too...
On Mon, Sep 26, 2011 at 7:30 PM, Michael Albert wrote:
> I don't suppose I am the first to notice this, but most of
> the pages on dev.mysql.com have been listed by google
> as "attack pages", e.g http://dev.mysql.com/downloads/.
> Has there been a problem, or is
Am 10.09.2011 19:21, schrieb a.sm...@ukgrid.net:
> Hi Walter/all,
>
> ok nailed it, the issue is the default hosts.allow installed on FreeBSD,
> and specifically the last section that
> denies everything. By default it looks like this:
>
> # The rest of the daemons are protected.
> ALL : ALL
Hi Walter/all,
ok nailed it, the issue is the default hosts.allow installed on
FreeBSD, and specifically the last section that denies everything. By
default it looks like this:
# The rest of the daemons are protected.
ALL : ALL \
: severity auth.info \
: twist /bin/echo "Y
Am 10.09.2011 19:02, schrieb a.sm...@ukgrid.net:
> Quoting Reindl Harald :
>
>>
>> "You are not welcome to use mysqld from tau" is NOT from mysqld
>> remove your hosts.allow/hosts.deny crap and replace it with firewall-rules
>> if the problem goes away make a bugreport on BSD side becahuse this
Quoting Reindl Harald :
"You are not welcome to use mysqld from tau" is NOT from mysqld
remove your hosts.allow/hosts.deny crap and replace it with firewall-rules
if the problem goes away make a bugreport on BSD side becahuse this
is NOT a mysqld issue
I've already established that the is
Am 10.09.2011 18:52, schrieb a.sm...@ukgrid.net:
> Quoting walter harms :
>
>> restart it with the same parameter on the command line and see what happens
>> the server support a verbos option (never used) perhaps it will tell you
>> more.
>>
>
> I can start mysqld direct from the command line an
Quoting walter harms :
restart it with the same parameter on the command line and see what happens
the server support a verbos option (never used) perhaps it will tell
you more.
I can start mysqld direct from the command line and reproduce the
problem. I checked and it seems the verbose
Am 10.09.2011 17:32, schrieb a.sm...@ukgrid.net:
> Quoting walter harms :
>
>> I still do not see why it is restarting ... there must be something
>> watching is disappear.
>> Just to be sure, you do from a remote host: mysql -hHOST -ume -e "show
>> tables" ?
>> long shot: Do you have LDAP, NIS
Quoting walter harms :
I still do not see why it is restarting ... there must be something
watching is disappear.
Just to be sure, you do from a remote host: mysql -hHOST -ume -e
"show tables" ?
long shot: Do you have LDAP, NIS or so enabled ?
Ok so made a script as you suggested, and it
Quoting Reindl Harald :
Odd that, so I added a mysql specific line to the hosts.allow
who is using hosts.allow for protection instead a firewall in front
of the machine
or iptables (linux) / ipf (bsd)?
Its used for denyhosts as I mentioned.
As I said I can get it to restart just by doing
Am 10.09.2011 16:25, schrieb a.sm...@ukgrid.net:
> Quoting walter harms :
>
>>
>> What i found odd that your mysqld actualy restarts.
>> Do you have it in some runlevel ? if yes stop and see
>> what happens.
>> If this does not work simple move the mysqld out of he way
>> and replace it with a s
Am 10.09.2011 16:07, schrieb a.sm...@ukgrid.net:
> Then I thought, what if I have hosts.allow misconfigured and its wide open
> maybe a remote system is connecting and
> messing with it. But hosts.allow was correct (mysql not listed, so denied by
> the last all:all). I tested connecting
> from
Quoting walter harms :
What i found odd that your mysqld actualy restarts.
Do you have it in some runlevel ? if yes stop and see
what happens.
If this does not work simple move the mysqld out of he way
and replace it with a script like
#!/bin/sh
echo "mysqld ..." | logger -t TEST
see what ha
Am 10.09.2011 16:07, schrieb a.sm...@ukgrid.net:
> Ok, this is pretty odd but I have found the problem.
>
> Today I have repointed all applications to a different DB server, so I
> have been free to do any testing on the problem server.
>
> I started by dropping the databases one by one, droppe
Ok, this is pretty odd but I have found the problem.
Today I have repointed all applications to a different DB server, so I
have been free to do any testing on the problem server.
I started by dropping the databases one by one, dropped em all and the
issue persisted.
I stopped crond, even t
i bet if he stops crond the problem is going away
anyways i have enough of this thread after "the part for the shutdown"
because if peopole are way too stupid to provide full logs (normally
in the first post) even after requested multiple times they should
learn their lessons the hard way...
This was me restarting MySQL as was requested by Suresh...
Quoting "Singer X.J. Wang" :
This doesn't look like a MySQL issue. Verify that there's no rogue scripts
that shutdowns MySQL...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
can you check for any table crashes in the db by using mysqlcheck.
and enable the general log for the database.
On Fri, Sep 9, 2011 at 10:37 PM, wrote:
> No need for that really is there? I posted what was requested.
> The part for the shutdown:
>
> 110909 17:27:31 InnoDB: Starting shutdown...
No need for that really is there? I posted what was requested.
The part for the shutdown:
110909 17:27:31 InnoDB: Starting shutdown...
110909 17:27:32 InnoDB: Shutdown completed; log sequence number 1589339
110909 17:27:32 [Note] /usr/local/libexec/mysqld: Shutdown complete
110909 17:27:32 mys
jesus christ can you post a WHOLE log
this is only a normal start, there is no single line about stop
Am 09.09.2011 18:30, schrieb a.sm...@ukgrid.net:
> Yep, but its basically identical to the info in the logs when its restarting
> itself. I have upgraded to MySQL 5.5
> as of yesterday, so the er
Yep, but its basically identical to the info in the logs when its
restarting itself. I have upgraded to MySQL 5.5 as of yesterday, so
the error info differs due to the version now. Here is the log output:
110909 17:27:35 mysqld_safe Starting mysqld daemon with databases from
/var/db/mysql
can you remove it from service and start it normally using mysqld_safe with
log warnings enabled in the cnf file.
On Fri, Sep 9, 2011 at 4:16 PM, wrote:
> Hi,
>
> that really is the complete error log, that exact same info gets repeated
> over and over, there is zero in the syslog and I get thi
Hi,
that really is the complete error log, that exact same info gets
repeated over and over, there is zero in the syslog and I get this
behaviour when running with no my.cnf (I do obviously have one but I
tried without and it I still see the prob, so that probably makes
things easier fr
Can yo paste the complete error log, Ram memory size and configuration file
here and make sure the machine has enough memory to run the services.
Check the sys log for what is happening just before the service restart.
On Wed, Sep 7, 2011 at 10:51 PM, wrote:
> Hi,
>
> as of yesterday the MySQL
Thanks Suresh, Problem solved it was the bind address.
On Tue, Aug 23, 2011 at 12:47 PM, Suresh Kuna wrote:
> Hello,
>
> Can you comment this line "bind-address = 10.5.1.100" in the
> configuration file and start the mysqld sever.
>
> On Tue, Aug 23, 2011 at 3:10 PM, madu...@gmail.com
Hello,
Can you comment this line "bind-address= 10.5.1.100" in the
configuration file and start the mysqld sever.
On Tue, Aug 23, 2011 at 3:10 PM, madu...@gmail.com wrote:
> [client]
> port= 3306
> socket = /var/run/mysqld/mysqld.sock
> #socket = /tmp/mys
[client]
port= 3306
socket = /var/run/mysqld/mysqld.sock
#socket = /tmp/mysqld.sock
user= "root"
pass= "%password%"
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# This was formally known a
Follow the steps :-
1. Check mysqld is running or not
> /etc/init.d/mysql status
2. If not > /etc/init.d/mysql start
If error occurs , check the logs & usually this error means ur server is
not running at the moment.
Good Luck !
Claudio Nanni wrote:
You have 2 options: use tcp/ip or find
You have 2 options: use tcp/ip or find the right .sock file
use this:
mysql -uUSER -p -h127.0.0.1 -P3306
or check in the my.cnf where the server creates the .sock file
you have to use the same with the local client.
Ciao Mad!
Claudio
2011/8/23 Andrew Moore
> That's too bad. How did you con
That's too bad. How did you configure things? What trouble shooting have you
done so far?
On Aug 23, 2011 9:18 AM, "madu...@gmail.com" wrote:
> When I try to start my mysql DB I keep getting the following message:
> "Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock
"Shawn Green (MySQL)" pisze:
(...)
> You can be the correct
> user, using the correct password but you may not be allowed (by the host
> pattern) to login from the machine from which you are attempting to login.
>
It could be the case you got your account setup as username@localhost and it
401 - 500 of 9506 matches
Mail list logo
