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