#1  
Old 8th January 2006, 09:36
Blu3 Blu3 is offline
Junior Member
 
Join Date: Jan 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Question Wrong MySQL password??

For some reason all 4 times Ive ran the ./setup program for ISPConfig, it states all prerequisites met and when I get to the part where I enter in my MySQL info, the setup program quits and states incorrect password detected???

Ive even tested the password by logging into mysql with that user account and password, and it works fine.

I followed these instructions: http://www.howtoforge.com/perfect_setup_ubuntu_5.10 to the exact letter and am pretty much stumped. Why does it not recognize the mysql login?

TIA
Reply With Quote
Sponsored Links
  #2  
Old 8th January 2006, 12:23
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,177
Thanks: 829
Thanked 5,414 Times in 4,257 Posts
Default

Does your mysql password contains any special characters like this: !"§$%&/#* ?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 8th December 2006, 21:45
rdmandel rdmandel is offline
Junior Member
 
Join Date: Dec 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default mysql password problem

Till asks if the MySQL password contains special characters - are the characters listed by Till not allowed? And I did use some of them and now what do I do about it?

I have tried all the fixes I can find and am still unable to get the system to accept:
#> mysqladmin -u root password blahblah
mysqladmin: connect to server at 'localhost' failed
"error: access denied for user 'root'@'localhost' failed"

SOMEHOW, USING EVERYTHING I COULD FIND ON THE WEB, I WAS ABLE TO RESET THE PASSWORD TO '' AND THEN RESET IT TO A REAL PASSWORD, SO NOW THAT IS FIXED,

BUT IT STILL WILL NOT RECOGNIZE MY HOSTNAME
.

root#> mysqladmin -h GX270.tech-transfer.com -u root password Mand1eMM
ERROR - GX270.tech-transfer.com is not allowed to connect to this MySQL server

and
root#> telnet gx270.tech-transfer.com 3306
connects then Phost says 'GX270.tech-transfer.com' is not allowed to connect to this MySQL server. Closed by foreign host

and
root:#>hostname
GX270.tech-transfer.com
and
root:#>hostname -f
GX270.tech-transfer.com

Last edited by rdmandel; 9th December 2006 at 04:13.
Reply With Quote
  #4  
Old 9th December 2006, 14:55
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

What's the output of
Code:
netstat -tap
?
__________________
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 9th December 2006, 17:04
rdmandel rdmandel is offline
Junior Member
 
Join Date: Dec 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default netstat -tap

netstat - tap shows what it is supposed to show as per the how-to with some strangeness:
1) I have uninstalled mysql, but it still shows up;
2) it shows my host as GX270.tech-trans:domain when the hostname and hostname -f commands show the proper name (GX270.tech-transfer.com) but maybe this is an abrreviation for the netstat format.

tcp 0 0 *:mysql *:* LISTEN 3829/mysqld
tcp 0 0 *:ftp *:* LISTEN 4138/proftpd: (acce
tcp 0 0 GX270.tech-trans:domain *:* LISTEN 3671/named
tcp 0 0 localhost:domain *:* LISTEN 3671/named
tcp 0 0 *:smtp *:* LISTEN 4039/master
tcp 0 0 localhost:953 *:* LISTEN 3671/named
tcp6 0 0 *:imaps *:* LISTEN 3746/couriertcpd
tcp6 0 0 *op3s *:* LISTEN 3783/couriertcpd
tcp6 0 0 *op3 *:* LISTEN 3763/couriertcpd
tcp6 0 0 *:imap2 *:* LISTEN 3728/couriertcpd
tcp6 0 0 *:www *:* LISTEN 4181/apache2
tcp6 0 0 *:ssh *:* LISTEN 4068/sshd
tcp6 0 0 *:smtp *:* LISTEN 4039/master
tcp6 0 0 ip6-localhost:953 *:* LISTEN 3671/named
tcp6 0 0 *:https *:* LISTEN 4181/apache2

And this from ps aux | grep mysql

root 3812 0.0 0.5 2616 1284 ? S 08:29 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 3829 0.0 5.8 101732 14948 ? Sl 08:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/GX270.tech-transfer.com.pid --skip-locking
root 3830 0.0 0.1 1548 500 ? S 08:29 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
root 4315 0.0 0.3 2876 792 tty1 R+ 09:10 0:00 grep mysql

Last edited by rdmandel; 9th December 2006 at 17:13.
Reply With Quote
  #6  
Old 10th December 2006, 12:26
sgrayban sgrayban is offline
Junior Member
 
Join Date: Dec 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I had the same issue and installed webmin and added the local hostname to the host table and all was good.

Might want to make sure that localhost is allowed along with setting root's password while you are there.
Reply With Quote
  #7  
Old 10th December 2006, 14:19
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Quote:
Originally Posted by rdmandel
netstat - tap shows what it is supposed to show as per the how-to with some strangeness:
1) I have uninstalled mysql, but it still shows up;
You have uninstalled MySQL?

Quote:
Originally Posted by rdmandel
but maybe this is an abrreviation for the netstat format.
Yes, it's an abbreviation.
__________________
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
mysql password problem brianetilley Installation/Configuration 30 31st December 2007 22:32
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04
Virtual Users And Domains With Postfix, etc, problem with SMTP/Auth wrong password ggere HOWTO-Related Questions 15 14th November 2005 16:08
mysql password during installation Hellbound Installation/Configuration 4 21st September 2005 18:52
Wrong username and password iceberg General 9 25th August 2005 21:48


All times are GMT +2. The time now is 08:11.


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