| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
<tradergt> look in my.cnf for it
<Baughn> fizzle: If it were high-end, you'd know.
<hopper> if you do, try connecting to one with the other. if that doesn't work. then it is your setup. if it does work, then it is your router..
<hopper> easy
<tradergt> that doesnt solve the problem
<tradergt> either
<fizzle> hopper i have 4 computers on my network
<fizzle> im trying to connect to my server from this computer
<fizzle> but its not working
<hopper> tradergt: you can either connect inside your netwpork or you cant
<hopper> which is it
<tradergt> ask fizzle
<tradergt> I know how to set up a mysql box
<fizzle> hopper; i can connect on the box that mysql is installed on
<hopper> fizzle: if you can't connect to your box when your behind your router. you didn't set it up right
<fizzle> hopper but i cant from this computer
<Baughn> fizzle: Domestic modem firewalls use embedded chips with low capacity tables for software routing, which mean they're incapable of implementing all of TCP/IP. PCs have plenty of capacity, so have no problem doing so for reasonable amounts of data. High-end telecom gear has no problem either, but differs from PCs in having many of the program paths in a PC done in hardware instead of software, and are far more powerful (and expensive) than any PC.
<hopper> fizzle: is it on the same lan network? or do you have a router between you and your server
<shabbs> fizzle: is it listening on 3306? when you connect locally are you connecting to localhost or your IP?
<tradergt> so, like i said, you have skip-networking on or bind-address is set local..
<fizzle> hopper yes i only have 1 LAN
<fizzle> shabbs not sure one sec
<hopper> fizzle: then follow tradergt advice
<hopper> he will help you from htere
<hopper> <<caving and looking for the connector/j rpm ;-)
<fizzle> shabbs i tried connecting on the box in which mysql is installed on through my ip and it didnt work so im guessing its my router
<shabbs> fizzle: what OS?
<hopper> fizzle: IT IS NOT YOUR ROUTER!
<fizzle> dude ;/
<fizzle> shabbs; Slackware-current
<shabbs> fizzle: netstat -nl
<shabbs> look for port 3306
<hopper> shabbs: we already did this test
<fizzle> shabbs no port 3306
<fizzle> hmmm
<shabbs> fizzle: check your my.cnf for skip-networking
<shabbs> if it's there, comment it out
<hopper> lol
<fizzle> i gotta find my.cnf
<hopper> thats what I just told him to do!
<fizzle> ok well
<fizzle> i need to find my my.cnf
<tradergt> /etc/my.cnf or /etc/mysql/my.cnf
<tradergt> something of that nature
<tradergt> unless on windows, thats my.ini
<shabbs> he did just say slackware :)
<tradergt> well, he isnt listening anyways
<fizzle> ok
<fizzle> skip-nerking is commeted
<fizzle> er
<fizzle> skip-networking is commented out *
<fizzle> its still not listening though :/
<tradergt> what about bind?
<tradergt> bind-address, what does that say
<fizzle> in the configuration?
<Zalamander> Anyone have an idea as to why a slave server would think that the master log file is an array?
<tradergt> yes
<fizzle> there is no bind-address
<tradergt> netstat shows it listening on 3306?
<shabbs> why don't you pastebin your netstat
<fizzle> ok one sec
<fizzle> er
<fizzle> thats alot of stuff to type :/
<shabbs> like I said
<shabbs> use the pastebin in the topic
<shabbs> and copy/paste
<fizzle> i cant copy/paste
<fizzle> stupid xterm
<fizzle> ;/
<shabbs> right click it after highlight
<fizzle> xterm doesnt let you copy/paste
<fizzle> bah hold
<fizzle> im not gonna type it all out but the only thing that is open for mysql is
<fizzle> unix 2 [ ACC
<fizzle> er
<fizzle> unix 2 [ ACC ] STREAM LISTENING 22845 /var/run/mysql/mysql.sock
<fizzle> and ports 37,587,6000,113,22,25,512,37,68 are also open
<shabbs> fizzle: were you the one that commented out skip-networking?
<shabbs> or was it like that already
<fizzle> it waslike that
<tradergt> did you give the correct error message?
<shabbs> make sure you're looking at the right conf file
<fizzle> shabbs; /etc/my.cnf
<shabbs> fizzle: are you using a startup script or are you starting it with mysqld& ?
<fizzle> Can't connect to MySQL server on '70.104.183.149' (10061) i get this error on here
<fizzle> and then on my server when i type the same command i get the same error but it says (111) instead
<tradergt> !perror 111
<SQL> System error: 111 = Connection refused
<fizzle> shabbs; im manually restarting it using the /etc/rc.d/rc.mysqld script
<shabbs> that's using a startup script, not manually starting it. check the script to make sure it's not using an alternate conf file
<fizzle> mk
<fizzle> hmm
<fizzle> ahhh i found the problem
<fizzle> it has skip-networking enabled in the startup script
<fizzle> ;/
<shabbs> there you go
<tradergt> in the script? wow, thats stupid
<fizzle> well
<fizzle> its working now but
<fizzle> Host 'pool-70-104-183-149.norf.east.verizon.net' is not allowed to connect to this MySQL server
<shabbs> you have to either add users using that host or disable name-resolve on the server and use IPs
<dingo001> i have 90K records, whats the fastest way to insert them into a database?
<fizzle> shabbs; ok well i already have databases and stuff made for the user fizzle so how do i fix it without losing my information?
<shabbs> fizzle: the databases aren't 'made' for the user, you just simply have to grant privileges to other users to use it
<shabbs> !m fizzle grant syntax
<SQL> fizzle: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<fizzle> oo
<fizzle> ok ty
<fizzle> Client does not support authentication protocol requested by server; consider upgrading MySQL client. aww
<fizzle> ;/
<shabbs> !m fizzle old client
<SQL> fizzle: (Client does not support authentication protocol) : http://dev.mysql.com/doc/mysql/en/Old_client.html
<fizzle> ah if i update my mysql library then the dll wont work
<fizzle> shabbs; this sounds retarded but im coding something in mirc using a dll to connect to mysql servers but the client uses the 4.0.1-alpha libraries
<fizzle> er not alpha, beta
<fizzle> bah ill just stick with plain text files :/
<tradergt> you can get mysqld to use old p***words
<tradergt> takes about 2 secs after you read the doc
<fizzle> tradergt; its telling me to upgrade my client and libraries but i cant. if i upgrade my libaries then my client wont work
<tradergt> you didnt read it all
<shabbs> fizzle: there is a flag old-p***word you can turn on at server level
<fizzle> oo
<fizzle> ok
<tradergt> its amazing, its a 1 page document and people miss it
<archivist_> reading is hard work
<fizzle> newpwwoo
<fizzle> woo
<fizzle> its working
<fizzle> :D
<synthetiq> What is the command to show the current connections in mysql?
<fizzle> ty
<dammit> synthetiq: show processlist;
<boguh> hi, im searching a good start to mysql. a tutorial on how to connect and how to create user and so on
<shabbs> !m boguh tutorial
<SQL> boguh: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<boguh> shabbs thx
<shabbs> np
<Tac_work> k i have a table of regions.. each row is like id | region | state | county,list
<Tac_work> i have a zip table ... which is zip | city | county | state
<Tac_work> i am trying to get to a region via a zip code ...
<dammit> !tell Tac_work about joins
<SQL> Alrighty.
<Tac_work> my query is SELECT region_id FROM regions INNER JOIN zip_codes ON(regions.counties LIKE CONCAT('%',zip_codes.county,'%')) WHERE zip_codes.zip=48312 AND state='MI'';
<Tac_work> but its not workign like i want....
<Tac_work> is INNER join the best choice there/
<Tac_work> dammit, yeah im using joins....
<Tac_work> just dont know if im using the right one for sure
Return to mysql
or
Go to some related
logs:
vlc.bin+how to
|
|