How to install and configure MySQL on Cent OS

-
Here are the steps to install and configure MySQL on Cent OS :
  • Install MySql Server
    • yum install mysql-server mysql php-mysql
  • Set to Chkconfig to start on boot
    • chkconfig –level 235 mysqld on
  • Start the MySQL service
    • service mysqld start
  • Set the password for all domains
    • myql -u root
    • SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new-password');
    • SET PASSWORD FOR 'root'@'localhost.localdomain' = PASSWORD('new-password');
    • SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('new-password');
  • Exit and verify the MySQL version
    • exit
    • mysql --version
      • mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1




Comments

Post a Comment

Popular posts from this blog

How TOTP Works: Generating OTPs Without Internet Connection

-
Introduction Have you ever wondered how authentication apps like RSA Authenticator generate One-Time Passwords (OTPs) without requiring an internet connection? This fascinating technology is made possible through Time-Based One-Time Passwords (TOTP). In this article, we will explore the mechanics of TOTP, its security features, and why it doesn't rely on the internet at the client-side for generating OTPs. Understanding TOPT 1. TOTP in a Nutshell TOPT, or Time-Based One-Time Password, is a security feature designed to enhance the authentication process. It generates OTPs that are only valid for a short period, typically 30 seconds. TOPT uses a secret key, often shared between the server and the user's device, to generate these OTPs. The central idea is to provide a second factor of authentication, beyond just a static password, to strengthen security. 2. The RSA Authenticator App One popular example of a TOPT implementation is the RSA Authenticator app. This app is commonly use...
Read more

OWASP Top 10: A Beginner's Guide

-
Image
Welcome to the tech world! 🚀 As you start your journey into software development, it's crucial to understand how important security is. The OWASP Top 10 is a list of the most critical security risks for applications. Let's break it down in a simple, beginner-friendly way with real-world examples and tips! 1. Broken Access Control What's happening? Users can access data or functions they shouldn't be able to. Example: Imagine a website where anyone can change another person's profile information just by modifying the URL like: /edit-profile?userId=1234 . Tip: Always check on the server-side if the user is allowed to perform an action! 2. Cryptographic Failures What's happening? Sensitive information like passwords or credit card numbers isn't properly protected. Example: A site stores user passwords in plain text. If hackers get access, they immediately see the passwords! Tip: Always hash passwords using secure algorithms like bcrypt or...
Read more

Streaming Spring boot logs to ELK stack

-
Image
In my previous blog , we have done ELK installation on windows 10 and we have even tried to push messages from input console to Elastic Search and finally viewed on Kibana Server. I will write a separate blog on why do we need ELK? In this blog, I’ll show you how can we push spring boot application log directly to Elastic search using Logstash which we can analyze on Kibana and If you don’t know how to install ELK on windows 10 then you can refer my previous blog and start Elastic Search and Kibana server. Prerequisite Elastic Search and Kibana running on your machine Basic knowledge of Spring boot application If you don’t want to start your application from scratch then you can download one spring boot application from my GitHub repository as well. I am assuming that the Elastic Search and Kibana server are running on your machine and you have a fair idea of how to start the Logstash server and what is Logstash conf file. So, to push spring boot logs cont...
Read more