Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to realize the mysql operation of connecting navicat to Ubuntu virtual machine

2025-03-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Development >

Share

Shulou(Shulou.com)06/01 Report--

Most people do not understand the knowledge points of this article "how to realize the mysql operation of navicat connecting Ubuntu virtual machine", so the editor summarizes the following content, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this article, "how to achieve the mysql operation of navicat connecting Ubuntu virtual machine".

1. View the ip of the virtual machine

Open the terminal in the virtual machine and enter the command

Ifconfig

2. Authorize mysql remote access

Enter the command at the terminal (the path of the configuration file may be a little different due to different versions)

Sudo vim / etc/mysql/conf.d/mysql.cnf

Type "I" to start editing, and modify bind-address = 0.0.0.0 (set to externally accessible, if set to 127.0.0.1, only locally accessible. )

Esc key to exit editing, type ": wq" to save and exit.

Then log in to MySQL to change permissions

Mysql-uroot-pGRANT ALL PRIVILEGES ON *. * TO 'root'@'%' IDENTIFIED BY' passwrd' WITH GRANT OPTION;FLUSH PRIVILEGES;# exit login MySQLexit;# restart server service mysql restart3, access via navicat

Supplement: Navicat connects to mysql in the virtual machine

The following sql means to add permissions to the root user with a password of 000000.

GRANT ALL PRIVILEGES ON *. * TO 'root'@'%' IDENTIFIED BY' 000000' WITH GRANT OPTION

Navicat Connect mysql Command Line

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Development

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report