thanks but

[root@x1-6-00-b0-d0-16-1c-01 etc]# cat hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost localhost
# ::1 localhost6.localdomain6 localhost6
[root@x1-6-00-b0-d0-16-1c-01 etc]#

had no effect

This seemed to start when I switched to cable internet!

I want to see if the /etc/sysconfig/network file has anything to do with it.
So change the line in /etc/sysconfig/network to
HOSTNAME=LMKIII
Reboot. Is it now LMKIII

Also what is the output from the command ' route '

Without going through the whole start of bash terminal which makes calls from /etc/profile, /etc/bashrc, Your own home .bashrc, .profile, and some others.

Brian

thanks! That worked as you can see on my prompt below

with the results of route displayed.

I hope mysql gives no problems with the hostname!

BTW what is the actual IP address of my computer?

This all started when I switched to cable internet!


[root@LMKIII ~]# route
Kernel IP routing table
Destination Gateway Genmask Flags Metric Ref Use Iface
192.168.122.0 * 255.255.255.0 U 0 0 0 virbr0
72.47.28.0 * 255.255.254.0 U 0 0 0 eth0
link-local * 255.255.0.0 U 0 0 0 eth0
default doc-72-47-28-1. 0.0.0.0 UG 0 0 0 eth0
[root@LMKIII ~]#


[root@LMKIII ~]# netstat -rn
Kernel IP routing table
Destination Gateway Genmask Flags MSS Window irtt Iface
192.168.122.0 0.0.0.0 255.255.255.0 U 0 0 0 virbr0
72.47.28.0 0.0.0.0 255.255.254.0 U 0 0 0 eth0
169.254.0.0 0.0.0.0 255.255.0.0 U 0 0 0 eth0
0.0.0.0 72.47.28.1 0.0.0.0 UG 0 0 0 eth0
[root@LMKIII ~]#

I was hoping to see x1-6-00-b0-d0-16-1c-01 in the route but not being found there. One more thing I see odd is the /etc/hosts file and the duplicate localhost words. I don't think you need the last one in the chain.
127.0.0.1 localhost.localdomain localhost

May return your /etc/sysconfig back to what it was and remove the last localhost from the /etc/hosts file. Doubt it would make a difference but my only has one.

What is in /etc/host.conf?

This just eludes me to what is going on. i would love to know why it is doing it like that on yours. Maybe something will come to me.

Brian

LMKIII (landon4) ~ [330]>mysql --user='landon@LMKIII' --password='rumprocella'
ERROR 1045 (28000): Access denied for user 'landon@LMKIII'@'localhost' (using password: YES)
LMKIII (landon4) ~ [331]>mysql --user='landon@localhost' --password='rumprocella'
ERROR 1045 (28000): Access denied for user 'landon@localhost'@'localhost' (using password: YES)
LMKIII (landon4) ~ [332]>

mysql is inserting localhost. I believe this is a strange characteristic of mysql and one must enter the exact code it wants!

thanks!

[root@LMKIII ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost localhost
# ::1 localhost6.localdomain6 localhost6
[root@LMKIII ~]#

Wondering if it is fixed.

Did you remove the second localhost and returned network file back to default?
If so does that resolve it and make mysql to work as well.

Also contents of /etc/host.conf file

Brian

second localhost commented out

[root@LMKIII ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost localhost
# ::1 localhost6.localdomain6 localhost6
[root@LMKIII ~]#

[root@x1-6-00-b0-d0-16-1c-01 ~]# cat /etc/host.conf
order hosts,bind

[root@x1-6-00-b0-d0-16-1c-01 ~]#

[root@x1-6-00-b0-d0-16-1c-01 ~]# cat /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=localhost.localdomain
#HOSTNAME=LMKIII

back to

[root@x1-6-00-b0-d0-16-1c-01 ~]# hostname
x1-6-00-b0-d0-16-1c-01
[root@x1-6-00-b0-d0-16-1c-01 ~]#

[root@x1-6-00-b0-d0-16-1c-01 ~]# route
Kernel IP routing table
Destination Gateway Genmask Flags Metric Ref Use Iface
192.168.122.0 * 255.255.255.0 U 0 0 0 virbr0
72.47.28.0 * 255.255.254.0 U 0 0 0 eth0
link-local * 255.255.0.0 U 0 0 0 eth0
default doc-72-47-28-1. 0.0.0.0 UG 0 0 0 eth0
[root@x1-6-00-b0-d0-16-1c-01 ~]#

I mean this edit, the line in /etc/hosts from this
127.0.0.1 localhost.localdomain localhost localhost
to this
127.0.0.1 localhost.localdomain localhost

Reboot and see what happens.

Brian

Thanks but back to square 1
seems like we were ahead HOSTNAME=LMKIII

after reboot here it is
[root@x1-6-00-b0-d0-16-1c-01 ~]# !388

cat /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=localhost.localdomain
#HOSTNAME=LMKIII


[root@x1-6-00-b0-d0-16-1c-01 ~]# !388
cat /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=localhost.localdomain
#HOSTNAME=LMKIII

cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
# ::1 localhost6.localdomain6 localhost6

I am at a total lost as to why your system is doing this as far as leaving network file as default. It should localhost in the bash prompt inside if the IPv6 stuff. I need to get hold of my Redhat contact and get his input if he is not busy.

I myself edited my network file to use a different name other than localhost. I return everything to default install, directly connected to modem, and dhcp setup. My reverts to user@localhost as expected. I thought maybe it was getting that info if the ISP has set a domain name to the IP. Again just mine blowing.

Brian

mysql> select user, host from mysql.user;
+---------+------------------------+
| user | host |
+---------+------------------------+
| root | 127.0.0.1 |
| lando | LMKIII |
| landon | LMKIII |
| landon4 | LMKIII |
| root | localhost |
| root | x1-6-00-b0-d0-16-1c-01 |
+---------+------------------------+
6 rows in set (0.00 sec)

mysql>

I have seen confusion in the use of hostname in mysql

however

[landon4@LMKIII ~]$ mysql -u landon4@LMKIII --password='Kateaux3141'
ERROR 1045 (28000): Access denied for user 'landon4@LMKIII'@'localhost' (using password: YES)
[landon4@LMKIII ~]$

mysql> select user, host from mysql.user;
+---------+------------------------+
| user | host |
+---------+------------------------+
| root | 127.0.0.1 |
| landon | LMKIII |
| landon4 | LMKIII |
| root | localhost |
| root | x1-6-00-b0-d0-16-1c-01 |
+---------+------------------------+
5 rows in set (0.00 sec)

mysql> drop user landon@LMKIII;
Query OK, 0 rows affected (0.00 sec)

mysql> grant all on *.* to landon4@localhost identified by 'Kateaux3141';
Query OK, 0 rows affected (0.00 sec)

mysql>

under a non-root user, I cannot log in

all the following fail
330 mysql --user='landon@LMKIII' --password='rumprocella'
331 mysql --user='landon@localhost' --password='rumprocella'
332 h
333 mysql --user='landon@localhost6' --password='rumprocella'
334 passwd
335 passwd
336 mysql --user='lando@localhost6' --password='passwordx'
337 mysql --user='lando@localhost' --password='passwordx'
338 mysql --user='lando@LMKIII' --password='passwordx'
339 h
340 mysql --user='landon4@LMKIII' --password='passwordx'
341 hostname
342 mysql --user='landon4'@'LMKIII' --password='passwordx'
343 mysql --user='landon4'@'LMKIII' --password='passwordx'
344 mysql -u other4 --password='passwordx'
345 mysql -u landon4 --password='passwordx'
346 mysql -u landon4@LMKIII --password='passwordx'
347 mysql -u landon4 --password='passwordx'
348 mysql -u landon4 --password='passwordx'
349 h
350 mysql --user='landon4@LMKIII' --password='passwordx'
351 mysql -u landon4 --password='passwordx'
352 mysql -u landon4 --password='passwordx'
353 mysql -u landon4@LMKIII --password='passwordx'
354 mysql -u landon4@LMKIII --password='passwordx'
355 mysql -u landon4@LMKIII@localhost --password='passwordx'
356 mysql -u landon4@localhost --password='passwordx'
357 h
358 mysql -u landon4 --password='passwordx'
359 vi xxx
360 vi xxx
361 mysql -u landon4@LMKIII --password='passwordx'
362 mysql -u landon4 --password='passwordx'
363 h