From a Python program, you can connect to MySQL database to access the tables and manipulate your data. For this, you should use one of the Python MySQL Libraries. While there are few of these libraries available, the most popular and stable is mysql-connector-python library. The mysql-connector-python library uses APIs that are complaint with the [...]
Ramesh Natarajan
Jenkins is an open source automation server, which will help you to build, deploy and automate your enterprise application. In Jenkins, after the install, it will launch a setup wizard and walk you through the initial security setup. But, if you like to create user accounts and restrict their privileges, you need to setup appropriate [...]
One of the most common MySQL operation is to change an existing value of a record in a table. In this article, we’ll explain how to use MySQL update command along with some helpful examples. The following are covered in this tutorial: Update All Rows Update Only Selected Rows Update Column Value with Expression DEFAULT [...]
When you create a new Chef cookbook, it will automatically create certain directories and files. You’ll then be adding your own custom files on top these default files and directories. For every chef cookbook you create, you’ll see 8 directories and 3 files under the top-level for that particular cookbook. In this tutorial, we’ll explain [...]
Q: I have multiple yum repositories on my system. For example, centos, epel, docker, mongo, etc. When I execute yum update command, installed packages from all the repositories are updated. How can I exclude a specific repository during yum update? A: During yum update, to exclude packages that belongs to a specific repository, use any [...]
By default MySQL database will be created under /var/lib/mysql directory. This might be Ok if you are running a small database that doesn’t take much space. But on production, for a larger database, you might not have enough space under root partition. In that case, you may want to move your MySQL database from root [...]
If you have PostgreSQL running in your environment, managing it from command-line might be bit difficult as you have to remember all the db commands and syntax. If you are MySQL DBA, you might notice that there is a slight difference in the syntax for few of the commands in PostgreSQL. Also, some of the [...]
Redis is an in-memory key-value pair database. Redis is extremely fast, as the operation happens in the memory. Redis also provides on-disk persistence and built-in replication. In Redis, you can use these data structures: 1) String 2) Hash 3) List 4) Set 5) Sorted Set. There is no integer or float data type in Redis. [...]