Is MySQL and PHP ADMIN MySql are diiferent?

[Hakoo]

Hello Friends,

I am working in JME. Now, I have situation in which, I suppose to connect with Database which has been used with PHP. So, How can I access to Mysql? As usual same as to connect mysql with JDBC? Is Mysql and Mysql in WAMP Server different?
Please Reply.

Thanking You,
Hakoo Desai.

[McLaren]

I think there is no difference. Actually I didn't even think that they might be different. And PHPMyAdmin is just a software for managing database.

[vibhaJ]

MySQL is a relational database management system.
Phpmyadmin is just a user interface with mysql.
There are some software based tool like Workbench, SQLyog, Mysql query browser and some web based application like phpmyadmin.

[Hakoo]

Thanks for replies.
Here the thing is, on our organization server, wamp server is installed but not MySql Essential, still they can connect. So, I installed it but now thing is configuration wizard goes failed and showing 3306 port is used. Still i can connect DB through MySQL command prompt. When I installed MySql GUI, MySql Administrator is not running and giving some dll file error.

I guess that if I uninstall WAMP server and then configure Mysql successfully and again install then it would work.

[vibhaJ]

Usually when you install WAMP, mysql is automatically configured.You don't need extra efforts.
After successful installation when you open http://localhost/phpmyadmin you can see phpmyadmin window.
Try to reinstall wamp.

[Hakoo]

But thing is that GUI mysql administrator can't be opened. Here I am attaching snap shots.

[TySkby]

I thought you were using phpMyAdmin, not Administrator for MySQL?

Your thumbnails looks like they're showing an error for Administrator for MySQL, which probably doesn't affect your MySQL installation.

Which system are you trying to use? Or is the problem that you can't access MySQL at all?

[Stefano Mtangoo]

Get MySQL workbench and give it a go. If you use netbeans it have services tab and there you can connect

[Hakoo]

Hello,
Those errors I am facing when I try to connect with MySQL Administrator GUI(MySQL WorkBench). MySQL server is working. In server, MyphpAdmin is installed and then I installed Mysql server and then Mysql Administrator. MySQL command prompt is working but GUI is not working and when I try to login, I am facing those errors which I attached before.

[Stefano Mtangoo]

Hello,
Those errors I am facing when I try to connect with MySQL Administrator GUI(MySQL WorkBench). MySQL server is working. In server, MyphpAdmin is installed and then I installed Mysql server and then Mysql Administrator. MySQL command prompt is working but GUI is not working and when I try to login, I am facing those errors which I attached before.

That have something to do with installation than PHP/MySQL. Just uninstall the whole thing and reinstall it!

[TySkby]

That have something to do with installation than PHP/MySQL. Just uninstall the whole thing and reinstall it!

+1 for this idea.

I would hazard to guess that you may have 2 MySQL installations going, since WAMP usually includes that in the installation, but much easier to just get a fresh start, I would think.

[Hakoo]

Ok, Thanks for all of your reply. Actually, Administrator was stated by itself without doing anything, but in other pc its working with same problem. I'll try and reply .

Thanking You,
Hakoo Desai

I haven't used WAMP, but I've never had a problem with XAMPP. I use SQLyog community version and sometimes MySQL Workbench. Much of a muchness.