| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> I wrote a simple taxonomy database with a small php script
<1> makin sure installation is done
<0> there's the sakila database
<2> weasel00: http://downloads.mysql.com/archives.php
<3> so.. how else would i create/edit databases (w/o that php script that has my pw in it)
<0> well php script is pretty safe because it never shows in the browser
<2> unless your webmaster is incompetent.
<0> but for creating a database, straight sql file
<3> right.. but if you went to mydown.com\mysql.php .. you'd be presented with a form that you can send sql queries
<3> mydomain*
<4> infi
<4> infi: would they be with the debug's?
<2> I don't know, look and see.
<0> stedios, I'm confused too
<0> php scripts only send the queries they're written to send
<3> ok, but this php script shows a web form that you can enter any query in
<3> and when you visit it, it connects/logs you in as root
<0> well of course it'd be wide open
<3> :0
<3> figured so
<3> and this book is using this method ..
<0> so that's not a good example of a secure page
<3> how else do i enter sql queries then (don't say php scripts ;0 , i mean.. i can sit there and create a database, cmd line?)
<3> bobfield: not by a long sho
<3> t*
<0> the mysql program will let you
<0> it can get tedious so I write scripts
<0> pipe them in or use the source command
<0> not to so I don't do a lot ad hoc
<0> but I'm almost certain not to get a database right the first time
<0> so I will be dropping it and recreating it ad inifinitum
<0> edit the script, tweak the definitions
<3> so there is no where to go , to just do. "show databases"
<3> i have to write a php script to do it..
<0> $query="show databases";
<0> $result=mysql_query($query);
<0> something like that?
<0> 'have to' -- is this like homework?
<3> no
<0> okay just checking
<3> i just dont' see why its necesary to have to write a php script to just do one thing ;0
<0> I don't either
<0> unless it's too involved for some other method
<3> like what this webform that the book had me create, i can enter a query in the box.. submit it, and then return back and put the next command (maybe check to make sure the table was created as intented)
<0> like I wrote a php script to create a million tables for a test
<3> but its not very secure
<0> I never bought a book
<3> http://pastebin.com/574407 ->run it, you'll see what i mean
<3> bobfield: pdf
<0> I would never put that script on my web server
<0> not even behind a firewall
<3> yea.. not secure. we established that one ;)
<0> however I have a number of php scripts that do include logon credentials but control the database interaction so it is secure
<0> i.e. you have p***words, cookies, etc.
<3> right
<0> ip logging, blacklisting
<0> whole 9 yards
<0> plus you can set up a less privileged account just for your php scripts to use
<0> carefully tailor what access you grant
<0> phpmyadmin proves it can be done
<3> gr, the mysql.exe doesn't work to well.. 'show database' and it goes to .. ->
<0> but not my cup of tea
<0> needs a semi-coon
<0> semi-colon ':'
<0> ';' even
<3> ; you mean :)
<3> hehe
<3> ah thx
<0> :P
<3> this is what iw as looking for :)
<3> how do i get out of " ->" if i accidenty get there..
<0> the mysql> prompt has pretty all the functionality anyone could want
<0> type a ; usually
<3> ah ok
<0> there's also the '> prompt if you've an open quote
<0> command line is best if you ask me
<0> I've been doing it for many years
<3> well, i think its a good way to get started.. you really understand it better this way ;0 then letting 'mysql admin' do things for you.. kinda like using a site builder
<3> i hate that
<0> only thing I use mysqladmin for is abnormal shutting down
<0> all else is mysql or php or some API
<3> welli think creating a db is better with cmd line.. you can do it one step at a time , rather write a large php script
<3> or at least it appears taht way to me atm
<0> like I said I write a sql script, start with drop database if exists
<0> go right on from there
<2> stedios: this might be of interest to you: http://dev.mysql.com/downloads/query-browser/1.1.html
<0> certainly I can't tell anyone what works best for them
<0> only what works best for me
<3> infi: nice
<0> how do you do that colon thing?
<0> (irc question)
<2> what colon thing?
<3> bobfield: ? that?
<3> what?
<0> yes that
<3> type my name.. than a :
<3> then a space
<3> ;0
<3> or part of my name, and tab it then a :
<3> like.. "bob <tab> colin message"
<2> it's client specific.
<3> bobfield: test
<0> it puts a comma when I tab
<0> stedios: test
<0> that work?
<3> i always did it manualy.. just typed name:
<3> did what work? yes i saw it? :)
<0> so apparently it's been working when I typed it manually before
<0> ok
<0> just wondering
<3> i don't get an alert or anything..
<3> i just see.. stedios:
<0> is it in red?
<3> no
<3> that part is client specific
<3> mirc , kinda.. blows . and i'm to lazy to set it up
<0> when you type my name and a colon like that it highlights
<0> I'm using x-chat
<0> didn't have to set up a thing
<3> yea, x-chat does that. tho i think even if i said your name, bobfield , it lights up ?
<0> yup anywhere on the line
<3> i noticed wheni used gentoo /e16 ;0 i decided then mirc ****ed
<0> I used mirc along time back on windows
<0> I haven't gotten into the bells&whistles accessories
<0> I'm with Scotty: "The more they over-think the plumbing, the easier it is to stop up the drain"
<3> me iether, but its prettier than cmd
<0> I can get pretty with even a small amount of php if I want
<0> like custom coloring each tile of a table
<0> based on field values
<3> custom color each field dependent on value
<0> I use elvis which is good at highlighting sql keywords
<0> I could probably write my own sql command line interface
<0> add my own custom pretty-ups
<0> from what I gather it's fairly 'thin' as clients go
<0> mysql program that is
<0> the power is in the simplicity sometimes
<3> i'd like syntax autocomplet
<0> that would be nice
<0> language-sensitive editing
<0> the APIs make it wide open for customizing
<0> okay another irc question, how do I do the 'asterisk' thing?
<5> SHIFT + 8 ?
<6> hi guys
<5> hey psykick
<6> is there any way of speeding up this stored proc: http://pastebin.ca/43319
Return to
#mysql
or
Go to some related
logs:
gentoo xmms alternative
#fedora
#css
tetrinet hangs
#perl
#perl
glib-1.2.10 ubuntu
xorg .xession
livina repository fedora rpm
ubuntu undelete
|
|