Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 03-11-2004, 08:05 AM   #1
Registered: Feb 2004
Posts: 50

Rep: Reputation: 15
Question MySQL root password.


I followed the instruction in a post from this forum about the need of changing root password for mysqld:

#mysqladmin -u root password xyz
#mysqladmin -u root -h host1 password xyz

Now, the first one works fine. But the second one, it gives me this error:

/usr/bin/mysqladmin: connect to server at 'host1' failed
error: 'Host '' is not allowed to connect to this MySQL server'

Anyone know what's wrong with it. I just reinstalled my system, and decided to setup the network/nameserver first.

I'm using slackware 9.1

Old 03-11-2004, 09:27 AM   #2
LQ Guru
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 255Reputation: 255Reputation: 255
Have you tried connecting as the first root account and updating your record from within mysql with the correct host info, etc?
Old 03-11-2004, 09:32 AM   #3
Registered: Feb 2004
Posts: 50

Original Poster
Rep: Reputation: 15
I just solved it, I go to mysql, using root account, and typed:

mysql> set password for 'root'@'host1' = password('xyz');

But I'm still wondering why am I not allowed to connect to MySQL server? I typed:

shell> mysql -h host1

and get this:
ERROR 1130: Host '' is not allowed to connect to this MySQL server

This mean I cant connect to mysql server from other machine? Any idea on how to solve this? So that I can use a tool like MySQL Front, and connect to the server to do table/data manipulation, etc.



Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
DISCUSSION: MySQL root password recovey Boby LinuxAnswers Discussion 1 02-19-2009 01:51 PM
mysql root password lost nazir Linux - Software 6 10-09-2007 10:18 AM
Resetting MySQL root password b200306 Linux - Software 3 02-08-2004 03:21 PM
Mysql root password spintrance7 Linux - Software 7 11-29-2003 04:20 PM
MYSQL root password forgotton jon_k Linux - Software 5 07-18-2003 08:09 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 06:26 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration