Cannot open Database

[Codegen]

So, here's the story:

Last night, after doing an apt-get dist-upgrade (Ubuntu 6.10 > 7.10), the update didn't take, which forced me to copy everything over to another machine and redo it.

Now, I can access the database from the MySQL shell alright, but any of the PHP scripts cannot access it, and the mysql_error() function doesn't appear to work. I've tested it with a chmod 777, but that didn't do anything.


Any other suggestions?

 

[jmackay]

Make sure that PHP is compiled with mysql support?

 

[Kaos]

first, back everything up.

whew, now you can try ANYTHING.

I would personally,

sudo apt-get --purge remove {packages} && sudo apt-get install {packages}

Think of it like a fresh start.

 

[Codegen]

Make sure that PHP is compiled with mysql support?

That was the first thing I installed.

And I've already done a nuke-and-pave, so everything is fresh.

 

[Kaos]

make a simple php script that would be able to be run from the shell that connects to whatever you're connecting to and redirect stderr to a file for you to review/post here.

 

[Codegen]

My knowledge of PHP is pretty limited, and I can't seem to find anything on Google (I suck at that, lately)

Another detail I forgot to mention: I have a login script at the start of the page, and that's working properly, so I don't think it's PHP's connection to MySQL (Though, I wouldn't completely rule that out).

 

[Codegen]

STUPID! STUPID! STUPID!

*forgot to configure the user account*

 

[MadJuggla9]

oh how much you learned though