Web Hosting Forum | Lunarpages
News: Server Migrations to San Diego: Deneb, Felix and Tsohea are moving to San Diego starting Tuesday, December 30, 2008 at 10pm Pacific. They will complete their moves Friday night, January 2, 2009

Isis, Seth and Ez-web-n-mail will move physically on Friday, January 2, 2009

Please see the forum posts at http://www.lunarforums.com/lunarpages_web_hosting_server_information-b54.0/

+ Submit Your Own Web Site for the January 2009 Site of the Month Contest!
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
January 07, 2009, 05:52:49 PM


Login with username, password and session length


Pages: [1]   Go Down
  Print  
Author Topic: Plesk & database management tool  (Read 917 times)
Jessamine
Trekkie
**
Offline Offline

Posts: 11


« on: March 27, 2008, 08:51:13 PM »

For some reason, I closed my original forum and planed to install a new 3-party application. (name: discuz!)

I have created a new Mysql database through Plesk but it connot work. When I install "discuz",it says "cannot connect the database, check the dbname and password."  I have checked my Mysql and password  and it seems no error.

I have test the application at another free web site and it works very well. I really have no idea what can I do to manage my Mysql through Plesk. May someone can give me some advices. Here are my questions:

1. My host is windows hosting.
    If lunarpages supports these softwares?
       a) httpd service(ex.  Apache、Zeus、IIS etc)
         b) php 4.1.0 or above  ----- I think this one is OK.
         c) Zend Optimizer 2.5.7 or above
         d) MySQL 3.23 or above -------> I think this one is OK.

2. How can I open  the Select/ update/ insert /delete/ create/alter/drop mode of my Mysql database from Plesk?

I guess it may something about the management of the Mysql database.

I really need some help. Please give me some directions. Thank you.
Logged
perestrelka
Administrator
Master Jedi
*****
Offline Offline

Posts: 1132



« Reply #1 on: March 29, 2008, 12:30:47 AM »

Hi Jessamine,

All your requirements are supported on our windows plans.

As for the MySQL management, there is phpMyAdmin available in Plesk that allows you to manage your database over the web.
Logged

Kind Regards,
Vlad Artamonov
Jessamine
Trekkie
**
Offline Offline

Posts: 11


« Reply #2 on: March 30, 2008, 07:34:53 PM »

Thank you. I am glad to "see" you again, because you are so nice.

I didin't find a phpMyAdmin tool on Plesk database section.
If any,there is one similar. The URL shows as .....phpmyadmin/index.htm on page tilte.(something like this.) Is this the right management page? But it is so difficult to handle,I cannot find a way to change my database access mod...etc., it even says that I have no privilege to creare table.
This one is more difficult than cpanel,I am confused. 
Can you give me some advice?

----------------------------------------------


AH,I think this is PhpMyadmin. I have one guestion. Should I learn SQL language for mysql database management? It's time spending for me. AH!
 
« Last Edit: March 31, 2008, 05:50:11 PM by Jessamine » Logged
perestrelka
Administrator
Master Jedi
*****
Offline Offline

Posts: 1132



« Reply #3 on: April 02, 2008, 02:23:35 AM »

Hi,

Yes, it is PhpMyAdmin. SQL knoweledge is not required to do basic management in it, but it would be advisable to learn it if you need something more advanced. As an alternative to PHPMyAdmin, you can setup an MySQL management tool on your PC and connect to the server as admin with Plesk administrator password to be able to make all the modifications to the databases. I would recommend to still create users and databases via Plesk in this scenario as they won't be listed in it otherwise.

I hope this helps.

P.S. Thanks for your kind words.
Logged

Kind Regards,
Vlad Artamonov
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.6 | SMF © 2006-2008, Simple Machines LLC

Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM