| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> Xgc, now there are both '127.0.0.1' and '172.0.0.1' has '1' in 'active'
<0> Xgc, and I need '127.0.0.1' has '1' and '172.0.0.1' has '0'
<1> aibo: I'm really sorry. But I can't keep up with all your changing questions. You just told be they were both really localhost and the 172.0.0.1 was a typo/example.
<0> Xgc, there can be ANY IP addr, just w8
<1> aibo: Now you ask the question again with 172.0.0.1 as though it's supposed to be there.
<1> aibo: Listen closely...
<2> How do I allow local remote acccess?
<1> aibo: UPDATE tbl1 SET col1=1-col1 WHERE col1 IN (0,1) AND addr IN ('127.0.0.1', '172.0.0.1', ...);
<1> aibo: Place whatever list of addresses you wish in the expression in that SQL. If you use the wrong list, that's not my fault.
<0> Xgc, ok, w8
<1> No. I'm not w8'ing.
<2> Guys how can I allow local remote access to mysql server?
<2> I got a database on my server, but I can't access it on my desktop
<1> mezoko: Do not --skip-networking, and set bind-address appropriately. Then set your GRANTS to allow access.
<2> Xgc, huh?
<2> That way to advance for me
<0> Xgc, works perfecly, many thx and sorry for my shouting
<1> mezoko: It's all in the documentation. Save my comments for later, if you don't yet understand them.
<2> Xgc, what would I look up in the docs
<1> aibo: You're welcome.
<1> mezoko: If you aren't sure you probably need to start at the beginning.
<2> Xgc, I don't want to spend all dam day reading a mysql document
<2> I just want to listen to my music, whcih I need to allow remote access from the sql database
<1> mezoko: Then do what I suggested. If you aren't sure about one of the steps, look it up in the docs.
<2> I'm not suing -skipp-networking
<1> mezoko: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
<1> mezoko: http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
<2> ERROR 2003 (HY000): Can't connect to MySQL server on '100.110.0.100' (111)
<2> grr
<3> this is blowing my mind
<1> mezoko: You need to read those links completely.
<2> I don't need to add a user
<1> mezoko: Ok. If you are sure, then skip that one.
<2> Xgc, do I need to put something in hosts.allow?
<1> mezoko: That has nothing to do with mysql. If you've blocked access outside of mysql, you'll need to address that. Sure.
<1> Any firewalls you have running may need to be adjusted.
<1> Again, not a mysql issue.
<2> mysql -h '172.0.0.1', that just hands if it localhost theres not a problem
<4> there is a unique keyword right?
<5> mysql does not support rc4 nativly does it?
<3> who uses rc4?
<4> SELECT * unique(category) FROM table_name
<5> gleam_: i know Rijnndael is better ;)
<3> rc4 isn't hard to implement, you could probably write one :P
<1> mezoko: 172.0.0.1 is not normally considered localhost.
<1> mezoko: Try 127.0.0.1
<1> FatalRemedy: SELECT DISTINCT col1, col2 FROM tbl1;
<1> FatalRemedy: If you want grouping by some columns and aggregates of others, use GROUP BY and aggregate functions.
<2> Xgc, I'm being told I can't connect
<2> same error that I posted above
<2> so mysql is disallowing connectiosn from 127.0.0.1
<1> FatalRemedy: For instance: SELECT name, AVG(age) FROM people GROUP BY name;
<1> mezoko: You've now changed the initial question. Explain exactly what you're attempting, so that I don't have to ***ume new details.
<3> or that he knows what he's doing
<2> Xgc, I want to connect to the server from my desktop
<2> and I'm not being allowed to
<1> mezoko: What server?
<1> mezoko: Where is it?
<2> my home server
<2> it about one foot away from my desktop
<1> mezoko: and you think localhost is routable?
<3> are you seriously using 100.110.0.100 internally?
<1> mezoko: localhost is not routable.
<2> gleam_, yes
<3> lord, why?
<1> mezoko: Don't use 127.0.0.1 for this.
<2> Xgc, ok, I was just trying to follow that link you gave me
<2> I find it
<2> skip-networking is in the sql config
<3> gah
<1> mezoko: I told you to not skip-networking.
<2> Xgc, it was in the config, I thought it was gonna be a startup opition
<2> ERROR 2013 (HY000): Lost connection to MySQL server during query
<2> what does that mean?
<1> mezoko: Remember my first comment?
<3> !m mezoko gone away
<6> mezoko: (MySQL server has gone away) : http://dev.mysql.com/doc/mysql/en/Gone_away.html
<2> well I just restarted mysql
<2> I'm so close
<2> so close but so far away
<1> http://www.loglar.com/song.php?id=2
<2> Xgc, would ya help me fix my problem?
<2> I'm so close
<7> what do I need to do to take only the first substring of a string of my select?
<1> http://www.lovelyrics.com/artists/THE%20CARPENTERS%20lyrics/THE%20CARPENTERS%20CLOSE%20TO%20YOU%20lyrics.php
<7> SELECT nome FROM Membro where cod_membro=".$registros['cod_membro']
<1> Azundris: Define substring. Also look into string function.
<7> is it better to do in php or mysql?
<1> Azundris: Don't ask SQL questions in terms of php or other languages.
<1> Azundris: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
<1> Azundris: SQL isn't really the best tool if you have multiple atoms within a single column value.
<7> Xgc: are you speaking to me?
<1> Azundris: It's probably better to let the external program strip atoms as needed.
<1> Azuos001: Could be.
<8> Lulol
<8> Xgc, Have you been drinking?
<2> Xgc, would you please help me finish this off?
<1> mezoko: Every question has been met with a reasonable answer, so far, right?
<7> colder: how can I tell to mysql that I want only the first substring?
<2> Xgc, I must have missed the last answer
<7> how can I tell to mysql that I want only the first substring?
<2> ERROR 2013 (HY000): Lost connection to MySQL server during query
<1> Azuos001: Define *first substring*
<2> competely not sure what to do, I've been on google to
<1> mezoko: [14:09] <6> mezoko: (MySQL server has gone away) : http://dev.mysql.com/doc/mysql/en/Gone_away.html
<9> how can i fix this error ? /usr/bin/perl: symbol lookup error: /usr/lib/perl5/site_perl/5.8.7/x86_64-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init
<7> I want to take the first name of the name
<2> Xgc, that was helpful :(
<1> mezoko: Based on your question, it was.
<2> Xgc, yes, but I just restarted the mysql service
<2> so it would be very hard for the server to be idle for 8 hours
<1> mezoko: Yes, and after that you didn't ask another/different question.
<9> anyone ?
<2> Xgc, because my current one is solved
<2> I need to fix that problem its th eonly thing thats stopping me
<1> mezoko: Restarting the server is not the end of the problem. Read further.
<1> dragova: There's php documentation that covers adding support for communication with mysql.
<7> I want to take the first name of the name, how can I do it in my select?
<2> well its not a pemrission problme
<9> :/
<2> I"m not using widnows
<1> Azuos001: You have a problem in your data. You shouldn't store first and last name in the same column.
<2> I don't think I'm sending packets that +16MB
<7> Xgc: why?
<2> both the client and the server are runnin gthe same version of sql
<1> Azuos001: It's a basic concept of relational theory having to do with atoms.
<2> hostname looks can't ben a problme because I give the ip
<1> Azuos001: Read about Codd's rules.
<2> Xgc, so I really don't know
<7> Xgc: here in Brazil we do not have problems with name like British or American. We never use surname before first name
<1> mezoko: I'm not sure. It tough to tell from here.
<1> Azuos001: That's not really the issue.
<7> Xgc: I didn't understand the problem so. Even in a bank enviroment they use only one field
<10> ehh ?
<1> Azuos001: If you need to access 'Roberto' as a separate atom from 'Roberto Carlos', you need to store 'Roberto' in a column and 'Carlos' in another column.
<10> those bank environments i have worked with have saved firstname and lastname in separate columns
<7> I see your point
<7> which bank is it Apachez?
<7> where is it from?
<11> heu
<7> you are right Xgc, but only if I will need that, but I wont
<1> Azuos001: Then stop asking for the first substring.
<7> I want it just to say "hello Mr. Xgc, welcome to my system"
<7> that is all
<1> Azuos001: Use concat() for that.
<7> concat will split it?
<1> Azuos001: SELECT CONCAT('Hello Mr. ', 'name') ...
<1> oops
<1> Azuos001: SELECT CONCAT('Hello Mr. ', name) ...
<7> but name will bring all the name
Return to
#mysql
or
Go to some related
logs:
how to downgrade mysql4 gentoo
#debian
freebsd mysqlclient.so
Cannot find word list spl vim gentoo
insertbeforesibling +javascript
#web
hpna usb linux driver ubuntu
rawwritewin xubuntu
uvfat 2.6
#centos
|
|