How to access EasyPhp MySql Command Line

Whatever you do, always back you file using php admin all the database first before accessing mysql via command line. You don't want to screw up your database if anything happen. I did.


Go to Ms Dos command line.


Change the directory where your mysql folder is located for easyphp. Mine is as follow


C:\Program Files\EasyPHP5.3.0\mysql\bin>


Type the following command, i am accessing via root.


C:\Program Files\EasyPHP5.3.0\mysql\bin>mysql -p -u root


Once click enter. It will request password. Just enter cause normally it is blank.


That's all, screen shot below. You will get the idea..

How to access EasyPhp MySql Command Line

How to create mysql database backup file in cpanel

To save yourself from virus and trojan problem, one way to do it is to create back up files for your website. You should backup your home directory, mysql database, Email forwarders configuration and Email filters configuration.


By having back up files, it will help you to restore your wesbite back fast after it was hacked by virus or hackers. I had a terrible experience of Trojan problem, luckily got back up files to restore the site back.


The step to create mysql database backup file in cpanel is as stated below. Another way is to use Backup Wizard in Cpanel.


Step 1: Login to your Cpanel control panel


Step 2: Scroll below to Database


Step 3: Click on phpMyAdmin hyperlink


Step 4: On the left menu of phpMyAdmin, choose the database you wish to export the backup from.


Step 5: Click on the Export Tab.


Step 6: Click the Select ALL link shown in blue. The check Save as file and click GO.


Step 7: You will be asked to save the .sql file to the personal computer, select the folder and Click Save.


Step 8: Your database has now been exported.


Open your database file and verify the data is correct. Done !