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

    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

  2. #2
    Join Date
    Jun 2008
    Location
    UTC+10
    Posts
    9,686
    Blog Entries
    4

    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.

  3. #3
    Join Date
    Nov 2008
    Location
    India
    Posts
    122

    Cool 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. You may download just the admin gui or all three Admin, Query Browser and Migration toolkit. Just go there and download.

  4. #4
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    10,823
    Blog Entries
    1

    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.

  5. #5

    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

  6. #6
    Join Date
    Nov 2008
    Location
    India
    Posts
    122

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

    Quote Originally Posted by vspunn View Post
    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.

  7. #7
    Join Date
    Jun 2008
    Location
    Denmark
    Posts
    68

    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

  8. #8

    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

  9. #9
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    10,823
    Blog Entries
    1

    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.

  10. #10

    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.

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
  •