Hmmm, that is strange indeed. Hopefully one of the Level 70+ MySQL Wizards
on the list can explain why this might happen.
~~Fish~~
On Sat, Oct 25, 2008 at 4:44 PM, Joe Auty <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Fish Kungfu wrote:
> | I think I see th
I think I see the typo. If that's an exact copy & paste of your GRANT
statement, then the problem is the spaces in the database designation:
You have: GRANT ALL PRIVILEGES ON * . * TOetc
But it should be: GRANT ALL PRIVILEGES ON *.* TOetc
There shouldn't be any spaces in the *.* part.
I think I see the typo. If that's an exact copy & paste of your GRANT
statement, then the problem is the spaces in the database designation:
You have: GRANT ALL PRIVILEGES ON * . * TOetc
But it should be: GRANT ALL PRIVILEGES ON *.* TOetc
There shouldn't be any spaces in the *.* part.
Fish Kungfu wrote:
Would you mind posting what you tried? Did you put single quotes around the
wildcard like '%' ?
For example: GRANT ALL ON somedb.* TO 'someuser'@'%';
Also see http://dev.mysql.com/doc/refman/5.0/en/grant.html
CheersFish
Sure!
On what I'll call "mynewserver"
CR
Deleting the files from the command line is not considered the 'correct' way:
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
There should be a 'log-bin' line in your my.cnf just comment it if
you don't want binary logs. Yes, they're mostly just used for
master/slave replication,
Would you mind posting what you tried? Did you put single quotes around the
wildcard like '%' ?
For example: GRANT ALL ON somedb.* TO 'someuser'@'%';
Also see http://dev.mysql.com/doc/refman/5.0/en/grant.html
CheersFish
On Sat, Oct 25, 2008 at 1:40 PM, Joe Auty <[EMAIL PROTECTED]> w
Hi everybody,
last week some friends started to think about a viable solution to
implement a SssS infrastructure to develop our applications on and
give the final users the power to customize every aspect of the
application (objects, properties, relations, processes and workflows)
... One
I'm also having this strange problem just as stated here, anybody find a
fix for this yet?
Again, using wildcards (%) for the Host don't work while the FQDN does
from the exact same remote machine, the exact same username, etc. There
is something about the wildcard ACL that is not working prop
Joerg Bruehe wrote:
Hi Mark, all!
Mark Goodge wrote:
I'd appreciate some advice on how best to handle a biggish dataset
consisting of around 5 million lines. At the moment, I have a single
table consisting of four fields and one primary key:
partcode varchar(20)
region varchar(10)
location va
Hi all,
I had a server pretty much locked up this morning due to the mysql bin logs
filling up the /var filesystem.
I had been investigating the my.cnf settings file a white back, got
sidetracked, and never finished it.
The bin logs are named:
/var/db/mysql/myserver-bin.01
/var/db/mysql/m
Or you can create a temporary table including a auto_increment attribute and
fill it with continuous numbers.
Then simply use it to left join the original table.
On Sat, Oct 25, 2008 at 2:57 PM, Moon's Father <[EMAIL PROTECTED]>wrote:
> Create an extra trigger on that table with delete event.Then
11 matches
Mail list logo
