Hi there,
In MySQL 8, how can you figure out if an entry in the mysql.user table is a
role or a user?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB
Am 08.01.2016 um 10:14 schrieb Nitin Mehta:
Looks like some kind of locking mechanism in the application. Should not be a
database issue.
no true - this is a native mysql error message!
honestly both of you should have used Google
http://dev.mysql.com/doc/refman/5.7/en/commands-out
r from our web site:
'commands out of sync, you can't run this command now'
This error is generated sometimes when opening a page ,and immediately
after refreshing the page, error gone.
Can you please help me to troubleshoot this issue, so that above error
disappears permanently? Is it a database
Hi all,
Suddenly I have started getting below error from our web site:
'commands out of sync, you can't run this command now'
This error is generated sometimes when opening a page ,and immediately
after refreshing the page, error gone.
Can you please help me to troubleshoot this issue, so
(no larger).
3. Meanwhile, try to make that long query more efficient.
Can you show it to us, together with SHOW CREATE TABLE, SHOW
TABLE STATUS, and EXPLAIN ?
Thanks for the feedback, Rick.
There are 1200+ tables in the database, so I don't think you want a SHOW CREATE
TABLE, SHOW TABLE
an index, so there will be table scans. The
solution is to CREATE TEMPORARY TABLE ... SELECT for each one, then add an
index.
You SELECT a bunch of rows as Query1, then filter?? Can't you move the
filtering into the subquery??
There is no need for either CAST in cast(cast('2013-05-07' as date
MyISAM? Or InnoDB?
Lock_time perhaps applies only to table locks on MyISAM.
SHOW ENGINE InnoDB STATUS;
You may find some deadlocks.
Is Replication involved?
Anyone doing an ALTER?
-Original Message-
From: Robinson, Eric [mailto:eric.robin...@psmnv.com]
Sent: Thursday, May 09, 2013
-Original Message-
From: Robinson, Eric [mailto:eric.robin...@psmnv.com]
Sent: Thursday, May 09, 2013 1:58 PM
To: mysql@lists.mysql.com
Subject: Slow Response -- What Does This Sound Like to You?
We have a situation where users complain that the system
periodically
: 8 x 2.9GHz Xeon
RAM: 32GB
Disk: RAID 5 (6 x 512GB SSD)
MySQL: 5.0.95 x64
Engine: MyISAM
--
Eric Robinson
Disclaimer - May 9, 2013
This email and any files transmitted with it are confidential and intended
solely for mysql@lists.mysql.com javascript:;. If you are not the named
.
You might try using low_priority_updates to mitigate this.
Regards,
--
Denis Jedig
syneticon networks gmbh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On Thu, May 9, 2013 15:25, Robinson, Eric wrote:
-Original Message-
From: Robinson, Eric [mailto:eric.robin...@psmnv.com]
Sent: Thursday, May 09, 2013 1:58 PM
To: mysql@lists.mysql.com
Subject: Slow Response -- What Does This Sound Like to You?
We have a situation where
-Original Message-
From: Wm Mussatto [mailto:mussa...@csz.com]
Sent: Thursday, May 09, 2013 3:50 PM
To: Robinson, Eric
Cc: Rick James; mysql@lists.mysql.com
Subject: RE: Slow Response -- What Does This Sound Like to You?
On Thu, May 9, 2013 15:25, Robinson, Eric wrote
Hello Eric,
On 5/9/2013 7:13 PM, Robinson, Eric wrote:
-Original Message-
From: Wm Mussatto [mailto:mussa...@csz.com]
Sent: Thursday, May 09, 2013 3:50 PM
To: Robinson, Eric
Cc: Rick James; mysql@lists.mysql.com
Subject: RE: Slow Response -- What Does This Sound Like to You?
On Thu
On 05/09/2013 03:25 PM, Robinson, Eric wrote:
-Original Message-
From: Robinson, Eric [mailto:eric.robin...@psmnv.com]
Sent: Thursday, May 09, 2013 1:58 PM
To: mysql@lists.mysql.com
Subject: Slow Response -- What Does This Sound Like to You?
We have a situation where users complain
. Meanwhile, try to make that long query more efficient. Can you show it to
us, together with SHOW CREATE TABLE, SHOW TABLE STATUS, and EXPLAIN ?
-Original Message-
From: Bruce Ferrell [mailto:bferr...@baywinds.org]
Sent: Thursday, May 09, 2013 6:05 PM
To: mysql@lists.mysql.com
Subject
Hi everybody,
I think we need to focus on three things:-
A) temp tables created on disk
B) table cache size
C) buffer sizes
If you find the number of temp tables created on disk is very large, please
increase the temp_table_size.
Enable the slow query log And check if sort buffer size
Dear Friends,
There has been some problems with my mail box and some spam emails have been
sent to you from my email.
Please do not open the link that was sent to you from my email address!!
Sorry for the problem caused.
Best regards,
Javad Bakhshi,
Computer Science M.Sc
Department
mysql select date_format(now(),'%m-%d%-%y
%h:%i:%s') AS time;
+---+
|
time
|
+---+
| 11-11-11 11:11:11 |
+---+
1 row in set (0.00 sec)
On 11/11/2011 16:29, Curtis Maurand wrote:
mysql select date_format(now(),'%m-%d%-%y
%h:%i:%s') AS time;
+---+
|
time
|
+---+
| 11-11-11 11:11:11 |
+---+
1 row in set (0.00 sec)
Actually, it should be select date_format(now(),'%y-%m%-%d
are!!! (for this case anyway)
-
Registered Office: 15 Stukeley Street, London WC2B 5LT, England.
Registered in England number 1421223
This message is for the designated recipient only and may contain privileged,
proprietary, or otherwise private information. If you have
Got It; Thank You, Thank You, Thank You
On 4/1/2011 11:28 PM, Claudio Nanni wrote:
Hi Thomas,
Did you run the post install script?
http://kae.li/iiikj
Claudio
On Apr 2, 2011 2:20 AM, Thomas Dineen tdin...@ix.netcom.com
mailto:tdin...@ix.netcom.com wrote:
...
Reality is that which, when you stop believing in it, doesn't go away. --
Philip K. Dick
Jan Steinman, EcoReality Co-op
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Dear friend,
friend (instantdegree...@gmail.com) has sent you the following link at
USAFlorist.com:
http://www.usaflorist.com/products/1-800-flowers_fun__flirty.htm?refcode=1A2
Your Friend's Message to you:
Do you have the knowledge and the experience in your field but lack the
qualifications
database. We're
not talking about it openly yet, but sign up for the mailing list
athttp://www.nimbusdb.com if you want more tech detail.
As relates to your request, give me a call. I think the timing will work.
Regards
Barry
On 2/12/11 4:46 AM, USAFlorist.com wrote:
Dear friend,
friend
else has worked out how to build an elastically scalable
JDBC/SQL/transactional database. We're not talking about it openly
yet, but sign up for the mailing list athttp://www.nimbusdb.com if
you want more tech detail.
As relates to your request, give me a call. I think the timing will
work
Hi mysql@lists.mysql.com ,
I just light a candle for 26/11.
It is time to show that we have neither forgiven nor forgotten 26/11.
It is time to remember those who paid with their lives for the fanaticism of
a few, to salute those who gave up their lives trying to shield others, and
to honor
pages become subject to frequent IO.
Any suggestions on what I should do? I am
thinking of doing one of these:
Whether any action is needed, and which, depends on the problem you
experience:
- If the system as a whole (both CPU and disk) has a significant idle
Thanks again :-)
Nunzio
From: Joerg Bruehe joerg.bru...@oracle.com
To: Nunzio Daveri nunziodav...@yahoo.com; mysQL General List
mysql@lists.mysql.com
Sent: Fri, July 30, 2010 1:31:54 PM
Subject: Re: Indexes larger than RAM (was: Do you know who can answer
Nunzio Daveri,
Joerg Bruehe gave you a lot of good tips to try and speed things up.
A few hundred queries per second seem to be a relatively small number to
cause the server to crawl. I don't have the rest of your thread, but can
you publish some of the slow queries (see Slow Query Log
Hi All,I am getting Can't execute the given command
because you have active locked tables or an active transaction error when
I am trying to truncate table. I am unable to understand the error as when I am
using the mysql query browser then the same command is working fine but when I
am doing
Hi,
I am getting Can't execute the given command because you have active locked
tables or an active transaction error when I am trying to truncate table. I
am unable to understand the error as when I am using the mysql query browser
then the same command is working fine but when I am doing
This only works for MyISAM :-)
However, there's another solution where you don't need to shut down, and
that works for any engine afaik:
rename table oldschema.table to newschema.table;
I agree that it's a silly thing to not have, but I can't say that I've
encountered a whole lot of instances
On Fri, December 11, 2009 7:38 am, Johan De Meersman wrote:
This only works for MyISAM :-)
Good to know -- thanks!
However, there's another solution where you don't need to shut down, and
that works for any engine afaik:
rename table oldschema.table to newschema.table;
Just to be 100
On Fri, Dec 11, 2009 at 1:56 PM, Ken D'Ambrosio k...@jots.org wrote:
rename table oldschema.table to newschema.table;
Just to be 100% clear -- I assume you have to first create the destination
database, and then do this for all the tables in the source database?
Yep. Easily scriptable
If you want to move the database atomically, a RENAME TABLE statement
may have multiple clauses.
RENAME TABLE
olddb.foo to newdb.foo,
olddb.bar to newdb.bar;
Here, I hot-swap a new lookup table 'active.geo' into a live system
confident that, at any given point, some version
Can you use that syntax if the databases are on different file systems? If
you can, and the original table is big, the command would take a while as it
moved data from one file system to another.
On Fri, Dec 11, 2009 at 7:58 AM, Johan De Meersman vegiv...@tuxera.bewrote:
On Fri, Dec 11, 2009
command would have the same limitations.
- michael dykman
On Fri, Dec 11, 2009 at 11:35 AM, Jim Lyons jlyons4...@gmail.com wrote:
Can you use that syntax if the databases are on different file systems? If
you can, and the original table is big, the command would take a while as it
moved data from
it simply changing pointers or is it a full on
copy/rm? (Assume same filesystem/directory)
-Original Message-
From: Michael Dykman [mailto:mdyk...@gmail.com]
Sent: Friday, December 11, 2009 6:08 AM
To: MySql
Subject: Re: Are you serious? mySQL 5.0 does NOT have a
RENAME DATABASE?
If you
.
Depending on how your data is stored, it might now be 'quite' as
simple as a unix 'mv' command.. if this is a production system, I
would recommend you do a dry run with a replicant/slave. No amount of
theorizing will tell as much as the experiment.
- michael dykman
On Fri, Dec 11, 2009 at 4:40
, this is by design afaik.
How fast is this? I mean, if I have an 80GB database, is it like a real
unix 'mv' command where it simply changing pointers or is it a full on
copy/rm? (Assume same filesystem/directory)
Don't know, but given that it works with InnoDB, you should be able to
easily test
if you have myisam alone tables you can rename the folder of the database. That
can work like rename database. If you have innodb table you have to move one by
one table because details of those tables will be stored in innodb shared table
space. Moving folder cannot work.
Thanks,
Saravanan
: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE?
if you have myisam alone tables you can rename the folder of the database. That
can work like rename database. If you have innodb table you have to move one by
one table because details of those tables will be stored in innodb shared
. :) Therefore permissions should be fine as they go by DB name AFAIK
and not some pointer.
-Original Message-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Friday, December 11, 2009 2:18 PM
To: Saravanan; MySql; Michael Dykman
Subject: RE: Are you serious? mySQL 5.0 does NOT have
How can it possibly be that mySQL doesn't allow you to rename a database? I
can't fathom how this can be a difficult task at all to do. Aren't mySQL
databases stored in a directory of the DB name? And for INNODB, can't you
just find the spot in the ibdata file and alter whatever needs
Uhhh... wow. Unless I'm very, very, very mistaken, I think you're missing
something pretty obvious: I believe you can simply
a) shut down the database
b) mv the directory to a different directory name.
*DONE* Your database now has a different name. Boy, that 30 seconds of
hard labor was sure
http://cfi.iflywestwind.com/nEACWal3iJ.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi everyone --
I'm pretty new to MySql, but not many years ago I was an ISAM guy so I
understand the issues with indexes and on-the-fly inserts.
I've seen many questions around this error message, Access denied; you need
the RELOAD privilege for this operation. But I'm not grokking
In the last episode (Sep 20), Pete Wilson said:
I'm pretty new to MySql, but not many years ago I was an ISAM guy so I
understand the issues with indexes and on-the-fly inserts.
I've seen many questions around this error message, Access denied; you
need the RELOAD privilege
(r...@localhost) [(none)] SELECT CONCAT('SHOW GRANTS FOR \'', user
,'\'@\'', host, '\';') AS mygrants FROM mysql.user ORDER BY mygrants;
+-+
| mygrants|
+-+
|
How the F do you remove a user from the grant table?!!
The mysql.com site is down too by the way...
(r...@localhost) [(none)] SHOW GRANTS FOR 'madc';
ERROR 1141 (42000): There is no such grant defined for user 'madc' on host
'%'
(r...@localhost) [(none)] SHOW GRANTS FOR 'madc'@;
ERROR 1141
Use information_schema!
select * from information_schema.user_privileges where grantee like
'madc'@%;
Should get you what you need.
John Daisley
Email: john.dais...@butterflysystems.co.uk
Mobile: +44 (0)7812 451238
MySQL Certified Database Administrator (CMDBA)
MySQL Certified Developer
*mysql create user 'test'@'localhost' identified by 'pass';*
Query OK, 0 rows affected (0.00 sec)
*mysql GRANT CREATE, DELETE ON *.* TO 'test'@'localhost';*
Query OK, 0 rows affected (0.00 sec)
*mysql select * from information_schema.user_privileges where grantee like
'test'@'localhost';*
(and tried to explain how to do
that).
But if somebody finds that the message
*1135: Can't create a new thread (errno 35); if you are not out of
available memory, you can consult the manual for a possible
OS-dependent bug*
really is caused by a file limit, I propose to report a bug about
into this.
- Mark
-Original Message-
From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com]
Sent: woensdag 29 april 2009 8:14
To: Mark; mysql@lists.mysql.com
Subject: Re: 1135: Can't create a new thread (errno 35); if you are not out
of available memory, you can consult the manual
Hello guys and gurus
I am keep getting this error after a while *1135: Can't create a new thread
(errno 35); if you are not out of available memory, you can consult the
manual for a possible OS-dependent bug*
Even though, I have 16GB memory and 32GB swap. But mysqlserver stops
answering. Could
Hi folks
then if I check with the process: I get following output:
# ps ax | grep mysqld
797 con- I 0:00.00 /bin/sh /usr/local/bin/mysqld_safe
--defaults-extra-file=/var/db/mysql/my.cnf --user=mysql
--datadir=/var/db/mysql --pid-file=/var/db/mysql/localhost.server1.pid
835 con- S
(and
'sysctl' it to higher if it's not sufficient). I'm always amazed how much
open files MySQL keeps. The amount of files MySQL reserves, way I recall,
is also directly related to max. connections; so you could lower that too,
temporarily, to see if it makes the error go away.
- Mark
-Original
Hi VeeJay, Mark, all,
VeeJay wrote:
Hi Mark
Yes, you are right. I should have provided complete information in order to
get help...
I am running
DB: Server version: 5.0.77-log FreeBSD port: mysql-server-5.0.77_1
OS: FreeBSD 7.1
On Tue, Apr 28, 2009 at 10:44 AM, Mark ad
.
Date: Tue, 28 Apr 2009 12:26:47 +0200
From: joerg.bru...@sun.com
Subject: Re: 1135: Can't create a new thread (errno 35); if you are not out
ofavailable memory, you can consult the manual for a possible
OS-dependent bug
To: maan...@gmail.com
CC: ad...@asarian-host.net; mysql
Hi Mark
Yes, you are right. I should have provided complete information in order to
get help...
I am running
DB: Server version: 5.0.77-log FreeBSD port: mysql-server-5.0.77_1
OS: FreeBSD 7.1
On Tue, Apr 28, 2009 at 10:44 AM, Mark ad...@asarian-host.net wrote:
It would probably
to Jörg's expertise on the matter. :)
- Mark
-Original Message-
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: dinsdag 28 april 2009 14:44
To: Joerg Bruehe; maan...@gmail.com
Cc: ad...@asarian-host.net; mysql@lists.mysql.com
Subject: RE: 1135: Can't create a new thread (errno 35); if you
This is because you didn't copy innodb ibdata and ib_log files togeter. Or
you forgot to stop mysqld when you remove its ib_log files.
On Sat, Feb 7, 2009 at 7:21 AM, my sql mysql.g...@gmail.com wrote:
WHY do I see this error when restoring my backup db :
InnoDB: Your database may be corrupt
WHY do I see this error when restoring my backup db :
InnoDB: Your database may be corrupt or you may have copied the InnoDB
tablespace but not the InnoDB log files.
GOAL: Trying to restore mysql backup on different host
using InnoDB backup that copes the backed up files to a files sever where
/internet.
---
I've done some research here, but nothing stands out as the winner...
but I'm open to any of these ideas if you can make a strong case for
them.
http://dev.mysql.com/doc/refman/5.1/en
on an incremental/differential InnoDB
backup tool. It is in need of a sponsor though.
I'm betting that you don't change all 70GB of that table every day,
and you'd appreciate being able to keep differentials and only do full
backups every so often.
For big datasets like this, dump is impossible or too
/differential InnoDB
backup tool. It is in need of a sponsor though.
I'm betting that you don't change all 70GB of that table every day,
and you'd appreciate being able to keep differentials and only do full
backups every so often.
For big datasets like this, dump is impossible or too expensive at
some
Something totally ghetto that might work...
If you could convert the files to appear to be text with some kind of
reversible fast translation, rsync might be able to handle the diff part.
You'd sure want to test this out thoroughly...
--
MySQL General Mailing List
For list archives
of these ideas if you can make a strong case for
them.
http://dev.mysql.com/doc/refman/5.1/en/mysqlhotcopy.html
mysqlhotcopy works only for backing up MyISAM and ARCHIVE tables.
http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html
InnoDB Hot Backup is an online backup tool you can use to backup
I know how you feel! I think your two best options are these:
1.) Use LVM snapshots per the MPB links you mentioned as a guide. Your
incremental backup would be the binary logs that MySQL writes. You could
copy any of this data off site by mounting the snapshots and using your
remote copy
So where's the advantage of VARCHAR ?
Less space on disc = less data retrieved from disc = faster data
retrieval - sometimes. If you have small columns, a small number of
rows, or both, then char columns may be faster. If you have large
columns of varying actual length, lots of rows, or both
On Wed, Jan 7, 2009 at 2:26 PM, Richard Heyes rich...@php.net wrote:
I still think a CHAR field would be faster than a VARCHAR because of
the fixed row length (assuming every thing else is fixed). Perhaps
someone from the MySQL list could clarify...?
Say that your column length goes up to
retrieved from disc = faster data
retrieval - sometimes. If you have small columns, a small number of
rows, or both, then char columns may be faster. If you have large
columns of varying actual length, lots of rows, or both, then varchar
columns may be faster.
I still think a CHAR field
On 1/7/09, Jim Lyons jlyons4...@gmail.com wrote:
There are other factors. If a table is completely fixed in size it makes
for a faster lookup time since the offset is easier to compute. This is
true, at least, for myisam tables. All books on tuning that I have read
have said the CHAR makes
On Wed, Jan 7, 2009 at 9:17 AM, David Giragosian dgiragos...@gmail.com wrote:
On 1/7/09, Jim Lyons jlyons4...@gmail.com wrote:
There are other factors. If a table is completely fixed in size it makes
for a faster lookup time since the offset is easier to compute. This is
true, at least, for
To find out more about Twitter, visit the link below:
http://twitter.com/i/429c961b36cd7c31a28772a32e82bb19f302ebaf
Thanks,
-The Twitter Team
About Twitter
Twitter is a unique approach to communication and networking based on the
simple concept of status. What are you doing? What are your
class=contactoitalicowebsite:/span a
href=http://arpsworldproperties.com; target=_blank
class=contactositewww.arpsworldproperties.com/a/td
/tr
tr
td colspan=3 class=textoitalicoWe are pleased in offering you 3
amazing opportunities for investment in Cape Verde.br /
3 amazing plots of land
On 07.02.2008 03:52 CE(S)T, Chris wrote:
If you don't mind a mysql-specific fix, and can get the data you want
from a select query you could:
insert into table (select goes here) on duplicate key update;
or maybe a replace into ?
INSERT/REPLACE ... SELECT will always overwrite the entire
On 06.02.2008 08:12 CE(S)T, Chris wrote:
Yves Goergen wrote:
My goal was to copy some potentially large BLOB from one record to
another in the same table
Update table set blob2_field=blob1_field;
This does something totally different. ;) See my first posting why.
--
Yves Goergen
-Original Message-
From: Yves Goergen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 05, 2008 6:22 PM
To: Baron Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Error: You can't specify target table '...' for update in
FROM clause
On 05.02.2008 23:25 CE(S)T, Baron Schwartz wrote
I missed the first post.
If you don't mind a mysql-specific fix, and can get the data you want
from a select query you could:
insert into table (select goes here) on duplicate key update;
or maybe a replace into ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi,
I've got an error message from MySQL 5.0 that I don't understand.
UPDATE message_revision SET HasData = 1, Data = (SELECT Data
FROM message_revision WHERE MessageId = 7 AND RevisionNumber = 5)
WHERE MessageId = 7 AND RevisionNumber = 6
SQL error: [SQLSTATE:HY000, 1093] You can't specify
AND RevisionNumber = 6
SQL error: [SQLSTATE:HY000, 1093] You can't specify target table
'message_revision' for update in FROM clause
What went wrong?
You can't select from a table you're updating at the same time. What
at the same time means is a bit unclear unless you're one of the
MySQL
On 05.02.2008 23:25 CE(S)T, Baron Schwartz wrote:
You can't select from a table you're updating at the same time. What
at the same time means is a bit unclear unless you're one of the
MySQL developers ;-)
Yes, Paul DuBois already replied to me off-list. Now I found that
documentation part
Yves Goergen wrote:
On 05.02.2008 23:25 CE(S)T, Baron Schwartz wrote:
You can't select from a table you're updating at the same time. What
at the same time means is a bit unclear unless you're one of the
MySQL developers ;-)
Yes, Paul DuBois already replied to me off-list. Now I found
proven software developers and
technological leadership will only make the community stronger and the
products better.
Good for MySQL users?
Todd, I can't express how much better it will be for end-users! If you
take a look at one of my other posts to this very mailing list, you'll
see a broad
Hello,
I'm a reporter at Computerworld magazine and I'm writing a story today on
MySQL user and developer reax to the Sun acquisition of MySQL.
Can you drop me a note and let me know your thoughts about this ASAP?
I'd like to know:
What are your impressions of this deal?
Is this good
\MySQL\MySQL Server 4.1\binmysqld-max-nt --standalone
Can't start server: Bind on TCP/IP port: Invalid argument
071207 22:50:57 [ERROR] Do you already have another mysqld server running
on
port: 3306 ?
071207 22:50:57 [ERROR] Aborting
071207 22:50:57 [Note] mysqld-max-nt: Shutdown complete
Also
[ERROR] Do you already have another mysqld server running on
port: 3306 ?
071207 22:50:57 [ERROR] Aborting
071207 22:50:57 [Note] mysqld-max-nt: Shutdown complete
Also when I try to run mysqladmin shutdown command it gives me the following
error
C:\Program Files\MySQL\MySQL Server 4.1\binmysqladmin
I started using MySQL 5 a couple of months ago and I was able to handle
most of the issues OK. However there is this particular problem that is
causing untold misery for my self and particularly my users.
At unexpected times, a roque query is executed or triggered all on its
accord and starts
Mysql restricts access outside the server after the installation (on not
all, but several cases) so i suggest to connect to the mysql database as
root and review the host values on the user table, that can give you an
idea of who is allowed and from where is allowed ...remeber that % means
Don't forget to allow port 3306 (or whatever port you're server listens on)
through any Windows firewall...
Tim
-Original Message-
From: Carlos Proal [mailto:[EMAIL PROTECTED]
Sent: Friday, June 22, 2007 1:40 PM
Cc: mysql@lists.mysql.com
Subject: Re: How do you allow external
I've installed MySQL5 on a machine running Windows XP. I'm not an advanced
user so I chose all the default configuration settings when I went through
the setup wizard for the server instance. The database works fine and I can
access it when I'm sitting at the computer through the command line
Hi,
Ferindo Middleton wrote:
I've installed MySQL5 on a machine running Windows XP. I'm not an advanced
user so I chose all the default configuration settings when I went through
the setup wizard for the server instance. The database works fine and I can
access it when I'm sitting at the
I found how to bind to addrees to but didn't find anything in my.ini about
skip-networking but now I have this problem where the I can't connect
locally sitting at the computer using hostname localhost if I type in
the IP address of the computer I get a messsage saying {Hostname} is not
SELECT 1+1 as foo, 2 as bar, foo+bar
This will not work, but I think you can see what I am trying to do. I need
to run a pretty hefty update on a database, and there are some pretty heavy
calculations I will be doing. The result of many of those, needs to be
further used to make updates
In the last episode (Jun 19), Scott Haneda said:
SELECT 1+1 as foo, 2 as bar, foo+bar
This will not work, but I think you can see what I am trying to do.
I need to run a pretty hefty update on a database, and there are some
pretty heavy calculations I will be doing. The result of many
Hi,
This is with reference of your profile for regarding job opportunities with
Microsoft IDC, Hyderabad.
As you know Microsoft is on hiring spree and IDC is Microsoft's second
biggest development center and is currently working on 35 products and
technologies including Windows Vista
Um... Did everyone get this message?
Quoting:
Dear Sirs,
We contacted you last week, because we would like to exchange links with you.
We understand that there is often not enough time in the day for everything,
but, I am sure you appreciate that getting targeted links to your website
Yes. :)
And the one before it.
On May 29, 2007, at 2:14 PM, Glen Barber wrote:
Um... Did everyone get this message?
Quoting:
Dear Sirs,
We contacted you last week, because we would like to exchange
links with you.
We understand that there is often not enough time in the day
Ok... just making sure. Spambots search mailing-lists often, I suppose?
signature.asc
Description: Digital signature
1 - 100 of 572 matches
Mail list logo