Database management can actually be made easier with phpMyAdmin especially when you've to perform on the fly operations but don't want to drop to the console of your VPS.
1. SSH into your VPS
2. Switch into your docroot for your site (eg. cd /usr/local/apache2/htdocs)
3. Run: wget http://localhost/phpMyAdmin-3.3.5-all-languages.tar.gz
4. Run: tar xvzf phpMyAdmin-3.3.5-all-languages.tar.gz
5. Rename the directory: mv phpMyAdmin-3.3.5-all-languages pmadmin
6. Run: vim config.sample.inc.php
7. Type: :set number
8. Type: :18
9. Press INSERT
10. Edit: $cfg['blowfish_secret'] = 'addsomethingsecrethere';
11. Press ESC
12. Type: :wq config.inc.php
13. Open your browser on your computer and access your VPS site (eg. YOUR_VPS_IP/pmadmin)
14. Login with your root username and password
If you see your databases you have successfully installed phpMyAdmin, if not review your config.inc.php as your particular configuration, if customized, can impact default or assumed values.
Notes:
* The elements in red are version dependent, you should always check the official site for the latest version of phpMyAdmin for security purposes.
* Any MySQL user with privileges to access a database can utilize phpMyAdmin for administration of those databases, they will be limited to what they have access to only.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Confused? Feel free to ask
Your feedback is always appreciated. I will try to reply to your queries as soon as time allows.
Note:
Please do not spam Spam comments will be deleted immediately upon my review.