Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: MySQL Administrator, where it is and how to locate it

  1. #1
    vspunn NNTP User

    Default MySQL Administrator, where it is and how to locate it


    For the past few days I have been banging my head on the forum, for
    MySQL Administrator, to administrate MySQL database. But could not find
    it anywhere.
    What I need is a graphical interface to manage the MySQL, just like
    phpMyAdmin.
    I checked Control Center, install software but could not locate MySQL
    Administrator.

    Please help me. And pl. explain in laymans language


    --
    vspunn
    ------------------------------------------------------------------------
    vspunn's Profile: http://forums.opensuse.org/member.php?userid=3819
    View this thread: http://forums.opensuse.org/showthread.php?t=401880


  2. #2
    ken yap NNTP User

    Default Re: MySQL Administrator, where it is and how to locate it


    A search using zypper search mysql showed that it is in the repos:

    > | mysql-administrator | A MySQL Server Management, Configurat-> |
    > package


    It's not on the DVD so I assume it's in the OSS repo. Make sure you've
    subscribed to the OpenSUSE OSS repo in YaST.


    --
    ken_yap
    ------------------------------------------------------------------------
    ken_yap's Profile: http://forums.opensuse.org/member.php?userid=221
    View this thread: http://forums.opensuse.org/showthread.php?t=401880


  3. #3
    sahaittanmoy NNTP User

    Default Re: MySQL Administrator, where it is and how to locate it


    MySQL admin can be used from command line, but you need a GUI. So u'd
    have looked in the MySQL website. It's very easily available and used
    everywhere. Get it 'MySQL :: MySQL GUI Tools Downloads'
    (http://dev.mysql.com/downloads/gui-tools/5.0.html). You may download
    just the admin gui or all three Admin, Query Browser and Migration
    toolkit. Just go there and download.


    --
    sahaittanmoy
    ------------------------------------------------------------------------
    sahaittanmoy's Profile: http://forums.opensuse.org/member.php?userid=15921
    View this thread: http://forums.opensuse.org/showthread.php?t=401880


  4. #4
    tsu2 NNTP User

    Default Re: MySQL Administrator, where it is and how to locate it


    My GUI choice is knoda when a picture is worth a thousand words.

    Otherwise, command line is my preference.


    --
    tsu2
    ------------------------------------------------------------------------
    tsu2's Profile: http://forums.opensuse.org/member.php?userid=2578
    View this thread: http://forums.opensuse.org/showthread.php?t=401880


  5. #5
    vspunn NNTP User

    Default Re: MySQL Administrator, where it is and how to locate it


    I downloaded MySQL GUI and extracted it. There were four rpm files.

    Wht to do now.

    I also tried phpmyadmin. It says:Cannot load mcrypt extension. Please
    check your PHP configuration.

    What to do?

    Please suggest


    --
    vspunn
    ------------------------------------------------------------------------
    vspunn's Profile: http://forums.opensuse.org/member.php?userid=3819
    View this thread: http://forums.opensuse.org/showthread.php?t=401880


  6. #6
    sahaittanmoy NNTP User

    Default Re: MySQL Administrator, where it is and how to locate it


    vspunn;1910734 Wrote:
    > I downloaded MySQL GUI and extracted it. There were four rpm files.
    >
    > Wht to do now.
    >
    > I also tried phpmyadmin. It says:Cannot load mcrypt extension. Please
    > check your PHP configuration.
    >
    > What to do?
    >
    > Please suggest

    Use
    Code:
    --------------------
    rpm -ivh filename
    --------------------
    . Then access them from the Application menu. Do have configured the
    mysql from command line?? And regarding phpMyAdmin 1st you have to
    configure it using the configuration script.


    --
    sahaittanmoy
    ------------------------------------------------------------------------
    sahaittanmoy's Profile: http://forums.opensuse.org/member.php?userid=15921
    View this thread: http://forums.opensuse.org/showthread.php?t=401880


  7. #7
    janoholm NNTP User

    Default Re: MySQL Administrator, where it is and how to locate it


    I think you still can install query-browser and admin-tools from
    Software Maintance in YAST. I could do it in 10.3 and 11.0.
    Just make a search using "mysql" and click the package you want.

    Jan


    --
    janoholm
    ------------------------------------------------------------------------
    janoholm's Profile: http://forums.opensuse.org/member.php?userid=676
    View this thread: http://forums.opensuse.org/showthread.php?t=401880


  8. #8
    vspunn NNTP User

    Default Re: MySQL Administrator, where it is and how to locate it


    WHere can I find the configuration file and I could not understand the
    code for rpm file.
    I go to terminal and the type this or something else.

    Pl. explain


    --
    vspunn
    ------------------------------------------------------------------------
    vspunn's Profile: http://forums.opensuse.org/member.php?userid=3819
    View this thread: http://forums.opensuse.org/showthread.php?t=401880


  9. #9
    tsu2 NNTP User

    Default Re: MySQL Administrator, where it is and how to locate it


    Just another thought...

    You can also download and install Webmin which includes support for
    managing MySQL using a web interface.

    If you're new to Linux and don't have much incentive to learn command
    line, I'd strongly recommend that approach for all the things you'll be
    able to do instead of looking for GUI interfaces piecemeal.


    --
    tsu2
    ------------------------------------------------------------------------
    tsu2's Profile: http://forums.opensuse.org/member.php?userid=2578
    View this thread: http://forums.opensuse.org/showthread.php?t=401880


  10. #10
    vspunn NNTP User

    Default Re: MySQL Administrator, where it is and how to locate it


    I downloaded PhpMyAdmin and did the setup. It is in the folder
    srv/htdocs

    I am able to go to http://localhost/phpmyadmin

    Here if I enter the username as "root", I get the error message- Access
    denied.
    On using localhosta s the username, the error is "#1045 - Access denied
    for user 'localhost'@'localhost' (using password: NO)"
    There is no password for it.

    I have not changed any file inside phpmyadmin folder.


    --
    vspunn
    ------------------------------------------------------------------------
    vspunn's Profile: http://forums.opensuse.org/member.php?userid=3819
    View this thread: http://forums.opensuse.org/showthread.php?t=401880


Page 1 of 2 12 LastLast

Posting Permissions

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