MySQL – Pain with port 3306 error message

While trying to setup MySQL 5.x on windows getting following error.
Running zone alarm. Later frustrated with Zone Alarm Free Edition and moved to comodo fire wall. It looks good and having many options to configure.

Problem:

Error Nr. 1045…. Please make sure you have opened the TCP port 3306.

mysql port 3306 error

Solution: Port 3306 is opened. Still getting error
solution

First first time setup dont enter root password. This is causing problem and mysql is giving wrong error message.

-o-

Problem 2: MySQL Browser is wrong name. It permits to do database schema creation, table creation, enter data in editable grid and similar. But Coming from MySQL CC to this environment is painful. Also it is little bit confusing for first few minutes.

Default user name is: root
mysql admin

Default Schema is : test
mysql browser

To edit data in grid, we need to do following steps
Step 1:
mysql enter data - Step 1

Step 2:
mysql enter data - Step 2

Now ready to play with MySQL….

-o-

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s