As Database
Admin, Linux Admin, or system admin, you must have come across this error
or situation,
Here I was
trying to see release details of the Linux operating system using the
lsb_release command but it failed with the below error.
On seeing
this error, I thought lsb_release was not installed on the server, so I tried
to...
Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts
To Know details about Linux OS :Oracle, PostgreSQL, MySQL and MongoDB
In
this small article, we are going to see different commands to check the OS
version in Linux and other details about the operating system
Here
are a few files and commands that can be used
1. Command uname:
Usage
uname -a [oracle@localhost
~]$ uname...
Installation of Python 3.10 on windows
This is going to be a short article with just a few steps for the installation of pythonStep 1: download python for windows for installation from https://www.python.org/downloads/windowsStep 2: click on .exe file for execution, you will...
Basic Operations on MySQL Users
In this article we are going to discuss about
different operations on mysql user like lock, unlock, grant, revoke etc.Lock-unlockExpire-unexpiredCheck privilegesRevoke privilegesChange passwordRename user (single user, multiple user)Drop
userUser list can be fetched using query mentioned below in the databaseselect
user,host,authentication_string,password_expired,account_locked...
Transferring file from one server to another server [FTP, SFTP, SCP etc]
There are number of ways to transfer file from one server to another server, below are the few methods to to achieve the same
ftp
sftp
scp
windows software (Filehippo, WinScp , FileZilla etc)
We will discuss these in details
1. FTP transfer
File Transfer Protocols basically is set of rules on computer network to communicate with one another....
ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
In previous articles, we have learned about user creation and grants in MySQL in detail, but there are a few privileges called global privileges that are meant to be granted to DBA accounts only
for example
PROCESS privileges is a global privilege.
we will try to grant it to user tech_user on author database
mysql>grant process...
MySQL: pid-file (process id file)
In previous articles have gone through options available with mysql_safe, one of the option is pid file i.e. process identifier file
The server writes its process id into pid file when mysql services are started and removes file when stopped.
The pid file is the means by which a server allows itself to be found by other processes.
Location
default...