Plesk - How to access MySQL from the command line?
Sunday, July 29th, 2007You can use this command on command prompt -
mysql -umysql_user -pmysqlpass
You can use this command on command prompt -
mysql -umysql_user -pmysqlpass
For more information check –
http://support.microsoft.com/?id=907733
Here are some usefull links for installing ROR –
Installing on Linux –
http://wiki.rubyonrails.org/rails/pages/HowtoInstallAndRunRubyOnRailsOnCpanel
Installing Rails on Windows –
http://wiki.rubyonrails.org/rails/pages/RailsOnWindows
A vulnerability has been identified in SWsoft Plesk, which could be exploited by attackers to gain unauthorized access to arbitrary files on a vulnerable system. This issue is caused by input validation errors in the “login.php3″ and “login_up.php3″ scripts when processing the “locale_id”, which could be exploited to conduct directory traversal attacks and disclose the contents of arbitrary files.
Affected Products
SWsoft Plesk version 7.6.1 for Windows
SWsoft Plesk version 8.1.0 for Windows
SWsoft Plesk version 8.1.1 for Windows
Here is what you can do –
Apply patch for Plesk 7.6.1 :
http://download1.swsoft.com/Plesk/Autoupdate/Windows/7.6.1/
Apply patch for Plesk 8.1.0 :
http://download1.swsoft.com/Plesk/Autoupdate/Windows/8.1.0/
Apply patch for Plesk 8.1.0 + plesk_8.1.0_update070216.19 :
http://download1.swsoft.com/Plesk/Autoupdate/Windows/8.1.0.3/
Apply patch for Plesk 8.1.1 :
http://download1.swsoft.com/Plesk/Autoupdate/Windows/8.1.1/
For further details check this –
http://kb.swsoft.com/en/1798
http://www.frsirt.com/
cd %plesk_dir%\mysql\bin
mysql -uadmin -p<admin_pass> -P8306 psa
8306 is the admin mysql port used by plesk and psa is the plesk database
To access to clients mysql use the same string except port. Clients mysql uses standard port 3306
mysql -u<clientdatabaseusername> -p<databasepass> -P3306 <clientdbname>
1. Download the PHP Installer
Download your favorite php version here: http://www.php.net/downloads.php
,and choose the windows installer
2. Installing PHP
Run the installer and choose Advanced Setup
Choose the path for your PHP installation
Choose the directory for temporary files (it’s recommended to use the default path)
Insert your smtp details
Now choose what kind of errors you want php to show ( Display all errors,warnings and notices is recommended only when you’re developing your website.If you have already completed the developing steps it’s better to choose Display all errors and warnings only).
Now select your webserver (On windows 2003 IIS 6.0 it’s the default webserver).
Select now the extensions you want to be run by php
Now click next to let the installation run on your server. Once the installation is complete reboot the server first.
3. IIS Configuration
Now open IIS,select Web Service Extensions on the left frame and check that PHP extension is allowed.If not click on Add a new Web service Extension and ,for the extension name,choose PHP, And in the required file field choose the isapi.dll file that you’ll find in the php directory.
4. PHP.ini file
Sometimes the installer,due to some permission problems,could not copy the php.ini file in the Windows directory. So select the php.ini file that you’ll find in the php directory and copy it in the C:/Windows directory.
5. Testing
Create a new text file and rename it “index.php”. This file should contain one line that reads:
<?
phpinfo();
?>
Simply copy this file to your web server and open it via your web browser. You should see a page like this one in the following screenshot:
Linux
free -m
free -k
cat /proc/meminfo
Windows
windows control panel -> system -> right in the general tab on the bottom.
Thank you ![]()
Happy Bloging
Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!