How to access mysql database without conrtol panel ?

[Redinit]

Thanks...

Btw I got an email notification describing a user (with my same ip) is entered in solusVM controle panel with the time of login. But that is not me. My IP also changed now. Is it possible ?

What makes you think it's not you? Just because you have a different IP now, doesn't mean you had a new one at that time of login. If they didn't screw with anything than it was probably you. But it doesn't hurt to change your login. Be sure to ALWAYS use SSL when logging into the control panel.

For one, I would NOT install PHPMyAdmin, Webmin or anything else on the Dom0 or DomU of the MasterGUI. Doing this will just increase the software hackers can exploit. There is no need to install PHPMyAdmin, nor should you be using the MySQL server for anything else but SolusVM.

If this is a seperate VM, than PHPMyAdmin is fine, but at the same time will be an overkill if you just want to create a user.

Refer to here for MySQL commands. http://wikiduh.com/508/essential-mys...ds-cheat-sheet

[jasoothai]

Be sure to ALWAYS use SSL when logging into the control panel.

Sorry, I am noob. How to use SSL when login ?

There is no need to install PHPMyAdmin

Without phpmyadmin, Can I execute SQL queries ?

Refer to here for MySQL commands. http://wikiduh.com/508/essential-mys...ds-cheat-sheet

Thanks for the link.

[Redinit]

Sorry, I am noob. How to use SSL when login ?

Without phpmyadmin, Can I execute SQL queries ?

Thanks for the link.

Yes, remember, a control panel is just a layer between you and the command line. Everything a control panel does you can do via the command line. Sometimes its faster and more secure to just do it via the command line.

To use SSL for solus, use https://example.com:5656 for login

[jasoothai]

Thank you Redinit.

[Cometolearn]

u can use ssh

[jasoothai]

okey Cometolearn.
Can anyone tell me what are the essential things to be installed to secure and speed up VPS after installing LAMP ? Thanks.

[Sp32]

http://www.besthostingforums.com/13-...ysqltuner.html

[jasoothai]

Thank you for giving link, I heard about eaccelerator, policycoreutils, clamAV etc. Do they are important in configuring a VPS ? Thanks.

[Redinit]

Securing your server is more involved. You want to secure each piece of sotware. SSH/MySQL/PHP, etc..

[feronso]

ClamAV is a antivirus for linux distributions, Its very easy to install and keep up to date. eAccelerator is a PHP cache module which boost your website browsing by saving already browsed pages where called PHP functions. it also help your VPS to reduce the memory.