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
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.
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.
My GUI choice is knoda when a picture is worth a thousand words.
Otherwise, command line is my preference.
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
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.
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
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
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.
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 wrote:
> 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.
Been ages since I played w/phpMyAdmin, but I’ll hazard a guess anyway.
The “root” user you’re entering shouldn’t be the system root user - it
should be the mysql root user. When you installed mysql and started it
for the first time it should have printed some instructions on setting a
root password:
/usr/bin/mysqladmin -u root password <password>
/usr/bin/mysqladmin -u root -h <hostname> password <password>
This is a user/password w/in mysql itself and is completely different
than the system root user/password.
Localhost is the an alias for your machine, not a user.
Kevin Miller
http://www.alaska.net/~atftb
Juneau, Alaska
Registered Linux User No: 307357, http://counter.li.org
You may want to look at the LAMP howto that I recently added to the openSUSE site.
If you already have everything installed you’ll want to start at the phpMyAdmin part. Though I suspect you’ll be more interested in the mysql part just above it.
Well:
Suppose you have downloaded the file in a folder named squel which is located on desktop. now open the folder squel, rightclick on the file mysql-gui-tools-5.0r12-suse10-i386.tar.gz, click extract here. then open terminal and use
cd Desktop/squel/mysql-gui-tools-5.0r12-suse10-i386/
su
Enter the root password
rpm -ivh mysql-gui-tools-5.0r12-1suse10.i586.rpm
rpm -ivh mysql-administrator-5.0r12-1suse10.i586.rpm
rpm -ivh mysql-query-browser-5.0r12-1suse10.i586.rpm
rpm -ivh mysql-migration-toolkit-5.0r12-1suse10.i586.rpm
U’ll find the GUI tools in menu.
I have had recent troubles with the step from mysql to phpMyAdmin. No matter how I try I cant set root password for mysql server. So i dont! I leave that step until phpMyAdmin is up and running. check out the how to Linux Apache MySQL PHP Server (lamp - openSUSE
It is pretty good. And thanks axeia.
You check this out too The Perfect Server - OpenSUSE 11.1 - Page 3 | HowtoForge - Linux Howtos and Tutorials or this if you don’t want to use apache. I always think lighttpd is a simpler but powerful webserver than apache, Installing Lighttpd With PHP5 And MySQL Support On OpenSUSE 11 | HowtoForge - Linux Howtos and Tutorials