Open Source Database Magazine - Issue One Released

2009-07-23 Thread bmurphy
I just uploaded the pdf of the summer issue of Open Source Database Magazine. Included in this issue: * A great article on the new features of Postgresql 8.4 by Robert Treat * Part one of a two part article on Percona’s new XtraBackup backup program Also the news, the book shelf and

dev.mysql.com is down. EOM

2009-07-23 Thread Daevid Vincent

How do you show ALL grants for a username?

2009-07-23 Thread Daevid Vincent
(r...@localhost) [(none)] SELECT CONCAT('SHOW GRANTS FOR \'', user ,'\'@\'', host, '\';') AS mygrants FROM mysql.user ORDER BY mygrants; +-+ | mygrants| +-+ |

Re: mysqldump output

2009-07-23 Thread peng yao
#mysqldump -u username -p -h mysqld_host databasename database_name.sql username is the mysqld server login name mysqld_host is the mysqld server address or hostname databasename is the database which you should dump You can use man mysqldump or mysqldump --help to get more infomation 2009/7/21

Where does mysqld write a core file?

2009-07-23 Thread Per Jessen
I've been trying to make mysqld write a coredump following a crash, and this morning I finally succeeded - according to mysqld.log anyway. It clearly says Writing a core file - but where to? I've checked the datadir /var/lib/mysql, whereelse might it be? /Per Jessen, Zürich -- MySQL General

How do you remove a user from the grant table?!!

2009-07-23 Thread Daevid Vincent
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

Re: How do you show ALL grants for a username?

2009-07-23 Thread John Daisley
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

PHP MYSQL Admin question

2009-07-23 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
Trying the latest phpMYAdmin on Mac OS X. Everything is set up correct but I get #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) And I am telling config.php where the mysql.sock file is located. Help. -- MySQL General Mailing List For

Re: PHP MYSQL Admin question

2009-07-23 Thread Johnny Withers
Are you sure MySQL is running? Can you connect with any other MySQL client? On Wed, Jul 22, 2009 at 1:55 PM, Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem r...@doctor.nl2k.ab.ca wrote: Trying the latest phpMYAdmin on Mac OS X. Everything is set up correct but I

Re: Index selection problem

2009-07-23 Thread Johnny Withers
Maybe I'm wrong :) On Tuesday, July 21, 2009, John Daisley john.dais...@mypostoffice.co.uk wrote: On Tue, 2009-07-21 at 19:42 +0200, Morten Primdahl wrote: On Jul 21, 2009, at 3:27 PM, Johnny Withers wrote: MySQL is unable to use your index when you use IN and/or OR on yoru column.

Re: PHP MYSQL Admin question

2009-07-23 Thread The Doctor
On Thu, Jul 23, 2009 at 08:47:41AM -0500, Johnny Withers wrote: Are you sure MySQL is running? Can you connect with any other MySQL client? Turns out the php.ini was not set properly. On Wed, Jul 22, 2009 at 1:55 PM, Dave Shariff Yadallee - System Administrator a.k.a. The Root of the

mysqldump and access rights

2009-07-23 Thread walter harms
Hi list, i use mysqldump --tab to create database dumps. this will produce txt and sql files. the resulting sql files is owned by the user but the resulting datafile is owned by mysql.mysql is there any way to change that ? re. wh -- MySQL General Mailing List For list archives:

Re: mysqldump and access rights

2009-07-23 Thread peng yao
# chown mysql.mysql datafile 2009/7/23 walter harms wha...@bfs.de Hi list, i use mysqldump --tab to create database dumps. this will produce txt and sql files. the resulting sql files is owned by the user but the resulting datafile is owned by mysql.mysql is there any way to change that

RE: How do you remove a user from the grant table?!!

2009-07-23 Thread Sudhir Menon
*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';*