IRC Logs

Network: freenode Channel: #mysql

	Enter your search terms Submit search form
	Web www.irclog.org

[20:51]<jygrjx>the host is localhost, how could I connect remotely?
[20:53]<jygrjx>anyone here?
[20:54]<jspzdgzjg>JinRoh: yes
[20:54]<jspzdgzjg>sometimes you have to wait more than one minute for people to speak
[20:54]<dugsggvzyg2>JinRoh: err, "the host is localhost"?...
[20:54]<jygrjx>yes, mmm
[20:54]<jygrjx>the host is a website
[20:54]<jygrjx>jinroh.org
[20:55]<jygrjx>and the host is localhost
[20:55]<jygrjx>how can I remote connect?
[20:55]<jygrjx>I don't have phpadmin
[20:55]<dugsggvzyg2>JinRoh: please explain what you are actually trying to do. Waht you are saying does not make much sense...
[20:55]<jygrjx>-_-
[20:56]<jygrjx>I want to remotelly connect to my mysql server, but I only have this info: Database Host: localhost database name : ... database user: ... database password: etc
[20:56]<jygrjx>I don't have phpmyadmin
[20:56]<dugsggvzyg2>so.. the database is on the web server
[20:56]<jygrjx>yes
[20:56]<dugsggvzyg2>and you ant to access the database directly, from your home box
[20:56]<dugsggvzyg2>is that right?
[20:56]<jygrjx>yes
[20:57]<dugsggvzyg2>well, in theory, isstall the mysql client and use it to connect to the database at the webserver (using the hostname jinroh.org).
[20:58]<dugsggvzyg2>but in practice, this is unlikey to work
[20:58]<jygrjx>so how can I get it to work?
[20:58]<dugsggvzyg2>the database server should not be accessible directly from the "wild" internet - that's dangerous.
[20:58]<dugsggvzyg2>well, the simplest thing would be to install phpmyadmin on your website.
[20:59]<dugsggvzyg2>you can access that with your browser
[20:59]<dugsggvzyg2>alternatively, install the mysql client and use an ssh-tunnel to connect to the databse.
[20:59]<dugsggvzyg2>that requires ssh-access to the webserver, and a little bit of networking knowledge
[21:00]<dugsggvzyg2>and an ssh client, obviously
[21:00]<jygrjx>mysql-client
[21:00]<jygrjx>I have installed it
[21:00]<dugsggvzyg2>basically... ask your hosting people what solution they would prefer. or is that your own box?
[21:00]<jygrjx>how to use it?
[21:00]<jygrjx>how can I run it?
[21:00]<jygrjx>mysql-client doesn't work
[21:01]<dugsggvzyg2>mysql -h <host> -u <user> -p <database>
[21:01]<dugsggvzyg2>host would be jinroh.org - if the database is accessible from the web, which it's probably not
[21:02]<jygrjx>ERROR 2003 (HY000): Can't connect to MySQL server
[21:02]<dugsggvzyg2>right
[21:02]<jygrjx>:'(
[21:02]<dugsggvzyg2>it does nto accept connection from the wild internet
[21:02]<dugsggvzyg2>as it should
[21:02]<dugsggvzyg2>well, as it shouldn't :)
[21:03]<jygrjx>so what can i do
[21:03]<dugsggvzyg2>as i said: either use a web interface to the database (i.e. use phpmyadmin)
[21:03]<dugsggvzyg2>or set up an ssh-tunnel (if you have ssh access)
[21:03]<dugsggvzyg2>if you set up an ssh-tunnel on port 8899, the command would be:
[21:03]<dugsggvzyg2>mysql -h localhost -P 8899 -u <user> -p <database>
[21:04]<jygrjx>ok thx I will try
[21:06]<zzzzsn>do you how to use 'union' for return a standar value when select fails?
[21:07]<dugsggvzyg2>err?
[21:08]<jspzdgzjg>you could use coalesce() to provide a default value for a column if it's returned null
[21:08]<dyac_fyguw>arrase, pseudocode: something like a if(select returns 0 rows) { return defsult value } ?
[21:09]<dyac_fyguw>so that i understand your question better
[21:10]<zzzzsn>example: if SELECT password FROM users WHERE name='arrase' fails because 'arrase' is not in users table return 'nobody'
[21:10]<zzzzsn>better? :)
[21:12]<dyac_fyguw>i'd say try a subselect + COALESCE()
[21:12]<jspzdgzjg>I'd say do it in the application
[21:13]<dyac_fyguw>that would work too :)
[21:13]<jspzdgzjg>you're trying to return a magic value, It hink you'd be best off actually returning a failure and let the business logic handle how it wants to ratehr than having to decode that "nobody" means it failed rather than "nobody" is the user's password
[21:14]<zzzzsn>i can't use COALESCE, is a restriction
[21:14]<jspzdgzjg>huh?
[21:14]<zzzzsn>osfameron : yes
[21:14]<jspzdgzjg>arrase: restriction because a) it's a school exercise or b) there are good technical reasons or c) some fool decidede you can't use coalesce out of superstition?
[21:15]<fsdyvx>:)
[21:15]<zzzzsn>a
[21:15]<zzzzsn>:)
[21:15]<dugsggvzyg2>arrase: it'S a trick question then :) the answer is "don't, it's stupid" :P
[21:15]<fsdyvx>then use CASE or IF ;)
[21:16]<dugsggvzyg2>hm... for something completely different:
[21:16]<dugsggvzyg2>is there a good plugin for handling recursive structures?
[21:17]<jspzdgzjg>if you really want a union, maybe it's stupid thing like: select foo from ( select password from blah UNION select "nobody") limit 1; ?
[21:17]<dugsggvzyg2>like, if there's a record for A,B and one for B,C, "simulate" a record A,C?
[21:21]<sugsxdgnlrmd>Hello
[21:30]<dyac_fyguw>anyone know why MySQL AB uses a Windows/Mac proprietary player for presentations? I want to view this: http://www.mysql.com/news-and-events/on-demand-webinars/mysql-performance-tuning.php
[21:31]<dyac_fyguw>but guess what my problem is ;-)
[21:32]<dyac_fyguw>is there an "open format" version of that presentation? (mpg, avi, ogg, flak, xvid.... hell pdf would work for me at this point)
[21:32]<jspzdgzjg>what format is it in?
[21:32]<dyac_fyguw>wfm
[21:33]<dyac_fyguw>.wfm
[21:33]<dyac_fyguw>or something like that
[21:33]<jspzdgzjg>does ffmpeg convert that?
[21:33]<dugsggvzyg2>wmf, perhaps?
[21:33]<dyac_fyguw>.wrf sorry
[21:33]<dyac_fyguw>http://www.webex.com/lp/player/download.html
[21:34]<dyac_fyguw>osfameron, i doubt
[21:34]<dyac_fyguw>hmm, connection issue at work... odd
[21:34]<dyac_fyguw>Duesentrieb, if it was wmf then i could run it ;)
[21:35]<dugsggvzyg2>yea...
[21:36]<dugsggvzyg2>mick_linux: wfm -> dBASE Form Designer Form Object, according to http://filext.com/detaillist.php?extdetail=WFM
[21:36]<jspzdgzjg>"However, WebEx has committed to releasing recorded webinar viewers for Linux and Solaris in their next product release, Meeting Center 7.0. We encourage users to contact WebEx technical support to register their interest in support for additional platforms"
[21:36]<dyac_fyguw>ah it was zelezney (or whatever that server is)
[21:36]<dugsggvzyg2>so... take it up with dbase ;)
[21:37]<dyac_fyguw>wrf :-P
[21:37]<dyac_fyguw>to me... "wfm" still means "works for me" :-P
[21:49]<muzznz>Hi all. Does anyone have an opinion of the best way of using bitfield values in mysql? I read bad things here --- http://www.xaprb.com/blog/2006/04/11/bit-values-in-mysql/ --- and wondered if there was a bette approach
[21:53]<xra>Duesentrieb: The SQL specification contains support for hierarchical constructs. MySQL doesn't. There has been a fair amount of research on the subject.
[21:56]<xra>Duesentrieb: If you look into it, you might find there are methods of storing that type of data that allow you to obtain the information you need, without using a linked list approach.
[22:09]<zzzjgczdf2nff>I'm having some issues with LIKE vs MATCH that I don't understand: http://hashmysql.org/paste/viewentry.php?id=1834
[22:11]<zzzjgczdf2nff>I have a single column FULLTEXT index that is being used for the MATCH, but it's still slower than like. Also, MATCH returns way fewer records. Any ideas why?

Back to #mysql
Or go to some related logs:
#gentoo
#gentoo
#gentoo
#gentoo
#gentoo