| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> RHEL3 is fun ;)
<0> And 4 doesn't even bother to install on a large number of dell poweredge boxes. I had to sacrifice one of our abundant local squirrels to get it to install
<1> BartVB, awesome man :-) I thought I was gonna have to write a php script to strtoupper each one!
<2> mysql is pretty flexible when it comes to (not extremely complex) manipulation of your data
<1> how about alpha numeric only? no punctuation and such
<3> hi guys
<3> question, can i use MySQL server on differnet Linux machine?
<4> -h host
<3> anybody answer?
<4> Dr-Linux: -h host
<1> Dr-Linux, yes you can, as long as it has remote connections enabled
<3> infi: what do you mean by -h host? :S
<4> change your connection string to include the host in $your_programming_language, or use -h host with the CLI client.
<3> BoBB: actually i have 2 server both are identical, one is ready with everything, the other server is very critical, so i wanna use same Mysql database for 2nd serer as well
<1> just set whatever piece of software you have to connect to that servers IP address instead of localhost
<3> BoBB: great. and what other things will be changed?
<1> that should be all you need to change to connect to a seperate server, unless it runs on a seperate port, but if they are identical like you say that should be it
<1> you may also need to go into the my.cnf and enable remote connections
<3> hhm..
<3> BoBB: where is my.cnf?
<3> location
<3> let me check
<1> depends, generally its in /etc/mysql, but it could be anywhere depending on the system you are running
<3> ok
<3> let me see
<3> BoBB: its here >> cd /etc/my.cnf
<1> there you go
<3> BoBB: do i need edit this file on mysql server machine or non-mysql ?
<1> whichever run the server you are trying to connect to is on
<3> BoBB: but this file is empty? :S
<3> [root@I2C-PBX root]# locate my.cnf
<3> /etc/my.cnfcopy
<3> /etc/my.cnf.rpmsave
<5> Hi, I am using mysql via TCP (do not use socket raw), but to connect I need to use this mysql -h 127.0.0.1 -u root, it's possible to say 'do not use socket raw' and connect only via -u root ? any idea?
<1> Dr-Linux, it souds like your my.cnf is either non-existent or located somewhere else
<6> myuo: p*** it -P 3306
<7> blargh.
<3> BoBB: i have many servers, should i copy this file from anywhere else to this? :S
<5> /opt/mysql/bin/mysql -u root -P 3306 -p
<5> Enter p***word:
<5> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
<5> same error, is mandatory for my use -h 127.0.0.1 why?
<1> Dr-Linux, no idea, i believe network connections is on by default ... I would just try it first
<1> Dr-Linux, from the command line, mysql -h ip.add.re.ss -u <user> -p
<5> Juzzy any idea?
<0> myuo: mysql --help gives --protocol. Take a look.
<3> BoBB: you mean from here?
<3> mysql>
<1> Dr-Linux, no, from a terminal command line on a server other than the one you want to connect to
<5> the problem is not on the protocol, I need to use -h 127.0.0.1 and works, my question is why?
<5> /opt/mysql/bin/mysql -u root -P 3306 -p
<5> Enter p***word:
<5> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
<5> ireth:~# /opt/mysql/bin/mysql -u root -P 3306 -p -h 127.0.0.1
<5> Enter p***word:
<5> Welcome to the MySQL monitor. Commands end with ; or \g.
<3> hhm... okey let me try :S
<5> you know?
<8> myuo: try using a pastebin next time instead of flooding the channel
<5> ok
<0> myuo: It connected? What is the problem exactly?
<5> sorry
<8> myuo: your problem is is that the socket isn't configured correctly for the client
<5> why do I need to use -h 127.0.0.1? it's possible to use it in my.cfn or something like this?
<7> Anyone have any tips and/or tricks for improving performance under Cluster? My queries are extremely slow, many times slower than running the same queries on a standalone MySQL server. I'm not able to identify where I may have misconfigured something.
<5> I use TCP, so, what's the way to say do not use socket?
<8> inviso myuo: mysql --help gives --protocol. Take a look.
<5> shabbs> I don't understand you, sorry
<8> myuo: don't understand me, understand inviso, he told you the answer already
<1> is there a mysql function to select data out of a database and not include any non-alphaumeric characters, or a way to replace a particular list of strings with nothing?
<5> :(
<5> so, what is the way to say under my.cnf do not use socket ?
<3> BoBB: i'm getting this error
<3> Enter p***word:
<3> ERROR 1130: #HY000Host '70.89.66.123' is not allowed to connect to this MySQL server
<9> fix your socket its faster
<1> Dr-Linux, that means that that server is not accepting outside network connection
<4> BoBB: incorrect.
<5> but I use mysql under chroot, so php cannot find it
<4> Dr-Linux: you need to grant that user@host access to the database.
<3> :S
<4> !m dr-linux grant
<10> dr-linux: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<7> Huh. Is there such thing as a multi-multi-multi-master replication setup or something like that?
<1> Dr-Linux, ahh yes, infi is correct, each user has a specific host it is allowed to connect from
<4> Dr-Linux: it *is* in fact, listening to outside connections (which really isn't a good idea to leave unfiltered). however, you need to add a host entry for that user@host.
<3> :S
<3> can you guys help me to add a user and database for this connection?
<4> !m dr-linux grant
<10> dr-linux: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<0> !m Dr-Linux adding users
<10> Dr-Linux: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<0> both links are helpful
<3> actullay english is not my native lanugae so i don't understand good web guides :(
<0> !m BoBB REPLACE
<10> BoBB: (REPLACE Syntax) : http://dev.mysql.com/doc/mysql/en/REPLACE.html
<0> !m BoBB string functions
<5> host=127.0.0.1 using this fix the problem :)
<10> BoBB: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<3> :S
<0> BoBB: ignore the first link. search for replace in the second link
<4> dr-linux: thankfully, the docs are in multiple languages!
<1> thanks guys, read through the strings page twice and didn't see the replace, been a loooong day =/
<0> BoBB: it's not a great solution, but it doesn't appear we have something like translate :(
<1> well, my boss told me he needed it to do that about a week after they started entering data into the database, quick and dirty is about all I can do now heh
<0> BoBB: if it's just for cleanup, go for it. Otherwise, I think performance will be a bit... lacking.. if you have a large translation table
<7> is there a way that I can be show a list of the most frequently used queries, statements, etc etc?
<4> danq: log them.
<7> --log= ?
<1> inviso, what i'm thinking is modify the script to not allow those characters, and then use this query to go through and select and replace each value already in there
<0> danq: Not that I'm aware of. You can get long running ones or a log of all queries. No summaries really though
<0> BoBB: sounds like a good plan
<7> aholmes, ok.
<1> inviso, i'm confused though, how does one use SELECT REPLACE('www.mysql.com', 'w', 'Ww'); to perform that on a value being selected from a database?
<0> BoBB: note that you can do, update table set col=replace(replace(replace(col, 'a', '1'), 'b', '2'), 'c', '3') if you want to translate all 'a' into '1', 'b' into '2', etc. You can nest it as deep as you need for a cleanup like this
<7> Last_query_cost | 10.499000
<7> Anyone care to elaborate on that one more than what the manual already does?
<0> BoBB: you'd use update rather than select
<1> so pull them all out, and foreach value update REPLACE('$value', 'uwnanted character', '')
<4> danq: that means you owe MySQL AB 10.49 Euros for the last query.
<7> Excellent.
<3> BoBB: i have added user, how can i see the users list?
<0> BoBB: nope. Don't even bother pulling them into php
<4> actually, e10.50, that would round up.
<3> and also how can i add database? :S
<0> Dr-Linux: select * from mysql.user;
<0> !m Dr-Linux create database
<10> Dr-Linux: (CREATE DATABASE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html
<0> Dr-Linux: please do a little searching on your own or read the tutorial
<4> dr-linux: read a tutorial, please.
<3> oo yes it's there and added
<3> ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client
<3> :(
<1> inviso, how do I refer to it's own string when doing an update?
<0> BoBB: your cleanup is seriously just a single sql statement. UPDATE some_table SET col=REPLACE(REPLACE(col, '#', ''), '!', ''); That's given that # and ! are illegal characters and should be "removed"
<3> may be it can be soloved by changing p***word :S
<0> !m Dr-Linux old client
<10> Dr-Linux: (Client does not support authentication protocol) : http://dev.mysql.com/doc/mysql/en/Old_client.html
<1> inviso, wow, thats spanktastic!
<0> BoBB: yup. Just don't figure on running that alot :)
<7> So if I run an ALTER TABLE query against a database to add a field as an index, can I expect a new index to be created using existing data, or will this only work for data which has been added AFTER I ran the ALTER TABLE query?
<5> invisio, socket is much faster than tcp ?
<5> unix socket
<0> myuo: yes
<11> I backed up my databases with mysqldump
<3> !m Dr-Linux how to create tables
<10> Dr-Linux: Nothing found
<11> i need to put them in another mysql server, but it says "unknown databases soandso"
<5> inviso: If I use tcp on localhost is bad idea?
<3> :S
Return to
#mysql
or
Go to some related
logs:
#fluxbox
#lisp
ai tictactoe mxm programming
#css
#lisp
suse 10.0 miniboot
how to use chpasswd
gentoo Q.A. ECLASS 'libtool' inherited illegally
#sdl
#bash
|
|