How Do I Login In MySQL Query Browser?

Bob_Binky · 11-06-2009, 04:32 AM

I keep getting the Error Number 2003

Could not connect to the specified instance

MySQL Error Number 2003
Can't Connect to MySQL server on localhost (10061)

If you want to check the network connection, please click the Ping Button

Pinging localhost
Reply from 127.0.0.1: Time = 0ms TTL = 128
Reply from 127.0.0.1: Time = 0ms TTL = 128
Reply from 127.0.0.1: Time = 0ms TTL = 128

I user "localhost" as my Service host

I even tried setting the username as root

I disabled my Firewall and uninstalled my anti-viruses...

MySQL Server is running but shuts down due to inactivity from time to time I think...

Additional details I can give:

Im using ---
Vista Home Premium 32bit
MySQL 5.0
MySQL GUI TOOLS 5.0
MySQL Connector ODBC 5.1.5

**wmorri** · 11-06-2009, 04:28 PM

Hi,

I would like to make sure that you can connect to your mysql server. I would recommend going on through the the root terminal, or command prompt in windows. Go in through root and make sure that it works.

I would also make sure that you have the user that you are trying to connect with actually in your system.

Cheers!

Bob_Binky · 11-06-2009, 11:36 PM

I can login now but I have a new problem...

I cant create a table in MySQL Query Browser....I cant find the optopn to create table

**wmorri** · 11-07-2009, 02:36 PM

Hi,

This is an easy one. you just type:

Code:

create table

I might recommend that you have a look at the documentation to refresh your memory on some of these basic terms.

Cheers!

11-06-2009, 04:32 AM	#1 (permalink)
Bob_Binky Registered User Join Date: Oct 2009 Posts: 18 OS: Windows Vista	How Do I Login In MySQL Query Browser? I keep getting the Error Number 2003 Could not connect to the specified instance MySQL Error Number 2003 Can't Connect to MySQL server on localhost (10061) If you want to check the network connection, please click the Ping Button Pinging localhost Reply from 127.0.0.1: Time = 0ms TTL = 128 Reply from 127.0.0.1: Time = 0ms TTL = 128 Reply from 127.0.0.1: Time = 0ms TTL = 128 I user "localhost" as my Service host I even tried setting the username as root I disabled my Firewall and uninstalled my anti-viruses... MySQL Server is running but shuts down due to inactivity from time to time I think... Additional details I can give: Im using --- Vista Home Premium 32bit MySQL 5.0 MySQL GUI TOOLS 5.0 MySQL Connector ODBC 5.1.5 Last edited by Bob_Binky; 11-06-2009 at 04:59 AM.

11-06-2009, 04:28 PM	#2 (permalink)
wmorri Moderator/Fedora Amb. Join Date: May 2008 Location: /pm/etc Posts: 2,805 OS: Window 7/Fedora 10 My System	Re: How Do I Login In MySQL Query Browser? Hi, I would like to make sure that you can connect to your mysql server. I would recommend going on through the the root terminal, or command prompt in windows. Go in through root and make sure that it works. I would also make sure that you have the user that you are trying to connect with actually in your system. Cheers! __________________ Linux Forever!

11-06-2009, 11:36 PM	#3 (permalink)
Bob_Binky Registered User Join Date: Oct 2009 Posts: 18 OS: Windows Vista	Re: How Do I Login In MySQL Query Browser? I can login now but I have a new problem... I cant create a table in MySQL Query Browser....I cant find the optopn to create table

11-07-2009, 02:36 PM	#4 (permalink)
wmorri Moderator/Fedora Amb. Join Date: May 2008 Location: /pm/etc Posts: 2,805 OS: Window 7/Fedora 10 My System	Re: How Do I Login In MySQL Query Browser? Hi, This is an easy one. you just type: Code: create table I might recommend that you have a look at the documentation to refresh your memory on some of these basic terms. Cheers! __________________ Linux Forever!