In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.