Can't Connect To MySQL Error

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
MoonSlice1
Posts: 2
Joined: Wed Jun 22, 2016 2:45 am

Can't Connect To MySQL Error

Post by MoonSlice1 »

Hi guys, i am new to this subject and don't really know much about running these programs or using cmd.I am an intern and they have asked me to install and use Cacti on Windows. I have downloaded the Cacti Installer and it downloaded the missing products like mysql and etc.

I have gave permissions to rra and the cacti file.

MySQL version is 5.6
I have used cacti 0.8.8h installer
After that part is kind of black to me for 3 days i have tried but i couldn't do anything.
I have found the cacti passwords document.Than from cmd i wrote the codes that were in guides.The part i don't get was they were installing MySQL before installing cacti.They assign a pass to mysql then create a cacti user to mysql and give it permissions and database configurations.But i already have my cacti , mysql username and passes on the document i don't get why they redo it.
------------
After trying "localhost/cacti" i get error : Fatal :Cannot connect to MySQL server on localhost.Please make sure you have specified a valid MySQL database name in 'include/config.php'

I generally get errors while trying to use the codes like

Code: Select all

mysql -u root -p 
then when trying to

Code: Select all

shell> UPDATE mysql.user SET Password = OLD_PASSWORD('cactipwd')
				WHERE Host = 'localhost' AND User = 'cactiuser';
mysql> FLUSH PRIVILEGES;
I got errors

I have tried a few guides like below but i think i may have made some mistakes still being a newbie.
http://www.cacti.net/downloads/docs/htm ... ndows.html
Also, i was unable to get the error message because i was unable to find comp_err to decode it . :cry:

Sorry if i lacked giving more information , if you inform me whats missing i will try to modify asap.
Thank you,well apreciated.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Re: Can't Connect To MySQL Error

Post by BSOD2600 »

you used http://forums.cacti.net/viewtopic.php?f=3&t=14946 to install? if yes, please ATTACH the installer.log generated.
did you previously have mysql or php installed before trying the installer? If yes, thats the likely cause of the issues.
MoonSlice1
Posts: 2
Joined: Wed Jun 22, 2016 2:45 am

Re: Can't Connect To MySQL Error

Post by MoonSlice1 »

I am unable to accees the pc i made the installation right now , i had mysql server before my download. I will remove all components then try again then . I will come with the install.log after trying again and having a problem. Thank you
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests