Can Not Connect To DB

[Cute Tink]

I'm wondering if there is something in your setup that isn't allowing your script to see the same database that your myphpadmin is.

However, try this script and see what happens. If it doesn't fail, then try your script again:

$link = mysqli_connect('localhost', 'root', '');
if (!$link) {
echo 'Unable to connect to the database server.';
exit();
}

$sql = 'CREATE DATABASE  `ijdb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci';
$query = mysqli_query($link, $sql) or die( mysqli_error( $link ) ); 

I tested this and it worked on my machine.

[tappiocca]

Will not allow me past the initial error check.

[Cute Tink]

You'll have to put your password in. If it is root then the first line would be:

$link = mysqli_connect('localhost', 'root', 'root');

[tappiocca]

What if I want to delete my MAMP and MySQL. I am starting to wonder if I have servers blocking each other. Otherwise I am at a loss on what to do

[Cute Tink]

I'm not sure on uninstalls in Macs. I work on a Windows system.

Did that last method work at all?

[tappiocca]

I'm not sure on uninstalls in Macs. I work on a Windows system.

Did that last method work at all?

Not at all...

[Cute Tink]

I'm out of ideas. Perhaps someone who is more familiar with a MAMP system will think of something.

[tappiocca]

Thx for all your help though.. There has to be a simple explanation why it will not do what it is supposed to do. In the meantime, I am deleted MAMP and MySQL from the computer and will try and start over. My professor seems to think that by downloading MAMP and MySQL separately, that they are causing a conflict. I don't think he is correct, but I don't know either say myself.

[Cute Tink]

Well, MAMP should stand for Mac Apache Mysql Php.

Perhaps you did end up with two distinct databases. Phpmyadmin saw one and your scripts saw another.

[tappiocca]

ok.. well i uninstalled MAMP & MySQL (via term window) and then reinstalled MAMP, as before I can get my basic .php files to work, yet I am still unable to get this fricken server thingy to work. It is getting hung up on the 1st error agian..

[StarLion]

'locate the file'... a Database is not a Directory. Not the same thing.

If you cant get past $link = mysqli_connect('localhost', 'root', '');, then you've got a deeper problem.
instead of echo 'Unable to connect to the database server.';, do echo mysqli_connect_error(); and tell us what comes out.

[tappiocca]

'locate the file'... a Database is not a Directory. Not the same thing.

If you cant get past $link = mysqli_connect('localhost', 'root', '');, then you've got a deeper problem.
instead of echo 'Unable to connect to the database server.';, do echo mysqli_connect_error(); and tell us what comes out.

On the 1st Error.. I get No such file or directory

[tappiocca]

I think.. it might have been the way I was typing in the URL.. at first I was typing
localhost/connect
then I changed it to
localhost:8888/connect
and it seems to be working.. I do not understand that reasoning.. as I can call .php files that do not access the db w/o using the :8888

[StarLion]

'No such file or directory' is a socket file issue. Your installation of PHP has got an incorrect socket file location.

[tappiocca]

'No such file or directory' is a socket file issue. Your installation of PHP has got an incorrect socket file location.

Why does it work now that I am telling it what port to use tho?