Cannot connect to Database MySQL from workbench

0
votes

I am try to using MySQL Workbench but its showing error "Cannot connect to database".Neither it taking it localhost or my Endpoint of AWS RDS as DNS in host in workbench. "I am using Xampp for mysql server running on port number 3306 "

Error : Cannot connect to DataBase Server

Your connection attemp to failed for user 'root' from host to server at localhost:NULL; can't open named pipe to host:pipe:MySQL (2)

Please: 1.Check that mysql is running on server localhost. 2.Check that mysql is running on port NULL (note 3306 is the default,but this can be changed)

3.Check the root has rights to connect to localhost from your address . 4.Make sure you are both providing a password if nedded and using the correct password for localhost connecting from the host address you are connecting from.

2
mysqldatabasedatabase-connectionmysql-workbench

2 Answers

0
votes

If you want to test the connection to MySql, Use Heidi (i recommend it). If it didn"t work, check if your DataBase server is running in port 3306 by taping:

netstat -atp tcp | grep -i "listen".

You can also change listenning port in /xampp/mysql/bin/my.ini:

my.ini:

Password = your_password port = 3306 ---> 3307 socket = "/ xampp / mysql / mysql.sock"``

0
votes

Looks like you have no port configured. Check your connection settings that you have a port set.

enter image description here