Sorry ya, not for my project ,
just i wat to know
Thanks
2009/5/25 Martin Gainty mgai...@hotmail.com:
cannot help with implementation details unless we see your DB schema e.g.
mysqluse DB
mysqlshow tables
msqyldesc table1
mysqldesc table2
Martin Gainty
Hi Martin,
Sorry my example wasn't clearer. I am doing a commit or rollback
depending on the success of the overall transaction. What I don't do is
retry parts of the transaction upon deadlock.
Thanks for pointing that out, though!
Best,
Mike
On Mon, 2009-05-25 at 16:46 -0400, Martin
Hydro Quebec just f***ed my server just as I was booting up three
machines; XP is ok, FreeBSD 7.1 is the one with mysql problem, FreeBSD
4.10 - don't know, but boots ok. Result: can't access database. One
table seems to abort mysqld. PhpMyAdmin connects to all databases except
one.
mysql CHECK
Wondering which of these will work or not?
(no quotes)
GRANT ALL PRIVILEGES ON mydb.mytable TO 'user'@'10.10.10.%' IDENTIFIED BY
PASSWORD 'secret';
(backticks)
GRANT ALL PRIVILEGES ON `mydb`.`mytable` TO 'user'@'10.10.10.%' IDENTIFIED
BY PASSWORD 'secret';
(single quotes)
GRANT ALL PRIVILEGES
Now I'm really confused.
I just did this:
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'10.10.10.%';
GRANT ALL PRIVILEGES ON mydb.* TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD
'secret';
and then I get this:
SHOW GRANTS FOR 'user'@'10.10.10.%';
I'm a little concerned and disappointed that the GRANT command doesn't do
any sort of checking (like a foreign key for example) to verify that the
database and table exist?!
I get the case of *.* but it seems crazy to me that it would allow foo.bar
when neither a database named 'foo' nor a table
Start the server with --skip-grants-table. That will disable logins.
Then do delete from mysql.user and restart :)
Walter
On Tue, May 26, 2009 at 6:05 PM, Daevid Vincent dae...@daevid.com wrote:
Now I'm really confused.
I just did this:
REVOKE ALL PRIVILEGES, GRANT OPTION FROM
*shrugs* I, for one, appreciate a tool that doesn't try to be smarter than I
am. If I want to be treated like an idiot, I'll use microsoft software.
On Wed, May 27, 2009 at 2:38 AM, Daevid Vincent dae...@daevid.com wrote:
I'm a little concerned and disappointed that the GRANT command doesn't
On Wed, May 27, 2009 at 2:05 AM, Daevid Vincent dae...@daevid.com wrote:
So why mySQL is putting back ticks in there even though I didn't,
Because it doesn't save your original statements, but recreates an
appropriate set from the grant tables.
and more importantly why doesn't the second