benching Posted October 17, 2012 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
Asura Posted October 18, 2012 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
benching Posted October 18, 2012 Author 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
Thanna Posted October 18, 2012 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.
benching Posted October 19, 2012 Author 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
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
4 answers to this question
Recommended Posts