Setting up MySQL 5.x in CentOS/Debian 6.x

After you've installed MySQL and its required dependencies in your server, configure it using the following steps.

1. Start the MySQL service:

/etc/init.d/mysql start; 

2. Log into your MySQL service, the password should be empty:

mysql -u root -p;

3. Update the password for the user account root of your MySQL service:

UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';

FLUSH PRIVILEGES;

4. Create a new MySQL database for testing purposes:

CREATE DATABASE <db name>;

5. Add a new user account for accessing your new MySQL database:

INSERT INTO mysql.user (User,Host,Password) VALUES('user name','host',PASSWORD('password'));

FLUSH PRIVILEGES;

6. Grant all access to the database <db name>:

GRANT ALL PRIVILEGES ON <db name>.* to <user name>@<host>;

FLUSH PRIVILEGES;

7. Change the default runlevels for your MySQL service:

chkconfig --levels 35 mysql on; 

8. Automatically start your MySQL service on boot up:

update-rc.d  mysql <options>;

9. Edit the file "/etc/hosts.allow" that's the hosts access control list for allowing access to services on your server from specific hostnames, IP addresses, networks, and FQDNs:

<service or wildcard>: <hostname> <ip address>/<subnet mask> <fqdn>

10. Edit the file "/etc/hosts.deny" that's the hosts access control list for denying access to services on your server from specific hostnames, IP addresses, networks, and FQDNs:

<service or wildcard>: <hostname> <ip address>/<subnet mask> <fqdn>

11. Allow incoming and outgoing client connections to your MySQL service through your firewall:

iptables -A INPUT -i <interface> -p tcp --dport 3306 -j ACCEPT

iptables -A OUTPUT -o <interface> -p tcp --sport 3306 -j ACCEPT

Do you have a suggestion about how to improve this blog? Let's talk about it. Contact me at David.Brenner.Jr@Gmail.com or 720-584-5229.

Comments

The meaning of time in reinforcement learning

Reinforcement learning (RL) is one of three basic machine learning paradigms, alongside supervised learning and unsupervised learning. Reinforcement learning is concerned with how software agents ought to take actions in an environment in order to maximize the notion of cumulative reward through the process of trial and error. In reinforcement learning an agent starts at an empty state then analyzes the available datasets according to a policy of positive states and negative states. Rather than being explicitly taught as in supervised learning the correct set of actions for performing a task, reinforcement learning uses rewards as signals for positive states and punishments as signals for negative states. The agent obtains the best path to a desirable reward as a cumulation of positive states and negative states. As compared to unsupervised learning, reinforcement learning is different in terms of goals. While the goal in unsupervised learning is to find similarities and differences...

Threat hunting polymorphic malware in Linux with Python

You can investigate suspicious activity that could be polymorphic malware by collecting relevant machine data from your endpoint. You can use the machine data to create your own analysis. Before you start your investigation you will need to determine normal activity on your endpoint. Normal activity is the scope of functionality of the software on your endpoint during periods of low activity and high activity. You will need some kind of software that periodically collects specific machine data from your endpoint like my software developed in Python that's available for free download at https://github.com/davidbrennerjr/server-stats-collector Ingest one or more of the following machine data from Category #1. Ingest one or more of the following machine data from Category #2. And ingest one or more of the following machine data from Category #3. Category #1 General system-wide error messages from /var/log/syslog Auditing logs of application rule...

Application behavior monitoring in Linux with Python

You can monitor application behaviors by collecting relevant machine data from your endpoint. You can use the machine data to investigate suspicious activity and create your own analysis. Before you start your investigation you will need to determine normal activity on your endpoint. Normal activity is the scope of functionality of the software on your endpoint during periods of low activity and high activity. You will need some kind of software that periodically collects specific machine data from your endpoint like my software developed in Python that's available for free download at https://github.com/davidbrennerjr/server-stats-collector Ingest one or more of the following machine data from Category #1. Ingest one or more of the following machine data from Category #2. Category #1 General system-wide error messages from /var/log/syslog Auditing logs of application rulesets Auditing logs of security contexts Auditing logs of ...

David Brenner Jr

Search This Blog