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]