MySQL error

View previous topic View next topic Go down

MySQL error

Post by ThunderBluff on 5th August 2008, 7:31 am

my MySQL Query Browser cant seem to connect to localhost as the server host
here is my typed in thing
serverhost:localhost port:3306
username:root
password:
default schema:odinms
i get error number 2003 cant connect to MqSQL server on 'localhost' (10061)
can anyone offer any aid? Let me think



ThunderBluff
Senior
Senior

Posts Posts : 373
Joined Joined : 2008-07-04
Gender Gender : Male
OS OS : Windows Vista Home Premium
Points Points : 31016
# Likes # Likes : 0

View user profile

Back to top Go down

Re: MySQL error

Post by Agent Cosmic on 5th August 2008, 9:28 am

I'm not a pro, but here's my guess.
Maybe
1) It's your firewall. So try switching it off or tweak the settings.

2) Go into c:\mysql\bin and right click the "mysqld" file and choosing run as.
Choose the first option (current user etc..) and hit ok.

3) The files are in the wrong place.
Removed the previous service.
/bin/mysqld-nt /remove
Then install the service.
/bin/mysqld-nt /install
Then edit the my.ini file, by opening winMysqladmin
/bin/winmysqladmin
That command having opened the program, then you should select 4th tab, which is the my.ini file.
You then edit the file to reflect where you had the files of MYSQL.
If the MY.ini said you had it under c:\mysql ....and you have it under another folder altogether....
Just copy the files from your current folder to the specified by my.ini




FunSubstance is the place to go for daily entertainment.

Agent Cosmic
Master
Master

Posts Posts : 3247
Joined Joined : 2008-03-07
Gender Gender : Male
OS OS : Windows 7
Protection Protection : ESET Smart Security
Points Points : 50488
# Likes # Likes : 0

View user profile

Back to top Go down

Re: MySQL error

Post by ThunderBluff on 5th August 2008, 2:52 pm

na those didnt help much cos number 2~3 i dont really understand what u r supposed to do..



ThunderBluff
Senior
Senior

Posts Posts : 373
Joined Joined : 2008-07-04
Gender Gender : Male
OS OS : Windows Vista Home Premium
Points Points : 31016
# Likes # Likes : 0

View user profile

Back to top Go down

Re: MySQL error

Post by rohndawson on 20th September 2008, 1:01 pm

An Access denied error can have many causes. Often the problem is related to the MySQL accounts that the server allows client programs to use when connecting.
---------------
rohn
Moderated Message:Link removed ~Doctor Inferno

rohndawson
Beginner
Beginner

Posts Posts : 1
Joined Joined : 2008-09-20
Points Points : 30040
# Likes # Likes : 0

View user profile

Back to top Go down

Re: MySQL error

Post by Nazzgull on 20th September 2008, 1:24 pm

@ThunderBluff wrote:my MySQL Query Browser cant seem to connect to localhost as the server host
here is my typed in thing
serverhost:localhost port:3306
username:root
password:
default schema:odinms
i get error number 2003 cant connect to MqSQL server on 'localhost' (10061)
can anyone offer any aid? Let me think

Probably Firewall. But i have one more opinion.
Hold Ctrl and Alt, than press Del and you will get Windows Task Manager. Try to find your server in Services list. Than you will know. Maybe off or on. Trust me you will know Smile



Nazzgull
Top Dog
Top Dog

Posts Posts : 2330
Joined Joined : 2008-08-03
Gender Gender : Male
OS OS : Windows 7 Professional
Points Points : 40505
# Likes # Likes : 1

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum