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
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.
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.
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.
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.
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:
If you already have everything installed you’ll want to start at the
‘phpMyAdmin’ (http://tinyurl.com/a65dyt) part. Though I suspect you’ll
be more interested in the mysql part just above it.
vspunn;1911550 Wrote:
> 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
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
Code:
cd Desktop/squel/ mysql-gui-tools-5.0r12-suse10-i386/
su
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’
(http://en.opensuse.org/Linux_Apache_MySQL_PHP_Server_(lamp))
It is pretty good. And thanks axeia.
– if it aint broken…dont let me near it and power to the GUI only
GANG!
You check this out too ‘The Perfect Server - OpenSUSE 11.1 - Page 3 |
HowtoForge - Linux Howtos and Tutorials’
(http://www.howtoforge.org/perfect-server-opensuse-11.1-p3) 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’
(http://tinyurl.com/45rayq)