Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: mysql kufuffle

 Answering my own question, I modified the user table in the mysql 
database, and changed the host to the fqdn string. I then did a flush 
privileges and that seemed to allow me to access the database. 

Cheers. Steve. 

Stephen Adler wrote: 
> Guys, 
> I'm having a hard time getting mysql setup on my redhat system. The 
> issue has to do with a not quite properly setup system in which the 
> hostname is not set to the fully qualified domain name of the system. 
> So, when mysql starts up for the first time, through the 
> /etc/rc.d/init.d/mysqld script, the database is inititlaized, and the 
> host is defined with the non-fqdn string. But when I go to set the 
> root password using the command 
> mysqladmin -u root -h basement00 password BlAa 
> it complains that root does not have access from the host and it spits 
> out the fully qualified domain name. It looks like I need to fix up 
> something within the db tables so that it recognizes my host, using 
> the fqdn string. Any ideas on this? 
> thanks in advance. 
> Cheers. Steve. 

BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!

Boston Linux & Unix /