| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> you want adminguy@% then
<1> evaded: sorry... I was away -- http://dev.mysql.com/doc/refman/5.0/en/news.html
<1> UncleD: get rid of the " 's
<1> andrewbryson: table.* is correct.
<1> er... sorry db.* is correct.
<0> TodoInTX: yup but adminguy@* is not unless that has been changed :P
<1> sorry. you are right.
<1> it's getting late here...
<2> TODO
<2> mysql> GRANT ALL ON *.* TO adminguy@* IDENTIFIED BY 'adminp***word';
<2> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* IDENTIFIED BY 'adminp***word'' at line 1
<2> so how do I fix the adminguy@* problem?
<2> what could i use as an alternative
<0> UncleD: you mean apart from adminguy@% ?
<1> use adminguy@% not adminguy@*
<2> mysql> GRANT ALL ON *.* TO adminguy@% IDENTIFIED BY 'adminp***word';
<2> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '% IDENTIFIED BY 'adminp***word'' at line 1
<1> the host '%' should be in single quotes.
<0> do you still need to have the host and username in single quotes ?
<2> yay it worked :)
<0> lol apparently so :P
<1> when you use %'s
<3> TodoInTX: Thanx for the link ;-)
<0> so only if there is a wildcard ?
<1> yes, it appears so.
<0> cool - i learned something :P
<3> I need to come a bit more here :-) So if i know more, i can also help the other
<1> hehe... I thought I was pretty good with MySQL then started to talk to lots of others in here (some mysql employees) that schooled my from time to time.
<1> I
<1> I've gotten better since hanging out here.
<2> TodoInTX: you've helped me quite a bit too :)
<0> heh
<2> for which i am forever grateful
<2> although i'll be bugging you soon!
<1> brb
<4> I have a table with 2 field, name and value, is there any syntax for mysql to select every row wich values is in an array or something, like "SELECT name, value FROM mytable WHERE name in (onename, anothername, etc ...)" ?
<5> I want to remove every record in each table i have in my database and set autonumber again to 1 of each table
<5> How can i do it..? is there some single query which does it
<5> ?
<0> Lepidosteus: just put onename, anothername, etc in ' :P
<4> andrewbryson: sorry, could you write a sample line ? i don't get it
<0> SELECT name, value FROM mytable WHERE name IN ('onename', 'anothername', 'etc')
<4> thanks
<1> preetish: use "truncate table tablename"
<5> TodoInTX, Cannot truncate table 'Products' because it is being referenced by a FOREIGN KEY constraint.
<5> This is what it says
<0> preetish: well you have to do it in the right order
<5> k
<0> does mysql support recursive stored procedures yet ?
<0> cos that is an easy way to deal with foreign keys in such situations :P
<0> i really need to read the manual one of these days :P
<1> Not sure what you mean by a "recursive stored proc." so read up and let us know -- http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html
<0> i mean a stored procedure that can call itself
<1> I saw something about that somewhere once.
<6> How can I test to see if any rows are returned by a query?
<7> mysql_num_rows :p
<7> client dependant...
<1> andrewbryson: not sure if mysql can thought.
<0> TodoInTX: i am sure it will eventually :P
<6> SpComb: Thanks. I'm using the mysqli version by the way.
<6> I just did --> if(!msyqli->query($sql) <-- thinking it would skip if no results were returned, but it isn't working
<1> that test to see if a result was recieved or not. the result is zero rows long so it will be true.
<8> hi guys has anyone had any experience setting up mysql using replication to do ha?
<1> peqe: not sure about the syntax but it might be something like if(mysqli->mysql_num_rows(query($sql)) > 0 )
<6> TodoInTX: Thanks. I'm just trying this one: if(!$mysqli->query($sql) && mysqli_num_rows($result))
<1> madbull: yes, I have.
<1> I use heartbeat, mon (and sometimes DRBD).
<9> Is there a way to set max_connections to an infinite amount? (MySQL 4.0) ... would setting it to 0 or -1 have that effect?
<0> well do you have a server with infinite resources ?
<10> hi
<10> I have on my box mysql from fedora core 3, I think 3 or 4 it is as version
<9> andrewbryson, yes.
<10> in another box I have mysql 5
<10> I am using mysql -p -h10.0.0.79 -v <--- do you watch this switch?
<0> taec: how much do you want for it ?
<10> I am getting always error can't connect
<9> I'm benchmarking MySQL and I want to set max_connections to some infentisimal amount so it isn't the limiting factor. It's not an unreasonable request.
<10> but I don't see any sort of explanation of errors about why...
<10> I mean the -v switch seems useless
<10> is it because I am using mysql lower version in fedora?
<11> is there a way to stop MATCH() AGAINST () ignoring words that occur too often?
<10> 3.23.8 version is in fedora
<0> that is a pretty old version
<11> I can see a way to do it by recompiling, is that really necessary?
<10> ????
<10> anyone?
<10> neither openoffice connects too
<12> Hi everyone, im looking for a bit of first time support, can i pm someone, or can someone please direct me to a good resource for first-timers. i have read through the website but it is all going over my head. googling my issue has not helped either
<0> perhaps if you mentioned what the issue actually is...
<0> lol or just leave :P
<8> todointx, mon and heartbeat hu
<8> hmmm i've written some scripts of my own to do the mon bit
<1> madbull: so what's your question exactly?
<8> TodoInTX, well i'm using freeradius with mysql backend, i've got a primary and backup radius server with sql1 and sql2 servers
<8> i'm just about got my head round the replication stuff
<8> and i'm worried about the case when sql1 fails and radius servers look at sql2
<1> ok and sql2 is a read-only slave ?
<8> when sql1 comes backup having it out of synch
<8> sql2 is a read only slave correct
<8> but it must become master when sql1 goes down
<8> i've read the replication faq and have the commands to do that stuff
<1> well, if you're dealing with only two boxes you could cross-replicate.
<8> hmmm
<1> have both machines setup as master for the other.
<8> i see
<8> that is probably the easiest
<8> thing to do
<1> and direct your writes to an IP that you float between them base on who the master is defined as.
<8> TodoInTX, so i will need a script to monitor whether sql1 is up
<1> I like heartbeat/mon for that so it can trigger fail-overs on it's own.
<8> and when/if it goes down
<8> actually
<1> in this scenario you don't need to fail the configuration back either.
<8> TodoInTX, in my radius setups i have radius look at sql1 and if down go to sql2
<8> so do i really need the floating ip?
<1> you really want some sort of mechanism in place to keep writes from going to both at the same time.
<8> right
<8> this stuff makes my hed hurt
<1> I don't know enough about radius to say.
<8> another thing is that these are hosted on soekris hardware
<8> embedded boxes with flash as storage
<8> now if i want to write accounting data from radius that could potentially be a write every 10secs
<8> i'm worried about flash lifetimes and trying to think of ways to ease the load on the flash filing sysems
<8> ?
<1> I see.
<8> TodoInTX, run the cross replication idea by me again please
<1> two machines, equal in dignity, in fair datacenter we set our play...
<1> ok... so basically we have two boxes that are both setup with binlog enabled.
<1> then you set each server up as master/slave of the other.
<1> if you trust radius to only write to one db at a time then you can stop there.
<8> ok so they both push updates to each other and are constantly replicating from each other
<8> TodoInTX, i trust radius to write to only
<8> on
<8> e
<8> except when one goes down
<8> then it will look at the backup one
<8> and then when the first one comes backup
<8> because its setup as slave/master to the other
<8> it won't matter that now radius is looking at the first one?
<8> right?
<7> sallee
<1> when the first comes back it will sync using the replication.
<8> yep
<8> thats kind of what i'm after actaully
<8> what are the gotchas?
<1> then the radius should look at it. but you really should have the data synced before you send traffic back to the first.
<8> so lock on them
<1> that's where heartbeat controling a floating IP (vIP) makes it nice.
<1> by having the vIP failed to the second radius will not be able to send traffic to the first at all untill you say so.
<13> SpComb: ?
<1> madbull: can you confiure radius to only switch servers when the one it's connected to goes down?
Return to
#mysql
or
Go to some related
logs:
python+load postscript
unresponsive TI-83
+maildrop glibc detected free
freedoss
unable to unrar access denied
dpkg reconf xorg
#python
uml rootfs etch
libsdl spdif
kuroo eix
|
|