Linux Secure Installation MySQL

First Spit slot Linux, I wipe, the full command of the exercise is really a pain in the egg. Many people say that Linux, indeed, I am the lowest Linux server fully enough, but really feel that the configuration of things to do not have Windows convenient, encountered the problem is the early hundred strange, is it OK people are want to experience the pleasure of solving the problem?

OK, no BB.

download MySQLdownload is very convenient, using the command: wget-c Http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-5.6.24-1.linux_glibc2.5.x86_64.rpm-bundle. Tar - C to support the continuation of the breakpoint, there can be a lot of relevant parameters, it is necessary to checkinstallationunzip the Bundle.tar above and use: tar-xvf Mysql-5.6.24-1.linux_glibc2.5.x86_64.rpm-bundle.tar -X performs-F requiredextracted out will appear a few MySQL installation package, of course, the server and the client is necessary, I am a bit to install all the installation package, using the command: Yum Install mysql-*.rpm--nogpgcheck --nogpgcheck means no need to sign the problem, if there is no option, my regular Report no public Keywait for installation .... (Enter Yes)note There will be a lot of useful logs during the installation process. Change PasswordI naively thought that MySQL's default password is empty, many online is deceptive, where the password is empty? I tried many times are wrong, I repeatedly installed a lot of times, found that the installation process of the log, will produce a random password, placed in the /root/.mysql_secret inside. OK, copy the inside password and log in to MySQL. mysql-uroot-p then enter a random password. The first time you enter the system, if you use the relevant database, you will be prompted to set a new password. SET PASSWORD =password (' New PASSWORD ');Deployment Projectfirst grant MySQL telnet permission mysql>grant all privileges on * * to ' root ' @ '% ' identified by ' Youpassword ' with GRANT OPTION ; flush privileges; (don't forget to refresh) the relevant deployment Tomcat war package is not said, the problem is that my database uses localhost, has been prompted to expire the password. I found the user table in the MySQL database:Select host,password_expired where user= ' root 'then, find that some of the passwords have expired and update the password:Update user set password_expired= ' N ' where user= ' root 'Then again, I want to witness a miracle. But,or prompt password expires, I am still using the localhost. And I've been trying to find a solution on the Internet that's always been out of line. I changed localhost to my extranet IP, which is normal to use. Finally, I'm on the server, using the
Mysql-h 127.0.0.1-uroot-p after logging into MySQL, I'm going to look at MySQL data sheet. Can you but prompt me to set the password, my password is not already set up? I reset the password again,SET PASSWORD =password (' New PASSWORD ').
unexpectedly, really no problem. What the mother fucker!For the first time to make a Linux server configuration, a complete project is done. episodeI use the Huawei Cloud Linux Server, the previous password input error, I locked my IP, unable to log on. 1. Set the new port number for SSH by default2. When locked, log in with a different IP to remove the locked IP from the Hosts.deny  

Linux Secure Installation MySQL