Try redoing from scratch but this time dont use a client just use command line!
> yeah, i can access the database server normally with the client mysql. > it works all right. the point is mysqladmin doesn't work. > > Thank u. > > On 9/7/05, 王静 <[EMAIL PROTECTED]> wrote: > > On 9/7/05, Ben <[EMAIL PROTECTED]> wrote: > > > What linux where you using? > > > > RedHat linux 2.4.21 > > > > > A blank password is not a good idea, I'm > > > not sure if it is allowed anyway. > > > > yeah, i know. so what i'm trying to do is adding/changing password for > > the only account root with the tool mysqladmin. but the error occured > > as i've posted before > > > > > I had the same prob with SuSE 9.3 > > > and I updated MySQL and the problem > > > left, But also you get the error when the account > > > is not set properly. > > > Can you log into # mysql -u root test > > > ? > > > > yes, i can log into #mysql and get the prompt mysql> > > > > Thank u. > > > > > -------Original Message------- > > > > > > From: 王静 > > > Date: 09/07/05 17:52:52 > > > To: mysql@lists.mysql.com > > > Subject: Re: a confusing error: 111 > > > > > > 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] > > > nz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]