[CentOS] mysql : Access denied for user
William L. Maltby
BillsCentOS at triad.rr.com
Sat May 20 17:44:57 UTC 2006
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.sig>
More information about the CentOS
mailing list