Shulou(Shulou.com)06/02 Report--

How to install Mysql in AWS, in view of this problem, this article introduces the corresponding analysis and answer in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

Step 1: switch to your root account

Sudo-s

Change the time zone to East Zone 8 (Beijing time)

Mv / etc/localtime / etc/localtime.bak cp / usr/share/zoneinfo/Asia/Shanghai / etc/localtime

Step 2: need to update yum (because Amazon's yum version is often behind fashion)

Yum update

Step 3: install mysql

Yum install-y mysql57-server

If prompted by Unable to find a match: mysql57-server, you need to go to mysql's official website to get the installation package.

/ / download sudo rpm-ivh https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm// and install sudo yum install mysql-server

Step 4: start mysql

Service mysqld start# setting Boot self-boot chkconfig mysqld on

Step 5: do some basic configuration

Mysql_secure_installation

The following content will be more, in fact, only a few

[root@ip-172-31-35-183 ec2-user] # mysql_secure_installationSecuring the MySQL server deployment.Connecting to MySQL using a blank password.VALIDATE PASSWORD PLUGIN can be used to test passwordsand improve security. It checks the strength of passwordand allows the users to set only those passwords which aresecure enough. Would you like to setup VALIDATE PASSWORD plugin?# asks whether you want to enable password checking Press y | Y for Yes, any other key for No: yThere are three levels of password validation policy:LOW Length > = 8MEDIUM Length > = 8, numeric, mixed case, and special charactersSTRONG Length > = 8, numeric, mixed case, special characters and dictionary file# asks what strength password you want to use, enter 0 and you can use any password, and there are 1 and 2 options. you can choose the strength requirements of the above two lines Please enter 0 = LOW. 1 = MEDIUM and 2 = STRONG: 0Please set the password for root here.# enter your password New password: # re-data your password Re-enter new password: # this line is to evaluate the strength of your password, you can ignore Estimated strength of the password: 50 # the previous line evaluated your password strength, if you feel it is not enough, you can enter n to reset your password, if you are satisfied with your password, enter y Confirm to use the new password Do you wish to continue with the password provided? (Press y | Y for Yes, any other key for No): yBy default, a MySQL installation has an anonymous user,allowing anyone to log into MySQL without having to havea user account created for them. This is intended only fortesting, and to make the installation go a bit smoother.You should remove them before moving into a productionenvironment.# asks you if you want to delete all anonymous users, just select y, and you don't need to think about it (think as much as you like) Remove anonymous users? (Press y | Y for Yes, any other key for No): ySuccess.Normally, root should only be allowed to connect from'localhost'. This ensures that someone cannot guess atthe root password from the network.# asks you if you want to disable remote connections to your root account. If it is disabled, you can only operate on a stand-alone, so choose nDisallow root login remotely? (Press y | Y for Yes, any other key for No): n... Skipping.By default, MySQL comes with a database named 'test' thatanyone can access. This is also intended only for testing,and should be removed before moving into a productionenvironment.# asked you if you want to delete all the test data, the new database will have some default test data, delete or not affect, y and n random Remove test database and access to it? (Press y | Y for Yes, any other key for No): y-Dropping test database...Success. -Removing privileges on test database...Success.Reloading the privilege tables will ensure that all changesmade so far will take effect immediately.# asks if you want to update the configuration (bullshit, if you set it up so hard, you must update it right away) yReload privilege tables now? (Press y | Y for Yes, any other key for No): ySuccess.All done!

Step 6: log in to the database with the password you just set, and modify the remote ip permissions

Mysql-u root-p

Set the user root to be accessed under any IP:

Grant all privileges on *. * to root@ "%" identified by "your password"

Set the user root to be accessed locally:

Grant all privileges on *. * to root@ "localhost" identified by "your password"

After setting the access permission, you need to refresh it.

Flush privileges

It's over.

This is the answer to the question about how to install Mysql in AWS. I hope the above content can be of some help to you. If you still have a lot of doubts to solve, you can follow the industry information channel for more related knowledge.

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.