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. You may download just the admin gui or all three Admin, Query Browser and Migration toolkit. Just go there and download.
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.
> I downloaded PhpMyAdmin and did the setup. It is in the folder
> I am able to go to http://localhost/phpmyadmin
> Here if I enter the username as “root”, I get the error message- Access
> 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
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
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