i recall i've managed to set up a connection to MySQL server using account root with the "password" item blank in Kdevelop. when i invoke mysqlaccess -uroot -p, it returned a prompt for password, i just hit return, but failed this time. mysqladmin -uroot got the same suituation with the error 111. i'm sure the default port 3306 isn't blocked by firewall, since i can access the server with the tool mysql. any port else invovled? thank u.
On 9/7/05, Ben <[EMAIL PROTECTED]> wrote: > yes, > You dont have an open account with root permissions > mysqladmin -u root passwd password > replace password with a real password > also check to make sure your firewall isnt blocking > your query if on a seperate network! > > hope this helps > > > -------Original Message------- > > From: 王静 > Date: 09/07/05 17:04:31 > To: mysql@lists.mysql.com > Subject: a confusing error: 111 > > hi all. > i've installed MySQL database server 4.1.14 under linux platform > After setting up the server successfully, i envoked mysqladmin, but > what i got is an error: can't connect to local MySQL server through > socket '/tmp/mysql.sock'(111) > is there anyone who ever run into similar problem and how to solve it? > thank u. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > nz > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
