can't seem to find anything on my problem. hope list can help:
thread class creates connection to mysql - all is well
if sql takes too long, calling thread interrupts thread, and close
resources:
rs.close(), stmt.close(), conn.close()
however mysqld server connections are not closed
after a wh
Hello,
I'm having issues where once every 24-36 hours a replication slave
locks up and I have to kill -9 the process and restart it. I'm using
mysql 5.1.26 and centos 5 (kernel 2.6.18-92.el5) but it's been
occurring since I simultaneously upgraded to 5x and started using the
slave in production (i
Hello,
A bit embarrassed, I have been away from the databasing side of system
development for quite a while so am a little rusty. This seems like a simple
issue.
I have a USER table:
userID
fName
lName
address
address2
city
province
country
referrerID
userID is the unique pr
grant all on *.* to root@'%.def.com'; /* The percent sign is your
wildcard character. */
flush privileges;
I don't think you need to flush privileges as of 5.0. I still do just
to be sure.
Curtis
[EMAIL PROTECTED] wrote:
Hi Parikh,
Yes.. It worked with IP i.e when I granted privileges
Hi Parikh,
Yes.. It worked with IP i.e when I granted privileges to 'root'@'ip of
my machine' and flushed it, it worked fine. But I have a qestion below:
GRANT ALL PRIVILEGES ON *.* to 'root'@'IP';
FLUSH PRIVILEGES;
However, Would '*.def.com' work in the place of IP?, as I feel that
giving privi
make sure to FLUSH PRIVILAGES;
- Original Message
> From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]; mysql@lists.mysql.com
> Cc: [EMAIL PROTECTED]
> Sent: Monday, 14 July, 2008 10:59:35 AM
> Subject: RE: Problem - "Host 'abc.def.com' is not allowed to connect to th
Hi,
I did that too,
I executed the command -> GRANT ALL PRIVILEGES ON *.* to
'root'@'localhost' ;
I tried also GRANT ALL PRIVILEGES ON *.* to 'root'@'abc.def.com' ; where
abc.def.com is my machine name
But both of these did not work, I did not mention this in my earlier
mail. Can you please let
Hi All,
I am facing a particular problem which i have explained here. Can
you please let me know a solution for this.
>From my web application, I am trying to connect the MySQL server by
using the IP address as the server name, and it says the following
error:
"Host 'abc.def.com' is not allow
Dear MySQL users,
We are proud to present to you the MySQL Server 5.1.26-rc release,
a new "release candidate" version of the popular open source database.
MySQL 5.1.26-rc is slated to be the last release candidate before we
declare MySQL 5.1 as "production ready" (GA). We therefore appreciate