On Monday 02 August 2004 22:34, James Weisensee wrote:
> What does your '/etc/hosts' file contain? Sounds like
> it may have the following entry:
>
> 127.0.0.1 localhost.localdomain
>
> change it to:
>
> 127.0.01localhost
Actually, it has
127.0.0.1 localhost.localdomain localhost
From mysql's point of view, localhost and 127.0.0.1 are not the same thing.
When you connect with
mysql -h localhost -u root -p
or simply
mysql -u root -p
(localhost is the default), you are connecting via unix socket, so the
user=root, host=localhost entry is used. When you connect with
What does your '/etc/hosts' file contain? Sounds like
it may have the following entry:
127.0.0.1 localhost.localdomain
change it to:
127.0.01localhost
or
Yes, add 'localhost.localdomain' to mysql.user
another option, Why not just SSH to 'daisy' and issue:
shell> mysql -u root -p
a
Hi folks,
Now that I can connect to my MySQL server using the Unix sockets (e.g.
[EMAIL PROTECTED] ~] mysql -u root
I'm moving on to the next step - connecting via TCP/IP.
Since I don't have physical access to the box (well, I'm just too lazy to walk
down to the basement), I SSH into the box