To directly login to a remote mysql console, use the below command: mysql -u {username} -p'{password}’ \ -h {remote server ip or name} -P {port} \ -D {DB name} For example mysql -u root -p’root’ \ -h 127.0.0.1 -P 3306 \ -D local no space after -p as specified in the documentation It will take … Read more
Two guesses: Run mysqladmin variables | grep socket to get where the socket is located, and try setting up a connection like so: pymysql.connect(db=’base’, user=”root”, passwd=’pwd’, unix_socket=”/tmp/mysql.sock”) Run mysqladmin variables | grep port and verify that the port is 3306. If not, you can set the port manually like so: pymysql.connect(db=’base’, user=”root”, passwd=’pwd’, host=”localhost”, port=XXXX)
If you are using Ubuntu, you have to use the following steps to avoid this error (if there is no replication enabled): run the command vim /etc/mysql/my.cnf comment bind-address = 127.0.0.1 using the # symbol restart your MySQL server once. In Step 1, if you cannot find bind-address in the my.cnf file, look for it … Read more
It probably means that your MySQL server is only listening the localhost interface. If you have lines like this : bind-address = 127.0.0.1 In your my.cnf configuration file, you should comment them (add a # at the beginning of the lines), and restart MySQL. sudo service mysql restart Of course, to do this, you must … Read more