| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> Hello!
<0> Anyone have time for a quick question?
<1> Nope
<1> That was a pretty quick question.
<0> Well I'll ask anyway :) I am having troubles connecting to mySQL instance from a remote machine
<1> Too late. You only asked for one question and you already used it.
<2> also, your text is blue
<3> i see it as green
<2> well, my terminal is crap
<0> its black in mine
<3> red stop, green go...away.
<3> lol i r make teh funny
<1> MystaMax, What is the error message?
<0> could not connect to the specified instance, FYI, I'm attempting to use MySQL Administrator GUI App
<1> Exact error?
<4> ewww, reminds me of the old CGA days
<5> mmm colours arnt good
<5> to much like out side
<5> out side bad
<4> there is an outside?
<4> outside of what?
<0> word for word it states, "Could not connect to the specified instance. MySQL Error Number 2003 Can't connect to mySQL server from "MYIPADDRESS"
<0> I can connect from shell, but not from a remote machine
<0> using the MySQL GUI App
<6> somehow, i'm under the impression that your text is colored
<4> shell (most likely) is localhost (127.0.0.1) and GUI app is going to be a remote IP
<0> thats right linuxkrn
<6> !m MystaMax grant
<7> MystaMax: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<0> Ok thanks guys, I'm off to read.. brb thanks again
<4> pls, change your text color while you're at it
<4> ewww
<6> (:
<8> hi there. i do not want to know an exact way for the solution, just the technique i have to use would be enough. i have one table named foo with say "id, team1_id, team2_id, some , more, field" and another table foo2 with "id, teamname, some, more, fields" now I enter several teams and several foo's, and I want the teamnames to be showd as team1-id and team2_id
<0> i tried but it wont stay linuxkrn :9
<4> get a better chat program?
<0> hold on i know why
<1> MystaMax, Linux?
<1> I don't care about the colors. Let's fix your server first :P
<0> will, yes it is a ubuntu linux
<1> !tell us about debian
<7> will_ asked me to tell you this: To access a MySQL server remotely on Debian, see http://www.livejournal.com/users/arjen_lentz/11410.html
<1> Check that out/
<9> !m nk_ SELECT
<7> nk_: (SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/SELECT.html
<10> guys
<10> whats a good book to learn sql
<0> SQL, I checked out that document navigated to that /etc/mysql directory and opened up my.cnf
<11> book ?
<11> is there something wrong with the manual ?
<10> hard to read/learn from
<0> but, there isn't a line to comment out
<0> If I wanted to allow remote connections from a particular address, including localhost, can I just add IP's to bind-address?
<12> is it posisble to set the host in the user table to *
<1> MystaMax, No, don't bind.
<0> will, ok
<12> or something that matches both local host and any remote host?
<1> MystaMax, Use a firewall and use GRANT
<0> ok
<1> I prefer to bind to 127.0.0.1 and use SSH TUNNEL to get in
<6> will_: that doesn't work to well for websites :)
<1> Why not?
<11> is the best way to do it will
<11> of course it does jink
<1> I usually have MySQL on the localhost of the server though, but I don't see why it wouldn't work
<6> andrewbryson: sure, perl/php/... sets up your ssh tunnel and queries the database? :)
<1> No, admin does that, not PHP
<11> you could easily make perl set up an ssh tunnel
<1> PHP just looks at 127.0.0.1
<11> not sure about php since it seems a little limited
<0> ha
<1> MySQL is written in PHP!
<12> how can I allow mysql access to a particular user to any host or localhost?
<11> LOL suuuuuuuuuuuuuuuure
<4> why do you need perl for a ssh tunnel? It takes one command?
<11> you don't need perl for it
<1> !m kib adding new user
<7> kib: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<11> i was just saying that it would be easy to make perl execute that command :P
<1> LinuxKrn, But you COULD
<13> anyone know if fulltext indexing is being worked on for NDB engine?
<1> That would be nice.
<0> ok, is it 'bad' to use the root user account? do you normally create another account from the get go?
<14> MySQL is not written in PHP will_, up to 5.0 was written in SmallTalk but since 5.1 they went with JUMBO
<14> that's why 5.1 is sooo big
<12> ok I tried that
<12> when when I sue username@'%' you cant login via localhost
<12> so how does one make an entry tthat works on both localhost and a remote host?
<6> kib: % is pretty much any host, but i prefer using two grants. one for localhost, one for the remote ip
<12> but % wont allow login from localhost
<12> is it possible to allow from both?
<6> afaik not in 1 grant
<12> I need to find a way to do this with only one p***word
<6> use the same p***word for both :)
<12> because the problem is when people change their p***word on one login it doesnt change on the other
<9> now now, that's too simple
<12> people have to update p***words twice using two methods to login with
<9> don't give them permission to change their p***words, then
<12> sjrussel: thats not good
<9> neither is giving them permission to do so
<12> we actually want to force them to update p***words every 6 months
<1> M3, Whatever you want to believe.
<12> using the smae p***word for too long leads to problems
<14> r u at work will_?
<1> Yes
<1> Are you?
<14> no, still on vacation at home
<12> so any ideas how to do this?
<9> kib, but afaik it's not possible to restrict p***word changes to a single account?
<6> i think i gave you a fair answer, it's up to you to decide on what to do
<14> will_, that's why u r serious
<9> kib - write a service that does it
<12> sjrussel: know any programmers?
<12> that work cheap
<9> heh
<1> kib, You can do that at the application level
<1> I wonder if a SP can do it
<12> will_: for righ tnow mysql is the only application level
<12> its used for various purposes
<1> They access the DB directly? EEK!
<9> ??
<12> but we dont control what its being used for specificlly
<9> kib, your service doesn't make any sense
<9> just fyi
<12> will_: they access via localhost socket or port 3306
<9> are you selling mysql as an ASP?
<12> sjrussel: what I want is to have just one login not two for each user
<12> so when things like p***word changes or permission to dbs change it only has to be done once
<12> note mutiple times
<9> kib, that's horribly insecure
<9> just fyi
<4> so create a table, update it everytime someone's p***word changes, after 6 mos, go in and change p***words for accounts, have a webpage they can goto and enter their old p***word and then new one
<12> sjrussel: who is one acocunt less secure then two?
<12> seems two accounts would be more insecure
<9> that's not the insecure part
<12> besides each user have very specific permissions on table and db levels
<9> the insecure part is them being able to access the permissions db
<12> sometimes limited right down to certain fields
<12> another reason why its better not to have to make two logins for everyone
<9> ???
<12> its seriously impossible to manage well by hand
<9> then write a program to do it
<12> sjrussel: only root has access to the db table
<12> sjrussel: then can you suggest a programmer who works cheap?
<12> if not I need a way to make mysql do it naturally
Return to
#mysql
or
Go to some related
logs:
perl open pipe ls *
ugandians
mounting root /tftpboot
#php
#ati
#perl
intel_piix module
ubuntu gparted freed space
emule wmv can't play
unmasking hardmasked
|
|