6

Mysql-workbench error, can't start querying :( :( ?

view full story
linux-howto

http://www.linuxquestions.org – in Mysql-Workbench,i clicked on open connection to start querying and i get a dialog where i get the hostname,username,password,etc... in hostname it has 127.0.0.1, user set as root, and i've enter the root password for mysql and i get this: Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 Please: 1 Check that mysql is running on server 127.0.0.1 2 Check that mysql is running on port 3306 (note: 3306 is the default, but this (HowTos)

robot1's picture
Submitted by robot1 on 11/13/2010 – Made popular on 11/13/2010

Stories similar to Mysql-workbench error, can't start querying :( :( ?

I'm on Windows 7 with MySQL Workbench 5.2.44 CE trying to connect to MySQL database at a remote Ubuntu 12.04.1 server using "Standard TCP/IP over SSH" feature of MySQL Workbench with a passphrased SSH key.

Mysql server is installed on my quest OS Centos6 (192.168.1.50) and using port 3306. I'm trying to connect from my Windows OS (192.168.1.2).

I'm getting error #1045 Access denied for user 'root'@'192.168.1.2' (using password: YES) So, as far as I understand this error is telling me that I have no rights to access mysql using user root from 192.168.1.2 host.

MySQL Workbech Wont Connect 2 years 42 weeks ago

I installed on my local desk workstation the MySQL Workbench application. It installed perfect and when I try to create a new connection to my database, it fails and tells me:

Quote:

Failed to Connect to MySQL at 192.168.0.79:3306 with user cmennens

I receive the following error when trying to connect to mySql through phpmyadin:

MySQL said:

1045 - Access denied for user 'root'@'localhost' (using password: NO) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection.

Mysql fun! 3 years 44 weeks ago

I am trying to set my root password for my mysql database. After I enter /etc/init.d/mysqld start

Starting MySQL: [FAILED] [root@server server]# [root@server server]# mysqladmin -u root password 'mypassword' mysqladmin: connect to server at 'localhost' failed

Brand new server, brand new MySQL 5.5 install on Ubuntu 12.04.

I can log in to the database as root from the command line. I can log on via Navicat MySQL or Sequel Pro as root on port 3306 from my Mac. I cannot log in using an SSH tunnel to the server and then to the database as root. I have tried both localhost and 127.0.0.1 as server for the local connection part. My password is fine.

I have a VPN with public and private subnets; I am considering only public subnet for now.

The node 10.0.0.23, I can ssh into it.

I really did it this time.. I deleted a database named MySQL in my server. Shortly after MySQL went haywire and now I cannot login as a user to mysql, I cannot re-install mysql, I get an error for every solution I try.

So I decided hell with it I'll remove mysql, php and start again. I used rpm -qa | grep mysql but it returned nothing.

I have the following problem: I cant get etherpad running, when my firewall rules are active.

My firewall: http://pastebin.com/82APzKhi

telnet localhost 3306 gives connection timeout

ps aux | grep mysql:

root 15212 0.0 0.0 4112 712 ? S 13:54 0:00 /bin/sh /usr/bin/mysqld_safe mysql 15526 0.7 0.9 426056 75392 ?