Linux Server MySQL installation and website publishing

Linux installs MySQL and configures the database to connect to the server via its own computer

Yesterday installed MySQL, this morning configuration MySQL can use the native connection server database, server when Digitalocean, provides a very comprehensive and professional documentation, when installing MySQL reference: https:// cloudsupport.digitalocean.com/s/#none |KA21N000000COX3QAC

Install the installation of this, install the default version of Apt MySql5.7, the above steps are no problem. (A security script was run at the time of installation, which set the strength of the password setting, making it cumbersome)

With MySQL Workbench connection, find the corresponding version of the remote connection document, the connection is still a problem, whether through SSL connection, or directly through the TCP/IP connection is not connected to, this morning and look, searched a bit, MySQL By default is not allowed remote connection, only through the local address connection, I went to find the method of configuration: There is a corresponding document, I looked carefully, the document is very troublesome but very safe for the database, the document is encrypted via SSL connection to the database (https:// cloudsupport.digitalocean.com/s/#none |ka21n000000coopqas), for the novice I still very troublesome, gave up this method, online search solution, through the TCP direct connection, https:// Www.linuxidc.com/Linux/2017-01/139502.htm (solution)

First step: Create a user and log in to this authorized remote connection

The second part: is to modify the configuration file, the configuration file in the MySQL default listening to the native address to comment out, and then restart MySQL on the line,

After testing can be used this method, very convenient, but may not have SSL connection security, for the novice is good.

MySQL installed, also configured, Tomcat has been installed a few days ago, the server is ready now, and then is to write a website, published to the server

Web interface is written in Bootstrap, this front-end framework is really great, for me this is not like writing interface of the people is the gospel, because you can not write a CSS file, directly using the various components and classes provided by Bootstrap to achieve a graceful interface.

Last Picture:

This is a blog site, at that time, the end of the work with ASP, the interface is completely bootstrap to achieve, basically did not write their own style, when the time 5 days to write this site, there are many problems, one of which is the database of Chinese garbled problem

Now intend to write a website, with Java to write, interface or intend to use bootstrap to write, backstage with the mainstream Java framework, when practiced hand,---------------summer to find a job-------------

This afternoon to get the interface out, referring to the ASP. NET, layout is the above, the homepage changed, not the blog, want to do a share of movies, music, book novel Site, from the C # code to get the interface out,

Next to a picture, this afternoon busy results (originally wanted to use the latest BOOTSTRAP4 to write, but the original C # page is used BOOTSTRAP3 to do, in order to save a bit of energy to steal a bit lazy to use 3, 4 of the document seems to have not translated, roughly looked at, 4 more features, more perfect)

Website: http://138.197.198.216:8080/Web/Not yet to get the domain name (but this one, apply for the GitHub package, it seems that there is a free one-year domain name, find a time to get it), and then slowly write this site

Linux Server MySQL installation and website publishing