| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Comments:
<0> !m beerdeliveryguy reset root
<1> beerdeliveryguy: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<2> how to config mysql on IIS
<2> I use Mysql 5.0
<3> why dose mysql say "No Database Selected" if I do more then a couple requests quickly?
<4> dancingmonkey: You need to select [USE] a database first.
<4> dancingmonkey: Be specific. What *exactly* did you do to duplicate this behavior?
<5> because you type like a *drunken* monkey?
<5> dancingmonkey - probably, some of those queries explicitely list a database (database . table . row) and the one that fails does not
<6> Hello all!
<6> I just found a case in 5.0.18 where a value returning "1" in a select doesn't evaluate to true in a where clause.
<6> !!column
<3> USE sadtler_op; SELECT * FROM bins WHERE location='2'
<3> Warning: mysql_fetch_***oc(): supplied argument is not a valid MySQL result resource in /home/sadtler/public_html/neatpleat/bins/Edit.php on line 86
<4> dancingmonkey: That has nothing to do with your original question.
<5> that's a php issue
<3> Xgc, is the query correct?
<5> you can only send one query per call in the php mysql api
<4> dancingmonkey: Probably not.
<5> it would work from the mysql shell
<5> ..it's a php problem
<5> not related to MySQL
<7> anyway to recover a forgotten root p***word for MYSQL
<8> another ever tried to access a mysql database running on a server from a pocketpc with windows CE 5.0?
<7> anyway but not shotting down the server
<7> shutting
<4> beerdeliveryguy: Just reset it.
<7> how can I reset it
<9> does mysql have anything like GROUP CONCAT?
<5> you already got the link
<4> ilia: GROUP_CONCAT(...)
<10> !man group by functions
<1> (GROUP BY (Aggregate) Functions) : http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html
<5> !m beerdeliveryguy reset p***word
<1> beerdeliveryguy: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<7> thanks.
<9> ah ty :)
<8> another ever tried to access a mysql database running on a server from a pocketpc with windows CE 5.0?
<7> Xgc: would that mess up any data or any tables I already have?
<4> beerdeliveryguy: No.
<6> EagertoLearn : You're being over-eager. We saw your question the first time.
<8> sorry
<6> EagertoLearn : No answer usually means no-one knows. Like with my double-!-question. :)
<6> EagertoLearn : As for PocketPC, that could be nice. Are you developing yourself? Have you simply tried building the client library?
<6> simply tried even
<6> Argh tried simply.. :)
<3> Thank you for the help, that USE was the biggest help since sleep!
<11> how do I right "and" in mysql? Easy one I know.
<6> !!1=1 but !!2!=1 in where..
<6> Hmm.
<6> I guess the where optimizer just strips off my two !s.
<6> !!1=1 but !!2=2
<7> isnt there like any written files anywhere containing the information for the root p***word?
<12> beerdeliveryguy: no not usuially.
<7> shiottt
<13> hi there
<12> !m reset p***word
<1> reset: (Access Control, Stage 1: Connection Verification) : http://dev.mysql.com/doc/mysql/en/Connection_access.html
<12> !m beerdeliveryguy reset p***word
<1> beerdeliveryguy: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<7> i tried /var/lib/mysql/mysql/user.MYD
<7> and those files
<7> but its all like: e3g45g9845ht934y9t3
<5> you are going to destroy your database
<7> eep
<7> i won't do it anymore then
<5> geez, they encrypt it? shocking...
<5> btw, changing that wouldn't change the p***word until the server was restarted anyway
<5> if you can find the server memory map, you could update it there
<5> :) good luck
<7> hm.
<6> Use a socket proxy.
<7> thing is, I dont want to restart the server without knowing exactly how it is started up
<7> cause they probably use some diff syntax to start it
<5> dude.
<14> hi
<6> Perhaps you can work on getting the syntax. Otherwise the socket proxy could work.
<5> ask them
<5> ? how CareBear\
<13> how can i join 2 tables to replace an collum ?
<13> table1.text <- Table2.text
<15> !tell ^Willie^ about joins
<1> Alrighty.
<6> Make special MySQL server that proxies queries to all tables other than the mysql database to the original server. It also depends on the amount of available time and whether the application has one persistant connection or opens several. I believe the latter is more common though.
<5> um
<5> but he doesn't have the p***word
<13> inviso i did read the MySQL 3.23, 4.0, 4.1 Reference Manual
<6> He does have access to the server.
<13> my point is i get 2 col`s with the same name
<13> in phpmyadmin
<6> sjrussel : May be easier to go for the memory map though! :)
<5> are you suggesting running a separate instance on the same data dir?
<5> that would work but would be a terrible idea
<6> No, proxy.
<5> a proxy still needs to communicate with the existing server, so it's locked to the permissions of the person creating the proxy
<6> Cl***ic MITM..
<6> Not if you only proxy whatever isn't for the mysql database.
<5> the backend db still wouldn't give you the permissions
<6> It doesn't have to..
<5> ?
<7> so I did ps aux | grep mysql
<7> and it shows the runnign comand if i do that same one it will start mysql fine right?
<5> if you're proxying, you're p***ing the data to the backend server
<6> sjrussel : Uh, wait, maybe I thought that out wrong.
<6> sjrussel :p
<5> it's ok. You can to that with lots of things. but I don't think it works yere
<6> All you'll get is the p***word used for the connection..
<6> No, right.
<5> beerdeliveryguy - clearly, you don't have the right information; you're trying to hack something you shouldn't be
<5> talk to the person who does
<6> By far easiest solution! :)
<5> CareBear - running a separate instance with the same data dir and skip-external-locks would work
<5> but it would leave you open to horrible corruption
<6> sjrussel : Yes, problems when writing.
<5> you could mount a different mysql database before starting the second instance
<5> :)
<16> Trying to rewrite a query, to avoid a dependent subquery. The query is available for review at http://hashmysql.org/1507
<6> Would work for read-only, but corrupt data is no fun.
<5> it's actually an interesting scaling solution in some cases - live slaves read-only on a mounted data dir
<5> yeah
<17> !man encryptions
<1> Nothing found.
<17> er
<17> !man encryption
<1> (Encryption Functions) : http://dev.mysql.com/doc/mysql/en/Encryption_functions.html
<17> hmm
<18> Hi guys.
<18> Anyone have a mo to help with a fairly simple Select Statement from Microsoft Access SQL...?
<18> http://pastebin.com/581047
<18> [Order Details] = Table with orders in it
<18> [Orders] is a form and I need to obtain the forms current record id that is being presented.
<18> For some reason MS Access is unable to gain focus on the form's OrderID field.
<19> Oh, I thought this was #mysql
<18> Mmmm...
<18> Nice.
<18> So, as I was saying.
<18> I know it's a relatively simple task in MySQL but the database has already been written in MS Access mate.
<18> Could you take a look for me please...?
<18> http://pastebin.com/581047
<19> Gain focus?
<18> Yeah.
<18> it's a VBA thing.
<19> No idea...
<19> Go to #vba
<7> what would my.p***wd in /etc/mysql do?
<18> Basically, there's a form displayed with an Order ID field and tha value of that field should be picked up by the query's WHERE statement but it is displaying a dialog asking for the OrderID
<18> Sorry, didn't know there was a VBA channel open.
<18> I can't see it mate
<20> hi! i could need some tips here : i have a server with LAMP. whenever mysql gets pre***ured, it collapses, it dies, so i have to restart it. could anyone have any idea? thinking maybe freebsd och a bad scsi-drive might be a prob?
Return to
#mysql
or
Go to some related
logs:
#gentoo
#web
#ubuntu
installing freeciv ubuntu
malformatted suse chmod
#python
junoscript cygwin cpan
Genkernel -all ERROR: Failed to compile
#gentoo
linux renich
|
|