We already discussed some basics of MySQL database management. Here is some more command line usages of MySQL with example. 1. To connect to MySQL we can use the command # mysql -u root -p Then, enter the MySQL root…
Author: Arunlal A
Senior System Developer at Zeta. Linux lover. Traveller.
Let's connect! Whether you're a seasoned DevOps pro or just starting your journey, I'm always eager to engage with like-minded individuals. Follow my blog for regular updates, connect on social media, and let's embark on this DevOps adventure together!
Happy coding and deploying!
How to get the MySQL root password details – cPanel
The MySQL server saves its root password in a file “.my.cnf” under the root directory. You can find out its from the file as I mentioned. Example: root@server [~]# cat /root/.my.cnf [client] password=”)%:pV(Yo” user=root If you were loged in to…
How to create a New Database-user and Grand Permissions – MySQL
We already discussed about the creation of MySQL DB and DB users. Here I am explaining the commands which are using to Grand Privileges to users for accessing the Databases in your server. Enter the mysql prompt by following the…
How to create a database and database user from command line
This is actually the base of MySQL command usage. By the help of a control panel we can simply create a database, create DB users, edit variables, set previeages etc. But in some situations it is necessary to manage these…
How to access MySQL without knowing its password in a Plesk server
Here I am explaining how you can access MySQL without knowing its password in a Plesk server. # mysql -uadmin -p`cat /etc/psa/.psa.shadow` The above command is used to access MySQL without prompting for a password. In case, if you need…
Repository details for PerconaDB – CentOS 5, 6 & Redhat 5, 6
To download and install PerconaDB on your server instead of MySQL the server must have a repo file which has PerconaDB details. Do follow the steps below to create a repo for PerconaDB. Step 1 : Login to server via…
15+ Rkhunter usages with example – Unix/Linux
We have already discussed about the installation of Rkhunter on Linux machine, Refer this Steps to install Rkhunter. Here I am explaining some common uses/switches of Rkhunter with examples. Switches with example: 1, -c, –check Check the local system. –config-check…