"using password: NO", really?!!
Moderator: Moderator Team
-
- Berichten: 16
- Lid geworden op: 19 mar 2011, 10:42
"using password: NO", really?!!
I have my MySQL server listen on a network address now (needed for various reasons). So far so good. But now, when I try to connect to spotweb, I get the following error:
Unable to connect to MySQL server: Access denied for user 'root'@'my-xp' (using password: NO)
"using password: NO"?! What the hell is spotweb talking about?! The password is configured just fine. Why is it not using it?? Is this some kind of bug?
My setting as are following:
$settings['db']['host'] = '192.168.78.81';
$settings['db']['dbname'] = 'spotweb';
$settings['db']['user'] = 'root';
$settings['db']['pass'] = 'notmyrealpassword';
Support Request Template
Welk spotX programma gebruik je?: SpotWeb
Wat is de versie van het spotX programma?: spotweb-77410df
Wat is je besturingssysteem?: Windows XP
Wat is de versie van het besturingssysteem?: 32bits
Welke Usenet Provider heb je?: giganews.com
Welke Internet Provider heb je?: xs4all.nl
Welk Anti-Virus/Firewall programma gebruik je?: MS Security Essentials
Met welk programma download je?: SABnzbd
Wanneer begon je probleem?: Vandaag, na Mysql op host
Geef een beschrijving van je probleem: Zie hierboven
XML bestand.: Geen antwoord gegeven
Generated by Support Toolkit SRT Generator.
Unable to connect to MySQL server: Access denied for user 'root'@'my-xp' (using password: NO)
"using password: NO"?! What the hell is spotweb talking about?! The password is configured just fine. Why is it not using it?? Is this some kind of bug?
My setting as are following:
$settings['db']['host'] = '192.168.78.81';
$settings['db']['dbname'] = 'spotweb';
$settings['db']['user'] = 'root';
$settings['db']['pass'] = 'notmyrealpassword';
Support Request Template
Welk spotX programma gebruik je?: SpotWeb
Wat is de versie van het spotX programma?: spotweb-77410df
Wat is je besturingssysteem?: Windows XP
Wat is de versie van het besturingssysteem?: 32bits
Welke Usenet Provider heb je?: giganews.com
Welke Internet Provider heb je?: xs4all.nl
Welk Anti-Virus/Firewall programma gebruik je?: MS Security Essentials
Met welk programma download je?: SABnzbd
Wanneer begon je probleem?: Vandaag, na Mysql op host
Geef een beschrijving van je probleem: Zie hierboven
XML bestand.: Geen antwoord gegeven
Generated by Support Toolkit SRT Generator.
-
- Berichten: 926
- Lid geworden op: 19 feb 2011, 12:01
- Usenet: Supernews
- Internet: Ziggo Z3
- Locatie: The Big Bang
Re: "using password: NO", really?!!
Is phpmyadmin installed on your host machine? If so, can you try to log in using those same credentials and check if that does work?
From my experience the root account can only be used on 'localhost' and is blocked for other IPs, even if they are in the same network. You can always try and add a new user with all administrative privileges to the database and retry.
From my experience the root account can only be used on 'localhost' and is blocked for other IPs, even if they are in the same network. You can always try and add a new user with all administrative privileges to the database and retry.



-
- Berichten: 16
- Lid geworden op: 19 mar 2011, 10:42
Re: "using password: NO", really?!!
Oops! You are right! I was being a moron.Carnifex schreef:Is phpmyadmin installed on your host machine? If so, can you try to log in using those same credentials and check if that does work?
From my experience the root account can only be used on 'localhost' and is blocked for other IPs, even if they are in the same network. You can always try and add a new user with all administrative privileges to the database and retry.

-
- Berichten: 28
- Lid geworden op: 14 feb 2011, 14:15
- Usenet: TweakNews
- Internet: Ziggo
Re: "using password: NO", really?!!
Off-topic: hoezo praat je ineens Engels Iwakura? Je vorige posts waren gewoon NL 
