MySQL Forums
Forum List  »  Newbie

Solotion of errno: 10060(1)
Posted by: Sebastian Busek
Date: August 01, 2009 06:32AM

hello, i had problem with mysql no. 10060 and I looked solution, but a lot of tips was... gimcrack...

So, this is my tip for you:
First, you must enable connect to db from other place than localhost -> go to /etc/mysql/ and edit my.cnf -> look for 'listen = 127.0.0.1' and add '#' (comment) ahead 'listen = ...'.
This make: provide connect from other place; not only from localhost.

Second (i advice you do this), make new user. In mysql command line write:
"CREATE USER 'newuser'@'%' IDENTIFIED BY 'password';"
this make new user, whitch can connect from anywhere, and add privileges:
"GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'%' WITH GRANT OPTION;"
this add all privileges to your new user.

restart mysql a try connect to db with new user.
in my case it works!

(sorry for my bad english... :)

EDIT: test on Ubuntu-9.04-server-version with mysql 5.0 and connecting to db with Navicat for MySQL (client)



Edited 3 time(s). Last edit at 08/01/2009 06:36AM by Sebastian Busek.

Options: ReplyQuote


Subject
Written By
Posted
Solotion of errno: 10060(1)
August 01, 2009 06:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.