Re: REVOKE GRANT OPTION - is that possible?

[Dan Fulbright]

> 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 seems,
> not on a certain database or table. Trying to use this query
> 
> REVOKE ALL PRIVILEGES, GRANT OPTION ON `test`.* FROM 'test'@'localhost'
> 
> fails with the error message
> 
> You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'ON `test`.* FROM 'test'@'localhost'' at line 1

It works as two separate queries:

REVOKE ALL PRIVILEGES ON `test`.* FROM 'test'@'localhost';
REVOKE GRANT OPTION ON `test`.* FROM 'test'@'localhost';

-- 
Dan Fulbright

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

回复： 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 company has upgraded mySQL
to 4.1.13 and now all varchars are shown incorrectly (
all collation attribute are set as latin_swidish_ci
now" ).. the phpMyAdmin verson is 2.6.4-pl2. my site
is at http://www.cnads.org/. 

Can anyone tell me how to fix this?

Thanks
Li






__
赶快注册雅虎超大容量免费邮箱?
http://cn.mail.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]




__
赶快注册雅虎超大容量免费邮箱?
http://cn.mail.yahoo.com

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

[mos]

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 rows in tables.


Mike  



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Row Count Discrepency

[William Allaire]

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 doing a query or
> a count on the same table shows that it only has 434?
> 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

[Hank]

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

[John in Pueblo]

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 right, basically, what you just said was the equivalent of "I want to 
upgrade my Office 1997 to Windows XP".  Don't you mean you need to transfer 
your dbs from one server to another.
-- 
Dr. Joseph Dolan: Isn't there a children's book about an elephant named Babar? 
Fletch: I don't know. I don't have any. 
Dr. Joseph Dolan: No children? 
Fletch: No, elephant books.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

need to upgrade

[Jon Miller]

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://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.1.16-1 RPM's

[Ryan]

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 with '--with-mysqli=/usr/bin/mysql_config' and '--with=zlib'.
After I install MySQL-devel-4.1.16-1.glibc23.i386.rpm, during the PHP
compilation process, I get the error:

grep: /usr/lib/mysql/libz.la: No such file or directory
/bin/sed: can't read /usr/lib/mysql/libz.la: No such file or directory
libtool: link: `/usr/lib/mysql/libz.la' is not a valid libtool archive

I also tried the MySQL-devel-standard-4.1.16-1.rhel3.i386.rpm package and
with that, I get errors:

/usr/lib/mysql/libz.a(adler32.o)(.text+0x0): In function `adler32':
: multiple definition of `adler32'
/usr/lib/mysql/libz.a(adler32.o)(.text+0x0): first defined here
/usr/lib/mysql/libz.a(adler32.o)(.text+0x250): In function
`adler32_combine':
: multiple definition of `adler32_combine'
/usr/lib/mysql/libz.a(adler32.o)(.text+0x250): first defined here
/usr/lib/mysql/libz.a(compress.o)(.text+0x0): In function `compress2':
: multiple definition of `compress2'
/usr/lib/mysql/libz.a(compress.o)(.text+0x0): first defined here
...

Did something change in the 4.1.16-1 RPM's in regards to zlib?  As I
mentioned above, 4.1.16-0 worked fine.

Thanks,
Ryan



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

REVOKE GRANT OPTION - is that possible?

[Yves Goergen]

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 the database. So I'm close to finished now, but there's one
major point that seems to be impossible or at least undocumented:

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 seems,
not on a certain database or table. Trying to use this query

REVOKE ALL PRIVILEGES, GRANT OPTION ON `test`.* FROM 'test'@'localhost'

fails with the error message

You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'ON `test`.* FROM 'test'@'localhost'' at line 1

I could of course modify the relevant part of the mysql.db table myself
but I felt this important task should be possible the standard way just
as I can grant the GRANT OPTION directly on a database or table.

PS: The whole thing must be compatible with MySQL 4.0 through 5.0.

-- 
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
"Does the movement of the trees make the wind blow?"
http://newsboard.unclassified.de - Unclassified NewsBoard Forum

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

回复： 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 version.
> 
> 
> Lizhou wrote:
> 

> 
> -- 
>

> Chenzhou Cui (China-VO Project)
> National Astronomical Observatory | Tel:
> (8610)64841695
> Chinese Academy of Sciences   | FAX:
> (8610)64878240
> Datun Road 20A, Chaoyang District | Email:
> [EMAIL PROTECTED]
> Beijing 100012, China | WWW:
> www.lamost.org/~cb
>

> 
> 
> 

;-(,anyone else out there get Simplified Chinese in
utf-8 encoding working with MySQL 4.1.13 or newer? It
was all fine with MySQL 4.0 series for more than 1
year.

http://www.cnads.org/

thanks.


__
赶快注册雅虎超大容量免费邮箱?
http://cn.mail.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Row Count Discrepency

[Terry Riley]

- 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 (or SQLyog or 
whatever), not an actual count, because of the way it does (or doesn't) 
store row information.

MyISAM tables, on the other hand, show accurately because they store the 
rowcount as part of the table data.

Terry

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

[Dotan Cohen]

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 own queries.
> > She is NOT about to learn SQL, and myPHPadmin is a little too
> > compicated. I looked at an Access installation the other day and it
> > seemed to be just what we need- a GUI for non-programmers to use a
> > database. Is there any such beast for MySQL? Anthing that will run on
> > Fedora Core 4 would be great. Or even a web-based solution would be
> > fine- I do have apache on localhost.
>
> You can use OpenOffice.org 2.0 via ODBC or JDBC and you can use a GUI
> nearly like Access under Linux.
>
> Mechtilde

Thanks. I was directed earlier to Base as an option. While it works,
it is very complicated for the non-techie, so what I did was write a
few simple php scripts for common queries and we run that in firefox.
As I already run apache on the machine, this was not much trouble.
Another plus is that the querys are available on the other machine on
the home network- we just surf to the machine's IP address.

Dotan Cohen
http://technology-sleuth.com/question/why_are_internet_greeting_cards_dangerous.html
*-