The installation steps are quiet simple. OK, before installing the VirtualBox package you must have an idea about it. What is VirtualBox ? What does it mean ? Of-course, It is time that you knew about it! We can simply…
MySQL Create DB, table and Insert contents from command line
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…
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…