Since you can connect on the server, the install should be fine. There is no setup program. You just unzip it to your hard drive. Use mysqlCC or some other tool on the server to change users/passwords. This is in the mysql.user table. Make sure that the host column is set to % and not just localhost also.
mysql test -h localhost -u username -ppasswd- Access denied using PW (YES)
--I would delte the my.ini file(don't know if 4.1.1 even uses that)>I don't use one. --the reason you can connect from localhost is because a password is not set. --search for all issues regarding passwords with 4.1.1(docs,readme's,release notes/known issues)
hope this helps
brian
[EMAIL PROTECTED] wrote:
OK. Thanks. Late now, and laptop is off. Client is the mysql.exe program.
I have to copy the mysql.exe to the laptop (or cd to the server machine and execute from it. Leave the space out.
Right now, just fooling around from the server machine:
mysql test -h localhost - works fine. mysql test -h localhost -u username
- works fine
mysql test -h localhost -u username -ppasswd
- Access denied using PW (YES)
I use the pw that is in the my.ini
Using any of the above fails to allow connection using the laptop--but I'll try again tomorrow.
I suspect I did something wrong in the install, though everything seems to work from the host machine.
I unzipped the the 4.1.1 catalog in winzip, read the readme that said "run setup". There was no setup so I simply unzipped to the \temp directory. I ran mysqladmin, mysql, the mysqlcc (control center) and all worked. It did not install like a 'regular' program (put itself in the add software list in control panel), so I simply moved all the files to a mysql directory and everything continued to work. Had to be too simple.
Well, I'll let you know if connecting from the laptop works.
chris
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 6:40 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Can't connect to MySQL server on 'localhost' (10061)
I've executed the mysql -h ip -u user -p pw
No space after -p. I know it's weird, but it's the only way it will work. So, use this: mysql -h ip -u user -ppw
With the result that I get asked for a PW and then told I can't connect.You shouldn't get asked for PW if you use the above syntax correctly.
But, I don't have the 4.1.1 client. Where is it?
If you downloaded mysql4.1.1 to your laptop, then you have it. Otherwise: http://www.mysql.com/downloads/mysql-4.1.html
There is no '...client' in the bin directory.
By client, I mean the mysql file in the bin dir. If you set your system path, you won't need to actually be in the bin dir.
Otherwise you need to cd to that dir. So the entire proc is:
1.Open command prompt.
2.cd C:\mysql\bin
3.mysql -h ip -u user -ppw
-- This mail composed and sent using Mozilla Thunderbird. (http://www.mozilla.org/projects/thunderbird/)
-----It's a brave, GNU world!(sorry Bill)------
http://www.linux.org
OpenSource is aimed at skilled users, not the 3l33T3 war3z crowd. (1f U sp3ll l1k3 th1s, gu3ss wh1ch U R)
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
