Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 3rd May 2008, 07:00
goingininsane goingininsane is offline
Junior Member
 
Join Date: May 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Question about mysql on perfect Debian Setup

Hi, been following the Perfect Debian Setup found here:

http://howtoforge.com/perfect_setup_debian_etch

I've made it up to page 4 with mysql. I commented out the bind.address like it says. and I'm trying to set my passwords. Except no matter what i type i keep getting the return "error: 'access denied for user 'root'@'localhost' (using password: NO)'".

I've tried every combination of "mysqladmin -u root 'password' 'passwordiwant'" that i can think, i've typed in every password i've created but i still get this error, and don't want to move on before i get this to work. any help is greatly appreciated.
Reply With Quote
Sponsored Links
  #2  
Old 3rd May 2008, 14:59
White White is offline
Member
 
Join Date: Apr 2008
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Default

you could try

Code:
apt-get remove --purge mysql-server mysql-client libmysqlclient15-dev
which will completely remove all instances of mysql

then

Code:
apt-get install mysql-server mysql-client libmysqlclient15-dev
and follow the steps again.

i take it you did replace 'yourrootsqlpassword' below with your own password

Code:
mysqladmin -u root password yourrootsqlpassword
mysqladmin -h server1.example.com -u root password yourrootsqlpassword
Reply With Quote
  #3  
Old 7th May 2008, 05:57
sergio.morales sergio.morales is offline
Senior Member
 
Join Date: Apr 2008
Posts: 107
Thanks: 3
Thanked 2 Times in 2 Posts
Default I'm having a very similar issue . . .

My issue is very similar, but I can't get to the step below his. My password is set and all is OK there, but when I try running the:
mysqladmin -h server1.example.com -u root password yourrootsqlpassword

it fails. I think it's because my hostname has a dash in it, but I don't know! This is the error I get:
mysqladmin -h email-bestXXXX.com -u root password mypassword
mysqladmin: connect to server at 'email-bestXXXX.com' failed
error: 'Host 'email-bestXXXX.com' is not allowed to connect to this MySQL server'

The "XXXX" is simply to hide my hostname . . .

Please HELP!!!
Reply With Quote
  #4  
Old 8th May 2008, 01:00
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
 
Default

You can try to correct the hostname in the MySQL database as shown in chapter 8 on http://www.howtoforge.com/perfect_se...pensuse10.3_p4 , beginning with "As you've seen in the netstat output, MySQL is not only listening on localhost, but on all interfaces, which means it can be accessed from the outside. Therefore we need to set a password for the user root@server1.example.com as well. But there's one little problem: most likely the Host column in the mysql.user table doesn't contain server1.example.com, but server1. We will change that now, and afterwards we will set a MySQL password for the user root@server1.example.com."
__________________
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
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
The Perfect Setup - Ubuntu 6.10 Server Question n74jw HOWTO-Related Questions 5 27th January 2008 13:14
Perfect setup Debian Etch ISPConfig - DNS Server kdclaver Installation/Configuration 16 28th December 2007 02:39
The Perfect Setup - Debian Etch: smart_host bidevi Server Operation 14 18th August 2007 20:11
New Setup Question using Debian ISPConfig Rocky Installation/Configuration 1 28th February 2007 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 08:47.


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