[CentOS] mysql : Access denied for user

Sat May 20 17:44:57 UTC 2006
William L. Maltby <BillsCentOS at triad.rr.com>

On Sat, 2006-05-20 at 13:00 -0400, William L. Maltby wrote:
> On Sat, 2006-05-20 at 12:49 -0400, William L. Maltby wrote:
> > On Sat, 2006-05-20 at 10:04 -0500, Johnny Hughes wrote:
> > > On Sat, 2006-05-20 at 08:41 -0400, William L. Maltby wrote:
> > > > On Sat, 2006-05-20 at 07:48 -0400, Alfred von Campe wrote:
> > > > > On May 20, 2006, at 7:33, Johnny Hughes wrote:
> > > > ><snip>
> 
> > > The problem is ... if you have DHCP ... you need the name of the machine
> > > in the same line, as your IP address changes
> > > <snip sig>
> >
> *sigh*

> I see that I really should have given a 2nd thought before hitting send.
> All my nodes keep their nodenames ok. Even as IP changes. I can ref all
> nodes by node name or IP equally well. Dig and nslookup act as expected.
> 
> This is a result of taking advantage of the client's ability to keep its
> nodename in the configuration and that overrides my IPCop nodename that
> would be generated. So, I'll post in a few more moments what my configs
> look like.
> <snip sig stuff>

Attached stuff from my setup. Hoping it saves aggravation for those
uninterested and helps those interested.


-- 
Bill
-------------- next part --------------
Having studied docs available on the net extensively, I feel sure that
using Dyndns fqacilities, smart local scripting, etc. I can convert to
a visible presence on the net w/o trouble. This will have DNS, html
server, etc.

I've X'd out some values for security reasons

# Workstation
[root at wlmlfs08 network-scripts]# cat ifcfg-eth0
DEVICE=eth0
BOOTPROTO=dhcp
HWADDR=00:0X:X0:XX:XX:XX
ONBOOT=yes
TYPE=Ethernet
DHCP_HOSTNAME=wlmlfs08
USERCTL=no
PEERDNS=yes
IPV6INIT=no

# Server (under construction)
[root at server01 network-scripts]# cat ifcfg-eth0
# Modified to add DHCP_HOSTNAME and on WLM.
DEVICE=eth0
BOOTPROTO=dhcp
HWADDR=00:0X:XX:XX:XX:XX
ONBOOT=yes
TYPE=Ethernet
DHCP_HOSTNAME=Server01
USERCTL=no
PEERDNS=yes
IPV6INIT=no

# Firewall
# This one is the result of IPCop setup/configuration I think
# Abbreviated some lines of no consequence or due to security
# denoted by the last 2 chars being '.*', in regex fashion.
root at HomeGroanFirewall:/var/ipcop # cat ethernet/settings
CONFIG_TYPE=2
GREEN_DRIVER=e100
GREEN_DRIVER_OPTIONS=
GREEN_DEV=eth0
GREEN_DISPLAYDRIVER=e100
GREEN_ADDRESS=192.168..*
GREEN_NETMASK=255.255..*
GREEN_NETADDRESS=192.168..*
GREEN_BROADCAST=192.168..*
ORANGE_DEV=
BLUE_DEV=
RED_DEV=eth1
RED_DRIVER=8139too
RED_DRIVER_OPTIONS=
RED_DISPLAYDRIVER=8139too
RED_DHCP_HOSTNAME=HomeGroanFirewall
RED_ADDRESS=0.0.0.0
RED_NETMASK=0.0.0.0
RED_TYPE=DHCP
RED_NETADDRESS=0.0.0.0
RED_BROADCAST=255.255.255.255
DNS1=
DNS2=
DEFAULT_GATEWAY=

# IIRC, the next file is a consequence of the immediately preceding.
# Abbreviated some lines of no consequence or due to security
# denoted by the last 2 chars being '.*', in regex fashion.

root at HomeGroanFirewall:/var/ipcop # cat dhcpc/dhcpcd-eth1.info
IPADDR=24..*
NETMASK=255.255..*
NETWORK=24..*
BROADCAST=255..*
GATEWAY=24..*
HOSTNAME='HomeGroanFirewall'
DOMAIN='triad.rr.com'
DNS=24.25.5.150,24.25.5.149
DHCPSID=10..*
DHCPGIADDR=10..*
DHCPSIADDR=0.0.0.0
DHCPCHADDR=00:0X:0X:0X:XX:XX
DHCPSHADDR=00:0X:X0:XX:XX:XX
DHCPSNAME=''
LEASETIME=3600
RENEWALTIME=1800
REBINDTIME=3150
INTERFACE='eth1'
CLASSID='Linux 2.4.31 i586'
CLIENTID=00:0X:0X:0X:CX:AX

######################################################################
Does it all work?
######################################################################
root at HomeGroanFirewall:~ # dnsdomainname
HomeGroanNetworking
root at HomeGroanFirewall:~ # hostname
HomeGroanFirewall.HomeGroanNetworking
root at HomeGroanFirewall:~ # ping -c 3 wlmlfs08
PING wlmlfs08.HomeGroanNetworking (192.168.X.XX): 56 data bytes
64 bytes from 192.168.X.XX: icmp_seq=0 ttl=64 time=0.865 ms
64 bytes from 192.168.X.XX: icmp_seq=1 ttl=64 time=0.730 ms
64 bytes from 192.168.X.XX: icmp_seq=2 ttl=64 time=0.724 ms
--- wlmlfs08.HomeGroanNetworking ping statistics ---
3 packets transmitted, 3 packets received, 0% packet loss
round-trip min/avg/max/stddev = 0.724/0.773/0.865/0.065 ms
root at HomeGroanFirewall:~ # ping -c 3 192.168.X.XX
PING 192.168.X.XX (192.168.X.XX): 56 data bytes
64 bytes from 192.168.X.XX: icmp_seq=0 ttl=64 time=0.772 ms
64 bytes from 192.168.X.XX: icmp_seq=1 ttl=64 time=0.723 ms
64 bytes from 192.168.X.XX: icmp_seq=2 ttl=64 time=0.719 ms
--- 192.168.X.XX ping statistics ---
3 packets transmitted, 3 packets received, 0% packet loss
round-trip min/avg/max/stddev = 0.719/0.738/0.772/0.024 ms

[hardtolove at wlmlfs08 ~]$ dig server01

; <<>> DiG 9.2.4 <<>> server01
;; global options:  printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 29817
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 0

;; QUESTION SECTION:
;server01.                      IN      A

;; ANSWER SECTION:
server01.               0       IN      A       192.168.X.XX

;; Query time: 3 msec
;; SERVER: 192.168.X.XX#53(192.168.X.XX)
;; WHEN: Sat May 20 13:35:17 2006
;; MSG SIZE  rcvd: 42

[hardtolove at wlmlfs08 ~]$ dig centos.org
; <<>> DiG 9.2.4 <<>> centos.org
;; global options:  printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 19527
;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 4, ADDITIONAL: 4

;; QUESTION SECTION:
;centos.org.                    IN      A

;; ANSWER SECTION:
centos.org.             300     IN      A       204.10.37.194

;; AUTHORITY SECTION:
centos.org.             14400   IN      NS      ns2.centos.org.
centos.org.             14400   IN      NS      ns2.uklinux.net.
centos.org.             14400   IN      NS      ns.owlriver.com.
centos.org.             14400   IN      NS      ns1.centos.org.

;; ADDITIONAL SECTION:
ns.owlriver.com.        313196  IN      A       66.195.224.112
ns1.centos.org.         32185   IN      A       72.21.40.11
ns2.centos.org.         19808   IN      A       131.211.85.43
ns2.uklinux.net.        164536  IN      A       80.84.64.25

;; Query time: 60 msec
;; SERVER: 192.168.X.XX#53(192.168.X.XX)
;; WHEN: Sat May 20 13:35:27 2006
;; MSG SIZE  rcvd: 202
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <http://lists.centos.org/pipermail/centos/attachments/20060520/49bea59f/attachment-0004.sig>