| nicomino | Shaba1: Dont even mentioned on the book Shaba1: thanks anyway Anyone is familiar with SSH tunneling MySQl |
| dr1v3r | guys i have installed mysql but when i try to start it it does not start. There is no errors on screen and no errors in the mysql.log. when i type mysql i get this error Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' i know its because it is not running, how can i fix this? |
| Xgc | dr1v3r: The startup error will tell you. |
| nicomino | Xgc: Familiar with SSH Tunneling? |
| Xgc | nicomino: If you redirect the proper ports it should just work. |
| dr1v3r | there is no startup error Xgc ^ when i type /etc/init.d/mysql start it just goes straight back to the prompt as if it has started. But it did not start and gave no errors |
| Xgc | dr1v3r: You probably won't see the error that way. |
| dr1v3r | how will i see what error its giving? even the mysql.err does not show anything |
| Xgc | dr1v3r: Try starting mysqld or mysqld_safe directly. |
| dr1v3r | i cant find mysqld when i do locate |
| nicomino | Xgc: Redirect them right, checked with Telnet. ut it gives me the error 2013 - lost connection to mysql server during query, which in the forums I have read that is the same as it couldnt connect |
| dr1v3r | so its missing that then, hmmm wonder why that has not installed |
| nicomino | Xgc: My school doe not allow direct connections to the mysql server, so need to connect to a another server and run it thru mysql command Xgc: But using Navicat, it has a feature to use SSH Tunneling and it works like a charm |
| dr1v3r | Xgc i have everything installed but i still get this issue, Any ideas? .j ubuntu shit sorry |
| Xgc | dr1v3r: Fix your PATH. |
| nicomino | Xgc: Some people suggested changing /etc/ssh/sshd_config I changed: AllowTcpForwarding no to AllowTcpForwarding yes |
| zeeeee | hi all, how does a rdbms typically maintain its on-disk data in sorted order? (what disk data structure does it use?) i wasn't successful at googling on this. (the data must be sorted on disk for 'clustered indexes' to exist/make sense, right?) |
| dr1v3r | i am using debian so its done via apt. But when i do locate mysqld it doe snot find anything Xgc^ |
| nicomino | Xgc: What would be the windows equivalent |
| XsSo | SELECT b.ip m.message_id, m.user_name, m.message, m.date_format(m.post_time, '%h:%i') as m.post_time FROM message AS m, ipban AS b; ... what's wrong here? |
| _RainMkr_ | what is m.date_format? |
| f_ry | hm |
| XsSo | okay fixed kinda |
| f_ry | show table status; 302 rows in set (2 min 9.12 sec) |