phpmyadmin access disabled on new domain

phpmyadmin access disabled on new domain

Posted by: ozort
Posted on: 2009-04-18 18:52:00

Created a new ftp user and i moved a fully hosted domain to his account for editing. I no longer have access to editing his files from ssh, but that's fine. SQL doesnt' seem to want to cooperate though

loading up mysql.domain.org returns this:

Warning: session_write_close() [function.session-write-close]: open(/tmp/sess_tgvd4rasie716iutbh4s5753dh5i2474, O_RDWR) failed: Permission denied (13) in /usr/local/dh/web/phpmyadmin/navigation.php on line 94

so i set the domain to be fully hosted on my account, moved it to his account, then set up an sql database. i can log in and access it from mysql.myoldwebsite.com, but not from mysql.newdomain.org

assuming this is a permissions error? he says he can log in just fine via terminal, just seems that phpmyadmin is having problems.

Re: phpmyadmin access disabled on new domain

Posted by: sXi
Posted on: 2009-04-19 03:51:00

SQL and userspace privs are entirely different entities.

Ensure the SQL user details you're using to log in are correct.




How To Install PHP.INI / ionCube on DreamHost

Re: phpmyadmin access disabled on new domain

Posted by: ozort
Posted on: 2009-04-19 14:47:00

at mysql.domain.com, incorrect login does nothing, correct login loads a ton of page errors. the new shell account can log into the sql via terminal, and the actual webpage works fine as far as database/sql references is going.

the only difference between this and my other pages is that the contents and entire domain are hosted out of a new shell account i just created.

Re: phpmyadmin access disabled on new domain

Posted by: sXi
Posted on: 2009-04-19 20:43:00

Panel > Goodies > Manage MySQL

Click the user who has access to the database in question.

Ensure that %.dreamhost.com is present in the Allowable Hosts field.




How To Install PHP.INI / ionCube on DreamHost

Tags: rdwrsql databasewikipediasshphpmyadmin