[MySQL] Access denied for users 'root'@'localhost'

[mew1997]

Avevo installato MySQL server 5.5 su Windows 2008 R2 server, poi perchè è stata scoperta la password per accedere al database e non riuscendo a cambiarla ho disinstallato MySQL, cancellato il servizio MySQL e poi anche tutta la cartella MySQL e ripulito VPS incluso registro, con Ccleaner, ma quando lo reinstallo da errore n° 1045: "Access denied for users 'root'@'localhost' (using password: NO)"
Ho controllato che la porta 3306, ma è aperta ed è attivato un firewall, ma prima dell' installazione l' avevo disattivato, altro non so

[MatCap83]

Ciao, non ho molta dimestichezza con MySQL, ma ho trovato questo discussione:

http://stackoverflow.com/questions/6...g-password-yes

dove dice ad un certo punto:

"Is there a user account entry in the DB for root@localhost? In MySQL you can set different user account permissions by host. There could be several different accounts with the same name combined with the host they are connecting from. The most common are root@127.0.0.1 and root@localhost. These can have different passwords and permissions. Make sure root@localhost exist and has the settings you expect.

I am willing to bet, based on your explanation, that this is the problem. Connecting from another PC uses a different account than root@localhost and the command line I think connects using root@127.0.0.1."

Può esserti d'aiuto??

[mew1997]

Ok, il collegamento al database ho risolto, però ora il CMS non riesce a connettersi col nuovo user, ecco il config.php e il core.php
config.php

<?php /*===================================================+ || # HoloCMS - Website and Content Management System |+===================================================+ || # Copyright © 2008 Meth0d. All rights reserved. || # [url]http://www.meth0d.org[/url] |+===================================================+ || # HoloCMS is provided "as is" and comes without || # warrenty of any kind. HoloCMS is free software! |+===================================================*/ /*-------------------------------------------------------*\ | ****** NOTE REGARDING THE VARIABLES IN THIS FILE ****** | +---------------------------------------------------------+ | If you get any errors while attempting to connect to | | MySQL, you will need to email your webhost because we | | cannot tell you the correct values for the variables | | in this file. | \*-------------------------------------------------------*/ // ****** MASTER DATABASE SETTINGS ****** // These are the settings required to connect to your MySQL Database. $sqlhostname = "localhost"; $sqlusername = "francesco"; $sqlpassword = "****"; $sqldb = "shop"; $conn = new mysqli("$sqlhostname", "$sqlusername", "$sqlpassword", "$sqldb"); // ****** STATUS CHECKS SYSTEM ****** // This option will allow HoloCMS to perform full status checks. This, // however, slows down your site A LOT. It is therefore disabled by // default. $enable_status_image = "0"; // ****** SITE PATH ****** // The full URL to your site; with an slash added on the end. $path = "http://crabbohotel.it/"; // ****** REFFERAL REWARD ****** // The amount of credits a user recieves upon referring a friend to the // hotel. Set to '5000' by default. $reward = "50"; // ****** HOLOCMS SYSTEM ADMINISTRATOR ****** // User ID of the System Administrator. Will be granted access to sensitive // features. Set to '1' by default. This setting will not change your // ingame priveliges. $sysadmin = "8013"; // ****** HOLOCMS ENCRYPTION SYSTEM ****** // How HoloCMS stores passowrds. // Do NOT manually change this unless you know what you are doing, // doing so may corrupt your database. $encryption = "old"; $hashtext = ""; // ****** BADGES ****** // Where badges are located. $cimagesurl = "http://albsnethotel.webnet32.com/r63/c_images/"; $badgesurl = "album1584/"; // ****** EMAIL VERIFY ****** // Email verification settings $email_verify = true; $email_force_verify = false; $email_verify_reward = "500"; ?>

Qui il core.php