Skip to main content

Posts

Showing posts with the label mariadb

Automated API Monitoring & Status Page

Have you ever thought about setting automated API monitoring? If yes, then it is good idea to setup an open source status page as well for your APIs. This way, you can establish trust and provide a view to your clients to check how your APIs are behaving over past few days. There could be several other ways to implement this, but this is what I am going to propose. Basically, we can interconnect few systems together and automatated API monitoring and status page. The workflow will be something like this: Build API monitoring script using Postman tool Export Postman collection Install following softwares on AWS EC2 instance: Jenkins (Installation steps in serarate article) Cachet (Installation steps in serarate article) MariaDB (Installation steps in serarate article) Newman (Command Line Postman Utility) (Installation steps in serarate article) Setup Jenkins job and configure postman collection using Newman Configure Jenkins job to run periodically Next, when ...

MariaDB / MySQL - Access denied for user 'root'@'localhost'

I am using MariaDB for one of the project and today I encountered some weird issue while connecting from command line. For those who are not familiar with MariaDB - it is basically open source version of MySQL . Click here to get more information about MariaDB. Also, click here to read various MariaDB articles, basic commands, etc. You can access various training tutorials here . Alright, so I was trying to login to MariaDB from my Ubuntu Command Prompt but I was constantly getting error: Access denied for user 'root'@'localhost' I was going in various directions, but the solution to this problem was very very simple. I just had to run the login command with sudo , can you believe it? If prompted, you will have to type sudo password. Just so you know, default password for MariaDB root user is <nopassword> , that's right, it does not have any password. P.S. Click here to access my other posts.