Web Hosting Forums

Results 1 to 3 of 3

This is a discussion on Sql in Plesk in the Hosting Talk & Chit-chat forum
How can we do this update in Plesk (linux) ...

  1. #1
    take it easy ... arianetwork's Avatar
    Join Date
    Mar 2006
    Location
    Hungry
    Posts
    110

    Sql in Plesk

    How can we do this update in Plesk (linux)


  2. #2
    Nearly 100% Pure Carbon thecoalman's Avatar
    Join Date
    Nov 2007
    Location
    Northeast Pennsylvania
    Posts
    690
    Assuming you have Administrator access to the control panel you can do it with phpmyadmin. After creating the new account in Plesk:

    On the left under system click "server", in the main frame click Database Servers.

    This will give you list of databases installed on machine, under hostname you should have a listing for MySql "Local MySQL server (default for MySQL)". Click the little icon all the way to the right for DB Admin which will open up phpmyadmin with admin privileges.


    If you want to grant Global permissions to a user select the privileges link.

    If you just want to alter privileges for a single database select the database on the left from the drop down menu. Click the tab on the top for privileges. Next to the users name all the way to the right select the icon for "edit privileges".


    ----------------------
    I believe by default when you create a new user all privileges are granted except "grant" which allows them to grant privileges themselves.

    Note untested as I've never had reason to do it and I don't know if there is any "gotchas" with Plesk but I see no reason why there should be.

  3. #3
    take it easy ... arianetwork's Avatar
    Join Date
    Mar 2006
    Location
    Hungry
    Posts
    110
    Quote Originally Posted by thecoalman View Post
    . Click the little icon all the way to the right for DB Admin which will open up phpmyadmin with admin privileges.

    when i click on this icon it shows me this message :

    Please type in the password to login as the database user *

    first i don't have this password for all of my accounts and second when i enter correct password i can't login to my phpmyadmin

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •