Hello, The easiest way to duplicate MySQL database is just using mysqldump command. Based on following variables: OS: CentOS 6.0 64bit MySQL root password: q1w2e3!@# Database name: grand_shopper Duplicate database name: grand_shopper_dev New database user: dev_user Password: D3eVVbf7 Firstly, since I just want to copy and duplicate database inside the same server, I need […]
See MoreTag: cpanel hosting
MySQL General Security Guidelines
Hello, 1. Do not ever give anyone (except MySQL root accounts) access to the user table in the mysql database! This is critical! 2. Learn the MySQL access privilege system. The GRANT and REVOKE statements are used for controlling access to MySQL. Do not grant more privileges than necessary. Never grant privileges to all […]
See More
Auto Start and Auto Shutdown Issue with VMware ESXi
Hello All, VMware has described this bug in details as refer to this link: http://blogs.vmware.com/vsphere/2012/07/clarification-on-the-auto-start-issues-in-vsphere-51-update-1.html. 1. As for me, I will need to download the patch for ESXi 5.0.0. Go to this page: http://www.vmware.com/patchmgr/findPatch.portal and login into your VMware account. Search with following criteria in that page: “ESXI (Embedded and Installable)” “5.0.0” “release date” […]
See More