MySQL Community Server 5.0.84 has been released

Dear MySQL users, MySQL Community Server 5.0.84, a new version of the popular Open Source Database Management System, has been released. This and future releases in the MySQL Community Server 5.0 series share version numbers with their MySQL Enterprise Server counterparts. The release is now av

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

*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'";* +-

Re: mysqldump and access rights

# chown mysql.mysql datafile 2009/7/23 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 ? > > r

mysqldump and access rights

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: http://list

Re: PHP MYSQL Admin question

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 P

Re: Index selection problem

Maybe I'm wrong :) On Tuesday, July 21, 2009, John Daisley 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. >> >> Is this really

Re: PHP MYSQL Admin question

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 wrote: > Trying the latest phpMYAdmin on Mac OS X. > > Everything is set up correct but I get > > #2002 - The s

PHP MYSQL Admin question

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 l

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

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 (CMD

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

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 (42

Where does mysqld write a core file?

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 Genera

Re: mysqldump output

#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/

How do you show ALL grants for a username?

(r...@localhost) [(none)]> SELECT CONCAT('SHOW GRANTS FOR \'', user ,'\'@\'', host, '\';') AS mygrants FROM mysql.user ORDER BY mygrants; +-+ | mygrants| +-+ | SHO

dev.mysql.com is down.

Open Source Database Magazine - Issue One Released

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 Peter