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…
MySql
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 replace MySQL with PerconaDB on a cPanel server
Percona Server is an enhanced drop-in replacement for MySQL. Features of PerconaDB >> Your queries will run faster and more consistently. >> You will consolidate servers on powerful hardware. >> You will delay sharding, or avoid it entirely. >> You will…
How to upgrade MySQL from 5.1 to 5.5 in a cPanel server – command line option
MySQL is an open source RDBMS (Relational Database Management System) and its using the SQL Language(Structured Query Language). A database is a structured collection of data. SQL is the most commonly using language for database operations. By using SQL the…
reset mysql root password from command line Unix/linux
MySQL MySQL is a Relational Database Management System (RDBMS) that runs as a server providing multi-user access to a number of databases. Installation: [root@server ~]# yum install mysql-server mysql php-mysql [root@server ~]# rpm -qa|grep mysql php-mysql-5.1.6-40.el5_9 mysql-5.0.95-5.el5_9 mysql-server-5.0.95-5.el5_9 Steps to…