DigitalOcean-CentOS7-enable MariaDB service, centos7mariadb

DigitalOcean-CentOS7-enable MariaDB service, centos7mariadb
Gossip:

My job has not been smooth recently. I have been in the ACM Team (back in seconds), engaged in php development, O & M, and scientific research (visualization). Now I am mainly writing java, most of the things I learned are related to the Web.

When looking for a job, the interviewer looked at a group of Web development projects on my resume and asked me why I chose client development (mainly C ++ ).

I personally think that the programmer's career is very long, not to mention that even the university is not over, and can be tried in any direction.

In my thoughts, as long as my coding basics, coding style, and coding habits meet the company's requirements, it is no problem to quickly learn to take up the job.

Q & A during the interview. In general, I feel that I have answered questions and answered questions.

The result is unfortunately rejected.

Another company, a Java R & D engineer, was rejected even after a written test.

During the written test, all major questions are within the capacity. Generally, answers should be good.

I don't know if I am too narcissistic or have enough people to answer better questions.

I can only complain a few words later and continue to work hard to make those reasons that I don't understand at the moment not enough to become obstacles on my way.

Body: https://www.digitalocean.com /? Refcode = 3a6149ad9924

1. create a new Droplet2. login 3. see what available update packages # yum check-update4. update all the updates (the source package update of yum is slow, but it is usually a stable version, so it can be updated extensively) # yum update5. update mariadb (Community version of mysql) install # yum install mariadb mariadb-server6. check the status # systemctl status mariadb. service7. enable the Service # systemctl start mariadb. service8. set the root password # mysql_secure_installation. if you do not have a password, press Enter. if you select Y/N, all the way to Y is fine and recommended. there is an option in it that does not allow remote root login. Let's look at your own ideas. For security reasons, it is better not to allow remote login, that is, Y.9. # mysql-u root-p reported 'msys ': unknown terminal type. stackoverflowhttp: // response
# Export TERM = cygwin no problem. both msys and cygwin are tools used to simulate unix/linux environments on windows. 10. mariaDB> show variables like 'collation _ % '; MariaDB> show variables like 'character _ set _ % '; reset all the items in collation that are not utf8 to utf8MariaDB> set collation_database = 'utf8 _ general_ci '; MariaDB> set collation_server = 'utf8 _ general_ci '; check whether the default values are utf8MariaDB> show variables like 'colation _ % '; MariaDB> show variables like 'character _ set _ %'; 11. create a database vastMariaDB> create database vast; create a user named vast and whose accessible ip address is % (that is, all) is yourpassword, and grant permissions to other users. mariaDB> grant all privileges on 'vast '. * to 'vast '@' % 'identified by 'yourpassword' with grant option; 12. refresh privileges. mariaDB> flush privileges; exit MariaDB> quit; 13. test the connection on your machine. successful. it seems that the firewall is opening the door... I will take a look... if the firewall is cautious, # firewall-cmd -- permanent -- add-service = mysql or # firewall-cmd -- permanent -- add-service = mariadb