That’s the detailed solution to navicat’s inability to connect to Ubuntu. Once again connect to mysql using Navicat, you can finally connect. CNF to modify the mysql configuration file.įind bind-Address Modify 127.0.0.1 to 0.0.0.0. The returned result is as shown in the figure and you are done. View character set sort settings: mysql> show variables like'collation' View Image. mysql> show variables like'characterset' View Image. Then check the database character set settings: linuxidclinuxidc: mysql -u root -p. Input flush privileges Refresh permission Settings.Įnter CD /etc/ into the mysql configuration directory.Įnter vim mysqld. Enter the password to log in: mysql -uroot -p. Related recommendation: Navicat for mysql Graphic Tutorial You can see that the binding is 127.0.0.1, which we need to change to 0.0.0.0, which will be covered below.įirst you have to modify mysql access permissions, type mysql-U root-p, enter, and then enter the password 123456 to enter the mysql command line.Įnter grant all privileges on *.* to identified by ‘123456’ with grant option Specifies that all clients can access mysql using the root account. Then enter netstat -an|grep 3306 to check the port startup and occupancy. The status indicates that it is inactive. This is an all-inclusive database front end provides a powerful graphical interface for databases management and. Navicat Lite is an ideal solution for MySQL, SQLite, SQL Server, Oracle and PostgreSQL administration and development. First, sufo UFW status checks if the firewall is on. Freeware - Navicat Lite for Windows (Cross-Database Admin Tools for MySQL, SQLite, SQL Server, Oracl v.10.0.3.
0 kommentar(er)
