How to reset your root MySQL password

Stop the MySQL process # service mysqld stop Once MySQL has stopped, restart it with the –skip-grant-tables option # mysqld_safe –skip-grant-tables & or edit your /etc/my.cnf file to add the line skip-grant-tables Connect to MySQL using the root user. mysql -u root Once logged in, you should see the following prompt: mysql> Enter the following […]

Read more
Reset SonarQube Admin User Password

Reset SonarQube Admin User Password by default sonar creates admin account : user: admin, password : admin Start root access to mysql database mysql -uroot -p Copy Bash Check if sonar database exists. show databases; Copy SQL use sonar; Copy SQL Reset admin user to admin password. update users set crypted_password = ’88c991e39bb88b94178123a849606905ebf440f5′, salt=’6522f3c5007ae910ad690bb1bdbf264a34884c6d’ where […]

Read more
git cmd

git pull # will get you repo updates git add . # will add files in your dir git add [dirname]/* # will add files under a new dir git commit -m “your comment“ # will commit your code to your changes git push # will push your code to a reposatory git pull # […]

Read more
Git Fundamentals

Git Fundamentals   Topics To be Covered Installation 2. Setup 3. Creating a Project 4. Checking the status of the repository 5. Making changes 6. Staging the changes 7. Staging and committing 8. Commiting the changes 9. Changes, not files 10. History 11. Aliases 12. Getting older versions 13. Tagging versions 14. Discarding local changes […]

Read more
Setup and Run Jenkins

Installing Jenkins: Download latest or specific version you want to install from here. For example: $ wget https://updates.jenkins-ci.org/download/war/2.123/jenkins.war Starting Jenkins The easiest way to execute Jenkins is through the built in Jetty servlet container. You can execute Jenkins like this: $ java -jar jenkins.war Of course, you probably want to send the output of Jenkins to […]

Read more
How Remove Files completely from git repository history

It is straight forward to remove a file from the current commit or HEAD but if you want remove entirely from the repository’s history then you need to run couple of commands. It took some trial and error for me to find something that worked for me Find out the path fo the file in […]

Read more
Create a HTTPS proxy for jenkins using NGINX

Create a HTTPS proxy for jenkins using NGINX In situations where you have existing web sites on your server, you may find it useful to run Jenkins (or the servlet container that Jenkins runs in) behind Nginx, so that you can bind Jenkins to the part of a bigger website that you may have. This document discusses […]

Read more
ssh tunnel for RDS AWS

ssh tunnel for RDS via bastion host Our RDS db is hosted on Amazon. Our Bastion(Jumphost) can connect to the db. Connections to the db are not allowed outside of the internet.     Run ssh tunnel locally: This creates a tunnel from my local machine to the Bastion: ssh -N -L 3307:my-rds-db.us-east-1.rds.amazonaws.com:3306 ec2-my-bastion-server.compute-1.amazonaws.com This will forward […]

Read more
Adding SMS Notifications to Your Bash Scripts

Cost Note: The first 100 text messages / month are free. After that, you may start incurring charges. Step 1: Create an Appropriate AWS User Start by creating a new User or Group in AWS with the appropriate privileges. You do NOT want to use your root account in production, for security reasons. I would suggest […]

Read more
oracle databases server

oracle databases server create database TEST MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 ‘C:\oraclexe\app\oracle\oradata\TEST\REDO01.LOG’ SIZE 50M BLOCKSIZE 512, GROUP 2 ‘C:\oraclexe\app\oracle\oradata\TEST\REDO02.LOG’ SIZE 50M BLOCKSIZE 512 DATAFILE’C:\oraclexe\app\oracle\oradata\TEST\SYSTEM.DBF’ size 100m autoextend on sysaux datafile ‘C:\oraclexe\app\oracle\oradata\TEST\SYSAUX.DBF’ size 100m autoextend on undo tablespace undotbs1 datafile ‘C:\oraclexe\app\oracle\oradata\TEST\UNDOTBS1.DBF’ size 100m autoextend on CHARACTER SET AL32UTF8 […]

Read more

Hit Counter provided by dental implants orange county