#1  
Old 6th October 2005, 01:29
jon335 jon335 is offline
Junior Member
 
Join Date: Oct 2005
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Angry MySQL error during setup

I keep getting this error:
Code:
Host 'localhost.localdomain' is not allowed to connect to this MySQL server
after I enter the MySQL information.

I have tried it on several machines and I keep getting this error on all of them.

I'm using the Debian Sarge Perfect Setup.

Last edited by jon335; 6th October 2005 at 02:08.
Reply With Quote
Sponsored Links
  #2  
Old 6th October 2005, 03:28
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

Quote:
Originally Posted by jon335
I keep getting this error:
Code:
Host 'localhost.localdomain' is not allowed to connect to this MySQL server
after I enter the MySQL information.

I have tried it on several machines and I keep getting this error on all of them.

I'm using the Debian Sarge Perfect Setup.
This has changed in Debian Sarge since I've written the tutorial.
Open /etc/mysql/my.cnf and comment out the line
Code:
bind-address            = 127.0.0.1
Then restart MySQL.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 6th October 2005, 15:58
jon335 jon335 is offline
Junior Member
 
Join Date: Oct 2005
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy

I tried that but I still keep getting this error:
Code:
ERROR 1045: Access denied for user: 'root@localhost.localdomain'
Would using a different Perfect Setup (i.e. another operating system) work?? If so which would you reccomend?

Reply With Quote
  #4  
Old 6th October 2005, 16:02
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

Quote:
Originally Posted by jon335
I tried that but I still keep getting this error:
Code:
ERROR 1045: Access denied for user: 'root@localhost.localdomain'
Would using a different Perfect Setup (i.e. another operating system) work?? If so which would you reccomend?

Can you open the database mysql with phpMyAdmin and have a look at the user table? Is there an entry for root and localhost.localdomain?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 6th October 2005, 16:39
jon335 jon335 is offline
Junior Member
 
Join Date: Oct 2005
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I haven't gotten phpMyAdmin installed, because this error occurs during ISPConfig setup.
Reply With Quote
  #6  
Old 6th October 2005, 19:36
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

Quote:
Originally Posted by jon335
I haven't gotten phpMyAdmin installed, because this error occurs during ISPConfig setup.
You can run
Code:
apt-get install phpmyadmin
or get phpMyAdmin from www.phpmyadmin.net and install it manually under /var/www.

You can then reach it under http://<your IP address>/phpmyadmin/
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 6th October 2005, 19:39
jon335 jon335 is offline
Junior Member
 
Join Date: Oct 2005
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

I looked around in the forums here and tried using a blank MySQL password. It worked. Thanks for your help.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 17:37
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 10:41
Mysql ejs Installation/Configuration 5 12th August 2005 08:01
MySQL Privileges mcfly Server Operation 4 26th May 2005 20:00
MYSQL and the perfect setup 9.2 Suse pkfrizzlefry HOWTO-Related Questions 7 21st May 2005 21:12


All times are GMT +2. The time now is 15:16.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.