Subject: Install and configure MySQL on AWS EC2 instance
Author: Linux
Posted on: 10/26/2011 01:28:13 AM

---

Here’s how to do that:

$ sudo yum list | grep mysql*

$ sudo yum install mysql
$ sudo yum install mysql-server
$ sudo yum install mysql-devel

$ sudo chgrp -R mysql /var/lib/mysql
$ chmod -R 770 /var/lib/mysql

$ sudo service mysqld start

Now you’ll have MySQL installed and the service has started. The next step is to set a password for the root user:

$ usr/bin/mysqladmin -u root password secret

If you only want to use MySQL internally, then you’re all done now.

But if you access MySQL externally then you’ll get the error message similar like this:

SQL Error (1130): Host 'adsl-71-146-123-45.sbcglobal.net' is not allowed to connect to this MySQL server

Replies:

• How to enable remote access to MySQL?  Linux  10/26/2011 02:05:35 AM
• Grant and revoke remote root access to MySQL  Linux  10/26/2011 02:11:30 AM
• MySQL client  Linux  10/26/2011 02:16:27 AM

---

References:

• Next Post: How to enable remote access to MySQL?  Linux  10/26/2011 02:05:35 AM
• Previous Post: Sundomain mapping with Apache httpd and Tomcat  AwsEC2  05/12/2016 01:34:26 AM
• Next Topic: Rename File on Unix / Linux  Unix  11/08/2011 01:13:36 PM
• Previous Topic: Integrate Apache httpd with Tomcat on AWS EC2 instance  Linux  10/21/2011 12:51:40 AM
• Index: by Date
• Index: by Topic