Common errors and solutions for connecting Navicat to virtual machine MySQL

Question 1

solve

Start the service: service mysqld start;

/sbin/iptables -I INPUT -p tcp --dport 8011 -j ACCEPT #Open port 8011 /etc/rc.d/init.d/iptables save #Save configuration /etc/rc.d/init.d/iptables restart #Restart service #Check if the port is open /etc/init.d/iptables status

Question 2

solve

Mysql -u root -proot (root is the password)
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;

Refresh permissions: FLUSH PRIVILEGES

Question 3

After the MySQL service is set up, the default root role cannot connect remotely. Enable remote login for the root user in the user table under the MySQL database on the machine where MySQL is installed.

This is the end of this article about common errors and solutions when Navicat connects to virtual machine mysql. For more information about errors when Navicat connects to virtual machine mysql, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!