#mysql
10 October 2007
Total 18 pages. You are browsing page 5/18.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
10:29 <****> Biolante, will it be needed to set all connects, even from the local server to the IP the Server listens on? Or is it still possible to connect to the localhost
10:39 <****> Biolante, is still doesnt work right.
10:40 <****> I changed now the host field in the mysql table to %
10:40 <****> and did set the IP address to listen to in the my.cnf, what else might there be needed?
10:43 <****> squitta: can you connect local mysql console the server using this account?
10:43 <****> to the*
10:45 <****> you mean if I am able to use the mysql command shell?
10:45 <****> yes I can
10:45 <****> yes, are you able to connect locally to the server
10:45 <****> and you cannot connect from remote machine?
10:45 <****> Okay you mean if one if my scripts can connect to the server, lets see
10:46 <****> Urgleflogue, yes, from local its possible to connect
10:46 <****> squitta: does running mysql -u dbUser -pdbPassword locally connects to the server?
10:46 <****> then it might be firewall related problem
10:47 <****> does executing: telnet mysql_server_ip 3306 connects to the server ?
10:47 <****> Urgleflogue, yes i can connect, but I cant remember to have installed a firewall anywhere
10:47 <****> from the remote machine
10:48 <****> squitta: winXP ?
10:48 <****> no linux
10:49 <****> what flavor?
10:49 <****> gentoo
10:49 <****> this is not mysql related I guess so if you'd like come private.
10:50 <****> Telnet says just unknown host
10:50 <****> maybe I did set the ip address wrong
10:50 <****> probably
10:51 <****> telnet 85.123.123.123:3306
10:51 <****> is that right?
10:51 <****> no
10:51 <****> oh, I see :))
10:51 <****> telnet 85.123.123.123 3306
10:51 <****> I am not using tellnet very often
10:52 <****> Escape character is '^]'.
10:52 <****> 8
10:52 <****> 5.0.44-log?PU8Z;W#I,?!('-Kr|;NVGAProot
10:52 <****> d handshakeConnection closed by foreign host.
10:52 <****> looks really weirred
10:53 <****> it connects
10:53 <****> yes, it seems so
10:54 <****> But the website doesnt
10:58 <****> is there a remote connection allow parameter in the mysql user table, I oversaw?
11:00 <****> user host field
11:01 <****> squitta: do you have mysql console on the remote(client) machine?
11:02 <****> yes
11:02 <****> try connecting to the server with this user/pass and see what (if) error pops up
11:02 <****> GRANT ALL PRIVILEGES TO 12312412 IDENTIFIED BY '12445';
11:02 <****> what is missing here?
11:03 <****> host
11:03 <****> I do not think user can start with a number
11:03 <****> but I am not sure about that
11:03 <****> no my username I am using on my host is not starting with a number
11:03 <****> and host too, as Biolante said - GRANT ALL PRIVILEGES TO 12312412'@%' IDENTIFIED BY '12445'; or something like that
11:04 <****> GRANT ALL PRIVILEGES *.* TO 12312412 IDENTIFIED BY '12445';
11:04 <****> GRANT ALL PRIVILEGES ON *.* TO 12312412 IDENTIFIED BY '12445';
11:04 <****> This was right now
11:04 <****> 'username'@'domain_or_ip'
11:04 <****> otherwise its localhost
11:05 <****> using % as domain is not very secure
11:05 <****> Biolante: sure.
11:07 <****> !help create table
11:17 <****> What is wrong with this query? (Unkown column) http://rafb.net/p/K1mTMQ85.html. Can't I use alias names in the where clause ?
11:18 <****> what error you got?
11:18 <****> ah. i see
11:19 <****> `a2f_agent_id` - may be a2f.agent_id ?
11:19 <****> MarcWeber, nope you can't
11:22 <****> MarcWeber, see http://dev.mysql.com/doc/refman/5.0/en/problems-with-alias.html
11:23 <****> what the.......
11:23 <****> no aliases in where?????
11:24 <****> right
11:24 <****> SELECT * FROM `Files` AS f WHERE f.Filesize < 9999999
11:24 <****> how this working then?
11:25 <****> this is not a column alias
11:25 <****> ah... me dumb, lol
11:25 <****> MarcWeber: use having instead
11:34 <****> Greetz. How do I name the row containing table names ? SHOW TABLES FROM `ordbogen_log_v3` I was thinking of SHOW TABLES AS `name` FROM `ordbogen_log_v3` but that dosn't work
11:35 <****> Jemt: you can't AFAIK.
11:35 <****> Oh, ok. Thanks
11:35 <****> you could select them from the infomration schema
11:39 <****> hi, how can i sort an table alhpabeticly?
11:39 <****> ... order by `column` ASC (or DESC)
11:46 * karmazilla wonder what it would take to get something added to the SQL standard
11:48 <****> karmazilla, a time maschine!
11:49 <****> :)
11:52 * karmazilla files a Jira for a time machine
11:54 * vizzy pushes a big red button which says: "bootstrap universe"
11:55 <****> I don't get it
11:55 <****> this query is working okay
11:56 <****> SELECT * FROM ipb43_forums f LEFT JOIN ipb43_moderators m ON (f.id=m.forum_id) ORDER BY f.position
11:56 <****> when I try to run
11:56 <****> SELECT * FROM ipb43_forums f, ipb43_categories c LEFT JOIN ipb43_moderators m ON (f.id=m.forum_id) ORDER BY f.position
11:56 <****> it says #1054 - Unknown column 'f.id' in 'on clause'
11:56 <****> (mysql 5.0.45-log)
11:57 <****> how can that be ?
11:58 <****> vizzy: select price as vatted_price, price - vat as price, (price - vat)*0.1 as revenue from inventory given vat = price * 0.2; # 'given' clause would be useful methinks
11:58 <****> kon: Yes, that could be the solution. Thanks :)
12:00 <****> someone can lend me a hand with grant problems?
12:03 <****> nobody? :S
12:05 <****> GRANT SELECT ON `testdata\_%`.* TO 'vstest'@'localhost' identified by 'something' <--basically this should give select permission to every table that starts with testdata_, and it does. But if i add another privilege lets say "grant create view on `testdata\_2`.* to 'vstest'@'localhost';", this database will not be selectable anymore?
12:06 <****> grant priv_type1, priv_type2, ...
12:07 <****> so i must add all privileges at one command?
12:07 <****> i guess so when using grant
Total 18 pages. You are browsing page 5/18.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last