| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> Do I just use mysql_connect("domain.com", "user", "p***") ?
<0> or does domain.com need to be setup to accept remote connections?
<1> you need to give the users accessing the database access from the hosts they're connecting from
<1> so yes
<0> where in WHM would I do this?
<0> oh, i need to look more
<0> "Setup remote mysql host"
<0> If you wish to change the mysql host, please use the form below (no p***word is required for localhost):
<0> so, say I am connecting from example.com, do I setup example.com with a username and p***word?
<2> use IP-s
<3> I have two computers, one mysql server and another a client, id like to send quieres to the server. Im trying to msyql -h 192.168.0.3 -p but I get: ERROR 1045 (28000): Access denied for user 'root'@'192.168.0.2' (using p***word: YES)
<0> ok, ips
<2> Clownboy: GRANT PRIVILEGE ON database.table TO 'user'@'IPADDR' IDENTIFIED BY 'p***';
<2> for example: GRANT ALL ON *.* TO 'admin'@'192.168.0.2' IDENTIFIED BY 'p***' WITH GRANT OPTION;
<2> this make near root privileges
<0> do i run that command in shell?
<3> in mysql monitor
<2> mysql shell
<4> hey guys - any quick way to get mysql cl client to dump a query as csv? phpMyAdmin is barfing on me...
<0> so run command like this:
<2> shift8: select into outfile?:)
<4> _andrej_: that gens csv?
<0> mysql GRANT ALL ON *.* TO 'user'@'192.168.1.5' IDENTIFIED BY 'p***' WITH GRANT OPTION;
<0> that exactcommand?
<2> Clownboy: look up in the manual for exact options for your needs
<0> well im having troubles understanding the mysql command
<0> i tried running a simple SELECT command and it didnt work
<0> Can I just not setup the user access in cPanel
<3> arg, how can i connect to a remote mysql?
<2> shift8: http://forums.digitalpoint.com/showthread.php?t=16247 @midpage
<2> stealth: with what?
<3> mysql -h
<2> mysql -hipaddr -p -u
<2> andsoon
<3> ERROR 1045 (28000): Access denied for user 'root'@'192.168.0.2' (using p***word: YES)
<0> _andrej_ would that not be mysql --host=1.1.1.1 ?
<2> that's an alias
<0> (dont mind me im just a noob)
<2> stealth: you don't have privilege :) use the -u otion
<2> -u myuser -h myhost -p
<5> how can i run mysql to accept ssl connections?
<3> _andrej_, same thing
<6> *grr*
<2> stealth: do you have privs on the remote machine?
<3> _andrej_, root does have privleges on the server itself
<2> stealth: on _itself_
<2> you can't just connect from outside :)
<5> is it possible to run mysql with ssl support?
<2> bop1: yes, from mysql4
<3> how can i setup to connect from 192.168.0.2? i made a new [client] host=192.168.0.2 block in my.cnf but still no go
<2> bop1: did you read the manual?
<5> _andrej_ i have, but how do i run it?
<5> yea
<5> i tried the --variable thingie
<2> stealth: first, GRANT ... TO 'root'@'remoteip';
<3> oh yea?
<3> could have swore i did that
<2> but it doesn't really seem to work
<7> How do I grant the ability to GRANT?
<2> grant WITH GRANT OPTION
<8> Which came first. The grant or the ability to grant?
<9> firewire, Ability to GRANT.
<9> -sgt
<10> what's uup
<10> I am bored
<9> The sky!
<11> how do you give the ability to grant?
<9> !m gleam- adding new user
<12> gleam-: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<10> grant grant on *.* to somebody@somewhere identified by ...
<9> WITH GRANT OPTION
<11> but what if no user has grant? ;P
<9> Duh!
<9> gleam-, Login with skip-grant-tables
<11> shhh
<11> you're supposed to play along
<10> hmm, good to know that
<11> with the grant/grant option charade
<9> oh
<8> will[werk] you can't grant the ability to grant without grant 0_o
<9> INSERT INTO...
<7> WITH GRANT OPTION worked fine.
<9> firewire, You never said what "without grant" meant...
<13> cold i change the complete data base with phpmyadmin? all tables, mysql and test also out-dip against an old safety device?
<14> colde89: I have no idea at all what you just asked.
<15> how do I select all rows where a field is not NULL ?
<16> rudenstam: select * from foo where x is not null;
<13> mendel: sorry about my english, i had a new installation of mysql. mysql again one installed. I would like to up-play the old data base against with localhost.sql which I secured have (complete safety device)
<16> rudenstam: simple as that :)
<15> ahh.. was missing the "is"
<14> colde89: I'm pretty sure phpmyadmin lets you restore a database, yes
<16> colde89: it may be possible with phpmyadmin, but it's probably not a good idea.
<8> will[werk] chicken and egg problem
<13> Duesentrib: why?
<14> mm, chicken and eggs.
<16> colde89: uploading big amounts of data via http tends to be unreliable. You'll also have to watch out for charset issues - but that's also true of you do it on the command line.
<13> Duesentrib: do i have to remove first the tabels? or cold it put the new tables over the old ones?
<16> colde89: i don't know exactly, probably depends... i'd just *rename* the old tables.
<2> night
<6> everyone, tanks for the help. My page works now ;)
<13> how cold i remove alle mysql-packages, so that i can install mysql and get new p***word for root/admin?
<16> colde89: you don't need to re-install for that
<16> !m colde89 reset root p***word
<12> colde89: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<13> ah, great thanks
<17> can i create a temporary field in a table in a query?
<18> hey on federated engine ? how can i include another table oon local db..
<18> OR anyother way to include the content of another table ?
<18> if table A = B .. then i add in B and i also want the A
<11> what do you mean, loopdee?
<18> ****.. left join lol
<18> oh no i cant join
<17> uhm...
<18> that the prob
<18> needs to be trasnaprent like a select * from A .. wouls also include B
<17> well, when doing a select to pull information to sort, is that a temp table?
<11> create a view that does the join or hte union for you?
<19> hmm what can make a simple procedure call cause any queries after the call to fail, i keep getting "Lost connection to MySQL server during query" if i try to run another query after the procedure call, i tried closing the result set
<18> l rest should be ok
<11> !m \monster\ gone away
<12> \monster\: (MySQL server has gone away) : http://dev.mysql.com/doc/mysql/en/Gone_away.html
<19> ya i was looking at that page
<18> yeah
<18> !m table replication
<12> table: (Replication in MySQL) : http://dev.mysql.com/doc/mysql/en/Replication.html
<20> gah, that's a horrible nick :(
<17> sorry, ima get all my ducks in a row before i ask..
<19> hmm duno
<19> server is not crashing, timeout ..its instant call on the next line so that shouldnt be
<18> ??
<18> i m federated should work iright ?
<19> http://pastebin.com/719762 is there something in this procedure that could cause the connection drop, its pretty simple
<19> i dont see anything wrong
<18> thing is .. i got table al with flower that are red.. and B that have one flower.. yellow or blue.. ..but i need to always include the red ones.. .. thats only an example of course ..wtfcares abotu flowers
<18> so can i used federated on localhost too ?
<21> in oracle i have a cursor for select * from table1; and i can use the following FOR i IN cursorname LOOP and do test on fields like this i.col1 = new.col1 , any way i can do this in mysql ?
<19> weird, if if i do a simple query like select * from mytable; i can run more queries afterwards, but if i run CALL sp_getFolderPath2(21); any query afterwards fails
<19> its something in this procedure, i have noather one slightly different and it works fine with multiple calls
<21> I got a cursor that selects * from a table, how do i open that cursor into a var ? I want to load every row into that var, and do some tests.
<11> why are you selecting *?
<21> gleam-: because i need every row, and every column.
<11> what do you need every column for?
<11> heh
<11> explicitly list the column names and the variables you want to select them into
<21> i ned to test every col in new.row agains every row in table/cursor..
<11> that sounds like poor design?
<22> trigger?
<21> might be, Im giving up makeing something new, so im trying to convert a oracle trigger (that actually works) to a mysql trigger.
<11> anyway all you should need to do is declare the cursor for select * and then fetch cursor into var,var,var,var
<11> varname for each column
<21> okay, ill try that, god damn life is more easy in oracle :)
Return to
#mysql
or
Go to some related
logs:
pakety smp
how do I reconfigue grub in ubuntu
#python
what are bots Webcam
disable beagled
#php
#perl
+gaim +unban
#postfix
#math
|
|