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
(two
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
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
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