Jump to content
xisto Community
Sign in to follow this  
lonebyrd

How To Use MySQL Monitor With XAMMP

Recommended Posts

I am taking the suggestions of other Xisto members, and trying my scripts out through Xammp before putting them on my website. Right now, I am reading the online book 'Practical PHP Programming' and learning some more about MySql, and trying to figure out how to use it without the PHPAdmin in Astahosts Cpanel. The book talks about a MySql Monitor, but I have no clue how to access that. I am using Xammp, and I have all my services running, but I'm just not sure how to use the MySql part of it. Is there a special way?

Share this post


Link to post
Share on other sites

I have not used the MySQL Monitor but you can see more about it HERE and from what I have seen it is a GUI just like phpMyAdmin (which you have with XAMPP) and you can access it by typing into the address bar LOCALHOST/xampp/ then select the phpMyAdmin link from the menu on the left hand side.

Practical PHP Programming is a great tool, it is a bookmark on my Firefox and a favorite in my Internet Explorer, you might just want to use phpMyAdmin on your local PC to try out some queries and import or export and all that.

Edited by Houdini (see edit history)

Share this post


Link to post
Share on other sites

I am taking the suggestions of other Xisto members, and trying my scripts out through Xammp before putting them on my website. Right now, I am reading the online book 'Practical PHP Programming' and learning some more about MySql, and trying to figure out how to use it without the PHPAdmin in Astahosts Cpanel. The book talks about a MySql Monitor, but I have no clue how to access that. I am using Xammp, and I have all my services running, but I'm just not sure how to use the MySql part of it. Is there a special way?


In xammp, you can access
\xampp\mysql\bin\winmysqladmin

it works like the SQLmonitor and is the default monitoring program for your host [localhost].

--

i recommend that you use phpmyadmin instead since in order to use sqlMonitor, you need to access the remote server fully. I doubt that hosting services will allow their database server to be connected from just anywhere in the network.

Rule of thumb, mySQL servers are 90% accesable only via localhost or ip 127.0.0.1 and the only computer that can connect to it is the physical computer where mySQL is running.

Your host account can see that server but i doubt other computers can see that database server as existing.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.