March 2003 - Developers - lists.phpmyadmin.net

RE: [Phpmyadmin-devel] CREATE TEMPORARY TABLE global priv
by Rabus 25 Mar '03

25 Mar '03

Hi again, -----Original Message----- From: Rabus [mailto:rabus@bugfixes.info] > > Hi Marc & list, > > -----Original Message----- > From: Marc Delisle [mailto:delislma@CollegeSherbrooke.qc.ca] > > > > Alexander, > > > > so, why can a user do USE MYSQL when he has CREATE TEMPORARY TABLES? > > > > Because of a MySQL bug...? > I'm going to report this to MySQL. > My report: http://bugs.mysql.com/179 Let's see, what they'll say about it :-) Alexander M. Turek <alex(a)bugfixes.info> +-----------------------------+ | The phpMyAdmin Project | | http://www.phpmyadmin.net | | rabus(a)users.sourceforge.net | +-----------------------------+ | [bugfixes.info] | | http://www.bugfixes.info | | rabus(a)bugfixes.info | +-----------------------------+

4 8

[Phpmyadmin-devel] 送5M数据库或50M企业邮局啦！
by cmaya 24 Mar '03

24 Mar '03

尊敬的客户，您好：滨州玛雅网络现推出全新定制的高速、稳定的虚拟主机服务：买各款虚拟主机均免费赠送二级域名，不限在线人数，不限流量！购Linux平台主机免费赠送 5M 数据库！购Windows平台主机免费赠送 50M 企业邮箱！并推出半年付、一年付、两年付的付款方式！了解更多产品及服务，请登陆玛雅 http://www.cmaya.com 联系QQ: 394507 4992981 （请勿直接回复此信！）如这封信件打扰了您，请随手删除，谢谢！致礼玛雅网络 service(a)cmaya.com

1 0

RE: [Phpmyadmin-devel] chance for transactions in pma?
by Beck, Mike 24 Mar '03

24 Mar '03

> There is no gaurentee that you'll get the same persistant connection > unfortunetly. If your browser really used HTTP/1.1 keepalive, you'd > stand a better chance of it, but really that is no way to do it. > > can anybody tell me more there? > The only workaround that is possible if we want transaction support in > PMA would be to buffer the queries inside PMA, using our own seperate > table, and then sending them atomically to MySQL on COMMIT or just > dumping them on ROLLBACK. no, i don't think that'd stand a chance - if i have a big table and want to do a updatequery on it and afterwards check if everything looks fine before doing commit or rollback, that'd mean PMA would do a copy of my big table on the heap for as long as it takes me to decide wether i like it? i doubt that any ISP would like that behaviour. but it is kind of sad, to see that here we seem to come to a point where MySQL is offering a useful feature that users will not be able to use with PMA - for usage of transactions i now installed the MySQL Controlcenter here again ;-( cheers Mike Beck

3 2

[Phpmyadmin-devel] chance for transactions in pma?
by Beck, Mike 24 Mar '03

24 Mar '03

obviously, as http is a stateless protocoll you can't just use pma to send the queries begin update ... then do some selects with pma and afterwards do a rollback. but if i set autocommit to false in the mysql serversettings and in the php.ini set php to use persistent connections as default do you think it would work? if that chance exists i'd start thinking if there is any useful way to help using transactions on innodb tables in pma, but i think that even if you use persistent connections these are only persistent within one apache child, so chances are that the connection is lost nevertheless and thus transaction can never work. can anybody tell me more there? regards mike beck

2 1

RE: [Phpmyadmin-devel] CREATE TEMPORARY TABLE global priv
by Beck, Mike 24 Mar '03

24 Mar '03

> >>>so, why can a user do USE MYSQL when he has CREATE > TEMPORARY TABLES? > >>> > Well, after reading their answer, I guess we will have to rely > on something else to set $is_superuser, like selecting records > from mysql.user. > > Marc > well, finally i do have MySQL 4.0.12 on my server here, so i am starting to read the list again. I think MySQLs Behaviour is correct here - you have a global privilege (even if it doesn't give you any useful right), so you have that for all Databases, so you can view it... What i think does not make any sense is that on upgrading from 3.23, when you run their script to update your rights users that didn't have ANY global rights before automatically get a global 'create temporary table' and 'lock tables'. if you remove that two global privileges everything works as we expect it again. so the question is: is that a bug with the upgrade script? regards Mike Beck

1 0

[Phpmyadmin-devel] tonstruction whisper
by Aron Morin 24 Mar '03

24 Mar '03

1 0

[Phpmyadmin-devel] spelgl�dje
by Peter Backman 21 Mar '03

21 Mar '03

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Upp till kamp mot svenska statens spelmonopol! -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Hej phpmyadmin-devel(a)lists.sourceforge.net, Visste du att svenska staten tjänar mer än 4500 miljoner kr varje år på sitt spelmonopol? Allt detta går rakt in i statens ficka! På senare tid har det dykt upp en del alternativa aktörer som erbjuder spel och vadhållning via Internet. Fördelen för dig som spelare blir att du får högre vinster, bättre odds och äkta spelglädje! Idag tipsar vi om nyöppnade: Casino Stockholm -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Casino Stockholm http://www.mallwiz.com%40%48%6F%6D%65%2E%65%61%72%74%68%6C%69%6E%6B%2E%6E%6… - Sveriges första riktiga Internet casino! -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- * Spela online dygnet runt. * 58 olika spel - bl.a. Blackjack, Poker, Roulette, Enarmade Banditer, Tärning, Sic Bo, Keno och spelautomater. * OTROLIGA Progressiva Jackpots - Vinn 2 miljoner på spelautomaterna! * Chatta med andra spelare från hela Sverige och resten av världen. * Spela på skoj med låtsaspengar - träna upp dina färdigheter. Öppningserbjudande: Få $75 i *RIKTIGA* spelmarker i bonus! -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Casino Stockholm http://www.mallwiz.com%40%48%6F%6D%65%2E%65%61%72%74%68%6C%69%6E%6B%2E%6E%6… - Sveriges första riktiga Internet casino! -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- ===================================================================== Detta är ett ideellt utskick från organisationen Stoppa Svenska SpelMonopolet (SSSM). Vi försöker främja en allsidig debatt och tipsar då och då om alternativa spelmöjligheter. Om du inte önskar få information av oss i fortsättningen ber vi dig skicka ett email till sssm.info(a)spray.se och ange "Remove" i ämnesraden. Nästa vecka recenserar vi: Unibet Detta meddelande är en sändning till allmänheten och är därmed grundlagsskyddat enligt YGL. (Jfr SOU 1997:49 sid 170 ff.) Ansvarig utgivare: Peter Backman =====================================================================

1 0

[Phpmyadmin-devel] CREATE TEMPORARY TABLE global priv
by Marc Delisle 21 Mar '03

21 Mar '03

Hi, I just upgraded to MySQL 4.0.12. Someone please explain why a user with CREATE TEMPORARY TABLE is seen by phpMyAdmin as a superuser ($is_superuser is TRUE, this is because USE MYSQL works!) And he sees all databases (but no table). My users got this priv because the had global FILE, I guess. Marc

3 5

[Phpmyadmin-devel] Die offenen Spalten erwarten Dich!
by sandra＠sexnews2.de 21 Mar '03

21 Mar '03

Diese Seite ist fast zu geil um wahr zu sein! Weit gedehnte, feuchte Mösen warten auf Dich! Erlebe Fotzen, die von harten Riesenschwänzen durchbohrt werden und geile heisse Arschlöcher die es so richtig besorgt bekommen! Nur die heissesten und süssesten Girls, mit den nassesten und geilsten Mösen warten auf Dich- eine Seite für echte Kenner und alle, die heisse, feuchte und offene Spalten lieben! Hier ist der Link http://www.moesen.de/index.php?MID=100460&WMID=2797&ml=1 Diese Girls machen einfach alles mit! Nachdem Du geil abgspritzt hast, willst Du der Schlampe noch in den Mund pissen? Dann klicke Dich jetzt zu Pullersex.de, denn hier kannst Du all die geilen Mädels treffen, die auf geile Pissaction stehen! Hier kommst Du hin: http://www.pullersex.de/index.php?MID=100460&WMID=2797&ml=1 Wenn Du diesen Newsletter nicht mehr erhalten möchtest, klicke einfach auf diesen Link: http://www.memberarea.tv/nl.php?adr=phpmyadmin-devel@lists.sourceforge.net E866788

1 0

[Phpmyadmin-devel] bzipped/gzipped upload
by Michal Cihar 20 Mar '03

20 Mar '03

Hi list I'm jist thinking about automatically detecting whether uploaded sql is compressed or not. Do you thing, we can safely remove current checkboxes and keep everything on autodetection or should we keep them as fallback when detection fails? The detection would check first few bytes ("BZh" is start of bzipped data, and 0x1F 0x8B for gzip). Comments wanted :-) -- Regards Michal Cihar nijel at users dot sourceforge dot net http://cihar.liten.cz

3 2