benching Posted October 17, 2012 Group: Members Topic Count: 26 Topics Per Day: 0.01 Content Count: 350 Reputation: 43 Joined: 09/07/12 Last Seen: August 30, 2019 Share Posted October 17, 2012 hello i am having this error on my site, Exception Details Error: PDOException Message: SQLSTATE[28000] [1045] Access denied for user 'ragnarok'@'localhost' (using password: YES) File: /home/a4725528/public_html/lib/Flux/Connection.php:81 File Line Function/Method /home/a4725528/public_html/lib/Flux/Connection.php 81 PDO::__construct() /home/a4725528/public_html/lib/Flux/Connection.php 94 Flux_Connection::connect() /home/a4725528/public_html/lib/Flux/Connection.php 159 Flux_Connection::getConnection() /home/a4725528/public_html/modules/install/index.php 17 Flux_Connection::getStatement() /home/a4725528/public_html/lib/Flux/Template.php 337 include() /home/a4725528/public_html/lib/Flux/Dispatcher.php 168 Flux_Template::render() /home/a4725528/public_html/index.php 170 Flux_Dispatcher::dispatch() Exception Trace As String #0 /home/a4725528/public_html/lib/Flux/Connection.php(81): PDO->__construct(*hidden*) #1 /home/a4725528/public_html/lib/Flux/Connection.php(94): Flux_Connection->connect(Object(Flux_Config)) #2 /home/a4725528/public_html/lib/Flux/Connection.php(159): Flux_Connection->getConnection() #3 /home/a4725528/public_html/modules/install/index.php(17): Flux_Connection->getStatement('SELECT VERSION(...') #4 /home/a4725528/public_html/lib/Flux/Template.php(337): include('/home/a4725528/...') #5 /home/a4725528/public_html/lib/Flux/Dispatcher.php(168): Flux_Template->render() #6 /home/a4725528/public_html/index.php(170): Flux_Dispatcher->dispatch(Array) #7 {main} my sql databases and password are correct, still having this error, does anyone know how to fix this? a little info is a great help, isnt it "mysql workbench", do i need databases on site? because i have mysql installed on my computer, it seems those login credentials that i am using in my sql on my computer, are not those what it needs, does it need an online database? Any Informaiton could be a great help, Thank you Link to comment Share on other sites More sharing options...
Asura Posted October 18, 2012 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 707 Reputation: 168 Joined: 01/26/12 Last Seen: February 7, 2014 Share Posted October 18, 2012 Hi jordan, You need to edit the '/config/servers.php' file inside your FluxCP, and put the correct MySQL information. Since you are hosting the MySQL information on your own PC, you must use your PC's IP (whatismyip.com) instead of 'localhost'. And you must port forward (portforward.com) 3306 for your PC in order to allow your webhost to connect to your MySQL server. 1 Link to comment Share on other sites More sharing options...
benching Posted October 18, 2012 Group: Members Topic Count: 26 Topics Per Day: 0.01 Content Count: 350 Reputation: 43 Joined: 09/07/12 Last Seen: August 30, 2019 Author Share Posted October 18, 2012 (edited) Okay thanks.. Ill do as you say, btw my IP is dynamic, can i use "myro.no-ip.org"? Please keep in touch im just reinstalling my CP Edited October 18, 2012 by jordan Link to comment Share on other sites More sharing options...
Thanna Posted October 18, 2012 Group: Members Topic Count: 45 Topics Per Day: 0.01 Content Count: 271 Reputation: 7 Joined: 01/06/12 Last Seen: May 16, 2015 Share Posted October 18, 2012 Okay thanks.. Ill do as you say, btw my IP is dynamic, can i use "myro.no-ip.org"? Please keep in touch im just reinstalling my CP dynamic IP cant host server's, if you are using PLDT then you can host it but with other ISP I think you cant. Link to comment Share on other sites More sharing options...
benching Posted October 19, 2012 Group: Members Topic Count: 26 Topics Per Day: 0.01 Content Count: 350 Reputation: 43 Joined: 09/07/12 Last Seen: August 30, 2019 Author Share Posted October 19, 2012 its working on other ISP.. but another error come up, SQLSTATE[HY000] [2013] Lost connection to MySQL server at 'reading initial communication packet', system error: 113 my site is fine now, thanks to all of you please make this topic solved Link to comment Share on other sites More sharing options...
Question
benching
hello i am having this error on my site,
Exception Details
Error: PDOException
Message: SQLSTATE[28000] [1045] Access denied for user 'ragnarok'@'localhost' (using password: YES)
File: /home/a4725528/public_html/lib/Flux/Connection.php:81 File Line Function/Method /home/a4725528/public_html/lib/Flux/Connection.php 81 PDO::__construct() /home/a4725528/public_html/lib/Flux/Connection.php 94 Flux_Connection::connect() /home/a4725528/public_html/lib/Flux/Connection.php 159 Flux_Connection::getConnection() /home/a4725528/public_html/modules/install/index.php 17 Flux_Connection::getStatement() /home/a4725528/public_html/lib/Flux/Template.php 337 include() /home/a4725528/public_html/lib/Flux/Dispatcher.php 168 Flux_Template::render() /home/a4725528/public_html/index.php 170 Flux_Dispatcher::dispatch()
Exception Trace As String
#0 /home/a4725528/public_html/lib/Flux/Connection.php(81): PDO->__construct(*hidden*)
#1 /home/a4725528/public_html/lib/Flux/Connection.php(94): Flux_Connection->connect(Object(Flux_Config))
#2 /home/a4725528/public_html/lib/Flux/Connection.php(159): Flux_Connection->getConnection()
#3 /home/a4725528/public_html/modules/install/index.php(17): Flux_Connection->getStatement('SELECT VERSION(...')
#4 /home/a4725528/public_html/lib/Flux/Template.php(337): include('/home/a4725528/...')
#5 /home/a4725528/public_html/lib/Flux/Dispatcher.php(168): Flux_Template->render()
#6 /home/a4725528/public_html/index.php(170): Flux_Dispatcher->dispatch(Array)
#7 {main}
my sql databases and password are correct, still having this error,
does anyone know how to fix this? a little info is a great help,
isnt it "mysql workbench",
do i need databases on site?
because i have mysql installed on my computer,
it seems those login credentials that i am using in my sql on my computer,
are not those what it needs,
does it need an online database?
Any Informaiton could be a great help,
Thank you
Link to comment
Share on other sites
4 answers to this question
Recommended Posts