| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Comments:
<0> I have a problem with my mysql installation. I'd like to grant access from one remote host to all databases. I did "GRANT ALL ON *.* TO root@remote_server IDENTIFIED BY 'foobar'". But it seems not to work. MySQL is bound to all interfaces. Any ideas?
<1> !tell us about doesn't work
<2> will_ asked me to tell you this: Look buddy, doesn't work is a strong statement. Does it sit on the couch all day? Does it want more money? Is it on IRC all the time? Please be specific! Give us the FULL EXACT error message. Tell us what it does and/or does not do.
<3> subsonic: also WHERE clauses are generally logic based, ie everything in them is true or false. with that in mind, you can use AND/OR/NOT to perform logical operations on them
<0> I have a problem with my mysql installation. I'd like to grant access from one remote host to all databases. I did "GRANT ALL ON *.* TO root@remote_server IDENTIFIED BY 'foobar'". I get an "Error 1130 (00000): #HY000Host 'remote_host' is not allowed to connect ot this MySQL server" message. MySQL is bound to all interfaces. Any ideas?
<4> shabbs: The turotial site has information about "in" which is impossible for me to find on mysql's site
<3> !man comparison operators
<2> (Comparison Functions and Operators) : http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
<5> Anyone up for a go on my single daemon problem ?
<1> Ox0000, That means the GRANT didn't work.
<0> will_: why?
<1> !m Ox0000 adding new user
<2> Ox0000: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<1> Double check your GRANT against examples there.
<4> shabbs: thanks
<0> ok
<5> ! T-Start finetuning mysql
<5> !m T-Start finetuning mysql
<2> T-Start: Nothing found
<1> What is your problem?
<5> i'm using mysql 4.1.11, before i was using 4.0.3.I have just copied my tuned my.cnf from my old machine but mysql handles differently. It IS using my configuration since the innodb database is initialized but now i am already recieving too many connections. Max connections is set on 500 wich was fine before.. But i see in my processes that only 1 daemon is running and before this was i think 8
<1> MySQL only uses one process, and spawns multiple threads.
<5> Indeed.. i mean threads, thread_concurrency is set on 8 in my.cnf
<4> I'm using the "in" end get error "Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE) for operation ' IN '"
<0> will_: I double checked it... still no success
<5> hm.. but i just checked and 'show variables' does not contain the variable thread_concurrency :-|
<5> i'll check..
<4> does that mean the table was set up bad?
<6> it means your connection collation and table collation are different, probably
<7> not to be critical, but the search implementation for the docs is terrible.
<4> that's way over my head
<3> yeah, it is
<7> search '"alter table" syntax'
<1> Ox0000, What is the exact query you are sending to MySQL?
<7> and that actual page doesnt even show on the first page of results.
<0> will_: i'm trying with mysql -u root -p -h host
<1> Ox0000, What is the exact GRANT you are sending to MySQL?
<0> ah
<1> The host name is host?
<0> GRANT ALL PRIVILEGES ON *.* TO 'root'@'host IDENTIFIED BY 'test' WITH GRANT OPTION;
<0> will_: i'm on host with hostname 'host', the remote server is 'remote_server'
<1> You're missing a '
<0> this is because i replaced the host
<0> sorry
<7> heh, table of contents/mozilla's find works better than the search engine.
<0> will_: any ideas?
<4> Man, I had the query right from the beginning, but mysql query browser's giving me that collation error when using IN
<4> I could have saved myself an hour if I used the command line
<3> jdolan: indeed, or google with site:dev.mysql.com
<1> Ox0000, What is the exact GRANT you are sending to MySQL?
<1> EXACT word for word.
<1> No changing of anything.
<0> will_: ok
<1> Copy and paste :)
<4> I think php's got the best search
<0> GRANT ALL PRIVILEGES ON *.* TO 'root'@'s1.realizeweb.ch' IDENTIFIED BY 'test' WITH GRANT OPTION;
<4> php.com's
<8> yeah... I think one of the reasons php's become so popular _is_ because php docs are so easy to browse and find
<3> Ox0000: chances are your hostname isn't being resolved correctly
<0> shabbs: i'll try with ip
<1> Ox0000, Looks fine to me...
<1> Yeah, try what shabbs said :P
<0> ok works =)
<0> thanks a lot
<9> codefriend: I'll second that one
<1> I'll first it.
<9> PHP has some of the best online documentation EVER for a FLOSS product
<9> and with sites like PHPBuilder and the like to teach people to use it
<1> phpfreaks!
<10> no mater what i type in mysqld -v or mysql -vvv i can't get the very verbose display
<1> They are insane.
<5> winn2, how about mysqld --verbose ?
<10> i figured this would show me the options selected at compile time, however nothing bt the version nfo shows
<10> unknown
<10> i am trying to start innodb support, and the docs said by v4 it was compiled by default, however when i turn on innodb support i get an error
<3> winn2: show variables like 'have_innodb';
<3> though that'll just tell you if it's on :/
<1> shabbs, SHOW VARIABLES LIKE 'have_will';
<1> See if that's turned on...
<3> +---------------+--------------+
<3> | Variable_name | Value |
<3> +---------------+--------------+
<3> | have_will | from_behind |
<3> +---------------+--------------+
<3> 1 row in set (0.00 sec)
<3> indeed
<10> thanks i appreciate that
<7> lol
<10> and no it was not selected at compile time :(
<7> winn2, my distro configures mysql with --without-innodb :/
<7> perhaps yours does too.
<7> winn2, it's not terribly hard to build yourself, or to download official binaries.
<11> Is there any easy way I can duplicate a row in a table, where the key is an auto-incremented value, so that the duplicate is the same as the source row except that the id is a new id?
<12> For query "SELECT alpha FROM table WHERE alpha = 'something' AND bravo = 'something else' ORDER BY charlie, delta LIMIT 10", would MySQL be able to use an index on (alpha, bravo, charlie delta)? IE: Two for the WHERE clause, would it be able to use the last two for the order by/limit?
<7> jak, sure
<7> insert into my_table select null, this, that, and_the_other_thing from my_table;
<7> throw a where clause in there too ;)
<11> jdolan, ah right, so you have to select all the fields manually
<7> off the top of my head yes..
<7> that doesn't qualify as hard, does it? =)
<7> (just verbose..)
<13> please somebody help me
<13> http://metamorfozis.hu/p/why.png
<13> the query and the result is here
<11> what would be really cool is something like SELECT * - id
<13> why the heck equal the count() fields?
<13> the count(TTOPICS) == 14
<13> but the other?
<3> jak: that's called being lazy :D
<14> any one help me with mysql cluster ?
<11> yes indeed
<7> jak, i agree.
<7> or of column names supported true regexps or sh style wildcards.
<13> noidea?:((
<14> no one can help me
<14> :(
<13> detto
<7> L|NUX, as l33t is your name is, you've not asked a real question yet.
<14> well
<14> bro
<14> i have configure cluster
<14> and it connected to nodes
<13> jdolan: i do it.... but no one checked, i think:(
<14> how can i test it ?
<7> L|NUX, that's rather vague, but i would think the documentation covers basic installation and testing.
<13> please somebody help me, the query and the result is here: http://metamorfozis.hu/p/why.png why the count()-s equal? in the first line, the count(TTOPICS.id) is 14, but the other? why?
<14> humm
<7> MetaMorfoziS, count(distinct col)
<7> instead of just count(col)
<3> !man join syntax
<2> (JOIN Syntax) : http://dev.mysql.com/doc/mysql/en/JOIN.html
<13> it's distinct
<13> or what you think?
<13> morf_lines.id instead of TLINES.id?
<15> Hello, I'm getting permission denied messages when attempt to connect a 4.1 database (which was just upgraded from version 3.23). If this user is missing: "EXECUTE, CREATE ROUTINE, ALTER ROUTINE" rights would it matter? I'm trying to use a perl script to connect to the database using the DBD:mysql module.
<13> no, morf_groups.id instead TGR.id?
<13> ok i try
<13> #1109 - Unknown table 'morf_groups' in field list
<3> Dforge: did you upgrade the priv tables?
<16> Can anyone comment on the maximum theoretical clients MySQL can support under Linux? For example, I have max clients set to 2500 right now - what if I set it to 15000 - is there a limit that anyone knows of besides just the system?
<15> shabbs: It was upgraded from RHEL 3.x to RHEL 4.x. I'm not sure if the person who upgraded the box did anything special.
<3> Dforge: can you connect from the command line?
<15> shabbs: yes.
<3> Dforge: can you show me the exact error you get?
<15> DBD::mysql::st execute failed: Access denied for user 'webgui'@'localhost' to database 'WebGUI' at ../lib/WebGUI/SQL.pm
<15> This is from the perl code I'm using to connect.
<15> I've double checked that line and it appears to be using the proper database,user and p***word.
<3> but 'mysql -uwebgui -p WebGui' works?
<15> yes.
<3> hrm
Return to
#mysql
or
Go to some related
logs:
#oe
#linux
ubuntu firmware-extractor
#web
#math
ubuntu minicom com1
QUOKE3
fedora disk limit
#lisp
#gaim
|
|
