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 Perconas new XtraBackup backup
program
Also the news, the book shelf and
(r...@localhost) [(none)] SELECT CONCAT('SHOW GRANTS FOR \'', user
,'\'@\'', host, '\';') AS mygrants FROM mysql.user ORDER BY mygrants;
+-+
| mygrants|
+-+
|
#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
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 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
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
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
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
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.
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
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:
# 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
*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';*
14 matches
Mail list logo