1. I read a lot about setting up remote access on the Internet , It doesn't work at all , Later, I saw an article on the Internet that finally solved my problem , In the configuration file /etc/mysql/my.cnf :

2. edit  vi /etc/mysql/mysql.conf.d/mysqld.cnf Modify the bind-address = 127.0.0.1 by bind-address = 0.0.0.0

3. Save changes , And then quit , restart mysql,service mysql restart, That's all right. !

linux Lower setup mysql5.7 More articles on remote database access

  1. Linux How to enable MySQL Database remote access

    Remote connection MySQL For safety reasons , Remote access is usually turned off , But sometimes you need to provide remote access to the database service , Now let's quickly learn : First step : modify my.cnf Files are edited with a text editor MySQL The configuration file for the server my.cnf ...

  2. Linux The following settings allow myql Database remote connection

    System environment : Linux ubuntu --generic #-Ubuntu SMP Thu Apr :: UTC x86_64 x86_64 x86_64 GNU/Linux It's already installed in the system mysq ...

  3. Linux Lower installation mysql5.6.11( It's hard to find some useful information )( turn )

    Linux Lower installation mysql5.6.11( It's hard to find some useful information ) (2013-04-25 10:25:09)     1. Apply for alicloud Linux The server Yesterday, I applied for a free trial in Alibaba cloud 5 Days of Linux The cloud service ...

  4. Linux Next oracle11gR2 The system is installed to the database to establish the configuration and finally oracle Of dmp File import one-stop operation record

    brief introduction Before that, too linux I've installed oralce, But every time I was in a daze , Because the brain is blank , Copy any document you see on the Internet , In the end, it was a mess , Even though it's loaded with , But it's a mess , Now write it down , Hope to give other online friends problems ...

  5. Linux Automatic backup under the background MySQL Database and upload to remote FTP The server

    Linux Automatic backup under the background MySQL Database and upload to remote FTP Server and delete the backup before the specified date Shell Script explain :  1. Backup MySQL Database storage directory /var/lib/mysql Below xshelldata database ...

  6. Linux Lower installation mysql5.7

    Linux Lower installation mysql5.7   Get ready first mysql5.7.17 Installation package , Install the package in  /data/software Under the table of contents Enter into /usr/local Under the table of contents , decompression mysql Installation package command : ...

  7. Linux Next time cutting Mongodb Database log and delete the log records before the specified number of days

    This is from the Internet , I think it's very good ! Achieve the goal : Yes Mongodb The database log is saved on a daily basis , And keep only the latest 7 Days of logging . Specific operation : Use Mongodb Database comes with the command to cut the log ps -def | grep ...

  8. Linux Automatic backup under the background Oracle Database and delete the specified number of days before the backup

    explain : Oracle database server operating system :CentOS IP:192.168.0.198 port :1521 SID:orcl Oracle Database version :Oracle11gR2 Specific operation : 1.root use ...

  9. Record CentOS7.X Install under version MySQL5.7 database

    Record CentOS7.X Install under version MySQL5.7 database   Set up rpm The download directory is in /opt Create a new directory to store mysql cd /opt sudo mkdir mysql12 download MySQL Source wg ...

Random recommendation

  1. ML(4): NavieBayes stay R Application in

    Naive Bayes method is a method that uses prior probability to calculate posterior probability , See the previous section for details . Algorithm package :e1071 function :navieBayes(formule,data,laplace=0,...,subset,na.act ...

  2. be based on Unity Of AR Exploration of development : Release AR Applied to the Android platform

    This article is followed by , How to get through Unity Release the first AR Apply to. Android platform , stay Android Use our first one on the phone AR application . One . Some preparatory work 1.1 Get ready Java JDK The choice here is JDK 1 ...

  3. 【ASP】session Realize shopping cart

    1. Ask questions utilize session Built-in objects , Design and implement a simple shopping cart , Requirements are as follows : 1) Using a user name and password , Log in to the front page of the shopping cart 2) The shopping homepage shows the login user name and the number of visitors the user is .( The refresh of the same user should record ...

  4. Applet ---- Choose the location ( wx.chooseLocation ) and Get the location (wx.getSetting)

    The problem is coming. : If I use it for the first time wx.chooseLocation() Access denied , And then use wx.getSetting() How to get permission again ? Ideas :wx.chooseLocation() Yes fail ...

  5. It's really eye opening : Why do many people advocate paying attention to ability and quality , But at the same time, there are strict requirements for academic qualifications ?—— It represents the last game , Recruitment costs are important . If the last game fails , Try to be at the top of the current group . Education is just one of the works , But a degree represents a sacrifice made in the student years . People tend to be concentrated good

    For software engineer positions , It doesn't matter if you don't have a degree , If you really think you're talented , Please attach... To your resume github Project links or appstore/google play On your work . If education is lower than others , Well, I think I spent my time and energy on it ...

  6. New virtual machine _WIN8 64 Bit system _ Initiate error reporting Directory "EZBOOT" not found

    preparation : download win8 64  Image file 1. Virtual machine installation win8 64 Bit operating system , The steps to create a new virtual machine are the same as XP System 2.BIOS Set up CD/ROM start-up , But the startup error , as follows , Because the image file exceeds 4G, Unable to install... From virtual machine , Need to be ...

  7. net.sf.json------json analysis

    Download address [plain] view plain copy   This time we use version :http://sourceforge.net/projects/json-lib/files/json-lib/json-l ...

  8. teamviewer and openconnect-gp (globalprotect) in ubuntu

    wget https://download.teamviewer.com/download/teamviewer_i386.deb sudo dpkg -i teamviewer_i386.deb a ...

  9. Spring Framework Official document learning ( Four ) And Validation、Data Binding、Type Conversion

    This article is too messy , Please move : Spring Framework Official document learning ( Four ) And Validation.Data Binding.Type Conversion( One ) Write, delete, delete, write , Repeat several times , I don't describe myself very well ...

  10. web Container and web The server

    apache.nginx These are web The server tomcat.jboss.Kestrel(asp.net core) These are web Container and iis.jexus Both are apache.nginx  You can't just run ...