Re: REVOKE GRANT OPTION - is that possible?

> How can I revoke a GRANT OPTION on a database or table from a user? > > The manual says > something about > > REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ... > > but this can only revoke the GRANT OPTION on a global level as it

回复： MySQL 4.1.13 and utf-8 language encoding

just use phpmyadmin 2.5* because the 2.6* default use utf8,what you need to do is dump out your old mysql in sql form, use phpmyadmin 2.5* to redeploy it on 4.1*. That is it. 立 周 <[EMAIL PROTECTED]> 写道： Hello list: I have a php website which uses utf-8 encoding. But recently the shared hosting

Re: I can't find the missing rows in a table--

At 08:33 PM 1/1/2006, Hank wrote: Don't you want the queries to be "outer join" and not "left join"? A "left join" is a "left outer join". I ended up using a subselect and that found the missing rows. I'm not sure why the left join didn't work. I've been using them for years to find missing r

Re: Row Count Discrepency

Some more information can be found here: http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html On 12/31/05 7:29 PM, "JJ" <[EMAIL PROTECTED]> wrote: > I have an InnoDB table in a MySQL 4.1.14 database. Can anyone suggest > why MySQL Adminstrator says the table has 497 rows, while do

Re: I can't find the missing rows in a table--

Don't you want the queries to be "outer join" and not "left join"? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: need to upgrade

On Sunday 01 January 2006 6:44 pm, Jon Miller wrote: > I need to upgrade MySQL from a RH7.2 server to either a Suse Enterprise 9.2 > or Debian 3.1 server. I understand that the only way to get the data from > the RH7.2 server is via mysqldump. Are there any gotchas or issues doing > this? all r

need to upgrade

I need to upgrade MySQL from a RH7.2 server to either a Suse Enterprise 9.2 or Debian 3.1 server. I understand that the only way to get the data from the RH7.2 server is via mysqldump. Are there any gotchas or issues doing this? Thanks -- MySQL General Mailing List For list archives: http://

4.1.16-1 RPM's

Not sure if this is a PHP or MySQL issue, but I am having problems re-compiling PHP 5.0.5 after upgrading to the 4.1.16-1 set of MySQL RPM's which were posted on Dec 25, 2005. I previously had version 4.1.16-0 which worked fine. It appears to be a zlib conflict of some sort as I am compiling PHP

REVOKE GRANT OPTION - is that possible?

Hi, I'm currently creating a PHP commandline tool to manage MySQL databases and user privileges easily since the whole thing is way to complex to do it by hand with SQL queries and you have nothing else right after installing the MySQL server on an SSH-only machine where the webserver depends on t

回复： Re: MySQL 4.1.13 and utf-8 lang uage encoding

--- Chenzhou Cui <[EMAIL PROTECTED]>写道: > The character encoding change is a common problem > for Chinese users. I > am a web hosting provider. Just because of the > character set problem, I > kept using MySQL 3.23.58 but not 4.x or 5.x, > although my Linux OS had > been upgraded to the latest ve

Re: Row Count Discrepency

- Original Message - > I have an InnoDB table in a MySQL 4.1.14 database. Can anyone suggest > why MySQL Adminstrator says the table has 497 rows, while doing a query > or a count on the same table shows that it only has 434? > IIRC, InnoDB only gives an estimated row count in admin

Re: GUI (linux X based or web based) for mysql

On 12/31/05, Mechtilde Stehmann <[EMAIL PROTECTED]> wrote: > Hello, > > Dotan Cohen schrieb: > > I keep a lot of personal information in a MySQL database. I have a few > > querys premade for the wife to use, but we have gotten to the point > > where we need a solution for her to be able to run her