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 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 *-
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 (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: 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]
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 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 http://dev.mysql.com/doc/refman/5.0/en/grant.html 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]
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 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]
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://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 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]
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: 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 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--
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]
回复: 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: REVOKE GRANT OPTION - is that possible?
How can I revoke a GRANT OPTION on a database or table from a user? The manual http://dev.mysql.com/doc/refman/5.0/en/grant.html 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]