I followed the instructions to a T, but it doesn't work. I have it set so root can't connect to anything but localhost and it still doesn't work. I've tried the internal IP, 127.0.0.1, localhost, etc, but no dice. Oh well, it seemed like a cool idea at the time.
ps aux won't work -- On Windows Thanks for getting back to me, Falco. ps aux won't work, as I'm running PuTTy and MySQL admin on Windows. I managed to get it to work partially -- I created a "Grant all on *.* to 'root'@'localhost.localdomain'; on the MySQL server, and now I can log in with a blank password using this method. Being on the server still requires the root password to access MySQL, so I'm not too worried about security for the moment. For some reason, adding a password to [email protected]ldomain didn't work -- it still logs me in with a blank password. When MySQL admin does run, however, it lets me see my databases but I can't change anything. I get an error that says "Either the server service or the configuration file could not be found. Startup variables and server are therefore disabled." I haven't Googled this one, yet. Thanks again for getting back to me.
Sorry, I meant "Falko". My bad! I was so happy to get a reply I forgot to spell your name properly. Sorry.
But your MySQL server is running on Linux, isn't it? Then connect to your Linux system with PuTTY (port 22 - SSH) and run Code: netstat -tap and Code: ps aux|grep -i mysql
Oh yeah. Whoops! Thanks for getting back to me. Here is the output of netstat -tap: Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 *:wnn6 *:* LISTEN 1982/jserver tcp 0 0 *:swat *:* LISTEN 1987/inetd tcp 0 0 *:mysql *:* LISTEN 2040/mysqld tcp 0 0 *:netbios-ssn *:* LISTEN 2088/smbd tcp 0 0 *op3 *:* LISTEN 1987/inetd tcp 0 0 localhost.localdo:spamd *:* LISTEN 1934/spamd.pid tcp 0 0 *:sunrpc *:* LISTEN 1626/portmap tcp 0 0 *:www *:* LISTEN 16742/apache2 tcp 0 0 *:canna *:* LISTEN 1946/cannaserver tcp 0 0 *:auth *:* LISTEN 1987/inetd tcp 0 0 *:munin *:* LISTEN 2128/munin-node tcp 0 0 *:ftp *:* LISTEN 1987/inetd tcp 0 0 *:ssh *:* LISTEN 2103/sshd tcp 0 0 localhost.localdom:smtp *:* LISTEN 1977/exim4 tcp 0 0 mail.<name withheld>:smtp *:* LISTEN 1977/exim4 tcp 0 0 *:https *:* LISTEN 16742/apache2 tcp 0 0 *:2812 *:* LISTEN 29878/monit tcp 0 0 *:microsoft-ds *:* LISTEN 2088/smbd tcp 0 0 mail.<name withheld>op3 mail.<name withheld>:2260 TIME_WAIT - tcp 0 0 mail.<name withheld>:mysql mail.<name withheld>:40330 ESTABLISHED2040/mysqld tcp 0 0 mail.<name withheld>:mysql mail.<name withheld>:40331 TIME_WAIT - tcp 0 0 mail.<name withheld>:www lj602239.inktomis:44796 TIME_WAIT - tcp 0 52 mail.<name withheld>:ssh mail.<name withheld>:2828 ESTABLISHED3900/sshd: <name withheld> [ tcp 0 0 mail.<name withheld>:40330 mail.<name withheld>:mysql ESTABLISHED3903/0 Here is the output for ps aux| grep -i mysql root 2006 0.0 0.3 2508 1236 ? S Jan01 0:00 /bin/sh /usr/bin/mysqld_safe mysql 2040 0.0 5.7 119640 18636 ? S Jan01 0:02 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock root 2041 0.0 0.1 1488 500 ? S Jan01 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld root 4296 0.0 0.1 1552 528 pts/0 S+ 08:13 0:00 grep -i mysql
Looks ok. What's the output of Code: mysql -h localhost -u root -p and Code: mysql -h 127.0.0.1 -u root -p ? What's the output of Code: ifconfig and what's in /etc/hosts?
Here you go: The first two worked fine with my regular root password for MySQL Ifconfig: -------------------------- eth0 Link encap:Ethernet HWaddr 00:50A:7C:1F:06 inet addr:192.168.X.XXX Bcast:192.168.X.XXX Mask:255.255.255.0 UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:883347 errors:0 dropped:0 overruns:0 frame:0 TX packets:350871 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:354650083 (338.2 MiB) TX bytes:95787104 (91.3 MiB) Interrupt:5 Base address:0x1000 lo Link encap:Local Loopback inet addr:127.0.0.1 Mask:255.0.0.0 UP LOOPBACK RUNNING MTU:16436 Metric:1 RX packets:670953 errors:0 dropped:0 overruns:0 frame:0 TX packets:670953 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:75728099 (72.2 MiB) TX bytes:75728099 (72.2 MiB) In /etc/hosts, this is what I have: ---------------------------- 192.168.X.XXX <local machine name> 127.0.0.1 localhost.localdomain localhost 192.168.X.XXX <one Windows PC> 192.168.X.XXX <Another Windows PC> # The following lines are desirable for IPv6 capable hosts ::1 ip6-localhost ip6-loopback fe00::0 ip6-localnet ff00::0 ip6-mcastprefix ff02::1 ip6-allnodes ff02::2 ip6-allrouters ff02::3 ip6-allhosts
This looks fine, so the tutorial should work. Please compare your settings again with those from the tutorial.
Issues making connection as with certain hosts Hi falko, I too followed the instructions in the 'How to connect to MySQL using PuTTy' tutorial and can not get the connection to work. The problem has something to do with my hosting provider as I was able to make a successful connection to my dedicated server. When I tried to connect to my shared hosting DB I receive "MySQL Error Number 2013. Lost connection to MySQL server during query". What I'm wondering is if there is anyway to specify what host name I want to connect to on the remote server as each database on my hosted server has its own unique Host Name. Thanks for any incite. -Bryan
Thanks for the response. Where exactly do I enter the mysql command? I can log into MySQL from in Putty using the command that you gave me but still receive the same error when I try to log in with the MySQL Administrator. I also tried using that same command in the username field in MySQL Administrator, hoping to get some different response. Neither seem to do anything, is there an extra field in the MySQL Administrator that I am missing to add additional login queries? Thanks again.
On the command line (e.g. in PuTTY). This means the user and password are correct. Seems to be a misconfiguration of MySQL Administrator...
hi falko I am new memeber on your forums. Through google i came across your post 'How to connect to MySQL using PuTTy' and i have the same problem/query. I can see that you have referred to see some tutorial but i am not able to find that tutorial. Can you please send me link to that tutorial where i can know how to connect MySQL database project using putty client server program. Thanks in advance Saif
I working on my term project and have few doubts 1. I dont know how to make a connection between server program and MySQL using putty 2. Can putty be installed and run on linux?? Thanks
Log in to your server with SSH, and then run Code: mysql -u root -p to connect to MySQL. Yes, but it's easier to use the terminal which is installed anyway.