Hi list,
I am going to change the type of table to InnoDB
Thank!!
Pablo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
[EMAIL PROTECTED] wrote:
Hi list!
I've a problem with transaction
I initiate a transaction with start transaction. Soon i execute
following query:
* update t1 set t=12; and by I complete I execute rollback but when I do
it I obtain the following thing:
non-transactional Some changed
Hey,
This morning the default timespan of ssl certificates took my servers
down...
Everything was running fine, but this morning the SSL encrypted MySQL
connections stopped working!
Then I realized that the Problem was, that the certificates ran out this
morning.
The first solution that I
Hello,
I have a table like this:
CREATE TABLE `places` (
`name` varchar(256) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
Then I want to insert two values:
pjöngjang.com and
pjongjang.com
But on the second record I
hi guys,
I'm researching the method of partition when partition key/column is not INT
type.
I create a table t3(a int,b decimal(10,4)) and want to create partition by b
column.
So I use a function floor() for b column, partition type is range:
alter table t3 partition by
We have a windows server running our main database and an IIS server. We also
have a linux box with apache/php that uses the same database server.
We have configured a replication from that host to another windows server. Then
we verified that not all the queries were replicated properly. We
Hi,
Jorge Martínez wrote:
We have a windows server running our main database and an IIS server. We also
have a linux box with apache/php that uses the same database server.
We have configured a replication from that host to another windows server. Then we verified that not all the queries
: Replication problem Hi, Jorge Martínez wrote: We have a windows
server running our main database and an IIS server. We also have a linux box
with apache/php that uses the same database server.We have configured a
replication from that host to another windows server. Then we verified that not
all
Hi all,
I'm benchmarking performance improvement with MySQL Query Cache turned
on but I'm facing some problem with queries inside stored procedures
when they contains variable parameters
I just created this stored procedure to identify the problem
CREATE PROCEDURE `proc_test_qcache
Hi,
Your questions are answered in the manual:
http://dev.mysql.com/doc/refman/5.0/en/query-cache-how.html
It is a known limitation.
Edoardo Serra wrote:
Hi all,
I'm benchmarking performance improvement with MySQL Query Cache
turned on but I'm facing some problem with queries inside
There is actually a lot in the MySQL manual that explains how things
work. Write back to the list with any questions you still have :)
Baron
Hugo Ferreira da Silva wrote:
Hi,
I've done some indexes in my tables and I solved my problem.
But I still confused with indexes. I created one multiple
I solved a similar problem with a messaging system that was very slow
because it was doing full table scan each time the query ran. I didn't have
the chance to change the schema so this is what I came up with...
SET @var = (SELECT MAX(message_id) FROM messages);
SELECT columns...
FROM message
I found something weird.
This is my query now
--
(SELECT
m.codmensagem,
m.codprioridade,
m.codusuario,
m.codmensagemoriginal,
m.codmensagempai,
m.assunto,
m.dataenvio,
m.horaenvio,
m.datalimite,
m.horalimite,
m.anexo,
m.tipo,
u.nome,
up.nome as nomepara,
mp.codrespondida,
To: mysql@lists.mysql.com
Subject: Re: Problem with a complex query
I found something weird.
This is my query now
--
(SELECT
m.codmensagem,
m.codprioridade,
m.codusuario,
m.codmensagemoriginal,
m.codmensagempai,
m.assunto,
m.dataenvio,
m.horaenvio,
m.datalimite,
m.horalimite
[mailto:[EMAIL PROTECTED]
Sent: 15 August 2007 13:35
To: mysql@lists.mysql.com
Subject: Re: Problem with a complex query
I found something weird.
This is my query now
--
(SELECT
m.codmensagem,
m.codprioridade,
m.codusuario,
m.codmensagemoriginal,
m.codmensagempai
Hi,
I've done some indexes in my tables and I solved my problem.
But I still confused with indexes. I created one multiple index with the
main 4 columns for mensagenspara's table. But it doesn't work. So, I created
one index with 3 columns and one for each column, wich give me 4 indexes
for
this message, with each answers of that message.
The first table, messages, has about 56.000 rows, and the messages for table
has about 200.000 rows.
The problem is when the user goes to messages list. Because the message
could be moved to any folder, I have to query in messages table
PROTECTED]
Sent: 14 August 2007 16:04
To: mysql@lists.mysql.com
Subject: Problem with a complex query
Hi,
I have a message system wich work in this way:
- Each message can be sent to one or more recipients
- Each message received have a lot of settings, like date and hour received,
date and hour
, August 14, 2007 11:04 AM
Subject: Problem with a complex query
Hi,
I have a message system wich work in this way:
- Each message can be sent to one or more recipients
- Each message received have a lot of settings, like date and hour
received,
date and hour of read, mark as read and so
hum... I get it.
But in my query, I look in 3 tables
FROM
mensagens m,
mensagenspara mp,
usuarios u,
usuarios up
WHERE
m.codmensagem = mp.codmensagem
AND u.codusaurio = m.codusuario
AND up.codusuario = mp.codusuario
m.codmensagem, u.codusaurio and up.codusuario are primary keys
mp.codusuario,
what does explain tell you about the query?
I also think you should try a combined index with all three columns
that are used in one index. As far as I know only one index can be
used per query...
B
On Aug 14, 2007, at 1:26 PM, Hugo Ferreira da Silva wrote:
hum... I get it.
But in my
The indexes are the primary way of tuning your query speed but bear in
mind that mysql can only use 1 index-per-table-per-query.. your
single column indexes do help some.
try an EXPLAIN to see what I mean:
EXPLAIN SELECT ...
This will show you how mysql is approaching the query. From your
I've created an index with the statement
create index `usuario_pasta_situacao` on `mensagens` (codusuario, codpasta,
situacao);
And for mensagenspara table this index
create index `mensagem_usuario_pasta_situacao_idx` on `mensagenspara`
(codmensagem, codusuario, codpasta, situacao);
This is
From explain you can see that your problem lies within the mensagens
table (the first entry from your explain query) where it says type:
ALL and rows 68337. This basically means that it is not using any
index for this table.
MySQL doesn't seem to be very smart about queries involving
MySQL doesn't seem to be very smart about queries involving OR and
things like . For me creating temporary tables or writing perl
scripts to do the job solved my particular problems. But I am working
with tables that don't change but have some 100,000,000 rows...
I guess I suggest,
Hi All,
I have an issue that I need to resolve that is difficult to explain. I
hope that someone can understand what I*m trying to do and shed some
light on a solution. Here goes.
I have three tables, inventory, which is a list of transactions with
positive and negative values; request, which
Ed Reed wrote:
Hi All,
I have an issue that I need to resolve that is difficult to explain. I
hope that someone can understand what I*m trying to do and shed some
light on a solution. Here goes.
I have three tables, inventory, which is a list of transactions with
positive and negative
Thanks Jay,
I had to make a change to the first part of the query to get the results that I
wanted but your suggestion was definitely what I needed to get to the solution.
Thanks again.
For those that are interested, here's the final solution,
INSERT INTO purchase (Source, Item, Qty)
Massimo
Someboby can help to find which is the problem ?
I'm having a very weird problem with $result-fetch_assoc(). Here are two
very simplified examples. One uses a prepared statement (although for this
exercise I'm not using any bound parameters, my results aren't affected);
the other example uses $db-query(). Look at the retrieved $row.
?php
$db
PROTECTED]
Sent: Thursday, July 26, 2007 10:29 AM
To: mysql@lists.mysql.com
Subject: PHP mysqli problem
I'm having a very weird problem with $result-fetch_assoc().
Here are two
very simplified examples. One uses a prepared statement
(although for this
exercise I'm not using any bound parameters
I am having a problem with SELECT. The table has 3 rows. I am using
the C api. Here is my C code.
count = mysql_query(my_db, SELECT * FROM accounts);
er = mysql_error(my_db);
res = mysql_use_result(my_db);
num_row = mysql_num_rows(res);
count is returned as 0 (no error)
er
On 7/6/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
How does the cpu power influence the speed of a query?
Sort is a cpu intensive process.
*Check if you are suffering from locks on the tables you look up.*
Also, was the table in the system where the queries are running faster
rebuilt
On 7/6/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
How does the cpu power influence the speed of a query?
Sort is a cpu intensive process.
*Check if you are suffering from locks on the tables you look up.*
Also, was the table in the system where the queries are running faster
rebuilt
Hello,
Explain where the Statement is very fast:
*** 1. row ***
table: Stuecke
type: ALL
possible_keys: PRIMARY,St_Autor
key: NULL
key_len: NULL
ref: NULL
rows: 694
Extra: Using where;
Hi,
Run explain plan on both the machines and post the same.
~Alex
On 7/4/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello Ananda,
yes, the testmachine has the same data.
Regards,
Spiker
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose
Hello Ananda,
yes, the testmachine has the same data.
Regards,
Spiker
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hello,
I've a performance problem with our database:
Some select statements take about 20 seconds.
The same statements on an equal testmachine take less than 1 second.
Server: CPU: 2 x 440 MHz sparcv9
RAM: 2GB
(top: Memory: 2048M real, 931M free, 732M swap in use, 2839M swap
does your test machine have the same data as your problem database.
Can you also please show the explain plan from both the machines.
On 7/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello,
I've a performance problem with our database:
Some select statements take about 20 seconds
Please, mount your disks using forcedirectio.
Regards,
Juan
On 7/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello,
I've a performance problem with our database:
Some select statements take about 20 seconds.
The same statements on an equal testmachine take less than 1 second.
Server
:53 AM
Subject: Re: Problem about fulltext search.
Steve Edberg wrote:
At 11:23 PM +0800 6/30/07, Niu Kun wrote:
To quote from
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
... words that are present in more than 50% of the rows are considered
common and do not match
DB Team
- Original Message -
From: Niu Kun [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, July 01, 2007 7:53 AM
Subject: Re: Problem about fulltext search.
Steve Edberg wrote:
At 11:23 PM +0800 6/30/07, Niu Kun wrote:
To quote from
http://dev.mysql.com/doc/refman/5.0
Dear all,
I'm planning to add fulltext search to my database.
I've got the following test command:
create table test(id int, name varchar(20));
alter table test add fulltext(name);
insert into test values(1,hello world);
insert into test values(1,hello);
When I execute the fulltext search
At 11:23 PM +0800 6/30/07, Niu Kun wrote:
Dear all,
I'm planning to add fulltext search to my database.
I've got the following test command:
create table test(id int, name varchar(20));
alter table test add fulltext(name);
insert into test values(1,hello world);
insert into test
Hi,
Try:
select * from test where match(name) against(hello in boolean mode);
Octavian
- Original Message -
From: Niu Kun [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, June 30, 2007 6:23 PM
Subject: Problem about fulltext search.
Dear all,
I'm planning to add
Octavian Rasnita wrote:
Hi,
Try:
select * from test where match(name) against(hello in boolean mode);
Octavian
Thank you for your suggestion. I tried, but failed.:(
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Steve Edberg wrote:
At 11:23 PM +0800 6/30/07, Niu Kun wrote:
To quote from
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
... words that are present in more than 50% of the rows are considered
common and do not match.
'hello' appears in both (100%) of your records
Not being very strong at math, I have a little problem that I'm not
sure how to solve. Maybe someone can help me.
Basically, given a point (latitude, longitude) and a radius (100
meters) (think circle), I need to compute an equivalent square: That
is, two points that would correspond
Not being very strong at math, I have a little problem that I'm not sure how
to solve. Maybe someone can help me.
Basically, given a point (latitude, longitude) and a radius (100 meters)
(think circle), I need to compute an equivalent square: That is, two points
that would correspond to two
At 03:11 PM 6/28/2007, M5 wrote:
Not being very strong at math, I have a little problem that I'm not
sure how to solve. Maybe someone can help me.
Basically, given a point (latitude, longitude) and a radius (100
meters) (think circle), I need to compute an equivalent square: That
is, two points
On 6/28/07, M5 [EMAIL PROTECTED] wrote:
Not being very strong at math, I have a little problem that I'm not
sure how to solve. Maybe someone can help me.
Basically, given a point (latitude, longitude) and a radius (100
meters) (think circle), I need to compute an equivalent square
Hi all,
I'm trying to wrap my brain around folowing problem.
table main(code, field_1, field_2, field_3, , , field_51)
111, 'X', '', 'X',,,
222, '', '', 'X',,,
333, '', 'X', '' ,,,
444, '', '', '' ,,,
555, 'X','X', '' ,,,
table map(id, field)
1, 'field_1'
5, 'field_2'
9, 'field_3
to accomplish on one step:
mysql -u user -ppass -D db -e the above sql | mysql -u user -ppass -D db
HTH,
Dan
On 6/27/07, Mogens Melander [EMAIL PROTECTED] wrote:
Hi all,
I'm trying to wrap my brain around folowing problem.
table main(code, field_1, field_2, field_3, , , field_51)
111, 'X
~9GB
worth of data. There is no single row any larger than 50MB, most
average around 40MB. Windows 2000 Server, MySQL v5.0.37-community-nt
and all tables are InnoDB.
If anyone can help me out with this problem the assistance is greatly
appreciated. I have scoured google and various other
-Original Message-
From: Dušan Pavlica [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 19, 2007 5:08 AM
To: Hartleigh Burton
Cc: MySql
Subject: {Spam?} Re: mysqldump problem with large innodb tables...
Try to look for Lost connection error in MySQL manual and it can give your some
hints
My machine with a good old mysql 4.0 crashed last week, and going trough
recovery I ended up with wrong encoding. Right now mysql is on the same version
as before the crash, but at one step data was in newer version of mysql (5.0.x)
and I think that this problem I have originated there. Basically
and all tables are InnoDB.
If anyone can help me out with this problem the assistance is
greatly appreciated. I have scoured google and various other
sources and not found much information that has been useful to me.
I hope I have enough info below... if more is required let me know
My backups use mysqldump, but they have always just worked. I would suggest you
try to make a minimal test case that can reproduce the problem and submit it as
a bug report, if possible.
I'm not familiar with the error message off-hand, but the InnoDB manual is large
and complete, so I'm
help me out with this problem the assistance is greatly
appreciated. I have scoured google and various other sources and not
found much information that has been useful to me. I hope I have
enough info below... if more is required let me know.
mysqldump example
P:\mysqldump -u username -p
Hi Hartleigh,
Hartleigh Burton wrote:
Hi All,
I have a database which is currently at ~10GB in it's test phase. It is
containing uncompressed audio and is expected to reach 1.5TB in no time
at all. I am just running some backup tests and I have been having lots
of problems creating an
Hi Baron,
There are no MySQL errors in the event viewer.
On 18/06/2007, at 10:36 AM, Baron Schwartz wrote:
Hi Hartleigh,
Hartleigh Burton wrote:
Hi All,
I have a database which is currently at ~10GB in it's test phase.
It is containing uncompressed audio and is expected to reach 1.5TB
How about in c:\Program Files\MySQL\MySQL Server 5.0\data\hostname.err?
Cheers
Baron
Hartleigh Burton wrote:
Hi Baron,
There are no MySQL errors in the event viewer.
On 18/06/2007, at 10:36 AM, Baron Schwartz wrote:
Hi Hartleigh,
Hartleigh Burton wrote:
Hi All,
I have a database which is
H no there are no new errors in there. Nothing out of the
ordinary thats for sure. Just notifications that MySQL has started
and is accepting connections etc. :|
On 18/06/2007, at 11:06 AM, Baron Schwartz wrote:
How about in c:\Program Files\MySQL\MySQL Server 5.0\data
\hostname.err?
Is there any indication that the mysqldump crash is killing the server and
causing it to restart? For example, ready for connections notifications just
after you try a mysqldump?
Hartleigh Burton wrote:
H no there are no new errors in there. Nothing out of the ordinary
thats for sure.
No there is no indication of that at all. The server service appears
to be in perfect order, does not drop/restart and my other
applications continue to function without any interruption.
It appears as if the mysqldump connection to the server is
interrupted or maybe there is something in
I'm out of ideas right now. I don't actually use mysqldump that much and have
never had this happen. Hopefully someone else on the mailing list can help, or
perhaps you can try #mysql on Freenode IRC.
Baron
Hartleigh Burton wrote:
No there is no indication of that at all. The server service
Ok... this error has just started popping up in my .err log file...
070618 14:31:10 InnoDB: ERROR: the age of the last checkpoint is
237821842,
InnoDB: which exceeds the log group capacity 237813351.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of
You might need to backup a few chapters.
Thanks a lot man atleast now I know what to look into.
On 12/06/07, Gerald L. Clark [EMAIL PROTECTED] wrote:
sizo nsibande wrote:
I am trying to install zabbix, and at the third step I get this error:
[EMAIL PROTECTED]
I am trying to install zabbix, and at the third step I get this error:
[EMAIL PROTECTED] etc]# mysql -u zabbix -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.27
Type 'help;' or '\h'
sizo nsibande wrote:
I am trying to install zabbix, and at the third step I get this error:
[EMAIL PROTECTED] etc]# mysql -u zabbix -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.27
with the compilation and not
configuration;
because if I use the mysql-client rpm packages from SUSE 10.2, the
keyboard
works ok in interactive mysql sessions!
Any ideas will be very much appreciated!
This is probably a problem with your terminal program.
I've had similar problems
Hi all,
I have compiled mysqld 5.0.37 with utf support:
( configure --with-charset=utf8 --with-extra-charsets=none)
utf8 is the default in my.cnf:
( [mysqld] character-set-server=utf8 and [mysql] default-character-set=utf8 )
mysqld acknowledges it:
mysql show variables like charac%;
Hi all,
I have compiled mysqld 5.0.37 with utf support:
( configure --with-charset=utf8 --with-extra-charsets=none)
utf8 is the default in my.cnf:
( [mysqld] character-set-server=utf8 and [mysql] default-character-set=utf8 )
mysqld acknowledges it:
mysql show variables like charac%;
Hi everyone,
I have a form where you fill out description from a textarea and on
submit, it updates description in mytable.
This works fine. I want to also add the current date into description in my
table.
Here's what I get:
$date = date (F d Y);
$sql = UPDATE mytable SET description=
I am having issues with type conversion not working as expected per the
documentation.
I am using in MySQL 5.0.27 for x86/Windows.
The documentation at
http://dev.mysql.com/doc/refman/5.0/en/type-conversion.html states that for
comparison operators If one of the arguments is a TIMESTAMP or
I'm not sure specifically why it's acting the way it is, but it looks
like it's converting your date strings slightly differently depending on
how you use them.
If you properly pad the month out in the two strings it seems to work.
SELECT '2007-05-24 00:00:00' BETWEEN ('2007-03-23' - INTERVAL
- have I misunderstood something somewhere?
Thanks,
No, I think the problem is the conversion when using BETWEEN is not clearly documented.
Here is more on that:
http://www.xaprb.com/blog/2006/09/12/type-conversion-semantics-of-mysqls-between-operator/
Baron
--
MySQL General Mailing List
Everything seems to go fine for me if I change the two 2007-3-23
to 2007-03-23.
Fred
-Original Message-
From: Rob Desbois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 29, 2007 5:02 AM
To: mysql@lists.mysql.com
Subject: datetime type conversion problem
I am having issues with type
for me if I change the two 2007-3-23
to 2007-03-23.
Fred
-Original Message-
From: Rob Desbois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 29, 2007 5:02 AM
To: mysql@lists.mysql.com
Subject: datetime type conversion problem
I am having issues with type conversion not working as expected
To: mysql@lists.mysql.com
Subject: datetime type conversion problem
I am having issues with type conversion not working as expected per the
documentation.
I am using in MySQL 5.0.27 for x86/Windows.
The documentation at
http://dev.mysql.com/doc/refman/5.0/en/type-conversion.html states
but other date and
in these case the problem is not present.
Can you help me to resolve it?
Thanks in advance
Alessandro Agostini
IFAC - CNR
Italy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello Allesandro,
Alessandro Agostini wrote:
Hi to all,
I have a strange error on using of timestamp data type.
See the follow table definition and insert command.
DROP TABLE IF EXISTS Storicocorrenti;
CREATE TABLE Storicocorrenti (
ID_LINEA mediumint(6) unsigned zerofill NOT NULL default
Hi Alessandro, all !
Baron Schwartz wrote:
Hello Allesandro,
Alessandro Agostini wrote:
[[...]]
Watching the table content, I see second record as:
032100, '2005-03-27 03:00:00', 0, '40.00', '0.000', '0.000', 0,
'0.00'
MySql change the time information of DATAORA field from 02:00:00
@lists.mysql.com
Subject: problem with timestamp data type
Hi to all,
I have a strange error on using of timestamp data type.
See the follow table definition and insert command.
DROP TABLE IF EXISTS Storicocorrenti;
CREATE TABLE Storicocorrenti (
ID_LINEA mediumint(6) unsigned zerofill NOT NULL
Friends,
im having troubles with the following query:
---
INSERT drp_volumen_venta_diaria_deposito (drp_id_sku, drp_id_deposito,
drp_volumen, drp_es_cct, drp_dia, drp_mes, drp_anno, drp_fecha_dia_cargado )
SELECT DISTINCT s.drp_id_sku,
On my servers i'm using the 'user'@'localhost' for PHP apps.
running on the local web-server. Those users allocated for
web-apps can only connect to their specific DB from localhost.
On Tue, May 22, 2007 03:19, Miguel Cardenas wrote:
Localhost is indeed a special value that isn't include in '%'.
Hi All,
I have a problem that I do not quite understand.
I have a table with individuals:
CREATE TABLE `individual` (
`ident` mediumint(8) unsigned NOT NULL auto_increment,
`fid` mediumint(8) unsigned NOT NULL,
`iid` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`ident`),
KEY `fidiid
Hi Patricio,
Some options are to prevent programmers/users make a bad queries into
the database' SQL_BIG_SELECTS = 0 | 1
The documentation say :
If set to 0, MySQL will abort if a SELECT is attempted that probably will
take a very long time. This is useful when an inadvisable WHERE statement
Juan Eduardo,
Great to hear about you :)
One thing you must know is that i can run this query from a mysql client,
without the insert part.
The problem only happens when is run from the J2EE (Websphere - drp)
application.
I run the query as you asked, here are some results
.
The problem only happens when is run from the J2EE (Websphere - drp)
application.
I run the query as you asked, here are some results:
++-+-+---+-+-+--+---+
| drp_id_sku | drp_id_deposito | drp_volumen | 1 | drp_dia
: martes 22 de mayo de 2007 13H31 (GMT-0400) America/Santiago
Asunto: Re: Problem with compex query
Hi Patricio,
Your explain is scary.No use of index...Please, ask to programers in order
to create some index in the schema.
Development Server has the same version of MySQL production
for the query?
3) Im goint to try that.
4) Good Idea.
Thanks.
- Mensaje Original -
De: Juan Eduardo Moreno [EMAIL PROTECTED]
Para: Patricio A. Bruna [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Enviados: martes 22 de mayo de 2007 13H31 (GMT-0400) America/Santiago
Asunto: Re: Problem with compex
If you don't specify a hostname in SHOW GRANTS, '%' is assumed. My mistake
for not telling you this before. If you enable networking, and connect
with
mysql -h 127.0.0.1
instead of
mysql -h localhost
Well, in fact 127.0.0.1 and localhost produce the same effect but by using
Localhost is indeed a special value that isn't include in '%'. It's a
feature not a bug ;)
Regards,
Bingo! That was the point! If i connect to the server ip or server name it
works perfectly, but if I try to connect to localhost it fails unless I add a
new user specific to localhost :D
that was the problem, connecting to localhost didn't work unless I add
specifically localhost... If tried with the host ip or name worked perfectly,
so your comment had sense and solved it all...
Just one comment, 127.0.0.1 had the same effect as localhost, I should connect
to the specific host ip or name
Baron Schwartz a écrit :
Hi,
Miguel Cardenas wrote:
Hello list
I have a problem adding a user with host '%' ...
*** If I add a user with host '%' when trying to connect get this error:
ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
password: YES)
*** If I add
Mathieu Bruneau wrote:
Baron Schwartz a écrit :
Hi,
Miguel Cardenas wrote:
Hello list
I have a problem adding a user with host '%' ...
*** If I add a user with host '%' when trying to connect get this error:
ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
password
, and you want bind-address set to the machine's IP address.
Now that I think of it, this is more likely to be the problem for you.
- skip-networking is disabled
- bind-address option is not present in /etc/my.cnf
should I try to add a:
bind-address = x.y.z.a
to the configuration file
is configured right. You want to
check
the bind-address and skip-networking settings. You don't want
skip-networking, and you want bind-address set to the machine's IP
address.
Now that I think of it, this is more likely to be the problem for you.
- skip-networking is disabled
- bind
. You don't want
skip-networking, and you want bind-address set to the machine's IP address.
Now that I think of it, this is more likely to be the problem for you.
- skip-networking is disabled
- bind-address option is not present in /etc/my.cnf
should I try to add a:
bind-address = x.y.z.a
801 - 900 of 8646 matches
Mail list logo