| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> ok
<1> exactly. standard issue.
<0> thanks
<2> what is wrong with that (grant all privileges on *.* to 'root'@g4.lan identified by 'test';)
<2> the syntax is ok but still nothing to acces
<1> le_mackeux: can g4.lan be looked up by the server if there's an incoming connection from that IP address?
<1> le_mackeux: mysql does not possess a crystal ball ;-)
<1> it needs to be able to do a reverseDNS looking
<1> lookup
<2> yes it does resolv nicely
<3> shouldnt 'test' be between p***word() ?
<3> brackets.
<1> frank-: no
<1> le_mackeux: so, check the general log (do turn it on ;-)
<1> le_mackeux: and also feel free to, at any point, actually tell us the exact error you're getting.
<4> sorry to bother you all... I'm trying to get the (correctly utf-8 encoded) data from one table into another and absolutely *cannot* make the contents of a varchar field come out other than in garbage characters. any pointers?
<1> genghis: SET NAMES. but do read the mysql manual sections on charsets
<5> i have two tables, a and b, a has 'id' and b has'parent_id' as unique keys...i need to select all the fields from a and some fields from b, where b's parent_id = a's id, in a singe statement...can it be done? my attemots either return nothing, or the row from a but with data from be which exists in a row with a different parent_id...can anyone help? I'm just learning mysql :)
<2> arjenAU: the server log? it's already on and there is no error
<1> le_mackeux: you do realise you are asking for a step by step handholding. how about you learn on your own? get a good book, use a tutorial, whatever.
<1> "help" is not "have someone else tell me step by step exactly what to do". it's not the same.
<2> ya that's what i'm doign for the last 2 days
<6> switch to Access, it's easier.
<2> doesn't run on linux
<2> and it ****s
<4> arjenAU: yeah, that's having no effect. I've explicitly set charsets on both databases and am doing "select into outfile"/"load data infile". is it the client?
<0> umm ACESS???? did i really just see that
<2> lol
<1> genghis: I suggest you re-read my response
<0> i dont know about you buy my goal in life is 10 concurrent users!
<2> infi suggess access cuz i'm still more then a noob with mysql ;)
<0> tis ok
<0> did you learn to drive in a bumper car?
<0> or a car
<6> indolent: i am suggesting it to him because GRANT ... is the FIRST thing you have to do when managing an RDBMS, and if it's taken him 2 days with that, and he still can't get it right without a step-by-step, personalized tutorial for his exact situation, he's got a dark future.
<0> mysql is easy enough.. and SQL is SQL for mst uses
<6> s/an RDBMS/mysql/
<5> i have two tables, a and b, a has 'id' and b has'parent_id' as unique keys...i need to select all the fields from a and some fields from b, where b's parent_id = a's id, in a singe statement...can it be done? my attemots either return nothing, or the row from a but with data from be which exists in a row with a different parent_id...can anyone help? I'm just learning mysql :)
<7> Hi
<8> good afternoon :)
<7> Please i need help
<7> I can't create database with p***word because i get this
<7> mysqladmin: connect to server at 'localhost' failed
<9> AlejandroG: is the server running?
<10> is there a way to phrase something like this: select field1, sum(field2) as total_field2 from table where total_field2 > threshold group by field1?
<7> jtacy, Of course 3306/tcp open mysql
<7> 19619 pts/1 S 0:01 /usr/sbin/mysqld --bas ...
<7> I need create database but i can't :-(
<7> Because i get this message
<7> :-(
<9> bizarre
<7> mysqladmin -u root -p create drupal
<7> ->> Enter p***word:
<7> mysqladmin: ->> connect to server at 'localhost' failed
<7> ->> error: 'Access denied for user: 'root@localhost' (Using p***word: YES)'
<3> try to reset your root p***word
<9> oh, that's not so bizarre...check the pw
<7> frank-, of mysql or of my session?
<3> mysql
<7> frank-, How i reset the p***word :-(?
<3> !m AlejandroG reset root p***word
<11> AlejandroG: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<8> ok: my turn - I'm trying to get master/slave replication working over SSL (using MySQL 4.1)
<7> Ok i got to reset p***word and next all must be good?
<3> try to log in after you reest it
<8> I've set up the replicator user on the master server, and when the GRANT entry doesn't have REQUIRE SSL enabled, it's working fine
<7> cat /var/log/mysql.err
<7> i the file is empy
<8> but when I add REQUIRE SSL, it gives me Error connecting to master: access denied errors
<7> But i don't want use p***word i must use pasword?
<7> p***word*
<3> you want to use a root p***word, yes
<8> i've made SSL certs/keys for both machines, but the docs are very vague about which options to set where in my.cnf
<3> no root p***word is quite insecure.
<7> frank-, Ok. Thanks. Hey my logs don't have anything i reset my p***word of the root?
<7> OHH no i reset the p***wordand now i don't can do nothing with mysql
<7> now i want to come in the console of mysql and i get this mysql
<7> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using p***word: NO)
<6> hint: (using p***word: NO)
<3> -p
<8> I have 'ssl' 'ssl-ca' 'ssl-cert' and 'ssl-key' in the [mysqld] section of my.cnf on the master....
<8> and the same on the slave, under the [client] section, using a different cert for the client
<12> AlejandroG: you did not specify the p***word (using p***word: NO)
<7> lokus, Ohh thanks is true
<7> I want install phpfusion but the configuration is ni the browser and is a problem
<7> Only ask me: Database Hostname:, Database Username:, , Database P***word:, Database Name: Table Prefix:
<7> And i don't see where put the p***word of root
<8> and I can connect: mysql --ssl -h dbmaster.domain.com -u replicator -p
<8> when SSL is enabled
<8> so I'm thinking I need to use the 'master-ssl', 'master-ssl-cert' etc etc options in my.cnf.... but do these need to be in the master, or slave's my.cnf file, under which section should they go, and which certificate do they need to be pointing to?
<8> anyone got any ideas?
<13> odbc fr MySQL 5.0.18
<13> ?
<14> !m ColdeOne myodbc
<11> ColdeOne: (MySQL ODBC Support) : http://dev.mysql.com/doc/mysql/en/ODBC_Connector.html
<13> thx
<15> if I'm reading the docs correctly, I can have 10 parallel processes using the same 'name' temp table and they won't collide, right?
<16> helo room.. can i ask for help here :-C
<1> virgomoon: the # 10 is irrelevant. any number. a temp table is local to the session/connection. always
<1> eafuna: you already did. now try smth more substantial
<15> that is soo handy
<16> :) i get "Client does not support authentication protocol requested by server; consider upgrading MySQL client" how can i upgrade this api?
<15> eafuna, oo .. oo .. I know this one
<16> great! :) how?
<15> eafuna, you need to 1) upgrade your client (you're using PHP, right)? or 2) reset the p***word with old_p***word()
<16> 1.) ohh.. so theres nothing wrong with mysql then? Im using php 4.4.0 already..
<14> nope
<14> !m eafuna old client
<11> eafuna: (Client does not support authentication protocol) : http://dev.mysql.com/doc/mysql/en/Old_client.html
<15> eafuna, no, your mysql's fine
<16> humm... great help.. thanks..
<8> i've fixed my problem - I had to define the master_ssl_cert etc in the CHANGE MASTER TO command... it wasn't picking up the values from my.cnf and putting them into master.info
<8> sigh
<15> eafuna, something about set p***word=old_p***word('...')
<16> ok.. hehe
<16> thanks..
<17> Someone knows, if you can use mysql with microsoft visual basic
<17> instead of the tradinional access
<18> install ODBC driver for mysql on the box in question
<18> then use VB ODBC functions
<17> The problem is thisone. I have a php page that conect to mysql. I also want to manage the information with a software done in visual basic. Can that be posible
<16> thanks room.. problem solved! great channel.. great people.. bye for now..
<17> I download mysql in tar.gz which sock that it use. Where I find it. I am trying to create a database with mysqlcc
<14> /tmp/mysql.sock I think
<17> I try but I doesn't find it. Mysql came already compile
<19> is there a way someone can find out my username/p***word list from a login box?
<1> IllegalC0de: perhaps you would like to phrase your question more clearly. and perhaps also consider whether this is a mysql question or not ;-)
<20> shouldn't this create a user with p***word 'foo' that can do all the usual stuff with all databases and tables? GRANT USAGE ON *.* TO 'joab'@'%' IDENTIFIED BY 'foo';
<19> my sql query is select id from userlist where username = '$uname' and p***wod = '$pword'; is there anything that the vars can be to bring up the table?
<1> joab: no. usage is just a "can't do anything but can login" priv. you don't want to grant privs on the global level like that
<1> IllegalC0de: "bring up the table".....???
<20> arjenAU: oh. but i can't login either
<1> joab: then read the exact errormsg you get, and work from there ;-)
<19> list the contense of the table ie get the usernames and p***words?
<20> arjenAU: i'll try with GRANT ALL PRIVILEGIES instead :)
<19> i know * wont do it but is there anything else that will?
<1> joab: that's fine but don't do that on *.* but on dbname.* instea
<1> IllegalC0de: if you want all rows, don't put in a WHERE clause
<20> arjenAU: i can never remember which star is the db and which one is the table, but the first is the db then?
<19> there is only 1 user that can have 1 name no 2 users can have the same name
<1> joab: apply brain
<20> arjenAU: no need to be rude, i'm a bit tired that's all
<1> nothing rude about it. but feel free to ***ume that someone actually bothers to insult like that
<20> ok. thanks anyway
<17> Someone may help me to configure the socket. I compile mysql form a .tar.gz
<1> ushiro: bad idea. don't compile. use binary tarball or RPM. you can configure the socket to be anywhere you want.
<17> arjenAU I am using slackware
<1> ushiro: ah. slackware does an incomplete install. very stupid.
<1> ushiro: find the slackware mysql installation info that will be on your HD
<1> no I have no idea what the filename is. this is a slackware mess. nothing to do with mysql.
<17> for that I decide to user a .tar.gz but when I was trying to ./configure I sway mysql was already compile ?
Return to
#mysql
or
Go to some related
logs:
hack using linux
lebnan swf
ubuntu gtk-config
mkreiserfs,yast,default
howto run a patch ubuntu
pyhon list unique function
#linux
gentoo gconfd-2
#perl
#python
|
|