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 detection of zero-day attacks in Linux with Python

You can investigate suspicious activity that could be a zero-day attack 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: General system-wide error messages from /var/log/syslog Auditing logs of application rulesets Auditing logs of security contexts Auditing logs of login attempts from /var/log/auth.log Auditing logs of user management or group manageme...

Web app comparison of async and real-time

Advantages of asynchronous web apps Generic request/response structure Stateless session control Message queue management Token access based on serverside date-time format PostgreSQL paging using token-centric tables and functions Shared pools of resources per customer One-to-many security policies Single domain name with TLS cert over HTTPS Shared bandwidth for uploads/downloads No endpoint/device registration No direct access to server resources Web app aggregation as control panel A/B Testing Advantages of (near) real-time web apps Stateful session control On-demand communication protocols per customer Custom request/response structure per customer Custom date-time formats per customer Endpoint/device registration PostgreSQL paging using static tables and aggregate functions Immediate execution of requests Dedicated pools of resources per customer Dedicated TLS cert over HTTPS per customer Dedicated IP addres...

David Brenner Jr

Search This Blog