Hi,
I seem to have two problems at the moment (on two different machines).
On the laptop, it looks like MySQL is messed up. If I issue
mysqladmin -u root password 'bluebuses'
I get an error that it can't connect to localhost
mysqladmin -u root -h T8.linux password 'bluebuses'
gives an error
mysqladmin: connect to server at 'T8.linux' failed error: '#HY000Host 'localhost.localdomain' is not allowed to connect to this MySQL server'
(T8.linux is the machines name).
Am I doing something wrong or is this broken?
My /etc/hosts file reads
127.0.0.1 localhost.localdomain T8.linux localhost T8
Second off is that udev fails to start on the other computer. While that doesn't stop it from working, it does make DVD burning somewhat slow. I'm using udev-050-7 with the 2.6.10-1.1063_FC4 kernel (1154 just doesn't work - the machine will get to the desktop and then crash requiring a power reset).
Any clues on either of these?
TTFN
Paul
On February 27, 2005 07:52, Paul wrote:
Hi,
I seem to have two problems at the moment (on two different machines).
On the laptop, it looks like MySQL is messed up. If I issue
mysqladmin -u root password 'bluebuses'
I get an error that it can't connect to localhost
mysqladmin -u root -h T8.linux password 'bluebuses'
gives an error
mysqladmin: connect to server at 'T8.linux' failed error: '#HY000Host 'localhost.localdomain' is not allowed to connect to this MySQL server'
(T8.linux is the machines name).
Am I doing something wrong or is this broken?
My /etc/hosts file reads
127.0.0.1 localhost.localdomain T8.linux localhost T8
Have you turned on msqld? checkconfig --list | grep mysql chkconfig mysql --level 345 on service mysql start
Can't help with the next one... sorry
Second off is that udev fails to start on the other computer. While that doesn't stop it from working, it does make DVD burning somewhat slow. I'm using udev-050-7 with the 2.6.10-1.1063_FC4 kernel (1154 just doesn't work - the machine will get to the desktop and then crash requiring a power reset).
Any clues on either of these?
TTFN
Paul
Phil
Hi,
Have you turned on msqld? checkconfig --list | grep mysql chkconfig mysql --level 345 on service mysql start
MySql is up and running and levels 3 and 5 and off on 01246
Just altered mysqld to be running on 345 and it made no difference - same errors.
TTFN
Paul
Not long ago, Paul proclaimed...
Second off is that udev fails to start on the other computer. While that doesn't stop it from working, it does make DVD burning somewhat slow. I'm using udev-050-7 with the 2.6.10-1.1063_FC4 kernel (1154 just doesn't work - the machine will get to the desktop and then crash requiring a power reset).
Sounds like you're using pre-beta code (FC4 is pre-beta) and expecting things to work. That's a poor assumption to make.
On Sun, 2005-02-27 at 11:19 -0700, Doran Barton wrote:
Not long ago, Paul proclaimed...
Second off is that udev fails to start on the other computer. While that doesn't stop it from working, it does make DVD burning somewhat slow. I'm using udev-050-7 with the 2.6.10-1.1063_FC4 kernel (1154 just doesn't work - the machine will get to the desktop and then crash requiring a power reset).
Sounds like you're using pre-beta code (FC4 is pre-beta) and expecting things to work. That's a poor assumption to make.
Works for me:
$ rpm -q mysql mysql-4.1.9-1 $ rpm -q kernel kernel-2.6.10-1.1149_FC4 kernel-2.6.10-1.1154_FC4 $ mysqladmin -u root -h 127.0.0.1 password 'foo' -p Enter password: $
mysqladmin: connect to server at 'T8.linux' failed error: '#HY000Host 'localhost.localdomain' is not allowed to connect to this MySQL server'
This gives me the impression that you had already previously set a root password for this server, and are attempting to change it. If this is right, then you need to connect to the MySQL server using the hostname you originally specified for the root user. E.g. user root needs to connect with some other hostname and it can't be an aliased hostname. It has to be the hostname that was set for the machine at networking time. 'T8.linux' is not the hostname. It is just an alias for 'localhost.localdomain' and it won't be sent to the MySQL server.
So I think you either must set your machine to the hostname MySQL is expecting for the root user ('T8.linux'?) or you must reset the MySQL root password.
There is a way to reset the root password, documented on the MySQL website, or in Paul DuBois' excellent book MySQL (Second Edition). You might want to read DuBois' suggestions for setting the root password, and at the same time change your host's configuration so that it is assigned a consistent hostname.
MySQL is big and complex, and there are a lot of books on the market for it. I very highly reccomend you buy and use DuBois' book. I can't live without it myself. No one else writes about MySQL better.
Bob Cochran
Robert L Cochran wrote:
mysqladmin: connect to server at 'T8.linux' failed error: '#HY000Host 'localhost.localdomain' is not allowed to connect to this MySQL server'
This gives me the impression that you had already previously set a root password for this server, and are attempting to change it. If this is right, then you need to connect to the MySQL server using the hostname you originally specified for the root user. E.g. user root needs to connect with some other hostname and it can't be an aliased hostname. It has to be the hostname that was set for the machine at networking time. 'T8.linux' is not the hostname. It is just an alias for 'localhost.localdomain' and it won't be sent to the MySQL server.
So I think you either must set your machine to the hostname MySQL is expecting for the root user ('T8.linux'?) or you must reset the MySQL root password.
There is a way to reset the root password, documented on the MySQL website, or in Paul DuBois' excellent book MySQL (Second Edition). You might want to read DuBois' suggestions for setting the root password, and at the same time change your host's configuration so that it is assigned a consistent hostname.
MySQL is big and complex, and there are a lot of books on the market for it. I very highly reccomend you buy and use DuBois' book. I can't live without it myself. No one else writes about MySQL better.
Bob Cochran
Or, if you are setting the root password for the first time, just check to make sure you know what your hostname truly is, perhaps by issuing 'env' and checking the HOSTNAME output:
[rlc@bobcp4 itemlist]$ env ... HOSTNAME=bobcp4.lingpgmr.com
And then use that as the hostname you supply to mysqladmin:
-h bobcp4.lingpgmr.com
Bob
Hi,
Second off is that udev fails to start on the other computer. While that doesn't stop it from working, it does make DVD burning somewhat slow.
udev cannot slow down your DVD! :-D
For some reason, with udev happy, DVDs burn at around x4. Without it, it's about x1.3
TTFN
Paul
Hi,
For some reason, with udev happy, DVDs burn at around x4. Without it, it's about x1.3
Same HW? What is the udev failure? How do you burn?
Exactly the same HW, failure - not sure (I'll need to check the logs tonight). Burn using k3b.
TTFN
Paul